[
https://issues.apache.org/jira/browse/PHOENIX-7766?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Viraj Jasani updated PHOENIX-7766:
----------------------------------
Fix Version/s: 5.4.0
5.3.1
> Generate point lookups while using IS NULL on trailing PK columns
> -----------------------------------------------------------------
>
> Key: PHOENIX-7766
> URL: https://issues.apache.org/jira/browse/PHOENIX-7766
> Project: Phoenix
> Issue Type: Improvement
> Reporter: Sanjeet Malhotra
> Assignee: Sanjeet Malhotra
> Priority: Major
> Fix For: 5.4.0, 5.3.1
>
>
> Currently, Phoenix explicitly prevents generating point lookups if a query
> has WHERE clause such that there is IS NULL condition on trailing PK columns.
> The proposal in this Jira is to generate point lookups for above case. This
> will especially be useful for cases when a new nullable PK column is added to
> a table and because of addition of new PK columns earlier single point
> lookups and multi point lookups regress to range and skip scan. The proposal
> will help prevent such regression.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
