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

Reply via email to