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)
