Added RecreateTableIT
Project: http://git-wip-us.apache.org/repos/asf/phoenix/repo Commit: http://git-wip-us.apache.org/repos/asf/phoenix/commit/746c6d8e Tree: http://git-wip-us.apache.org/repos/asf/phoenix/tree/746c6d8e Diff: http://git-wip-us.apache.org/repos/asf/phoenix/diff/746c6d8e Branch: refs/heads/txn Commit: 746c6d8ea613bbab04e6ea8c1aec53496407d930 Parents: 97196e0 Author: Thomas D'Silva <[email protected]> Authored: Tue Nov 17 14:10:24 2015 -0800 Committer: Thomas D'Silva <[email protected]> Committed: Tue Nov 17 14:10:24 2015 -0800 ---------------------------------------------------------------------- .../phoenix/transactions/RecreateTableIT.java | 59 ++++++++++++++++++++ 1 file changed, 59 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/phoenix/blob/746c6d8e/phoenix-core/src/it/java/org/apache/phoenix/transactions/RecreateTableIT.java ---------------------------------------------------------------------- diff --git a/phoenix-core/src/it/java/org/apache/phoenix/transactions/RecreateTableIT.java b/phoenix-core/src/it/java/org/apache/phoenix/transactions/RecreateTableIT.java new file mode 100644 index 0000000..deb1a75 --- /dev/null +++ b/phoenix-core/src/it/java/org/apache/phoenix/transactions/RecreateTableIT.java @@ -0,0 +1,59 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ +package org.apache.phoenix.transactions; + +import static org.apache.phoenix.util.TestUtil.TEST_PROPERTIES; + +import java.sql.Connection; +import java.sql.DriverManager; +import java.sql.SQLException; +import java.sql.Statement; +import java.util.Map; +import java.util.Properties; + +import org.apache.phoenix.end2end.BaseHBaseManagedTimeIT; +import org.apache.phoenix.end2end.Shadower; +import org.apache.phoenix.query.BaseTest; +import org.apache.phoenix.util.PropertiesUtil; +import org.apache.phoenix.util.ReadOnlyProps; +import org.junit.BeforeClass; +import org.junit.Test; + +import com.google.common.collect.Maps; + +public class RecreateTableIT extends BaseTest { + + @BeforeClass + @Shadower(classBeingShadowed = BaseHBaseManagedTimeIT.class) + public static void doSetup() throws Exception { + Map<String, String> props = Maps.newHashMapWithExpectedSize(1); + setUpTestDriver(new ReadOnlyProps(props.entrySet().iterator())); + } + + @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)"); + } +}
