[jira] [Created] (PHOENIX-1298) Queries on fixed width type columns that have an index declared on them don't use that index with Row Value Constructors.

["Samarth Jain (JIRA)" <ji...@apache.org>]

Samarth Jain created PHOENIX-1298:
-------------------------------------

             Summary: Queries on fixed width type columns that have an index declared on them don't use that index with Row Value Constructors.
                 Key: PHOENIX-1298
                 URL: https://issues.apache.org/jira/browse/PHOENIX-1298
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 5.0.0, 4.2, 3.2
            Reporter: Samarth Jain


Happens when the index is on a column whose data type is fixed width. If V1 is made of type VARCHAR, then the test passes.

{code}

@Test
    public void testRVCUsingPkColsReturnedByPlanShouldUseIndex() throws Exception {
        Connection conn = DriverManager.getConnection(getUrl());
        conn.createStatement().execute("CREATE TABLE T (k VARCHAR NOT NULL PRIMARY KEY, v1 CHAR(15), v2 VARCHAR)");
        conn.createStatement().execute("CREATE INDEX IDX ON T(v1, v2)");
        PhoenixStatement stmt = conn.createStatement().unwrap(PhoenixStatement.class);
        String query = "select * from t where (v1, v2, k) > ('1', '2', '3')";
        QueryPlan plan = stmt.optimizeQuery(query);
        assertEquals("IDX", plan.getTableRef().getTable().getTableName().getString());
    }
    
 
{code}

Instead of going through the index table, the query ends up using the data table.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)