Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-35

Support parenthesized sub-clause in JOIN

    XMLWordPrintableJSON

Details

    Description

      SQL-92 allows joins to be grouped into trees using parentheses. For example,

      select * from a join (b join c on b.x = c.x) on a.y = c.y

      Optiq should support this. Currently this gives "org.eigenbase.util.EigenbaseException: Non-query expression encountered in illegal context".

      ---------------- Imported from GitHub ----------------
      Url: https://github.com/julianhyde/optiq/issues/35
      Created by: julianhyde
      Labels:
      Created at: Fri Apr 19 02:46:01 CEST 2013
      State: open

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-5194 Cannot parse parenthesized UNION in subquery

          • Blocker - Blocks development and/or testing work, production could not run
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-5042 Incorrect syntax in sub-query

          • Blocker - Blocks development and/or testing work, production could not run
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-2981 Syntax error with simple nested select query

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-2153 SQL parser fails to parse valid multi nested join subqueries

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-4961 Add support for parenthesis-wrapped joined tables

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-1648 Cannot use parentheses after FROM in SQL

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-3051 Babel parser should parse special table expressions

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-3463 Parse SQL Query - Non-query expression encountered in illegal context

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-2152 SQL parser unable to parse SQL with nested joins produced by RelToSqlConverter

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-5168 Allow AS after parenthesized JOIN

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-5233 Support for SQL syntax with parenthesis for outer join associativity

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link GitHub Pull Request #1204

          Web Link GitHub Pull Request #1228

          Web Link GitHub Pull Request #2820

          Activity

            People

              Unassigned Unassigned
              github-import GitHub Import
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h 40m
                  1h 40m