jira TRAFODION-2234 turn aligned format on, phase 1 This is phase 1 of aligned format change.
Dev regressions now run with aligned format tables. To test both hbase and aligned format, some tests have explicit specification to create hbase format tables. Tests that test for features that are currently only available with hbase format (like pushdown sel expr) create hbase format tables. Many expected files have been updated to reflect aligned format, mostly in showddl and explain output. Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/af1b8e36 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/af1b8e36 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/af1b8e36 Branch: refs/heads/master Commit: af1b8e362b29831dd7b63f3b95467681794ddb47 Parents: 552b949 Author: Anoop Sharma <anoop.sha...@esgyn.com> Authored: Wed Sep 21 15:41:35 2016 +0000 Committer: Anoop Sharma <anoop.sha...@esgyn.com> Committed: Wed Sep 21 15:41:35 2016 +0000 ---------------------------------------------------------------------- core/sql/regress/charsets/EXPECTED003 | 3 +- core/sql/regress/charsets/EXPECTED012 | 4 +- core/sql/regress/compGeneral/EXPECTED013.SB | 11 +- core/sql/regress/compGeneral/EXPECTED071 | 4 + core/sql/regress/compGeneral/TEST071 | 2 + core/sql/regress/core/EXPECTED029.SB | 105 +- core/sql/regress/core/EXPECTED056.SB | 9 + core/sql/regress/core/EXPECTED061.SB | 8 +- core/sql/regress/core/EXPECTED116 | 56 +- core/sql/regress/core/EXPECTEDRTS | 1362 +++++++++++----------- core/sql/regress/core/TEST116 | 6 + core/sql/regress/executor/EXPECTED013.SB | 56 +- core/sql/regress/executor/EXPECTED014.SB | 22 +- core/sql/regress/executor/EXPECTED016.SB | 14 +- core/sql/regress/executor/EXPECTED122 | 9 +- core/sql/regress/executor/EXPECTED131 | 24 +- core/sql/regress/executor/EXPECTED140 | 74 +- core/sql/regress/executor/TEST140 | 2 + core/sql/regress/qat/eqatddl01 | 3 + core/sql/regress/qat/qatddl01 | 1 + core/sql/regress/seabase/EXPECTED010 | 611 +++++----- core/sql/regress/seabase/EXPECTED011 | 14 +- core/sql/regress/seabase/EXPECTED012 | 5 +- core/sql/regress/seabase/EXPECTED016 | 56 +- core/sql/regress/seabase/EXPECTED020 | 56 +- core/sql/regress/seabase/EXPECTED025 | 32 +- core/sql/regress/seabase/EXPECTED027 | 85 +- core/sql/regress/seabase/EXPECTED031 | 23 +- core/sql/regress/seabase/EXPECTED040 | 11 + core/sql/regress/seabase/TEST010 | 2 + core/sql/regress/seabase/TEST011 | 1 + core/sql/regress/seabase/TEST027 | 1 + core/sql/regress/tools/sbdefs | 2 +- core/sql/sqlcomp/CmpSeabaseDDLmd.h | 24 + core/sql/sqlcomp/CmpSeabaseDDLrepos.h | 6 +- core/sql/sqlcomp/PrivMgrMDDefs.h | 32 +- 36 files changed, 1481 insertions(+), 1255 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/charsets/EXPECTED003 ---------------------------------------------------------------------- diff --git a/core/sql/regress/charsets/EXPECTED003 b/core/sql/regress/charsets/EXPECTED003 index 4aad76f..2becf87 100755 --- a/core/sql/regress/charsets/EXPECTED003 +++ b/core/sql/regress/charsets/EXPECTED003 @@ -12,7 +12,7 @@ >>invoke t002; -- Definition of Trafodion table TRAFODION.SCH.T002 --- Definition current Thu Feb 25 10:23:15 2016 +-- Definition current Tue Sep 20 12:51:23 2016 ( SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE @@ -28,6 +28,7 @@ CREATE TABLE TRAFODION.SCH.T002 C CHAR(10) CHARACTER SET UCS2 COLLATE DEFAULT DEFAULT NULL ) + ATTRIBUTES ALIGNED FORMAT ; --- SQL operation complete. http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/charsets/EXPECTED012 ---------------------------------------------------------------------- diff --git a/core/sql/regress/charsets/EXPECTED012 b/core/sql/regress/charsets/EXPECTED012 index d38b2df..337eec5 100755 --- a/core/sql/regress/charsets/EXPECTED012 +++ b/core/sql/regress/charsets/EXPECTED012 @@ -24,6 +24,7 @@ CREATE TABLE TRAFODION.SCH.TLONGVARCHAR0 A VARCHAR(10) CHARACTER SET UCS2 COLLATE DEFAULT DEFAULT NULL ) + ATTRIBUTES ALIGNED FORMAT ; --- SQL operation complete. @@ -34,13 +35,14 @@ CREATE TABLE TRAFODION.SCH.TLONGWVARCHAR0 A VARCHAR(50) CHARACTER SET UCS2 COLLATE DEFAULT DEFAULT NULL ) + ATTRIBUTES ALIGNED FORMAT ; --- SQL operation complete. >>invoke tlongwvarchar1; -- Definition of Trafodion table TRAFODION.SCH.TLONGWVARCHAR1 --- Definition current Thu Feb 25 10:25:29 2016 +-- Definition current Tue Sep 20 12:53:27 2016 ( SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/compGeneral/EXPECTED013.SB ---------------------------------------------------------------------- diff --git a/core/sql/regress/compGeneral/EXPECTED013.SB b/core/sql/regress/compGeneral/EXPECTED013.SB index 97143c6..7d59c34 100644 --- a/core/sql/regress/compGeneral/EXPECTED013.SB +++ b/core/sql/regress/compGeneral/EXPECTED013.SB @@ -81,6 +81,7 @@ CREATE TABLE TRAFODION.SCH.ORDERS , O_CUSTKEY INT DEFAULT NULL , PRIMARY KEY (O_ORDERKEY ASC) ) + ATTRIBUTES ALIGNED FORMAT ; -- The following index is a system created index -- @@ -111,17 +112,18 @@ CREATE TABLE TRAFODION.SCH.ORDERS1 , O_CUSTKEY INT DEFAULT NULL , PRIMARY KEY (O_ORDERKEY ASC) ) + ATTRIBUTES ALIGNED FORMAT ; -- The following index is a system created index -- -CREATE INDEX ORDERS1_998788426_4228 ON TRAFODION.SCH.ORDERS1 +CREATE INDEX ORDERS1_256625783_9645 ON TRAFODION.SCH.ORDERS1 ( O_CUSTKEY ASC ) ; ALTER TABLE TRAFODION.SCH.ORDERS1 ADD CONSTRAINT - TRAFODION.SCH.ORDERS1_998788426_4228 FOREIGN KEY + TRAFODION.SCH.ORDERS1_256625783_9645 FOREIGN KEY ( O_CUSTKEY ) @@ -140,17 +142,18 @@ CREATE TABLE TRAFODION.SCH.ORDERS2 , O_CUSTKEY INT DEFAULT NULL , PRIMARY KEY (O_ORDERKEY ASC) ) + ATTRIBUTES ALIGNED FORMAT ; -- The following index is a system created index -- -CREATE INDEX ORDERS2_498988426_4228 ON TRAFODION.SCH.ORDERS2 +CREATE INDEX ORDERS2_838925783_9645 ON TRAFODION.SCH.ORDERS2 ( O_CUSTKEY ASC ) ; ALTER TABLE TRAFODION.SCH.ORDERS2 ADD CONSTRAINT - TRAFODION.SCH.ORDERS2_498988426_4228 FOREIGN KEY + TRAFODION.SCH.ORDERS2_838925783_9645 FOREIGN KEY ( O_CUSTKEY ) http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/compGeneral/EXPECTED071 ---------------------------------------------------------------------- diff --git a/core/sql/regress/compGeneral/EXPECTED071 b/core/sql/regress/compGeneral/EXPECTED071 index fe3fea5..2e8f767 100644 --- a/core/sql/regress/compGeneral/EXPECTED071 +++ b/core/sql/regress/compGeneral/EXPECTED071 @@ -6,6 +6,10 @@ --- SQL operation complete. >> +>>cqd traf_aligned_row_format 'OFF'; + +--- SQL operation complete. +>> >>-- table with identity column >>create table mtd00(id smallint unsigned GENERATED BY DEFAULT AS IDENTITY not >>null, +> sname varchar(50) not null, http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/compGeneral/TEST071 ---------------------------------------------------------------------- diff --git a/core/sql/regress/compGeneral/TEST071 b/core/sql/regress/compGeneral/TEST071 index cf42391..50fdbec 100644 --- a/core/sql/regress/compGeneral/TEST071 +++ b/core/sql/regress/compGeneral/TEST071 @@ -40,6 +40,8 @@ drop schema mtd cascade; create schema mtd; set schema mtd; +cqd traf_aligned_row_format 'OFF'; + -- table with identity column create table mtd00(id smallint unsigned GENERATED BY DEFAULT AS IDENTITY not null, sname varchar(50) not null, http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/core/EXPECTED029.SB ---------------------------------------------------------------------- diff --git a/core/sql/regress/core/EXPECTED029.SB b/core/sql/regress/core/EXPECTED029.SB index 9b3005f..9ade331 100755 --- a/core/sql/regress/core/EXPECTED029.SB +++ b/core/sql/regress/core/EXPECTED029.SB @@ -11,7 +11,7 @@ >> >>showddl T29x; -CREATE TABLE CAT.SCH.T29X +CREATE TABLE TRAFODION.SCH.T29X ( A INT DEFAULT 10 NOT NULL NOT DROPPABLE , B INT DEFAULT NULL @@ -20,6 +20,7 @@ CREATE TABLE CAT.SCH.T29X , D INT DEFAULT 1 , E INT DEFAULT 0 ) + ATTRIBUTES ALIGNED FORMAT ; ALTER TABLE TRAFODION.SCH.T29X ADD CONSTRAINT TRAFODION.SCH." T29x" CHECK @@ -90,8 +91,8 @@ CREATE VIEW TRAFODION.SCH.T29XV3 (S, R, D) AS >> >>showddl T29xv4; -CREATE VIEW SEABASE.SCH.T29XV4 AS - SELECT X.S, X.R, X.D FROM SEABASE.SCH.T29XV3 X WHERE X.R > 5 ; +CREATE VIEW TRAFODION.SCH.T29XV4 AS + SELECT X.S, X.R, X.D FROM TRAFODION.SCH.T29XV3 X WHERE X.R > 5 ; --- SQL operation complete. >> @@ -112,7 +113,7 @@ CREATE VIEW SEABASE.SCH.T29XV4 AS >> >>insert into T29x(a,b,c,d) values (8,8,'d',-1); -*** ERROR[8101] The operation is prevented by check constraint CAT.SCH." T29x" on table CAT.SCH.T29X. +*** ERROR[8101] The operation is prevented by check constraint TRAFODION.SCH." T29x" on table TRAFODION.SCH.T29X. --- 0 row(s) inserted. >> -- violates T29X constraint (a<>b) @@ -173,37 +174,37 @@ S R D >> >>insert into T29xv3 default values; -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV3. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV3. --- 0 row(s) inserted. >> -- null value in B violates v2 WCO >>insert into T29xv3(r,s,d) values(10,11,-1); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV3. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV3. --- 0 row(s) inserted. >> -- violates v3 WCO >>insert into T29xv3(r,s,d) values(1,0,-1); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV3. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV3. --- 0 row(s) inserted. >> -- violates v2 WCO >>insert into T29xv3(r,s,d) values(-1,0,0); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV3. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV3. --- 0 row(s) inserted. >> -- violates v1 cascaded WCO >>insert into T29xv3(r,s,d) values(1,1,-1); -*** ERROR[8101] The operation is prevented by check constraint CAT.SCH." T29x" on table CAT.SCH.T29X. +*** ERROR[8101] The operation is prevented by check constraint TRAFODION.SCH." T29x" on table TRAFODION.SCH.T29X. --- 0 row(s) inserted. >> -- violates T29X constraint >>insert into T29xv3(r,s,d) values(null,1,-1); -*** ERROR[4122] NULL cannot be assigned to NOT NULL column CAT.SCH.T29X.A. +*** ERROR[4122] NULL cannot be assigned to NOT NULL column TRAFODION.SCH.T29X.A. *** ERROR[8822] The statement was not prepared. @@ -247,31 +248,31 @@ A B C D E >> >>insert into T29xv4(r,s,d) values(10,11,-1); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV3. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV3. --- 0 row(s) inserted. >> -- violates v3 WCO >>insert into T29xv4(r,s,d) values(1,0,-1); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV3. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV3. --- 0 row(s) inserted. >> -- violates v2 WCO >>insert into T29xv4(r,s,d) values(-1,0,0); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV3. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV3. --- 0 row(s) inserted. >> -- violates v1 cascaded WCO >>insert into T29xv4(r,s,d) values(1,1,-1); -*** ERROR[8101] The operation is prevented by check constraint CAT.SCH." T29x" on table CAT.SCH.T29X. +*** ERROR[8101] The operation is prevented by check constraint TRAFODION.SCH." T29x" on table TRAFODION.SCH.T29X. --- 0 row(s) inserted. >> -- violates T29X constraint >>insert into T29xv4(r,s,d) values(null,1,-1); -*** ERROR[4122] NULL cannot be assigned to NOT NULL column CAT.SCH.T29X.A. +*** ERROR[4122] NULL cannot be assigned to NOT NULL column TRAFODION.SCH.T29X.A. *** ERROR[8822] The statement was not prepared. @@ -330,31 +331,31 @@ A B C D E >> >>insert into T29xv2 default values; -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV2. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV2. --- 0 row(s) inserted. >> -- null value in B violates v2 WCO >>insert into T29xv2 values(99,0,'c',1); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV2. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV2. --- 0 row(s) inserted. >> -- violates v2 WCO >>insert into T29xv2 values(1,0,'c',1); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV2. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV2. --- 0 row(s) inserted. >> -- violates v2 WCO >>insert into T29xv2 values(1,1,'c',-1); -*** ERROR[8101] The operation is prevented by check constraint CAT.SCH." T29x" on table CAT.SCH.T29X. +*** ERROR[8101] The operation is prevented by check constraint TRAFODION.SCH." T29x" on table TRAFODION.SCH.T29X. --- 0 row(s) inserted. >> -- violates T29X >>insert into T29xv2 values(null,1,'c',-1); -*** ERROR[4122] NULL cannot be assigned to NOT NULL column CAT.SCH.T29X.A. +*** ERROR[4122] NULL cannot be assigned to NOT NULL column TRAFODION.SCH.T29X.A. *** ERROR[8822] The statement was not prepared. @@ -371,7 +372,7 @@ A B C D E >> -- ok >>insert into T29xv2 values(19,20,'a',0); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV2. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV2. --- 0 row(s) inserted. >> -- violates v1 cascaded WCO @@ -439,19 +440,19 @@ A B C D E >> -- ok >>insert into T29xv1(z,b,c,d) values(-99,0,'d',1); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV0. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV0. --- 0 row(s) inserted. >> -- violates v0 constraint >>insert into T29xv1(z,b,c,d) values(1,1,'d',-1); -*** ERROR[8101] The operation is prevented by check constraint CAT.SCH." T29x" on table CAT.SCH.T29X. +*** ERROR[8101] The operation is prevented by check constraint TRAFODION.SCH." T29x" on table TRAFODION.SCH.T29X. --- 0 row(s) inserted. >> -- violates T29X constraint >>insert into T29xv1(z,b,c,d) values(null,1,'d',-1); -*** ERROR[4122] NULL cannot be assigned to NOT NULL column CAT.SCH.T29X.A. +*** ERROR[4122] NULL cannot be assigned to NOT NULL column TRAFODION.SCH.T29X.A. *** ERROR[8822] The statement was not prepared. @@ -503,25 +504,25 @@ A B C D E >> >>update T29xv3 set r=10; -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV3. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV3. --- 0 row(s) updated. >> -- violates v2 >>update T29xv3 set r=10,s=11; -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV3. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV3. --- 0 row(s) updated. >> -- violates v3 >>update T29xv3 set r=s+1; -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV3. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV3. --- 0 row(s) updated. >> -- violates v2 >>update T29xv3 set r=0,d=0 where r=9; -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV3. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV3. --- 0 row(s) updated. >> -- violates v1 cascaded WCO @@ -531,13 +532,13 @@ A B C D E >> -- ok, result is rows (r=2,s=13),() >>update T29xv3 set r=s-1,s=s+10; -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV3. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV3. --- 0 row(s) updated. >> -- violates v3 >>update T29xv3 set r=null; -*** ERROR[4122] NULL cannot be assigned to NOT NULL column CAT.SCH.T29X.A. +*** ERROR[4122] NULL cannot be assigned to NOT NULL column TRAFODION.SCH.T29X.A. *** ERROR[8822] The statement was not prepared. @@ -550,13 +551,13 @@ A B C D E >> -- violates notnull >>update T29xv3 set s=null; -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XV3. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XV3. --- 0 row(s) updated. >> -- violates v2 WCO >>update T29xv3 set s=2; -*** ERROR[8101] The operation is prevented by check constraint CAT.SCH." T29x" on table CAT.SCH.T29X. +*** ERROR[8101] The operation is prevented by check constraint TRAFODION.SCH." T29x" on table TRAFODION.SCH.T29X. --- 0 row(s) updated. >> -- violates T29X @@ -644,7 +645,7 @@ A B C D E >> -- 11+1 rows >>delete from T29xv2 where c like 'f%'; -*** ERROR[4001] Column C is not found. Tables in scope: CAT.SCH.T29XV2. Default schema: CAT.SCH. +*** ERROR[4001] Column C is not found. Tables in scope: TRAFODION.SCH.T29XV2. Default schema: TRAFODION.SCH. *** ERROR[8822] The statement was not prepared. @@ -733,11 +734,11 @@ CREATE VIEW TRAFODION.SCH.T29XVRN2 AS --- SQL operation complete. >> showddl T29xvRN3; -CREATE VIEW SEABASE.SCH.T29XVRN3 AS +CREATE VIEW TRAFODION.SCH.T29XVRN3 AS SELECT O.A, O.B, O.E FROM (SELECT I.A, I.B, I.C, I.D, I.E FROM (SELECT - SEABASE.SCH.T29X.A, SEABASE.SCH.T29X.B, SEABASE.SCH.T29X.C, - SEABASE.SCH.T29X.D, SEABASE.SCH.T29X.E FROM SEABASE.SCH.T29X WHERE - SEABASE.SCH.T29X.A > 1) I WHERE I.A < 10) O WHERE O.A <> O.B WITH CHECK + TRAFODION.SCH.T29X.A, TRAFODION.SCH.T29X.B, TRAFODION.SCH.T29X.C, + TRAFODION.SCH.T29X.D, TRAFODION.SCH.T29X.E FROM TRAFODION.SCH.T29X WHERE + TRAFODION.SCH.T29X.A > 1) I WHERE I.A < 10) O WHERE O.A <> O.B WITH CHECK OPTION ; --- SQL operation complete. @@ -760,7 +761,7 @@ CREATE VIEW TRAFODION.SCH.T29XVRN4 AS >> >>insert into T29xvRN1(a,b) values(1,1); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XVRN1. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XVRN1. --- 0 row(s) inserted. >> -- fail @@ -770,13 +771,13 @@ CREATE VIEW TRAFODION.SCH.T29XVRN4 AS >> -- ok >>insert into T29xvRN2(a,b) values(1,1); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XVRN2. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XVRN2. --- 0 row(s) inserted. >> -- fail >>insert into T29xvRN2(a,b) values(11,11); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XVRN2. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XVRN2. --- 0 row(s) inserted. >> -- fail @@ -786,19 +787,19 @@ CREATE VIEW TRAFODION.SCH.T29XVRN4 AS >> -- ok >>insert into T29xvRN3(a,b) values(1,1); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XVRN3. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XVRN3. --- 0 row(s) inserted. >> -- fail >>insert into T29xvRN3(a,b) values(11,11); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XVRN3. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XVRN3. --- 0 row(s) inserted. >> -- fail >>insert into T29xvRN3(a,b) values(9,9); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XVRN3. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XVRN3. --- 0 row(s) inserted. >> -- fail @@ -808,25 +809,25 @@ CREATE VIEW TRAFODION.SCH.T29XVRN4 AS >> -- ok >>insert into T29xvRN4(a,b) values(8,9); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XVRN4. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XVRN4. --- 0 row(s) inserted. >> -- fail >>insert into T29xvRN4(a,b,e) values(1,1,1); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XVRN4. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XVRN4. --- 0 row(s) inserted. >> -- fail >>insert into T29xvRN4(a,b,e) values(11,11,1); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XVRN4. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XVRN4. --- 0 row(s) inserted. >> -- fail >>insert into T29xvRN4(a,b,e) values(9,9,1); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XVRN4. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XVRN4. --- 0 row(s) inserted. >> -- fail @@ -836,7 +837,7 @@ CREATE VIEW TRAFODION.SCH.T29XVRN4 AS >> -- ok >>insert into T29xvRN4(a,b,e) values(7,9,5); -*** ERROR[8105] The operation is prevented by the check option on view CAT.SCH.T29XVRN4. +*** ERROR[8105] The operation is prevented by the check option on view TRAFODION.SCH.T29XVRN4. --- 0 row(s) inserted. >> -- fail @@ -984,7 +985,7 @@ A >>-- BindRelExpr fix >>select * from T29MISCA a, (select * from T29MISCB b where a.a=b.a) x; -*** ERROR[4002] Column A.A is not found. Table A not exposed. Tables in scope: B. Default schema: CAT.SCH. +*** ERROR[4002] Column A.A is not found. Table A not exposed. Tables in scope: B. Default schema: TRAFODION.SCH. *** ERROR[8822] The statement was not prepared. @@ -1046,21 +1047,21 @@ SK A >>-- TableNameMap fix >>select count(*) from T29MISCA, T29MISCA; -*** ERROR[4056] Exposed name CAT.SCH.T29MISCA appears more than once. +*** ERROR[4056] Exposed name TRAFODION.SCH.T29MISCA appears more than once. *** ERROR[8822] The statement was not prepared. >>-- 4056 >>select count(*) from T29MISCA T29MISCA, T29MISCA; -*** ERROR[4057] Correlation name T29MISCA conflicts with qualified identifier of table CAT.SCH.T29MISCA. +*** ERROR[4057] Correlation name T29MISCA conflicts with qualified identifier of table TRAFODION.SCH.T29MISCA. *** ERROR[8822] The statement was not prepared. >>-- 4057 >>select count(*) from T29MISCA, T29MISCA T29MISCA; -*** ERROR[4057] Correlation name T29MISCA conflicts with qualified identifier of table CAT.SCH.T29MISCA. +*** ERROR[4057] Correlation name T29MISCA conflicts with qualified identifier of table TRAFODION.SCH.T29MISCA. *** ERROR[8822] The statement was not prepared. http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/core/EXPECTED056.SB ---------------------------------------------------------------------- diff --git a/core/sql/regress/core/EXPECTED056.SB b/core/sql/regress/core/EXPECTED056.SB index 9ea76a1..e574132 100755 --- a/core/sql/regress/core/EXPECTED056.SB +++ b/core/sql/regress/core/EXPECTED056.SB @@ -6,6 +6,7 @@ CREATE TABLE TRAFODION.SCH.T056T10 SWALLOW INT DEFAULT 121 NOT NULL NOT DROPPABLE , BARNOWL INT DEFAULT 1000 NOT NULL NOT DROPPABLE ) + ATTRIBUTES ALIGNED FORMAT ; CREATE UNIQUE INDEX T056IN5 ON TRAFODION.SCH.T056T10 @@ -29,6 +30,7 @@ CREATE TABLE TRAFODION.SCH.T056T11 , BLACKBIRD INT DEFAULT NULL , PRIMARY KEY (WREN ASC, JUNCO ASC) ) + ATTRIBUTES ALIGNED FORMAT ; CREATE UNIQUE INDEX T056IN6 ON TRAFODION.SCH.T056T11 @@ -111,6 +113,7 @@ CREATE TABLE TRAFODION.SCH.T056T10 , GOSLING INT DEFAULT 700 HEADING 'goose' /*added_col*/ ) + ATTRIBUTES ALIGNED FORMAT ; -- The following index is a system created index -- @@ -148,6 +151,7 @@ CREATE TABLE TRAFODION.SCH.T056T11 , ROBIN INT DEFAULT 410 /*added_col*/ , PRIMARY KEY (WREN ASC, JUNCO ASC) ) + ATTRIBUTES ALIGNED FORMAT ; CREATE UNIQUE INDEX T056IN6 ON TRAFODION.SCH.T056T11 @@ -2036,6 +2040,7 @@ CREATE TABLE TRAFODION.SCH.T056T57 A1 NUMERIC(2, 2) DEFAULT 0 NOT NULL NOT DROPPABLE ) + ATTRIBUTES ALIGNED FORMAT ; --- SQL operation complete. @@ -2061,6 +2066,7 @@ CREATE TABLE TRAFODION.SCH.T056T58 A1 DECIMAL(4, 4) DEFAULT -0.0000 NOT NULL NOT DROPPABLE ) + ATTRIBUTES ALIGNED FORMAT ; --- SQL operation complete. @@ -2086,6 +2092,7 @@ CREATE TABLE TRAFODION.SCH.T056T59 A1 DECIMAL(3, 3) DEFAULT -0000.12 NOT NULL NOT DROPPABLE ) + ATTRIBUTES ALIGNED FORMAT ; --- SQL operation complete. @@ -2111,6 +2118,7 @@ CREATE TABLE TRAFODION.SCH.T056T60 A1 NUMERIC(2, 2) UNSIGNED DEFAULT 0.00 NOT NULL NOT DROPPABLE ) + ATTRIBUTES ALIGNED FORMAT ; --- SQL operation complete. @@ -2136,6 +2144,7 @@ CREATE TABLE TRAFODION.SCH.T056T61 A1 NUMERIC(2, 2) DEFAULT -0.0 NOT NULL NOT DROPPABLE ) + ATTRIBUTES ALIGNED FORMAT ; --- SQL operation complete. http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/core/EXPECTED061.SB ---------------------------------------------------------------------- diff --git a/core/sql/regress/core/EXPECTED061.SB b/core/sql/regress/core/EXPECTED061.SB index f7312fd..339643e 100755 --- a/core/sql/regress/core/EXPECTED061.SB +++ b/core/sql/regress/core/EXPECTED061.SB @@ -10,7 +10,7 @@ >>invoke t2421; -- Definition of Trafodion table TRAFODION.SCH.T2421 --- Definition current Thu Feb 25 06:40:41 2016 +-- Definition current Tue Sep 20 05:37:10 2016 ( SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE @@ -48,7 +48,7 @@ A B C D E F H >>invoke t101t2; -- Definition of Trafodion table TRAFODION.SCH.T101T2 --- Definition current Thu Feb 25 06:40:43 2016 +-- Definition current Tue Sep 20 05:37:14 2016 ( SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE @@ -76,6 +76,7 @@ CREATE TABLE TRAFODION.SCH.T101T2 , C13 CHAR(21) CHARACTER SET ISO88591 COLLATE DEFAULT DEFAULT NULL ) + ATTRIBUTES ALIGNED FORMAT ; --- SQL operation complete. @@ -105,7 +106,7 @@ ab 4 abcdefghijklmnopqrstu 1 >>invoke t104t2; -- Definition of Trafodion table TRAFODION.SCH.T104T2 --- Definition current Thu Feb 25 06:40:45 2016 +-- Definition current Tue Sep 20 05:37:18 2016 ( C CHAR(15) CHARACTER SET ISO88591 COLLATE @@ -124,6 +125,7 @@ CREATE TABLE TRAFODION.SCH.T104T2 , D INT NO DEFAULT NOT NULL NOT DROPPABLE , PRIMARY KEY (C ASC, D ASC) ) + ATTRIBUTES ALIGNED FORMAT ; --- SQL operation complete. http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/core/EXPECTED116 ---------------------------------------------------------------------- diff --git a/core/sql/regress/core/EXPECTED116 b/core/sql/regress/core/EXPECTED116 index 6b82161..2c85b49 100644 --- a/core/sql/regress/core/EXPECTED116 +++ b/core/sql/regress/core/EXPECTED116 @@ -341,7 +341,7 @@ A1 C1 B1 >>invoke t116t1; -- Definition of Trafodion table TRAFODION.SCH.T116T1 --- Definition current Sat Sep 17 23:53:11 2016 +-- Definition current Wed Sep 21 03:01:46 2016 ( SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE @@ -359,7 +359,7 @@ A1 C1 B1 >>invoke t116t1; -- Definition of Trafodion table TRAFODION.SCH.T116T1 --- Definition current Sat Sep 17 23:53:11 2016 +-- Definition current Wed Sep 21 03:01:46 2016 ( SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE @@ -374,7 +374,7 @@ A1 C1 B1 >>invoke t116v1; -- Definition of Trafodion view TRAFODION.SCH.T116V1 --- Definition current Sat Sep 17 23:53:11 2016 +-- Definition current Wed Sep 21 03:01:47 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -391,7 +391,7 @@ A1 C1 B1 >>invoke t116t1; -- Definition of Trafodion table TRAFODION.SCH.T116T1 --- Definition current Sat Sep 17 23:53:19 2016 +-- Definition current Wed Sep 21 03:01:55 2016 ( SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE @@ -406,7 +406,7 @@ A1 C1 B1 >>invoke t116v1; -- Definition of Trafodion view TRAFODION.SCH.T116V1 --- Definition current Sat Sep 17 23:53:19 2016 +-- Definition current Wed Sep 21 03:01:56 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -423,7 +423,7 @@ A1 C1 B1 >>invoke t116t1; -- Definition of Trafodion table TRAFODION.SCH.T116T1 --- Definition current Sat Sep 17 23:53:22 2016 +-- Definition current Wed Sep 21 03:01:59 2016 ( SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE @@ -438,7 +438,7 @@ A1 C1 B1 >>invoke t116v1; -- Definition of Trafodion view TRAFODION.SCH.T116V1 --- Definition current Sat Sep 17 23:53:23 2016 +-- Definition current Wed Sep 21 03:02:00 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -456,7 +456,7 @@ A1 C1 B1 >>invoke t116t1; -- Definition of Trafodion table TRAFODION.SCH.T116T1 --- Definition current Sat Sep 17 23:53:23 2016 +-- Definition current Wed Sep 21 03:02:00 2016 ( SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE @@ -471,7 +471,7 @@ A1 C1 B1 >>invoke t116v1; -- Definition of Trafodion view TRAFODION.SCH.T116V1 --- Definition current Sat Sep 17 23:53:23 2016 +-- Definition current Wed Sep 21 03:02:00 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -488,7 +488,7 @@ A1 C1 B1 >>invoke t116t1; -- Definition of Trafodion table TRAFODION.SCH.T116T1 --- Definition current Sat Sep 17 23:53:32 2016 +-- Definition current Wed Sep 21 03:02:10 2016 ( SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE @@ -503,7 +503,7 @@ A1 C1 B1 >>invoke t116v1; -- Definition of Trafodion view TRAFODION.SCH.T116V1 --- Definition current Sat Sep 17 23:53:33 2016 +-- Definition current Wed Sep 21 03:02:10 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -521,7 +521,7 @@ A1 C1 B1 >>invoke t116t1; -- Definition of Trafodion table TRAFODION.SCH.T116T1 --- Definition current Sat Sep 17 23:53:37 2016 +-- Definition current Wed Sep 21 03:02:15 2016 ( SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE @@ -536,7 +536,7 @@ A1 C1 B1 >>invoke t116v1; -- Definition of Trafodion view TRAFODION.SCH.T116V1 --- Definition current Sat Sep 17 23:53:37 2016 +-- Definition current Wed Sep 21 03:02:15 2016 ( A INT NO DEFAULT NOT NULL NOT DROPPABLE @@ -595,7 +595,7 @@ End of MXCI Session >>invoke t116t1; -- Definition of Trafodion table TRAFODION.SCH.T116T1 --- Definition current Sat Sep 17 23:53:58 2016 +-- Definition current Wed Sep 21 03:02:38 2016 ( SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE @@ -717,7 +717,7 @@ T116T1 >>invoke t116t2; -- Definition of Trafodion table TRAFODION.SCH.T116T2 --- Definition current Sat Sep 17 23:55:00 2016 +-- Definition current Wed Sep 21 03:03:44 2016 ( SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE @@ -742,7 +742,7 @@ T116T1 >>invoke t116t2; -- Definition of Trafodion table TRAFODION.SCH.T116T2 --- Definition current Sat Sep 17 23:55:13 2016 +-- Definition current Wed Sep 21 03:03:50 2016 ( SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE @@ -758,9 +758,7 @@ T116T1 --- SQL operation failed with errors. >>alter table t116t2 alter column a largeint; -*** ERROR[20125] This ALTER operation cannot be performed if a user-defined transaction has been started or AUTOCOMMIT is OFF. - ---- SQL operation failed with errors. +--- SQL operation complete. >>cleanup table t116t2; *** ERROR[20123] A user-defined transaction has been started. This DDL operation cannot be performed. @@ -772,6 +770,26 @@ T116T1 >>set transaction autocommit on; --- SQL operation complete. +>>drop table if exists t116t2; + +--- SQL operation complete. +>>create table t116t2 (a int) attribute hbase format; + +--- SQL operation complete. +>>set transaction autocommit off; + +--- SQL operation complete. +>>alter table t116t2 alter column a largeint; + +*** ERROR[20125] This ALTER operation cannot be performed if a user-defined transaction has been started or AUTOCOMMIT is OFF. + +--- SQL operation failed with errors. +>>rollback work; + +--- SQL operation complete. +>>set transaction autocommit on; + +--- SQL operation complete. >> >>-- index creation checking >>-- index creation is done with multiple transactions
