Swaroopa Kadam created PHOENIX-6460: ---------------------------------------
Summary: Improve the optimizer to consider all plans and prefer regular over reverse scans Key: PHOENIX-6460 URL: https://issues.apache.org/jira/browse/PHOENIX-6460 Project: Phoenix Issue Type: Improvement Reporter: Swaroopa Kadam Fix For: 5.1.1, 4.17.0 In QueryOptimizerTest, following test fails, as it uses IDX over view @Test public void testChooseIndexOverTable_diffOrder() throws Exception { Connection conn = DriverManager.getConnection(getUrl()); conn.createStatement().execute("CREATE TABLE t (k INTEGER NOT NULL, v1 VARCHAR NOT NULL, v2 VARCHAR CONSTRAINT" + " PK PRIMARY KEY (k, v1)) IMMUTABLE_ROWS=true"); conn.createStatement().execute("CREATE VIEW v(v4 VARCHAR) AS SELECT * FROM t"); conn.createStatement().execute("CREATE INDEX idx ON v(v1 DESC) INCLUDE (v4)"); PhoenixStatement stmt = conn.createStatement().unwrap(PhoenixStatement.class); QueryPlan plan = stmt.optimizeQuery("SELECT v1 FROM v ORDER BY v1"); assertEquals("V", plan.getTableRef().getTable().getTableName().getString()); } -- This message was sent by Atlassian Jira (v8.3.4#803005)