[jira] [Created] (PHOENIX-1588) TableNotFoundException when optimizing "SELECT * FROM a tenant-specific table"

["Maryann Xue (JIRA)" <ji...@apache.org>]

Maryann Xue created PHOENIX-1588:
------------------------------------

             Summary: TableNotFoundException when optimizing "SELECT * FROM a tenant-specific table"
                 Key: PHOENIX-1588
                 URL: https://issues.apache.org/jira/browse/PHOENIX-1588
             Project: Phoenix
          Issue Type: Bug
            Reporter: Maryann Xue


Testcase:
{code}

    public void testOptimizationTenantSpecific() throws Exception {
        createBaseTable(TestUtil.DEFAULT_DATA_TABLE_NAME, null, "('e','i','o')", true);
        Connection conn1 = DriverManager.getConnection(getUrl() + ';' + PhoenixRuntime.TENANT_ID_ATTRIB + "=tid1");
        try{
            conn1.createStatement().execute("UPSERT INTO " + TestUtil.DEFAULT_DATA_TABLE_NAME + " values(1,2,4,'z')");
            conn1.createStatement().execute("UPSERT INTO " + TestUtil.DEFAULT_DATA_TABLE_NAME + " values(1,2,3,'a')");
            conn1.createStatement().execute("UPSERT INTO " + TestUtil.DEFAULT_DATA_TABLE_NAME + " values(2,4,2,'a')");
            conn1.createStatement().execute("UPSERT INTO " + TestUtil.DEFAULT_DATA_TABLE_NAME + " values(3,1,1,'c')");
            conn1.commit();
            createIndex(TestUtil.DEFAULT_INDEX_TABLE_NAME, TestUtil.DEFAULT_DATA_TABLE_NAME, "v1");
            
            String query = "SELECT * FROM " + TestUtil.DEFAULT_DATA_TABLE_NAME +" where v1='a'";
            ResultSet rs = conn1.createStatement().executeQuery(query);
            assertTrue(rs.next());
            assertEquals(1, rs.getInt("k1"));
            assertEquals(2, rs.getInt("k2"));
            assertEquals(3, rs.getInt("k3"));
            assertEquals("a", rs.getString("v1"));
            assertTrue(rs.next());
            assertEquals(2, rs.getInt("k1"));
            assertEquals(4, rs.getInt("k2"));
            assertEquals(2, rs.getInt("k3"));
            assertEquals("a", rs.getString("v1"));
            assertFalse(rs.next());
        } finally {
            conn1.close();
        }
    }
{code}

Stacktrace:
org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=T
	at org.apache.phoenix.schema.PMetaDataImpl.getTable(PMetaDataImpl.java:241)
	at org.apache.phoenix.compile.ProjectionCompiler.projectAllIndexColumns(ProjectionCompiler.java:174)
	at org.apache.phoenix.compile.ProjectionCompiler.compile(ProjectionCompiler.java:330)
	at org.apache.phoenix.compile.QueryCompiler.compileSingleFlatQuery(QueryCompiler.java:490)
	at org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.java:447)
	at org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:152)
	at org.apache.phoenix.optimize.QueryOptimizer.addPlan(QueryOptimizer.java:224)
	at org.apache.phoenix.optimize.QueryOptimizer.getApplicablePlans(QueryOptimizer.java:140)
	at org.apache.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:81)
	at org.apache.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:67)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:222)
	at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:1)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:216)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:1030)
	...




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