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

DDL Importer does drops quotes from quoted column names

XMLWordPrintable

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

      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.

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

            blafond Barry LaFond
            mkralik@redhat.com Matej Kralik
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: