phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "oktay tuncay (Jira)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-5744) wrong results when using the local secondary index
Date Tue, 25 Feb 2020 10:45:00 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

oktay tuncay updated PHOENIX-5744:
----------------------------------
    Affects Version/s: 5.0.0

> 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
>    Affects Versions: 5.0.0
>            Reporter: oktay tuncay
>            Priority: Critical
>
> 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)

Mime
View raw message