phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-4322) DESC primary key column with variable length does not work in SkipScanFilter
Date Tue, 31 Oct 2017 03:41:00 GMT

    [ 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)

Mime
View raw message