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

Ability to not strip comments when SQL queries are executed in Jobs and Transformations.

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Severity: Unknown
    • Resolution: Duplicate
    • Affects Version/s: 4.4.0 GA (4.8.0 GA Suite Release)
    • Fix Version/s: None
    • Labels:
      None
    • 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

      Whenever SQL queries having comments are executed in transformations or jobs, those SQL comments are being ignored by PDI.

      Use case is as follows,
      Oracle hints are represented in the form /+ hint_text */, but when a SQL query is executed anything inside " / */ " is being treated as a "SQL Comment" and is being ignored.
      Please refer the below link regarding Oracle hints,

      http://docs.oracle.com/cd/B19306_01/server.102/b14211/hintsref.htm

      Also, we have attached screenshot for reference.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              project admin Triage
              Reporter:
              nprakash Nikhil Prakash
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: