Istvan Toth created PHOENIX-6728:
------------------------------------
Summary: Exists operator does not work at all
Key: PHOENIX-6728
URL: https://issues.apache.org/jira/browse/PHOENIX-6728
Project: Phoenix
Issue Type: Bug
Components: core
Affects Versions: 5.1.2
Reporter: Istvan Toth
{noformat}
0: jdbc:phoenix:> select exists (select 1);
+-------+
| false |
+-------+
| false |
+-------+
1 row selected (0.001 seconds)
0: jdbc:phoenix:> select not exists (select 1);
+------+
| true |
+------+
| true |
+------+
1 row selected (0.001 seconds)
0: jdbc:phoenix:> select 1 where exists (select 1);
java.lang.NullPointerException
at org.apache.phoenix.compile.JoinCompiler.compile(JoinCompiler.java:160)
at
org.apache.phoenix.optimize.QueryOptimizer.getApplicablePlans(QueryOptimizer.java:147)
at
org.apache.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:116)
at
org.apache.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:102)
at
org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:315)
at
org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:297)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:296)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:289)
at
org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:2012)
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)
0: jdbc:phoenix:>{noformat}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
