You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "pingle wang (JIRA)" <ji...@apache.org> on 2019/04/08 07:47:00 UTC
[jira] [Issue Comment Deleted] (CALCITE-2981) Syntax error with
simple nested select query
[ https://issues.apache.org/jira/browse/CALCITE-2981?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
pingle wang updated CALCITE-2981:
---------------------------------
Comment: was deleted
(was: ```sql
select
*
from
(
(select * from test1) test3
)
```
Occurring Exception is not parsed sub-query test3 table reference correctly, I can try this issue, thanks.)
> 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
> Priority: Critical
>
> Below standard sql-92 query reports syntax error in calcite:
> create table test1(id integer, name integer);
> create table test2(id integer, name integer);
> select * from (
> ( select id,name from test1 ) test3
> inner join
> ( select id,name from test2) test4 on test4.id = test3.id
> );
> 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 postgres/oracle/sql server. This is a commonly generated query pattern by popular BI tools.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)