[ https://issues.apache.org/jira/browse/PHOENIX-6854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tanuj Khurana reassigned PHOENIX-6854: -------------------------------------- Assignee: Tanuj Khurana > 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, 5.1.3 > > > 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)