You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Lars Hofhansl (Jira)" <ji...@apache.org> on 2021/03/10 21:23:00 UTC

[jira] [Resolved] (PHOENIX-6408) LIMIT on local index query with uncovered columns in the WHERE returns wrong result.

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

Lars Hofhansl resolved PHOENIX-6408.
------------------------------------
    Fix Version/s: 5.2.0
                   4.16.1
                   5.1.1
       Resolution: Fixed

Merged in master and cherry-picked into 5.1 and 4.x.

Thanks [~kozdemir]

> LIMIT on local index query with uncovered columns in the WHERE returns wrong result.
> ------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-6408
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6408
>             Project: Phoenix
>          Issue Type: Sub-task
>    Affects Versions: 5.1.1, 4.16.1, 5.2.0
>            Reporter: Lars Hofhansl
>            Assignee: Lars Hofhansl
>            Priority: Major
>             Fix For: 5.1.1, 4.16.1, 5.2.0
>
>
> Sorry one more issue.
> In PHOENIX-6402 I fixed local indexes with uncovered columns in the WHERE clause.
> It turns out that LIMIT is also executed as a filter, so now that also needs to change and be invoked after the extra filter.



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