[jira] [Created] (PHOENIX-2294) Recreating a non-txn table as a txn table fails.

["Thomas D'Silva (JIRA)" <ji...@apache.org>]

Thomas D'Silva created PHOENIX-2294:
---------------------------------------

             Summary: Recreating a non-txn table as a txn table fails.
                 Key: PHOENIX-2294
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2294
             Project: Phoenix
          Issue Type: Sub-task
            Reporter: Thomas D'Silva
            Assignee: Thomas D'Silva


@Test
public void testReCreateTxnTableAfterDroppingExistingNonTxnTable()
throws SQLException {
Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
        Connection conn = DriverManager.getConnection(getUrl(), props);
        conn.setAutoCommit(false);
        Statement stmt = conn.createStatement();
stmt.execute("CREATE TABLE DEMO(k VARCHAR PRIMARY KEY, v1 VARCHAR, v2
VARCHAR)");
        stmt.execute("DROP TABLE DEMO");
        stmt.execute("CREATE TABLE DEMO(k VARCHAR PRIMARY KEY, v1
VARCHAR, v2 VARCHAR) TRANSACTIONAL=true");
        stmt.execute("CREATE INDEX DEMO_idx ON DEMO (v1) INCLUDE(v2)");
}



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