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.

        Gliffy Diagrams

          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: