[
https://issues.apache.org/jira/browse/PHOENIX-6854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tanuj Khurana updated PHOENIX-6854:
-----------------------------------
Fix Version/s: (was: 5.1.3)
> Salted global indexes do not work for queries with uncovered columns
> --------------------------------------------------------------------
>
> Key: PHOENIX-6854
> URL: https://issues.apache.org/jira/browse/PHOENIX-6854
> Project: Phoenix
> Issue Type: Bug
> Reporter: Kadir Ozdemir
> Assignee: Tanuj Khurana
> Priority: Major
> Fix For: 5.2.0
>
>
> With an index hint, global indexes can be used for queries with uncovered
> columns. However, when the data table is salted, Phoenix does not project the
> columns correctly for queries with uncovered columns, and thus the result set
> returns wrong columns. For example, the following select statement returns
> 'b' instead of 'bcde'.
>
> {code:java}
> create table T1 (id varchar not null primary key, val1 varchar, val2 varchar,
> val3 varchar) SALT_BUCKETS=4;
> upsert into T1 values ('b', 'bc', 'bcd', 'bcde');
> create index I1 on T1 (val1) include (val2);
> select /*+ INDEX(T1 I1)*/ val3 from T1 WHERE val1 = 'bc';
> {code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
