You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "thrylokya (Jira)" <ji...@apache.org> on 2022/07/17 12:28:00 UTC
[jira] [Assigned] (PHOENIX-6728) Exists operator does not work at all
[ https://issues.apache.org/jira/browse/PHOENIX-6728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
thrylokya reassigned PHOENIX-6728:
----------------------------------
Assignee: thrylokya
> 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
> Assignee: thrylokya
> Priority: Major
>
> {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.10#820010)