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

MySQL Bulk Loader - field_format_ok changes from STRING_ESC to OK when run on Carte

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Duplicate
    • Affects Version/s: 6.0.1 GA
    • Fix Version/s: None
    • Component/s: Step
    • Labels:
    • Environment:
      Pentaho Data Integration 6.0.1
    • 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.
    • Steps to Reproduce:
      Hide

      1. Download the zip file attached to ESR-5138
      2. Configure attached jobs and transformation with connection details for your environment
      3. Start carte:
      ./carte.sh localhost 9000 -u cluster -p cluster
      4. Run the job from kitchen:
      ./kitchen.sh -file=<path_to_job>/main.kjb
      (This runs the exact same transformation, which inserts 1 row into a MySQL table, 2 times. Once on kitchen, once on carte).

      The ETL also creates the table where the inserted rows can be checked

      Show
      1. Download the zip file attached to ESR-5138 2. Configure attached jobs and transformation with connection details for your environment 3. Start carte: ./carte.sh localhost 9000 -u cluster -p cluster 4. Run the job from kitchen: ./kitchen.sh -file=<path_to_job>/main.kjb (This runs the exact same transformation, which inserts 1 row into a MySQL table, 2 times. Once on kitchen, once on carte). The ETL also creates the table where the inserted rows can be checked

      Description

      Pentaho Product: Data Integration
      Version: 6.0.1
      Operating System: Ubuntu 14.04 LTS
      Database for data: MySQL 5.6.12
      JDBC Driver version: 5.1.36

      In the MySQL Bulk Loader step, the field_format_ok value defined in a transformation XML is changing from STRING_ESC to OK
      when the transformation is run on Carte. This causes data enclosed in quotes, for instance, to be loaded incorrectly into the
      target table.

      There is an example job and also a patch suggestion described in ESR-5138 where this issue was originally raised.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            nmidson Nick Midson
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: