Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@phoenix.apache.org
Date: Tue, 5 Dec 2017 21:02:00 +0000 (UTC)
From: "Hudson (JIRA)" <jira@apache.org>
To: dev@phoenix.apache.org
Message-ID: <JIRA.13112118.1508968948000.392463.1512507720198@Atlassian.JIRA>
In-Reply-To: <JIRA.13112118.1508968948000@Atlassian.JIRA>
References: <JIRA.13112118.1508968948000@Atlassian.JIRA> <JIRA.13112118.1508968948610@jira-lw-us.apache.org>
Subject: [jira] [Commented] (PHOENIX-4322) DESC primary key column with
 variable length does not work in SkipScanFilter
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Tue, 05 Dec 2017 21:02:06 -0000


    [ https://issues.apache.org/jira/browse/PHOENIX-4322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16279174#comment-16279174 ] 

Hudson commented on PHOENIX-4322:
---------------------------------

FAILURE: Integrated in Jenkins build Phoenix-master #1885 (See [https://builds.apache.org/job/Phoenix-master/1885/])
PHOENIX-4322 DESC primary key column with variable length does not work (maryannxue: rev d77c237b560900671c3a9c58f6f2398342655e8a)
* (edit) phoenix-core/src/main/java/org/apache/phoenix/expression/RowValueConstructorExpression.java
* (edit) phoenix-core/src/it/java/org/apache/phoenix/end2end/SortOrderIT.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.14.0
>
>         Attachments: PHOENIX-4322.patch
>
>
> 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)