Description
1 . create table t (a integer not null, b integer not null, c integer
constraint pk primary key (a,b));
2. select c from t where a in (1,2) and b = 3 and (a,b) in ( (1,2) , (1,3));
I got exception on compile :
java.lang.IllegalArgumentException
at
com.google.common.base.Preconditions.checkArgument(Preconditions.java:76)
at
org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor$KeySlot.inter
sect(WhereOptimizer.java:955)
at
org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor.intersectSlot
s(WhereOptimizer.java:506)
at
org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor.andKeySlots(W
hereOptimizer.java:551)
at
org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor.visitLeave(Wh
ereOptimizer.java:725)
at
org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor.visitLeave(Wh
ereOptimizer.java:349)
at
org.apache.phoenix.expression.AndExpression.accept(AndExpression.java:100)
at
org.apache.phoenix.compile.WhereOptimizer.pushKeyExpressionsToScan(WhereOpti
mizer.java:117)
at
org.apache.phoenix.compile.WhereCompiler.compile(WhereCompiler.java:105)
at
org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.ja
va:324)
at
org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:132)
at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePl
an(PhoenixStatement.java:296)
at
org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePl
an(PhoenixStatement.java:284)
at
org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:208)
at
org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:204)
at
org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.j
ava:54)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:
204)
at
org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:967)
at sqlline.SqlLine$Commands.execute(SqlLine.java:3673)
at sqlline.SqlLine$Commands.sql(SqlLine.java:3584)
at sqlline.SqlLine.dispatch(SqlLine.java:821)
at sqlline.SqlLine.begin(SqlLine.java:699)
at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
at sqlline.SqlLine.main(SqlLine.java:424)