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

Adding source table with quoted name results in wrong generated SQL statement

    XMLWordPrintable

Details

    Description

      1) Created source model with simple table named "My.Quoted.Table" (including quotes
      2) Created simple virtual table and pasted: SELECT * FROM "My.Quoted.Table"
      3) Parser returned a command resulting in the SQL: SELECT * FROM My.Quoted."Table"

      Parser should be able to handle quoted names properly. In this case the SQL should have been valid as is.

      Attachments

        Issue Links

          blocks

          Feature Request - Feature requests from customers and/or users TEIIDDES-2100 Add ability to migrate older models containing table names with "." characters

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed
          is cloned by

          Bug - A problem that impairs or prevents the functions of the product. TEIID-2993 Adding source table with quoted name results in wrong generated SQL statement

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              parichar@redhat.com Paul Richardson
              blafond Barry LaFond
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: