[PHOENIX-4846] WhereOptimizer.pushKeyExpressionsToScan() does not work correctly if the sort order of pk columns being filtered on changes

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 4.14.0, 5.0.0
• Fix Version/s: 5.2.1
• Assignee: Unassigned
• Reporter: Thomas D'Silva
• Created: 11/Aug/18 21:07
• Updated: 23/Jun/22 20:05

Description

ExpressionComparabilityWrapper should set the sort order based on childPart.getColumn() or else the attached test throws an IllegalArgumentException

java.lang.IllegalArgumentException: 4 > 3
at java.util.Arrays.copyOfRange(Arrays.java:3519)
at org.apache.hadoop.hbase.io.ImmutableBytesWritable.copyBytes(ImmutableBytesWritable.java:272)
at org.apache.phoenix.compile.WhereOptimizer.getTrailingRange(WhereOptimizer.java:329)
at org.apache.phoenix.compile.WhereOptimizer.clipRight(WhereOptimizer.java:350)
at org.apache.phoenix.compile.WhereOptimizer.pushKeyExpressionsToScan(WhereOptimizer.java:237)
at org.apache.phoenix.compile.WhereCompiler.compile(WhereCompiler.java:157)
at org.apache.phoenix.compile.WhereCompiler.compile(WhereCompiler.java:108)
at org.apache.phoenix.compile.QueryCompiler.compileSingleFlatQuery(QueryCompiler.java:556)

Also in pushKeyExpressionsToScan() we cannot extract pk column nodes from the where clause if the sort order of the columns changes.

Issue Links

• requires: PHOENIX-4841 Filters that uses RVC with pk columns where with DESC sort order don't work correctly