Repository: phoenix Updated Branches: refs/heads/master 0c38f493c -> b0220fa75
PHOENIX-4322 DESC primary key column with variable length does not work in SkipScanFilter Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/b0220fa7 Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/b0220fa7 Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/b0220fa7 Branch: refs/heads/master Commit: b0220fa7522fd7e1848ad428a47121b205dec504 Parents: 0c38f49 Author: maryannxue <maryann....@gmail.com> Authored: Mon Oct 30 11:49:40 2017 -0700 Committer: maryannxue <maryann....@gmail.com> Committed: Mon Oct 30 11:49:40 2017 -0700 ---------------------------------------------------------------------- .../src/it/java/org/apache/phoenix/end2end/SortOrderIT.java | 9 +++++++++ .../src/main/java/org/apache/phoenix/util/ScanUtil.java | 7 +++++-- 2 files changed, 14 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/phoenix/blob/b0220fa7/phoenix-core/src/it/java/org/apache/phoenix/end2end/SortOrderIT.java ---------------------------------------------------------------------- diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/SortOrderIT.java b/phoenix-core/src/it/java/org/apache/phoenix/end2end/SortOrderIT.java index 655dbb1..58bbabb 100644 --- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/SortOrderIT.java +++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/SortOrderIT.java @@ -167,6 +167,15 @@ public class SortOrderIT extends ParallelStatsDisabledIT { runQueryTest(ddl, upsert("oid", "code"), insertedRows, new Object[][]{{"o2", 2}}, new WhereCondition("oid", "IN", "('o2')"), table); } + + @Test + public void inDescCompositePK3() throws Exception { + String table = generateUniqueName(); + String ddl = "CREATE table " + table + " (oid INTEGER NOT NULL, code VARCHAR NOT NULL constraint pk primary key (oid DESC, code DESC))"; + Object[][] insertedRows = new Object[][]{{1, "o1"}, {2, "o2"}, {3, "o3"}}; + runQueryTest(ddl, upsert("oid", "code"), insertedRows, new Object[][]{{2, "o2"}, {1, "o1"}}, + new WhereCondition("(oid, code)", "IN", "((1, 'o1'), (2, 'o2'))"), table); + } @Test public void likeDescCompositePK1() throws Exception { http://git-wip-us.apache.org/repos/asf/phoenix/blob/b0220fa7/phoenix-core/src/main/java/org/apache/phoenix/util/ScanUtil.java ---------------------------------------------------------------------- diff --git a/phoenix-core/src/main/java/org/apache/phoenix/util/ScanUtil.java b/phoenix-core/src/main/java/org/apache/phoenix/util/ScanUtil.java index a844226..8ab4f20 100644 --- a/phoenix-core/src/main/java/org/apache/phoenix/util/ScanUtil.java +++ b/phoenix-core/src/main/java/org/apache/phoenix/util/ScanUtil.java @@ -431,8 +431,11 @@ public class ScanUtil { anyInclusiveUpperRangeKey |= !range.isSingleKey() && inclusiveUpper; // A null or empty byte array is always represented as a zero byte byte sepByte = SchemaUtil.getSeparatorByte(schema.rowKeyOrderOptimizable(), bytes.length == 0, field); - - if ( !isFixedWidth && ( sepByte == QueryConstants.DESC_SEPARATOR_BYTE + // The result of an RVC evaluation can come with a trailing separator already, so we + // should avoid adding another one. + if ( !isFixedWidth + && ( bytes.length == 0 || key[offset - 1] != sepByte ) + && ( sepByte == QueryConstants.DESC_SEPARATOR_BYTE || ( !exclusiveUpper && (fieldIndex < schema.getMaxFields() || inclusiveUpper || exclusiveLower) ) ) ) { key[offset++] = sepByte;