[
https://issues.apache.org/jira/browse/PHOENIX-1299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17498733#comment-17498733
]
Istvan Toth commented on PHOENIX-1299:
--------------------------------------
According to my quick test, ANY/ALL doesn't work at all (despite some
references to it in the grammar definition file)
{noformat}
select count(*) from system.catalog where table_name = ANY ('LOG', 'FUNCTION') ;
Error: ERROR 602 (42P00): Syntax error. Missing "LPAREN" at line 1, column 43.
(state=42P00,code=602)
org.apache.phoenix.exception.PhoenixParserException: ERROR 602 (42P00): Syntax
error. Missing "LPAREN" at line 1, column 43.
at
org.apache.phoenix.exception.PhoenixParserException.newException(PhoenixParserException.java:33)
at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:111)
at
org.apache.phoenix.jdbc.PhoenixStatement$PhoenixStatementParser.parseStatement(PhoenixStatement.java:1799)
at
org.apache.phoenix.jdbc.PhoenixStatement.parseStatement(PhoenixStatement.java:1882)
at
org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:2001)
at sqlline.Commands.executeSingleQuery(Commands.java:1054)
at sqlline.Commands.execute(Commands.java:1003)
at sqlline.Commands.sql(Commands.java:967)
at sqlline.SqlLine.dispatch(SqlLine.java:734)
at sqlline.SqlLine.begin(SqlLine.java:541)
at sqlline.SqlLine.start(SqlLine.java:267)
at sqlline.SqlLine.main(SqlLine.java:206)
Caused by: MissingTokenException(inserted [@-1,0:0='<missing
LPAREN>',<100>,1:42] at table_name)
at
org.apache.phoenix.parse.PhoenixSQLParser.recoverFromMismatchedToken(PhoenixSQLParser.java:375)
at
org.apache.phoenix.shaded.org.antlr.runtime.BaseRecognizer.match(BaseRecognizer.java:115)
at
org.apache.phoenix.parse.PhoenixSQLParser.not_expression(PhoenixSQLParser.java:8315)
at
org.apache.phoenix.parse.PhoenixSQLParser.and_expression(PhoenixSQLParser.java:8135)
at
org.apache.phoenix.parse.PhoenixSQLParser.or_expression(PhoenixSQLParser.java:8072)
at
org.apache.phoenix.parse.PhoenixSQLParser.expression(PhoenixSQLParser.java:8037)
at
org.apache.phoenix.parse.PhoenixSQLParser.single_select(PhoenixSQLParser.java:5602)
at
org.apache.phoenix.parse.PhoenixSQLParser.unioned_selects(PhoenixSQLParser.java:5684)
at
org.apache.phoenix.parse.PhoenixSQLParser.select_node(PhoenixSQLParser.java:5750)
at
org.apache.phoenix.parse.PhoenixSQLParser.oneStatement(PhoenixSQLParser.java:867)
at
org.apache.phoenix.parse.PhoenixSQLParser.statement(PhoenixSQLParser.java:525)
at org.apache.phoenix.parse.SQLParser.parseStatement(SQLParser.java:108)
... 10 more{noformat}
> Optimize ANY/SOME/ALL sub-queries
> ---------------------------------
>
> Key: PHOENIX-1299
> URL: https://issues.apache.org/jira/browse/PHOENIX-1299
> Project: Phoenix
> Issue Type: Improvement
> Affects Versions: 3.0.0, 4.0.0
> Reporter: Wei Xue
> Assignee: Wei Xue
> Priority: Major
> Original Estimate: 120h
> Remaining Estimate: 120h
>
> ANY/SOME/ALL can usually be rewritten to their equivalents:
> http://www.oracle-base.com/articles/misc/all-any-some-comparison-conditions-in-sql.php
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
