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

When executing a database query through the step "Table Input" does not interpret comments with "--"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Duplicate
    • Affects Version/s: 7.1.0.12 GA
    • Fix Version/s: None
    • Component/s: API, 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:
      Windows 7 (64-bit)
    • Steps to Reproduce:
      Hide

      Crear una nueva transformación de tipo Table Input.
      Añadir dentro para ejecutar una consulta de base de datos que lleve algún comentario en su código (Ver apartado descripción)

      Show
      Crear una nueva transformación de tipo Table Input. Añadir dentro para ejecutar una consulta de base de datos que lleve algún comentario en su código (Ver apartado descripción)

      Description

      Create a transformation that internally executes a database query, for example one of type "Table Input" and the query takes a comment,

      For example:

      Select nombre, apellido 
      from usuarios 
      -- )
      where edad = 32;
      

      When looking at the example, the query when executed does not apply the WHERE clause, perhaps when it is executed internally carriage returns are eliminated and this generates the error since it seems to execute the following:

      Select nombre, apellido 
      from usuarios 
      

      Muchas gracias,
      Un saludo

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              anmarpei Antonio Martínez Peiró
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: