[PHOENIX-1298] Queries on fixed width type columns that have an index declared on them don't use that index

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.2.0, 3.2.0
• Fix Version/s: 4.2.0, 3.2.0
• Assignee: Samarth Jain
• Reporter: Samarth Jain
• Created: 26/Sep/14 23:27
• Updated: 21/Nov/15 02:17
• Resolved: 27/Sep/14 04:21

Description

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.

@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)");
        PhoenixStatement stmt = conn.createStatement().unwrap(PhoenixStatement.class);
        String query = "select * from t where v1 = '1'";
        QueryPlan plan = stmt.optimizeQuery(query);
        assertEquals("IDX", plan.getTableRef().getTable().getTableName().getString());
    }
 

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