[jira] [Updated] (PHOENIX-6644) Fix column name based ResultSet getter for view indexes

["Viraj Jasani (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-6644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Viraj Jasani updated PHOENIX-6644:
----------------------------------
    Summary: Fix column name based ResultSet getter for view indexes  (was: Fix column name based ResultSet getter with view indexes)

> Fix column name based ResultSet getter for 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
>            Assignee: Saurabh Rai
>            Priority: Major
>
> 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.10#820010)