Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2858

DDL Importer does drops quotes from quoted column names

    XMLWordPrintable

    Details

    • Steps to Reproduce:
      1. import project
      2. create data source from source model
      3. preview date (new_table)
      4. change name
      5. preview data again (new_table)

      Description

      When I wanted preview date from the table which contains column with specific name, server shows me this error:

      TEIID31100 Parsing error: Encountered "'FALSE'), [*]YEAR[*] string(" at line 8, column 9.
      Was expecting: "constraint" | "foreign" | "primary" | "unique" | id

      I looked on the DDL which designer generated (screenshot1) and I think that column TIME should be between quotation marks.

      "YEAR" string(4000) OPTIONS(NAMEINSOURCE '"YEAR"', UPDATABLE 'FALSE')

      When I change column name from TIME to "TIME", the preview passed and showed me data. (screenshot2)

      A similar situation is when I generated dynamic VDB.

        Attachments

        1. remoteXML.zip
          35 kB
        2. screenshot1.png
          screenshot1.png
          308 kB
        3. screenshot2.png
          screenshot2.png
          344 kB

          Issue Links

            Activity

              People

              Assignee:
              blafond Barry LaFond
              Reporter:
              mkralik Matej Kralik
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: