[
https://issues.apache.org/jira/browse/PHOENIX-4322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16226193#comment-16226193
]
Hudson commented on PHOENIX-4322:
---------------------------------
FAILURE: Integrated in Jenkins build Phoenix-master #1853 (See
[https://builds.apache.org/job/Phoenix-master/1853/])
Revert "PHOENIX-4322 DESC primary key column with variable length does
(jtaylor: rev 6b24e0d5869839f861f3b7069e865e71d1fc61c6)
* (edit) phoenix-core/src/main/java/org/apache/phoenix/util/ScanUtil.java
Revert "PHOENIX-4322 DESC primary key column with variable length does
(jtaylor: rev a7af29f9e90308d5a2805cc3eabf4e607fbe3cb2)
* (edit) phoenix-core/src/it/java/org/apache/phoenix/end2end/SortOrderIT.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/util/ScanUtil.java
> DESC primary key column with variable length does not work in SkipScanFilter
> ----------------------------------------------------------------------------
>
> Key: PHOENIX-4322
> URL: https://issues.apache.org/jira/browse/PHOENIX-4322
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.11.0
> Reporter: Maryann Xue
> Assignee: Maryann Xue
> Priority: Minor
> Fix For: 4.13.0
>
>
> Example:
> {code}
> @Test
> public void inDescCompositePK3() throws Exception {
> String table = generateUniqueName();
> String ddl = "CREATE table " + table + " (oid VARCHAR NOT NULL, code
> VARCHAR NOT NULL constraint pk primary key (oid DESC, code DESC))";
> Object[][] insertedRows = new Object[][]{{"o1", "1"}, {"o2", "2"},
> {"o3", "3"}};
> runQueryTest(ddl, upsert("oid", "code"), insertedRows, new
> Object[][]{{"o2", "2"}, {"o1", "1"}}, new WhereCondition("(oid, code)", "IN",
> "(('o2', '2'), ('o1', '1'))"),
> table);
> }
> {code}
> Here the last column in primary key is in DESC order and has variable length,
> and WHERE clause involves an "IN" operator with RowValueConstructor
> specifying all PK columns. We get no results.
> This ends up being the root cause for not being able to use child/parent join
> optimization on DESC pk columns as described in PHOENIX-3050.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
