You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Vamshi (JIRA)" <ji...@apache.org> on 2019/04/05 23:13:00 UTC

[jira] [Created] (CALCITE-2981) Syntax error with simple nested select query

Vamshi created CALCITE-2981:
-------------------------------

             Summary: Syntax error with simple nested select query
                 Key: CALCITE-2981
                 URL: https://issues.apache.org/jira/browse/CALCITE-2981
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.18.0
            Reporter: Vamshi


Below standard query reports a syntax error:

select * from (

( select id,name from test1 ) test3

inner join

( select id,name from test2) test4 on test4.id = test3.id

)dt

Caused by: org.apache.calcite.parser.ParseException: Encountered "test3" at line 4, column 31.
Was expecting one of:
 ")" ...
 "ORDER" ...
 "LIMIT" ...
 "OFFSET" ...
 "FETCH" ...
 "UNION" ...
 "INTERSECT" ...
 "EXCEPT" ...
 "MINUS" ...
 "." ...
 "NOT" ...
 "IN" ...
 "<" ...
 "<=" ...
 ">" ...
 ">=" ...
 "=" ...
 "<>" ...
 "!=" ...
 "BETWEEN" ...
 "LIKE" ...
 "SIMILAR" ...
 "+" ...
 "-" ...
 "*" ...
 "/" ...
 "%" ...
 "||" ...
 "AND" ...
 "OR" ...
 "IS" ...
 "MEMBER" ...
 "SUBMULTISET" ...
 "CONTAINS" ...
 "OVERLAPS" ...
 "EQUALS" ...
 "PRECEDES" ...
 "SUCCEEDS" ...
 "IMMEDIATELY" ...
 "MULTISET" ...
 "[" ...
 "YEAR" ...
 "MONTH" ...
 "DAY" ...
 "HOUR" ...
 "MINUTE" ...
 "SECOND" ...

 

The above query works in standard databases like oracle/postgres/sql server.

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)