[
https://issues.apache.org/jira/browse/PHOENIX-3498?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15677742#comment-15677742
]
Hudson commented on PHOENIX-3498:
---------------------------------
SUCCESS: Integrated in Jenkins build Phoenix-master #1505 (See
[https://builds.apache.org/job/Phoenix-master/1505/])
PHOENIX-3498 Query with index failed when query back to data table with
(maryannxue: rev 3b3d8ad3ab3bb0fae013154878ba0467691c5b30)
* (edit) phoenix-core/src/it/java/org/apache/phoenix/end2end/index/IndexIT.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/join/HashCacheClient.java
> Query with index failed when query back to data table with desc PK column
> -------------------------------------------------------------------------
>
> Key: PHOENIX-3498
> URL: https://issues.apache.org/jira/browse/PHOENIX-3498
> Project: Phoenix
> Issue Type: Bug
> Reporter: William Yang
> Assignee: William Yang
> Fix For: 4.9.0
>
> Attachments: PHOENIX-3498.patch
>
>
> This bug can be re-pro against two conditions:
> 1. select must hit index table and have to query back to data table
> 2. at least one of the data table's PK column is in DESC order
> see the following SQLs:
> {code}
> create table tt (p1 integer not null, p2 integer not null, a integer, b
> integer constraint pk primary key (p1,p2));
> create index tti on tt (a);
> upsert into tt values (0, 1, 2, 3);
> select /*+index(tt tti)*/ b from tt where a = 2; // will query back
> to data table
> //this SELECT works fine, will return b=3
> {code}
> if we declare ether p1/p2 as DESC, then the same SELECT will return nothing.
> {code}
> create table tt (p1 integer not null, p2 integer not null, a integer, b
> integer constraint pk primary key (p1 desc, p2));
> create index tti on tt (a);
> upsert into tt values (0, 1, 2, 3);
> select /*+index(tt tti)*/ b from tt where a = 2; // return nothing
> {code}
> if p1 is not DESC, but p2 is, SELECT will fail too.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
