Kadir Ozdemir created PHOENIX-6644:
--------------------------------------
Summary: Column name based Result Set getter issue with view
indexes
Key: PHOENIX-6644
URL: https://issues.apache.org/jira/browse/PHOENIX-6644
Project: Phoenix
Issue Type: Improvement
Affects Versions: 5.1.2
Reporter: Kadir Ozdemir
If a column used to define the view is also a projected column in a select
clause, a view index is chosen by the Phoenix query optimizer for the select
statement, and the value of the projected column is retrieved using the column
name based ResultSet getter, Phoenix returns ColumnNotFoundException.
For example, the last assertEquals fails with
{quote}org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703):
Undefined column. columnName=V1
{quote}
in the following integration test:
{code:java}
@Test
public void test() throws Exception {
try (Connection conn = DriverManager.getConnection(getUrl())) {
conn.createStatement().execute("create table T "+
" (id INTEGER not null primary key, v1 varchar, v2 varchar, v3
varchar)");
conn.createStatement().execute("CREATE VIEW V AS SELECT * FROM T WHERE
v1 = 'a'");
conn.createStatement().execute("CREATE INDEX I ON V (v2) INCLUDE (v3)");
conn.createStatement().execute("upsert into V values (1, 'a', 'ab',
'abc')");
conn.commit();
ResultSet rs = conn.createStatement().executeQuery("SELECT v1, v3 from
V WHERE v2 = 'ab'");
assertTrue(rs.next());
assertEquals("a", rs.getString(1));
assertEquals("a", rs.getString("v1"));
}
} {code}
Without the view index, the above test passes.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
