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

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

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

Thomas D'Silva resolved PHOENIX-2294.
-------------------------------------
    Resolution: Fixed

> 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)