[teiid-issues] [JBoss JIRA] (TEIID-2993) Adding source table with quoted name results in wrong generated SQL statement

[Paul Richardson (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2993?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Paul Richardson moved TEIIDDES-2202 to TEIID-2993:
--------------------------------------------------

              Project: Teiid  (was: Teiid Designer)
                  Key: TEIID-2993  (was: TEIIDDES-2202)
    Affects Version/s: 8.7
                       7.7.2
                           (was: 8.5)
             Assignee: Steven Hawkins  (was: Paul Richardson)
          Component/s: Query Engine
                           (was: Transformations)
        Fix Version/s: 8.7.1
                       8.8
                           (was: 8.6)
                           (was: 8.3.4)
                           (was: 8.5.1)


> Adding source table with quoted name results in wrong generated SQL statement
> -----------------------------------------------------------------------------
>
>                 Key: TEIID-2993
>                 URL: https://issues.jboss.org/browse/TEIID-2993
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.7, 7.7.2
>            Reporter: Paul Richardson
>            Assignee: Steven Hawkins
>             Fix For: 8.7.1, 8.8
>
>
> 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.



--
This message was sent by Atlassian JIRA
(v6.2.3#6260)