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

DDL Importer does drops quotes from quoted column names

    XMLWordPrintable

Details

      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

        2. screenshot1.png
          308 kB
          Matej Kralik
        3. screenshot2.png
          344 kB
          Matej Kralik

        Issue Links

          is incorporated by

          Task - Represents a small unit of work that is not end-user facing. TEIIDDES-2699 Issues with Dynamic VDB import/export

          • Blocker - To be worked above all other priorities. This term is chosen when the severity of the issue is very high, has no workaround, or the effort for the change is comparatively low. Issues that may be very publicly visible and could generate significant media attention may also drive a higher priority.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: