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

Semi colons in Execute SQL Script job step

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Duplicate
    • Affects Version/s: 4.4.0 GA (4.8.0 GA Suite Release) , 4.4.2, 4.8.3.0 GA, 4.8.3.1 GA, 4.8.3.2 GA, 4.8.3.3 GA, 4.8.3.4 GA, 4.8.3.5 GA, 4.8.3.6 GA, 4.8.3.7 GA, 4.8.3.4, 5.0.0 GA (5.0.0 GA Suite Release), 5.0.1 GA, 5.0.2 GA, 5.0.3 GA, 5.0.4 GA, 5.0.5 GA, 5.0.6 GA, 5.0.7 GA, 5.0.9.0 GA, 5.1.0 GA, 5.1.2.0 GA, 5.1.2.1 GA, 5.2.0.1, 5.2.0.2
    • Fix Version/s: None
    • Component/s: Job
    • Labels:
      None
    • Story Points:
      0
    • PDI Sub-component:
    • 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

      When upgrading from 4.2.0 to 4.4.2 we encountered problems with the Execute SQL Script Job step. This is due to a change in the Database class in package org.pentaho.di.core.database.
      Former statement splitting logic has been replaced by "String[] statements = all.split(";")" which causes all queries containing semi colons in string literals to fail.

      To reproduce:

      add to a Execute SQL Script the following query:
      select replace('aaa;bbb',';','');

      Which will produce an error

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              project admin Triage
              Reporter:
              dgroen Dennis in 't Groen
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: