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

parse issue when create PSQL functions dollar quoted string

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Not a Bug
    • Affects Version/s: 6.0.0 GA
    • 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.
    • Operating System/s:
      CentOS 6.x
    • Steps to Reproduce:
      Hide

      create a job wit an SQL script step talking to a PSQL database
      and point that step at a sql file.

      Show
      create a job wit an SQL script step talking to a PSQL database and point that step at a sql file.

      Description

      When a job SQL script step tries to execute code to create a PSQL function, I get an error:

      2015/12/08 10:33:02 - fn_clean_log - ERROR (version 6.0.0.0-353, build 1 from 2015-10-07 13.27.43 by buildguy) : An error occurred executing this job entry : 
      2015/12/08 10:33:02 - fn_clean_log - Couldn't execute SQL: create function log.fn_clean_log() returns void as
      2015/12/08 10:33:02 - fn_clean_log - $$
      2015/12/08 10:33:02 - fn_clean_log - declare
      2015/12/08 10:33:02 - fn_clean_log - 	_row		record
      2015/12/08 10:33:02 - fn_clean_log - 
      2015/12/08 10:33:02 - fn_clean_log - ERROR: unterminated dollar-quoted string at or near "$$
      2015/12/08 10:33:02 - fn_clean_log - declare
      2015/12/08 10:33:02 - fn_clean_log - 	_row		record"
      2015/12/08 10:33:02 - fn_clean_log -   Position: 52
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            dnrickner Dan Rickner
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: