You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Thomas D'Silva (JIRA)" <ji...@apache.org> on 2015/09/26 04:56:04 UTC
[jira] [Updated] (PHOENIX-2294) Recreating a non-txn table as a txn table fails.

     [ https://issues.apache.org/jira/browse/PHOENIX-2294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas D'Silva updated PHOENIX-2294:
------------------------------------
    Description: 
{code}
@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)");
}
{code}

  was:
@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)");
}


> 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
>
> {code}
> @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)");
> }
> {code}



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