[PHOENIX-2138] Non equality comparisons don't work for ARRAY type columns that are DESC in row key

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.5.1
• Assignee: Dumindu Buddhika
• Reporter: James R. Taylor
• Created: 22/Jul/15 17:57
• Updated: 21/Nov/15 02:16
• Resolved: 13/Aug/15 05:57

Description

An exception occurs when you attempt to query an array column declared as DESC in the row key with <, >, <=, and >=. Here's how to reproduce:

create table a (k varchar array primary key desc);
upsert into a values (array['a']);
select * from a where k >= array['a'];

The exception is:

java.lang.IllegalArgumentException
	at java.nio.Buffer.position(Buffer.java:236)
	at org.apache.phoenix.schema.types.PArrayDataType.createPhoenixArray(PArrayDataType.java:1074)
	at org.apache.phoenix.schema.types.PArrayDataType.toObject(PArrayDataType.java:335)
	at org.apache.phoenix.schema.types.PVarcharArray.toObject(PVarcharArray.java:65)
	at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:966)
	at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:970)
	at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:999)
	at org.apache.phoenix.schema.types.PDataType.toStringLiteral(PDataType.java:1072)
	at org.apache.phoenix.schema.types.PDataType.toStringLiteral(PDataType.java:1068)
	at org.apache.phoenix.iterate.ExplainTable.appendPKColumnValue(ExplainTable.java:182)
	at org.apache.phoenix.iterate.ExplainTable.appendScanRow(ExplainTable.java:257)
	at org.apache.phoenix.iterate.ExplainTable.appendKeyRanges(ExplainTable.java:273)
	at org.apache.phoenix.iterate.ExplainTable.explain(ExplainTable.java:122)
	at org.apache.phoenix.iterate.BaseResultIterators.explain(BaseResultIterators.java:713)
	at org.apache.phoenix.iterate.RoundRobinResultIterator.explain(RoundRobinResultIterator.java:153)
	at org.apache.phoenix.execute.BaseQueryPlan.getPlanSteps(BaseQueryPlan.java:406)
	at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:263)
	at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:161)
	at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:265)
	at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:255)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:254)
	at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1435)
	at sqlline.Commands.execute(Commands.java:822)
	at sqlline.Commands.sql(Commands.java:732)
	at sqlline.SqlLine.dispatch(SqlLine.java:808)
	at sqlline.SqlLine.begin(SqlLine.java:681)
	at sqlline.SqlLine.start(SqlLine.java:398)
	at sqlline.SqlLine.main(SqlLine.java:292)