[PHOENIX-1709] And expression of primary key RVCs can not compile

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.3.1, 4.3.1, 4.4.0
• Assignee: James R. Taylor
• Reporter: James R. Taylor
• Created: 07/Mar/15 07:41
• Updated: 21/Nov/15 02:18
• Resolved: 10/Mar/15 17:44

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)