Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4107

HSQL Syntax error when Teiid sends it a join query with no parenthesis

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            gsteinberg_jira Gabriel Steinberg (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: