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)
