[
https://issues.apache.org/jira/browse/PHOENIX-6217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gokcen Iskender resolved PHOENIX-6217.
--------------------------------------
Resolution: Duplicate
Dupe of PHOENIX-6023
> WHERE statement that combines values from different column families (that
> runs on index on a table with SINGLE_CELL_ARRAY_WITH_OFFSETS) doesn't return
> correct results
> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: PHOENIX-6217
> URL: https://issues.apache.org/jira/browse/PHOENIX-6217
> Project: Phoenix
> Issue Type: Bug
> Reporter: Gokcen Iskender
> Priority: Major
>
> CREATE IMMUTABLE TABLE S.TBL_N000001( varchar_pk VARCHAR NOT NULL, char_pk
> CHAR(10) NOT NULL, int_pk INTEGER NOT NULL, long_pk BIGINT NOT NULL,
> decimal_pk DECIMAL(31, 10) NOT NULL, date_pk DATE NOT NULL, a.varchar_col1
> VARCHAR, a.char_col1 CHAR(10), a.int_col1 INTEGER, a.long_col1 BIGINT,
> a.decimal_col1 DECIMAL(31, 10), a.date1 DATE, b.varchar_col2 VARCHAR,
> b.char_col2 CHAR(10), b.int_col2 INTEGER, b.long_col2 BIGINT, b.decimal_col2
> DECIMAL(31, 10), b.date2 DATE CONSTRAINT pk PRIMARY KEY (varchar_pk, char_pk,
> int_pk, long_pk DESC, decimal_pk, date_pk))
> IMMUTABLE_STORAGE_SCHEME=SINGLE_CELL_ARRAY_WITH_OFFSETS,COLUMN_ENCODED_BYTES=2
> CREATE INDEX IF NOT EXISTS IND_N000002 ON S.TBL_N000001 (long_pk, varchar_pk)
> INCLUDE (long_col1, long_col2)
> IMMUTABLE_STORAGE_SCHEME=SINGLE_CELL_ARRAY_WITH_OFFSETS,COLUMN_ENCODED_BYTES=2
>
> String selectFromIndex = "SELECT long_pk, varchar_pk, long_col1, long_col2
> FROM " + fullTableName + " where a.long_col1=2 and b.long_col2=3";
> rs = conn.createStatement().executeQuery("EXPLAIN " + selectFromIndex);
> assertTrue(QueryUtil.getExplainPlan(rs).contains(indexName));
> rs = conn.createStatement().executeQuery(selectFromIndex);
> assertTrue(rs.next());
> This test fails since the result set is empty.
> The same query that runs with /*+ NO_INDEX */ hint, returns results
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
