Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-12068

Instaview: Error in generated SQL queue while using the "RDBMS Sample".

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 5.0.5 GA, Master
    • Fix Version/s: 5.1.0 GA
    • Component/s: Instaview
    • Labels:
    • Environment:
      win7 x32, ubuntu12 x64
      Nightly 5.0.6 #231, Nightly 5.1 #585
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      If user answers "Yes" on question "Do you want to include the field-names in the SQL?" while using the "RDBMS Sample" generated field-name would be in quotes and such queue would lead to an error if executed.

      This is a regression against 4.8.

      steps:
      1. Open Instaview and click "Create new" button.
      2. Select the "Samples" tab and click on the RDBMS button.
      3. Click "Get SQL select statement" and choose AgileBI => Schemas => sys => args and press "OK"
      4. Answer "Yes" on the "Do you want to include the field-names in the SQL?" question.
      Note, that "NAME" and "TYPE" is in quotes (and marked red). And executing this queue would lead to an error.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jthomas Jeffrey Thomas (Inactive)
              Reporter:
              ihar_chekan Ihar Chekan (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: