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