You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2016/02/06 01:18:22 UTC
[1/2] incubator-trafodion git commit: TRAFODION-1798- Enable DDL
transaction infrastructure by default. This is Step 0 ( of 4 steps ) as
outlined in the jira.
Repository: incubator-trafodion
Updated Branches:
refs/heads/master 7f33541a4 -> 30b513285
TRAFODION-1798- Enable DDL transaction infrastructure by default.
This is Step 0 ( of 4 steps ) as outlined in the jira.
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/5ce37555
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/5ce37555
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/5ce37555
Branch: refs/heads/master
Commit: 5ce3755555fbb1814c533f6b1331197e7959ff99
Parents: aa3deff
Author: Prashant Vasudev <pr...@esgyn.com>
Authored: Fri Feb 5 14:35:55 2016 +0000
Committer: Prashant Vasudev <pr...@esgyn.com>
Committed: Fri Feb 5 14:35:55 2016 +0000
----------------------------------------------------------------------
core/sqf/sql/scripts/genms | 2 +-
core/sql/regress/core/EXPECTED116 | 301 ++++++++++++++++++++++-----
core/sql/regress/core/FILTER116 | 33 +++
core/sql/regress/core/TEST116 | 55 +++--
core/sql/regress/tools/runregr_core.ksh | 4 +-
5 files changed, 329 insertions(+), 66 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5ce37555/core/sqf/sql/scripts/genms
----------------------------------------------------------------------
diff --git a/core/sqf/sql/scripts/genms b/core/sqf/sql/scripts/genms
index 13839db..e06f698 100755
--- a/core/sqf/sql/scripts/genms
+++ b/core/sqf/sql/scripts/genms
@@ -31,7 +31,7 @@ echo "TM_TLOG_AUTO_FLUSH=0"
echo "TM_TLOG_DISABLE_BLOCK_CACHE=0"
echo "#TM_TLOG_MAX_VERSIONS less than 3 will be ignored"
echo "TM_TLOG_MAX_VERSIONS=5"
-echo "TM_ENABLE_DDL_TRANS=0"
+echo "TM_ENABLE_DDL_TRANS=1"
echo "TM_USE_SSCC=0"
echo "TSE_CONVERT_NOUNDO_TRANS=1"
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5ce37555/core/sql/regress/core/EXPECTED116
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTED116 b/core/sql/regress/core/EXPECTED116
index f396847..ec5d614 100644
--- a/core/sql/regress/core/EXPECTED116
+++ b/core/sql/regress/core/EXPECTED116
@@ -5,6 +5,8 @@
--- SQL operation complete.
>>
+>>-- Simple create then rollback
+>>------------------------------
>>begin work;
--- SQL operation complete.
@@ -14,20 +16,48 @@
>>create table t116t2(a2 int, c2 int, b2 char(6));
--- SQL operation complete.
->>get user hbase objects;
+>>sh `echo "exists '$TEST_SCHEMA.T116T1'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
-TRAFODION.SCH.T116T1
-TRAFODION.SCH.T116T2
+exists 'TRAFODION.SCH.T116T1'
+Table TRAFODION.SCH.T116T1 does exist
+0 row(s) in 1.2310 seconds
+
+>>sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T2'
+Table TRAFODION.SCH.T116T2 does exist
+0 row(s) in 1.2080 seconds
---- SQL operation complete.
>>rollback work;
--- SQL operation complete.
->>get user hbase objects;
+>>sh `echo "exists '$TEST_SCHEMA.T116T1'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T1'
+Table TRAFODION.SCH.T116T1 does not exist
+0 row(s) in 1.2200 seconds
+
+>>sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T2'
+Table TRAFODION.SCH.T116T2 does not exist
+0 row(s) in 1.2600 seconds
---- SQL operation complete.
>>
>>--repeat the same tables again
+>>------------------------------
>>begin work;
--- SQL operation complete.
@@ -37,20 +67,48 @@ TRAFODION.SCH.T116T2
>>create table t116t2(a2 int, c2 int, b2 char(6));
--- SQL operation complete.
->>get user hbase objects;
+>>sh `echo "exists '$TEST_SCHEMA.T116T1'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
-TRAFODION.SCH.T116T1
-TRAFODION.SCH.T116T2
+exists 'TRAFODION.SCH.T116T1'
+Table TRAFODION.SCH.T116T1 does exist
+0 row(s) in 1.2480 seconds
+
+>>sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T2'
+Table TRAFODION.SCH.T116T2 does exist
+0 row(s) in 1.1770 seconds
---- SQL operation complete.
>>rollback work;
--- SQL operation complete.
->>get user hbase objects;
+>>sh `echo "exists '$TEST_SCHEMA.T116T1'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T1'
+Table TRAFODION.SCH.T116T1 does not exist
+0 row(s) in 1.1770 seconds
+
+>>sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T2'
+Table TRAFODION.SCH.T116T2 does not exist
+0 row(s) in 1.1750 seconds
---- SQL operation complete.
>>
>>-- unique constraint
+>>---------------------
>>begin work;
--- SQL operation complete.
@@ -60,20 +118,48 @@ TRAFODION.SCH.T116T2
>>alter table t116t1 add constraint tc1 unique (c1);
--- SQL operation complete.
->>get user hbase objects;
+>>sh `echo "exists '$TEST_SCHEMA.T116T1'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
-TRAFODION.SCH.T116T1
-TRAFODION.SCH.TC1
+exists 'TRAFODION.SCH.T116T1'
+Table TRAFODION.SCH.T116T1 does exist
+0 row(s) in 1.2840 seconds
+
+>>sh `echo "exists '$TEST_SCHEMA.TC1'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.TC1'
+Table TRAFODION.SCH.TC1 does exist
+0 row(s) in 1.1420 seconds
---- SQL operation complete.
>>rollback work;
--- SQL operation complete.
->>get user hbase objects;
+>>sh `echo "exists '$TEST_SCHEMA.T116T1'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T1'
+Table TRAFODION.SCH.T116T1 does not exist
+0 row(s) in 1.2250 seconds
+
+>>sh `echo "exists '$TEST_SCHEMA.TC1'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.TC1'
+Table TRAFODION.SCH.TC1 does not exist
+0 row(s) in 1.3010 seconds
---- SQL operation complete.
>>
>>--setup two tables
+>>-------------------
>>begin work;
--- SQL operation complete.
@@ -94,12 +180,16 @@ TRAFODION.SCH.TC1
--- SQL operation complete.
>>
>>--drop table simple case
->>get user hbase objects;
+>>--------------------------
+>>sh `echo "exists '$TEST_SCHEMA.T116T1'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
-TRAFODION.SCH.T116T1
-TRAFODION.SCH.T116T2
+exists 'TRAFODION.SCH.T116T1'
+Table TRAFODION.SCH.T116T1 does exist
+0 row(s) in 1.1350 seconds
---- SQL operation complete.
>>begin work;
--- SQL operation complete.
@@ -109,18 +199,27 @@ TRAFODION.SCH.T116T2
>>commit work;
--- SQL operation complete.
->>get user hbase objects;
+>>sh `echo "exists '$TEST_SCHEMA.T116T1'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
-TRAFODION.SCH.T116T2
+exists 'TRAFODION.SCH.T116T1'
+Table TRAFODION.SCH.T116T1 does not exist
+0 row(s) in 1.1660 seconds
---- SQL operation complete.
>>
>>--drop table with rollback
->>get user hbase objects;
+>>----------------------------
+>>sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
-TRAFODION.SCH.T116T2
+exists 'TRAFODION.SCH.T116T2'
+Table TRAFODION.SCH.T116T2 does exist
+0 row(s) in 1.2350 seconds
---- SQL operation complete.
>>begin work;
--- SQL operation complete.
@@ -151,14 +250,27 @@ A1 C1 B1
*** ERROR[8822] The statement was not prepared.
+>>sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T2'
+Table TRAFODION.SCH.T116T2 does exist
+0 row(s) in 1.2070 seconds
+
>>rollback work;
--- SQL operation complete.
->>get user hbase objects;
+>>sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
-TRAFODION.SCH.T116T2
+exists 'TRAFODION.SCH.T116T2'
+Table TRAFODION.SCH.T116T2 does exist
+0 row(s) in 1.2070 seconds
---- SQL operation complete.
>>select * from t116t2;
A1 C1 B1
@@ -180,9 +292,26 @@ A1 C1 B1
--- 2 row(s) selected.
>>
->>
->>
>>--create table1 with dml, drop table2
+>>-------------------------------------
+>>sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T2'
+Table TRAFODION.SCH.T116T2 does exist
+0 row(s) in 1.1940 seconds
+
+>>sh `echo "exists '$TEST_SCHEMA.T116T3'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T3'
+Table TRAFODION.SCH.T116T3 does not exist
+0 row(s) in 1.2370 seconds
+
>>begin work;
--- SQL operation complete.
@@ -192,25 +321,69 @@ A1 C1 B1
>>insert into t116t3 values(2,2,'b');
--- 1 row(s) inserted.
->>get user hbase objects;
+>>sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
-TRAFODION.SCH.T116T2
-TRAFODION.SCH.T116T3
+exists 'TRAFODION.SCH.T116T2'
+Table TRAFODION.SCH.T116T2 does exist
+0 row(s) in 1.2660 seconds
+
+>>sh `echo "exists '$TEST_SCHEMA.T116T3'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T3'
+Table TRAFODION.SCH.T116T3 does exist
+0 row(s) in 1.1690 seconds
---- SQL operation complete.
>>drop table t116t2;
--- SQL operation complete.
>>commit work;
--- SQL operation complete.
->>get user hbase objects;
+>>sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
-TRAFODION.SCH.T116T3
+exists 'TRAFODION.SCH.T116T2'
+Table TRAFODION.SCH.T116T2 does not exist
+0 row(s) in 1.2380 seconds
+
+>>sh `echo "exists '$TEST_SCHEMA.T116T3'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T3'
+Table TRAFODION.SCH.T116T3 does exist
+0 row(s) in 1.2930 seconds
---- SQL operation complete.
>>
>>--create table1 with dml , drop table2 and rollback
+>>---------------------------------------------------
+>>sh `echo "exists '$TEST_SCHEMA.T116T3'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T3'
+Table TRAFODION.SCH.T116T3 does exist
+0 row(s) in 1.2740 seconds
+
+>>sh `echo "exists '$TEST_SCHEMA.T116T4'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T4'
+Table TRAFODION.SCH.T116T4 does not exist
+0 row(s) in 1.1730 seconds
+
>>begin work;
--- SQL operation complete.
@@ -220,12 +393,24 @@ TRAFODION.SCH.T116T3
>>insert into t116t4 values(2,2,'b');
--- 1 row(s) inserted.
->>get user hbase objects;
+>>sh `echo "exists '$TEST_SCHEMA.T116T3'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
-TRAFODION.SCH.T116T3
-TRAFODION.SCH.T116T4
+exists 'TRAFODION.SCH.T116T3'
+Table TRAFODION.SCH.T116T3 does exist
+0 row(s) in 1.1590 seconds
+
+>>sh `echo "exists '$TEST_SCHEMA.T116T4'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T4'
+Table TRAFODION.SCH.T116T4 does exist
+0 row(s) in 1.2290 seconds
---- SQL operation complete.
>>select * from t116t3;
A1 C1 B1
@@ -243,14 +428,36 @@ A1 C1 B1
*** ERROR[8822] The statement was not prepared.
+>>sh `echo "exists '$TEST_SCHEMA.T116T3'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T3'
+Table TRAFODION.SCH.T116T3 does exist
+0 row(s) in 1.3560 seconds
+
>>rollback work;
--- SQL operation complete.
->>get user hbase objects;
+>>sh `echo "exists '$TEST_SCHEMA.T116T3'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
-TRAFODION.SCH.T116T3
+exists 'TRAFODION.SCH.T116T3'
+Table TRAFODION.SCH.T116T3 does exist
+0 row(s) in 1.2320 seconds
+
+>>sh `echo "exists '$TEST_SCHEMA.T116T4'" | regrhbase.ksh >> LOG116`;
+HBase Shell; enter 'help<RETURN>' for list of supported commands.
+Type "exit<RETURN>" to leave the HBase Shell
+Version 0.98.6-cdh5.3.0, rUnknown, Tue Dec 16 19:18:44 PST 2014
+
+exists 'TRAFODION.SCH.T116T4'
+Table TRAFODION.SCH.T116T4 does not exist
+0 row(s) in 1.2680 seconds
---- SQL operation complete.
>>select * from t116t3;
A1 C1 B1
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5ce37555/core/sql/regress/core/FILTER116
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/FILTER116 b/core/sql/regress/core/FILTER116
new file mode 100755
index 0000000..0907c60
--- /dev/null
+++ b/core/sql/regress/core/FILTER116
@@ -0,0 +1,33 @@
+#! /bin/sh
+# @@@ START COPYRIGHT @@@
+#
+# 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.
+#
+# @@@ END COPYRIGHT @@@
+
+fil=$1
+if [ -z "$fil" ]; then
+ echo "Usage: $0 filename"
+ exit 1
+fi
+
+sed "
+s/0 row(s) in [0-9]\.[0-9][0-9][0-9][0-9] seconds//g
+/HBase Shell/d
+/Version/d
+" $fil
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5ce37555/core/sql/regress/core/TEST116
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/TEST116 b/core/sql/regress/core/TEST116
index acabe34..4d33130 100755
--- a/core/sql/regress/core/TEST116
+++ b/core/sql/regress/core/TEST116
@@ -42,30 +42,41 @@ log LOG116 clear;
set parserflags 131072;
control query default DDL_TRANSACTIONS 'ON';
+-- Simple create then rollback
+------------------------------
begin work;
create table t116t1(a1 int, c1 int, b1 char(6));
create table t116t2(a2 int, c2 int, b2 char(6));
-get user hbase objects;
+sh `echo "exists '$TEST_SCHEMA.T116T1'" | regrhbase.ksh >> LOG116`;
+sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
rollback work;
-get user hbase objects;
+sh `echo "exists '$TEST_SCHEMA.T116T1'" | regrhbase.ksh >> LOG116`;
+sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
--repeat the same tables again
+------------------------------
begin work;
create table t116t1(a1 int, c1 int, b1 char(6));
create table t116t2(a2 int, c2 int, b2 char(6));
-get user hbase objects;
+sh `echo "exists '$TEST_SCHEMA.T116T1'" | regrhbase.ksh >> LOG116`;
+sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
rollback work;
-get user hbase objects;
+sh `echo "exists '$TEST_SCHEMA.T116T1'" | regrhbase.ksh >> LOG116`;
+sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
-- unique constraint
+---------------------
begin work;
create table t116t1(a1 int, c1 int, b1 char(6));
alter table t116t1 add constraint tc1 unique (c1);
-get user hbase objects;
+sh `echo "exists '$TEST_SCHEMA.T116T1'" | regrhbase.ksh >> LOG116`;
+sh `echo "exists '$TEST_SCHEMA.TC1'" | regrhbase.ksh >> LOG116`;
rollback work;
-get user hbase objects;
+sh `echo "exists '$TEST_SCHEMA.T116T1'" | regrhbase.ksh >> LOG116`;
+sh `echo "exists '$TEST_SCHEMA.TC1'" | regrhbase.ksh >> LOG116`;
--setup two tables
+-------------------
begin work;
create table t116t1(a1 int, c1 int, b1 char(6));
insert into t116t1 values(1,1,'a');
@@ -74,47 +85,59 @@ insert into t116t2 values(1,1,'a');
commit work;
--drop table simple case
-get user hbase objects;
+--------------------------
+sh `echo "exists '$TEST_SCHEMA.T116T1'" | regrhbase.ksh >> LOG116`;
begin work;
drop table t116t1;
commit work;
-get user hbase objects;
+sh `echo "exists '$TEST_SCHEMA.T116T1'" | regrhbase.ksh >> LOG116`;
--drop table with rollback
-get user hbase objects;
+----------------------------
+sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
begin work;
insert into t116t2 values(3,3,'c');
select * from t116t2;
drop table t116t2;
insert into t116t2 values(1,1,'a');
select * from t116t2;
+sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
rollback work;
-get user hbase objects;
+sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
select * from t116t2;
insert into t116t2 values(1,1,'a');
select * from t116t2;
-
-
--create table1 with dml, drop table2
+-------------------------------------
+sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
+sh `echo "exists '$TEST_SCHEMA.T116T3'" | regrhbase.ksh >> LOG116`;
begin work;
create table t116t3(a1 int, c1 int, b1 char(6));
insert into t116t3 values(2,2,'b');
-get user hbase objects;
+sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
+sh `echo "exists '$TEST_SCHEMA.T116T3'" | regrhbase.ksh >> LOG116`;
drop table t116t2;
commit work;
-get user hbase objects;
+sh `echo "exists '$TEST_SCHEMA.T116T2'" | regrhbase.ksh >> LOG116`;
+sh `echo "exists '$TEST_SCHEMA.T116T3'" | regrhbase.ksh >> LOG116`;
--create table1 with dml , drop table2 and rollback
+---------------------------------------------------
+sh `echo "exists '$TEST_SCHEMA.T116T3'" | regrhbase.ksh >> LOG116`;
+sh `echo "exists '$TEST_SCHEMA.T116T4'" | regrhbase.ksh >> LOG116`;
begin work;
create table t116t4(a1 int, c1 int, b1 char(6));
insert into t116t4 values(2,2,'b');
-get user hbase objects;
+sh `echo "exists '$TEST_SCHEMA.T116T3'" | regrhbase.ksh >> LOG116`;
+sh `echo "exists '$TEST_SCHEMA.T116T4'" | regrhbase.ksh >> LOG116`;
select * from t116t3;
drop table t116t3;
insert into t116t3 values(2,2,'b');
+sh `echo "exists '$TEST_SCHEMA.T116T3'" | regrhbase.ksh >> LOG116`;
rollback work;
-get user hbase objects;
+sh `echo "exists '$TEST_SCHEMA.T116T3'" | regrhbase.ksh >> LOG116`;
+sh `echo "exists '$TEST_SCHEMA.T116T4'" | regrhbase.ksh >> LOG116`;
select * from t116t3;
insert into t116t3 values(2,2,'b');
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5ce37555/core/sql/regress/tools/runregr_core.ksh
----------------------------------------------------------------------
diff --git a/core/sql/regress/tools/runregr_core.ksh b/core/sql/regress/tools/runregr_core.ksh
index c4e916d..d3fc649 100755
--- a/core/sql/regress/tools/runregr_core.ksh
+++ b/core/sql/regress/tools/runregr_core.ksh
@@ -135,7 +135,7 @@ if [ "$REGRCONCURRENT" -ne 0 ]; then
else
# sequential execution
export TEST_CATALOG='cat'
- export TEST_SCHEMA_NAME='sch'
+ export TEST_SCHEMA_NAME='SCH'
fi
seabase=0
@@ -302,7 +302,7 @@ skipTheseTests="TEST007 TEST030 TEST035 TEST040 TEST043 TEST050 TEST066 TEST113
# TEST051 TEST070
skipTheseTests="$skipTheseTests TEST051 TEST070"
-skipTheseTests="$skipTheseTests TEST082 TEST088 TEST116"
+skipTheseTests="$skipTheseTests TEST082 TEST088"
if [ "$SQ_COVERAGE" = "" -a "$SQ_COVERAGE_OPTIMIZER" = "" ]; then
skipTheseTests="$skipTheseTests TESTNAHEAP"
[2/2] incubator-trafodion git commit: Merge [TRAFODION-1798] PR 309
Enable DDL transactions
Posted by db...@apache.org.
Merge [TRAFODION-1798] PR 309 Enable DDL transactions
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/30b51328
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/30b51328
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/30b51328
Branch: refs/heads/master
Commit: 30b513285a79ba5c808dc3e6c3bde0247e253c52
Parents: 7f33541 5ce3755
Author: Dave Birdsall <db...@apache.org>
Authored: Sat Feb 6 00:17:35 2016 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Sat Feb 6 00:17:35 2016 +0000
----------------------------------------------------------------------
core/sqf/sql/scripts/genms | 2 +-
core/sql/regress/core/EXPECTED116 | 301 ++++++++++++++++++++++-----
core/sql/regress/core/FILTER116 | 33 +++
core/sql/regress/core/TEST116 | 55 +++--
core/sql/regress/tools/runregr_core.ksh | 4 +-
5 files changed, 329 insertions(+), 66 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/30b51328/core/sqf/sql/scripts/genms
----------------------------------------------------------------------
diff --cc core/sqf/sql/scripts/genms
index 8357a88,e06f698..845058a
--- a/core/sqf/sql/scripts/genms
+++ b/core/sqf/sql/scripts/genms
@@@ -31,9 -31,8 +31,9 @@@ echo "TM_TLOG_AUTO_FLUSH=0
echo "TM_TLOG_DISABLE_BLOCK_CACHE=0"
echo "#TM_TLOG_MAX_VERSIONS less than 3 will be ignored"
echo "TM_TLOG_MAX_VERSIONS=5"
- echo "TM_ENABLE_DDL_TRANS=0"
+ echo "TM_ENABLE_DDL_TRANS=1"
echo "TM_USE_SSCC=0"
+echo "TM_IDTMSRV_REFRESH_DELAY_SECONDS=3"
echo "TSE_CONVERT_NOUNDO_TRANS=1"