[teiid-issues] [JBoss JIRA] (TEIID-4107) HSQL Syntax error when Teiid sends it a join query with no parenthesis

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-4107:
----------------------------------
    Fix Version/s: 9.0
                       (was: 9.0.0)


> HSQL Syntax error when Teiid sends it a join query with no parenthesis
> ----------------------------------------------------------------------
>
>                 Key: TEIID-4107
>                 URL: https://issues.jboss.org/browse/TEIID-4107
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 7.0
>            Reporter: Gabriel Steinberg
>            Assignee: Steven Hawkins
>             Fix For: 9.0, 8.12.5, 8.13.4
>
>
> The query
>  SELECT R_NAME FROM region LEFT OUTER JOIN (customer INNER JOIN nation ON C_NATIONKEY = N_NATIONKEY) ON R_REGIONKEY = N_REGIONKEY
> When run against an HSQL DB causes a syntax error because the query passed to HSQL contains no parenthesis, and HSQL cannot handle it, as described in https://developer.jboss.org/message/953580?et=watches.email.thread#953580.
> As Steve points out there, this was solved for H2 in https://issues.jboss.org/browse/TEIID-3549.  H2 and HSQL come from the same project, they split at some point in time, and I suspect they still share a lot of code.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)