[jira] [Created] (PHOENIX-5744) wrong results when using the local secondary index

["oktay tuncay (Jira)" <ji...@apache.org>]

oktay tuncay created PHOENIX-5744:
-------------------------------------

             Summary: wrong results when using the local secondary index
                 Key: PHOENIX-5744
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5744
             Project: Phoenix
          Issue Type: Bug
            Reporter: oktay tuncay


If the PK column(s) is included in the local index script and this column order by condition is also used, wrong result issue occurs.

Workaround: NO_INDEX hint

Example:
PK columns: ID, CREATETIME
SECONDARY INDEX: CREATETIME,TYPE2, KEY, SEQ_NUM, ...

Query 1: works properly and returns 4 rows
select /*+ NO_INDEX */ ID, TYPE, JOB, CON_ID, CREATETIME, TYPE2, KEY, SEQ_NUM FROM owner.table_name WHERE KEY='AAA' order by CREATETIME desc;

Query 2: wrong result, shows 1 rows
select /*+ NO_INDEX */ ID, TYPE, JOB, CON_ID, CREATETIME, TYPE2, KEY, SEQ_NUM FROM owner.table_name WHERE KEY='AAA' order by CREATETIME desc;



--
This message was sent by Atlassian Jira
(v8.3.4#803005)