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

Execute SQL Script bug with semicolon in string literal

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Duplicate
    • Affects Version/s: 4.4.0 GA (4.8.0 GA Suite Release)
    • Fix Version/s: None
    • Component/s: Job
    • Labels:
      None
    • Environment:
      Oracle
    • 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

      Running an "Execute SQL Script" step from a file with the "Send SQL as Single Statement" option unchecked, and a command like this:

      INSERT INTO TABLE_1 (FOO) VALUES ('BA;R');

      The parser separates it into two statements:
      1) INSERT INTO TABLE_1 (FOO) VALUES ('BA
      2) R')
      Which throws an error when it tries to execute the first one because it was not terminated

      I believe this worked fine in 4.2.1, because the only issue I was having in 4.2.1 was a similar issue with a double dash "--" in a string literal, and I upgraded to resolve that issue.

      Work around is to change the statement to something like this:

      INSERT INTO TABLE_1 (FOO) VALUES ('BA' || CHR(59) || 'R');

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jbleuel Jens Bleuel
              Reporter:
              tmeyer Tim Meyer
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: