http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/core/TEST116
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/TEST116 b/core/sql/regress/core/TEST116
index 0cc0de4..9f380f8 100755
--- a/core/sql/regress/core/TEST116
+++ b/core/sql/regress/core/TEST116
@@ -213,6 +213,12 @@ alter table t116t2 alter column a largeint;
 cleanup table t116t2;
 rollback work;
 set transaction autocommit on;
+drop table if exists t116t2;
+create table t116t2 (a int) attribute hbase format;
+set transaction autocommit off;
+alter table t116t2 alter column a largeint;
+rollback work;
+set transaction autocommit on;
 
 -- index creation checking
 -- index creation is done with multiple transactions

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/executor/EXPECTED013.SB
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED013.SB 
b/core/sql/regress/executor/EXPECTED013.SB
index 08e8b07..1c488f3 100644
--- a/core/sql/regress/executor/EXPECTED013.SB
+++ b/core/sql/regress/executor/EXPECTED013.SB
@@ -21,7 +21,7 @@
 >>invoke t013t1;
 
 -- Definition of Trafodion table TRAFODION.T013_SCH.T013T1
--- Definition current  Sun Aug 21 05:08:36 2016
+-- Definition current  Tue Sep 20 07:20:12 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -50,7 +50,7 @@ A
 >>invoke t013t1;
 
 -- Definition of Trafodion volatile table T013T1
--- Definition current  Sun Aug 21 05:08:59 2016
+-- Definition current  Tue Sep 20 07:20:38 2016
 
   (
     A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -115,7 +115,7 @@ A
 >>invoke t013t1;
 
 -- Definition of Trafodion table TRAFODION.T013_SCH.T013T1
--- Definition current  Sun Aug 21 05:10:25 2016
+-- Definition current  Tue Sep 20 07:22:16 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -141,7 +141,7 @@ A
 >>invoke t013t1;
 
 -- Definition of Trafodion volatile table T013T1
--- Definition current  Sun Aug 21 05:10:55 2016
+-- Definition current  Tue Sep 20 07:22:52 2016
 
   (
     A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -181,7 +181,7 @@ A            B            C
 >>invoke t013t1;
 
 -- Definition of Trafodion table TRAFODION.T013_SCH.T013T1
--- Definition current  Sun Aug 21 05:11:11 2016
+-- Definition current  Tue Sep 20 07:23:09 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -204,7 +204,7 @@ A
 >>invoke t013t1;
 
 -- Definition of Trafodion volatile table T013T1
--- Definition current  Sun Aug 21 05:11:30 2016
+-- Definition current  Tue Sep 20 07:23:33 2016
 
   (
     A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -448,7 +448,7 @@ CONTROL QUERY DEFAULT
 >>invoke t013t1;
 
 -- Definition of Trafodion table TRAFODION.T013_SCH.T013T1
--- Definition current  Sun Aug 21 05:13:08 2016
+-- Definition current  Tue Sep 20 07:25:28 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -469,7 +469,7 @@ CONTROL QUERY DEFAULT
 >>invoke t013t1;
 
 -- Definition of Trafodion table TRAFODION.T013_SCH.T013T1
--- Definition current  Sun Aug 21 05:13:19 2016
+-- Definition current  Tue Sep 20 07:25:39 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -561,7 +561,7 @@ control query shape nested_join(anything,anything);
 >>invoke t013t3;
 
 -- Definition of Trafodion table TRAFODION.T013SCH1.T013T3
--- Definition current  Sun Aug 21 05:14:35 2016
+-- Definition current  Tue Sep 20 07:27:04 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -579,7 +579,7 @@ control query shape nested_join(anything,anything);
 >>invoke t013t3;
 
 -- Definition of Trafodion volatile table T013T3
--- Definition current  Sun Aug 21 05:14:51 2016
+-- Definition current  Tue Sep 20 07:27:22 2016
 
   (
     A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -595,7 +595,7 @@ control query shape nested_join(anything,anything);
 >>invoke t013t3;
 
 -- Definition of Trafodion table TRAFODION.T013SCH1.T013T3
--- Definition current  Sun Aug 21 05:15:07 2016
+-- Definition current  Tue Sep 20 07:27:40 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -618,6 +618,7 @@ CREATE VOLATILE TABLE T013T3
     A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
   , PRIMARY KEY (A ASC)
   )
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 CREATE VOLATILE INDEX T013T3I1 ON T013T3
@@ -639,6 +640,7 @@ CREATE VOLATILE TABLE T013T3
     A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
   , PRIMARY KEY (A ASC)
   )
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -661,7 +663,7 @@ CREATE VOLATILE TABLE T013T3
 >>invoke t013t3;
 
 -- Definition of Trafodion table TRAFODION.T013SCH1.T013T3
--- Definition current  Sun Aug 21 05:16:08 2016
+-- Definition current  Tue Sep 20 07:28:47 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -702,6 +704,7 @@ CREATE VOLATILE TABLE T013T1
     A                                INT DEFAULT NULL
   , PRIMARY KEY (A ASC)
   )
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -719,6 +722,7 @@ CREATE VOLATILE TABLE T013T1
     A                                INT DEFAULT NULL
   , PRIMARY KEY (A ASC)
   )
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -736,6 +740,7 @@ CREATE VOLATILE TABLE T013T1
     A                                INT DEFAULT NULL
   )
   STORE BY (A ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -757,6 +762,7 @@ CREATE VOLATILE TABLE T013T1
     A                                INT DEFAULT NULL
   , PRIMARY KEY (A ASC)
   )
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -778,6 +784,7 @@ CREATE VOLATILE TABLE T013T1
     A                                INT DEFAULT NULL
   )
   STORE BY (A ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -813,6 +820,7 @@ CREATE VOLATILE TABLE T013T1
     A                                INT DEFAULT NULL
   )
   STORE BY (A ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -833,6 +841,7 @@ CREATE VOLATILE TABLE T013T1
   , B                                INT DEFAULT NULL
   )
   STORE BY (B ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -851,6 +860,7 @@ CREATE VOLATILE TABLE T013T1
     A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
   )
   STORE BY (A ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -871,6 +881,7 @@ CREATE VOLATILE TABLE T013T1
   , B                                INT NO DEFAULT NOT NULL NOT DROPPABLE
   )
   STORE BY (B ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -894,6 +905,7 @@ CREATE VOLATILE TABLE T013T1
   , E                                INT NO DEFAULT NOT NULL NOT DROPPABLE
   )
   STORE BY (C ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -915,6 +927,7 @@ CREATE VOLATILE TABLE T013T1
   , C                                DATE NO DEFAULT NOT NULL NOT DROPPABLE
   )
   STORE BY (B ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -934,6 +947,7 @@ CREATE VOLATILE TABLE T013T1
   , B                                DATE NO DEFAULT NOT NULL NOT DROPPABLE
   )
   STORE BY (B ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -954,6 +968,7 @@ CREATE VOLATILE TABLE T013T1
       DEFAULT DEFAULT NULL
   )
   STORE BY (B ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -977,6 +992,7 @@ CREATE VOLATILE TABLE T013T1
   , D                                LARGEINT DEFAULT NULL
   )
   STORE BY (D ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -998,6 +1014,7 @@ CREATE VOLATILE TABLE T013T1
       DEFAULT DEFAULT NULL
   )
   STORE BY (B ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -1020,6 +1037,7 @@ CREATE VOLATILE TABLE T013T1
       DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
   )
   STORE BY (C ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -1037,6 +1055,7 @@ CREATE VOLATILE TABLE T013T1
   (
     A                                REAL NO DEFAULT NOT NULL NOT DROPPABLE
   )
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -1052,6 +1071,7 @@ CREATE VOLATILE TABLE T013T1
   (
     A                                REAL DEFAULT NULL
   )
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -1071,6 +1091,7 @@ CREATE VOLATILE TABLE T013T1
       DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
   )
   STORE BY (A ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -1088,6 +1109,7 @@ CREATE VOLATILE TABLE T013T1
       DEFAULT DEFAULT NULL
   )
   STORE BY (A ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -1108,6 +1130,7 @@ CREATE VOLATILE TABLE T013T1
       DEFAULT NO DEFAULT NOT NULL NOT DROPPABLE
   )
   STORE BY (B ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -1129,6 +1152,7 @@ CREATE VOLATILE TABLE T013T1
   , B                                INT NO DEFAULT NOT NULL NOT DROPPABLE
   )
   STORE BY (B ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -1148,6 +1172,7 @@ CREATE VOLATILE TABLE T013T1
   , B                                INT DEFAULT NULL
   )
   STORE BY (A ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -1167,6 +1192,7 @@ CREATE VOLATILE TABLE T013T1
   , B                                INT DEFAULT NULL
   )
   STORE BY (A ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -1188,6 +1214,7 @@ CREATE VOLATILE TABLE T013T1
   , B                                INT DEFAULT NULL
   , PRIMARY KEY (B ASC)
   )
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -1207,6 +1234,7 @@ CREATE VOLATILE TABLE T013T1
   , B                                INT NO DEFAULT NOT NULL NOT DROPPABLE
   )
   STORE BY (B ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -1230,6 +1258,7 @@ CREATE VOLATILE TABLE T013T1
   , B                                INT NO DEFAULT NOT NULL NOT DROPPABLE
   )
   STORE BY (A ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -1252,6 +1281,7 @@ CREATE VOLATILE TABLE T013T1
     B                                INT DEFAULT NULL
   )
   STORE BY (B ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -1283,7 +1313,7 @@ CREATE VOLATILE TABLE T013T1
 >>invoke t013t1;
 
 -- Definition of Trafodion table TRAFODION.T013_SCH.T013T1
--- Definition current  Sun Aug 21 05:25:42 2016
+-- Definition current  Tue Sep 20 07:39:44 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/executor/EXPECTED014.SB
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED014.SB 
b/core/sql/regress/executor/EXPECTED014.SB
index 22727a6..054e3c3 100755
--- a/core/sql/regress/executor/EXPECTED014.SB
+++ b/core/sql/regress/executor/EXPECTED014.SB
@@ -13,7 +13,7 @@
 >>invoke t014t1t;
 
 -- Definition of Trafodion table TRAFODION.SCH.T014T1T
--- Definition current  Thu Feb 25 08:03:23 2016
+-- Definition current  Tue Sep 20 07:41:13 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -41,7 +41,7 @@ A            B
 >>invoke t014t1t;
 
 -- Definition of Trafodion table TRAFODION.SCH.T014T1T
--- Definition current  Thu Feb 25 08:03:30 2016
+-- Definition current  Tue Sep 20 07:41:21 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -69,7 +69,7 @@ A            B
 >>invoke t014t1t;
 
 -- Definition of Trafodion table TRAFODION.SCH.T014T1T
--- Definition current  Thu Feb 25 08:03:35 2016
+-- Definition current  Tue Sep 20 07:41:32 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -98,7 +98,7 @@ A                     B
 >>invoke t014t1t;
 
 -- Definition of Trafodion table TRAFODION.SCH.T014T1T
--- Definition current  Thu Feb 25 08:03:42 2016
+-- Definition current  Tue Sep 20 07:41:42 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -126,7 +126,7 @@ C            D
 >>invoke t014t1t;
 
 -- Definition of Trafodion table TRAFODION.SCH.T014T1T
--- Definition current  Thu Feb 25 08:03:46 2016
+-- Definition current  Tue Sep 20 07:41:52 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -154,7 +154,7 @@ C            D
 >>invoke t014t1t;
 
 -- Definition of Trafodion table TRAFODION.SCH.T014T1T
--- Definition current  Thu Feb 25 08:03:51 2016
+-- Definition current  Tue Sep 20 07:42:01 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -183,7 +183,7 @@ C                     D
 >>invoke t014t1t;
 
 -- Definition of Trafodion table TRAFODION.SCH.T014T1T
--- Definition current  Thu Feb 25 08:03:55 2016
+-- Definition current  Tue Sep 20 07:42:12 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -212,7 +212,7 @@ C                     D
 >>invoke t014t1t;
 
 -- Definition of Trafodion table TRAFODION.SCH.T014T1T
--- Definition current  Thu Feb 25 08:04:00 2016
+-- Definition current  Tue Sep 20 07:42:21 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -243,7 +243,7 @@ A            B
 >>invoke t014t1t;
 
 -- Definition of Trafodion table TRAFODION.SCH.T014T1T
--- Definition current  Thu Feb 25 08:04:04 2016
+-- Definition current  Tue Sep 20 07:42:31 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -287,6 +287,7 @@ CREATE TABLE TRAFODION.SCH.T014T1T
   , B                                INT NO DEFAULT NOT NULL NOT DROPPABLE
   )
   STORE BY (B ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -314,6 +315,7 @@ CREATE TABLE TRAFODION.SCH.T014T1T
   , D                                INT NO DEFAULT NOT NULL NOT DROPPABLE
   )
   STORE BY (D ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -341,6 +343,7 @@ CREATE TABLE TRAFODION.SCH.T014T1T
   , D                                INT NO DEFAULT NOT NULL NOT DROPPABLE
   )
   STORE BY (D ASC)
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -367,6 +370,7 @@ CREATE TABLE TRAFODION.SCH.T014T1T
     A                                INT DEFAULT NULL
   , B                                INT NO DEFAULT 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/executor/EXPECTED016.SB
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED016.SB 
b/core/sql/regress/executor/EXPECTED016.SB
index c6306f5..2ef3ea6 100644
--- a/core/sql/regress/executor/EXPECTED016.SB
+++ b/core/sql/regress/executor/EXPECTED016.SB
@@ -68,7 +68,7 @@
 >>invoke t016t1;
 
 -- Definition of Trafodion table TRAFODION.SCH.T016T1
--- Definition current  Wed May 14 05:01:26 2014
+-- Definition current  Tue Sep 20 07:57:51 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -120,6 +120,7 @@ CREATE TABLE TRAFODION.SCH.T016T1
   , K                                NUMERIC(128, 128) DEFAULT NULL
   , L                                NUMERIC(60, 59) DEFAULT NULL
   )
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -127,7 +128,7 @@ CREATE TABLE TRAFODION.SCH.T016T1
 >>invoke t016t2;
 
 -- Definition of Trafodion table TRAFODION.SCH.T016T2
--- Definition current  Wed May 14 05:01:27 2014
+-- Definition current  Tue Sep 20 07:57:52 2016
 
   (
     A                                NUMERIC(39, 12) NO DEFAULT NOT NULL NOT
@@ -150,6 +151,7 @@ CREATE TABLE TRAFODION.SCH.T016T2
   , C                                NUMERIC(21, 21) DEFAULT NULL
   , PRIMARY KEY (A ASC, B ASC)
   )
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 --- SQL operation complete.
@@ -329,7 +331,7 @@ A                                          B                
      C
 >>invoke t016v1;
 
 -- Definition of Trafodion view TRAFODION.SCH.T016V1
--- Definition current  Wed May 14 05:01:35 2014
+-- Definition current  Tue Sep 20 07:58:02 2016
 
   (
     A                                NUMERIC(10, 0) UNSIGNED DEFAULT NULL
@@ -363,7 +365,7 @@ A                                          B                
      C
 >>invoke t016v2;
 
 -- Definition of Trafodion view TRAFODION.SCH.T016V2
--- Definition current  Wed May 14 05:01:37 2014
+-- Definition current  Tue Sep 20 07:58:04 2016
 
   (
     JJ                               NUMERIC(128, 0) UNSIGNED DEFAULT NULL
@@ -381,7 +383,7 @@ A                                          B                
      C
 >>invoke t016t2t1;
 
 -- Definition of Trafodion table TRAFODION.SCH.T016T2T1
--- Definition current  Wed May 14 05:01:40 2014
+-- Definition current  Tue Sep 20 07:58:11 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -416,7 +418,7 @@ A                                          B                
      C
 >>invoke t016t2t2;
 
 -- Definition of Trafodion table TRAFODION.SCH.T016T2T2
--- Definition current  Wed May 14 05:01:42 2014
+-- Definition current  Tue Sep 20 07:58:16 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/executor/EXPECTED122
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED122 
b/core/sql/regress/executor/EXPECTED122
index 027ada3..59d1416 100644
--- a/core/sql/regress/executor/EXPECTED122
+++ b/core/sql/regress/executor/EXPECTED122
@@ -65,7 +65,7 @@ A
 >>invoke t122t1;
 
 -- Definition of Trafodion table TRAFODION.SCH.T122T1
--- Definition current  Fri Aug  5 14:03:34 2016
+-- Definition current  Tue Sep 20 08:28:14 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -118,7 +118,7 @@ A
 >>execute s3;
 
 -- Definition of Trafodion table TRAFODION.SCH.T122T1
--- Definition current  Fri Aug  5 14:03:34 2016
+-- Definition current  Tue Sep 20 08:28:14 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -178,7 +178,7 @@ iv
 >>invoke t122t1;
 
 -- Definition of Trafodion table TRAFODION.SCH.T122T1
--- Definition current  Fri Aug  5 14:03:49 2016
+-- Definition current  Tue Sep 20 08:28:43 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -225,7 +225,7 @@ iv
 
 
 -- Definition of Trafodion table TRAFODION.SCH.T122T1
--- Definition current  Fri Aug  5 14:03:49 2016
+-- Definition current  Tue Sep 20 08:28:44 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -1225,6 +1225,7 @@ CREATE TABLE TRAFODION.SCH.T122T6
   , LARGE_2                          LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
   , PRIMARY KEY (INT_1 ASC)
   )
+ ATTRIBUTES ALIGNED FORMAT
 ;
 
 CREATE INDEX T122T6_IDX1 ON TRAFODION.SCH.T122T6

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/executor/EXPECTED131
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED131 
b/core/sql/regress/executor/EXPECTED131
index b730277..e48e481 100644
--- a/core/sql/regress/executor/EXPECTED131
+++ b/core/sql/regress/executor/EXPECTED131
@@ -71,7 +71,7 @@
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212321106837120815
+PLAN_ID .................. 212341123369312144
 ROWS_OUT ................. 3
 EST_TOTAL_COST ........... 0.01
 STATEMENT ................ select * from t1311k where uniq >2 and uniq <5;
@@ -102,7 +102,7 @@ DESCRIPTION
   SCHEMA ................. T131SCH
   HBASE_SMALL_SCANNER .... SYSTEM
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 6569714930762029600
+  ObjectUIDs ............. 2464140936984138637
   select_list ............ TRAFODION.T131SCH.T1311K.UNIQ,
                              TRAFODION.T131SCH.T1311K.C1000,
                              TRAFODION.T131SCH.T1311K.STR1
@@ -128,7 +128,7 @@ DESCRIPTION
   small_scanner .......... ON
   probes ................. 1
   rows_accessed .......... 3
-  column_retrieved ....... #1:1,#1:2,#1:3
+  column_retrieved ....... #1:1
   key_columns ............ UNIQ
   executor_predicates .... (UNIQ > 2) and (UNIQ < 5)
 
@@ -138,7 +138,7 @@ DESCRIPTION
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212321106837208060
+PLAN_ID .................. 212341123369559929
 ROWS_OUT ................ 97
 EST_TOTAL_COST ........... 0.01
 STATEMENT ................ select * from t1311k where uniq >2 and uniq <99;
@@ -169,7 +169,7 @@ DESCRIPTION
   SCHEMA ................. T131SCH
   HBASE_SMALL_SCANNER .... SYSTEM
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 6569714930762029600
+  ObjectUIDs ............. 2464140936984138637
   select_list ............ TRAFODION.T131SCH.T1311K.UNIQ,
                              TRAFODION.T131SCH.T1311K.C1000,
                              TRAFODION.T131SCH.T1311K.STR1
@@ -194,7 +194,7 @@ DESCRIPTION
   cache_size ........... 100
   probes ................. 1
   rows_accessed ......... 97
-  column_retrieved ....... #1:1,#1:2,#1:3
+  column_retrieved ....... #1:1
   key_columns ............ UNIQ
   executor_predicates .... (UNIQ > 2) and (UNIQ < 99)
 
@@ -317,7 +317,7 @@ UNIQ         C1000
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212321106837369355
+PLAN_ID .................. 212341123369831943
 ROWS_OUT ................ 29
 EST_TOTAL_COST ........... 0.01
 STATEMENT ................ select * from t1311k where uniq >2 and uniq <30;
@@ -348,7 +348,7 @@ DESCRIPTION
   SCHEMA ................. T131SCH
   HBASE_SMALL_SCANNER .... SYSTEM
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 6569714930762029600
+  ObjectUIDs ............. 2464140936984138637
   select_list ............ TRAFODION.T131SCH.T1311K.UNIQ,
                              TRAFODION.T131SCH.T1311K.C1000,
                              TRAFODION.T131SCH.T1311K.STR1
@@ -373,7 +373,7 @@ DESCRIPTION
   cache_size ........... 100
   probes ................. 1
   rows_accessed ......... 29
-  column_retrieved ....... #1:1,#1:2,#1:3
+  column_retrieved ....... #1:1
   key_columns ............ UNIQ
   executor_predicates .... (UNIQ > 2) and (UNIQ < 30)
 
@@ -384,7 +384,7 @@ DESCRIPTION
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212321106838405209
+PLAN_ID .................. 212341123371665258
 ROWS_OUT ................ 29
 EST_TOTAL_COST ........... 0.01
 STATEMENT ................ select * from t1311kbis where uniq >2 and uniq <30;
@@ -415,7 +415,7 @@ DESCRIPTION
   SCHEMA ................. T131SCH
   HBASE_SMALL_SCANNER .... SYSTEM
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 6569714930762031952
+  ObjectUIDs ............. 2464140936984140319
   select_list ............ TRAFODION.T131SCH.T1311KBIS.UNIQ,
                              TRAFODION.T131SCH.T1311KBIS.C1000,
                              TRAFODION.T131SCH.T1311KBIS.STR1
@@ -441,7 +441,7 @@ DESCRIPTION
   small_scanner .......... ON
   probes ................. 1
   rows_accessed ......... 29
-  column_retrieved ....... #1:1,#1:2,#1:3
+  column_retrieved ....... #1:1
   key_columns ............ UNIQ
   executor_predicates .... (UNIQ > 2) and (UNIQ < 30)
 

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/executor/EXPECTED140
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED140 
b/core/sql/regress/executor/EXPECTED140
index 862de36..390c05d 100644
--- a/core/sql/regress/executor/EXPECTED140
+++ b/core/sql/regress/executor/EXPECTED140
@@ -1,4 +1,8 @@
 >>obey TEST140(ddl);
+>>cqd traf_aligned_row_format 'OFF';
+
+--- SQL operation complete.
+>>
 >>create table t140helper (a int not null, primary key(a));
 
 --- SQL operation complete.
@@ -124,9 +128,9 @@ Task:  CLEANUP         Status: Started    Object: 
TRAFODION.SCH.T140C
 Task:  CLEANUP         Status: Ended      Object: TRAFODION.SCH.T140C
 Task:  PREPARATION     Status: Started    Object: TRAFODION.SCH.T140C
        Rows Processed: 2750311 
-Task:  PREPARATION     Status: Ended      ET: 00:00:45.041
+Task:  PREPARATION     Status: Ended      ET: 00:01:24.119
 Task:  COMPLETION      Status: Started    Object: TRAFODION.SCH.T140C
-Task:  COMPLETION      Status: Ended      ET: 00:00:01.911
+Task:  COMPLETION      Status: Ended      ET: 00:00:02.219
 
 --- 2750311 row(s) loaded.
 >>update statistics for table t140c on every column sample;
@@ -147,7 +151,7 @@ Task:  COMPLETION      Status: Ended      ET: 00:00:01.911
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212338343609062204
+PLAN_ID .................. 212341158264313307
 ROWS_OUT ................ 33
 EST_TOTAL_COST ........... 0.01
 STATEMENT ................ select a from t140 where b>500;
@@ -181,11 +185,11 @@ DESCRIPTION
   HBASE_SERIALIZATION .... ON
   HBASE_SMALL_SCANNER .... SYSTEM
   HBASE_FILTER_PREDS ..... 2
-  TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
+  TRAF_ALIGNED_ROW_FORMAT  OFF
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 3636762910170544433
+  ObjectUIDs ............. 6419990294398173909
   select_list ............ TRAFODION.SCH.T140.A
 
 
@@ -233,7 +237,7 @@ A
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212338343609413438
+PLAN_ID .................. 212341158264999300
 ROWS_OUT ................ 33
 EST_TOTAL_COST ........... 0.01
 STATEMENT ................ select an from t140b where b<=200;
@@ -267,11 +271,11 @@ DESCRIPTION
   HBASE_SERIALIZATION .... ON
   HBASE_SMALL_SCANNER .... SYSTEM
   HBASE_FILTER_PREDS ..... 2
-  TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
+  TRAF_ALIGNED_ROW_FORMAT  OFF
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 3636762910170544692
+  ObjectUIDs ............. 6419990294398174249
   select_list ............ TRAFODION.SCH.T140B.AN
 
 
@@ -306,7 +310,7 @@ DESCRIPTION
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212338343609602246
+PLAN_ID .................. 212341158265214353
 ROWS_OUT ................ 33
 EST_TOTAL_COST ........... 0.01
 STATEMENT ................ select an from t140 where b<=200;
@@ -340,11 +344,11 @@ DESCRIPTION
   HBASE_SERIALIZATION .... ON
   HBASE_SMALL_SCANNER .... SYSTEM
   HBASE_FILTER_PREDS ..... 2
-  TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
+  TRAF_ALIGNED_ROW_FORMAT  OFF
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 3636762910170544433
+  ObjectUIDs ............. 6419990294398173909
   select_list ............ TRAFODION.SCH.T140.AN
 
 
@@ -390,7 +394,7 @@ AN
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212338343609793981
+PLAN_ID .................. 212341158265449379
 ROWS_OUT ................ 10
 EST_TOTAL_COST ........... 0.01
 STATEMENT ................ select an from t140 where b=200 and an is not null;
@@ -424,11 +428,11 @@ DESCRIPTION
   HBASE_SERIALIZATION .... ON
   HBASE_SMALL_SCANNER .... SYSTEM
   HBASE_FILTER_PREDS ..... 2
-  TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
+  TRAF_ALIGNED_ROW_FORMAT  OFF
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 3636762910170544433
+  ObjectUIDs ............. 6419990294398173909
   select_list ............ TRAFODION.SCH.T140.AN
   input_variables ........ %(200)
 
@@ -472,7 +476,7 @@ AN
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212338343609993741
+PLAN_ID .................. 212341158265858457
 ROWS_OUT ................ 67
 EST_TOTAL_COST ........... 0.01
 STATEMENT ................ select an, a from t140 where b!=500;
@@ -506,11 +510,11 @@ DESCRIPTION
   HBASE_SERIALIZATION .... ON
   HBASE_SMALL_SCANNER .... SYSTEM
   HBASE_FILTER_PREDS ..... 2
-  TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
+  TRAF_ALIGNED_ROW_FORMAT  OFF
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 3636762910170544433
+  ObjectUIDs ............. 6419990294398173909
   select_list ............ TRAFODION.SCH.T140.AN, TRAFODION.SCH.T140.A
 
 
@@ -590,7 +594,7 @@ AN
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212338343610235075
+PLAN_ID .................. 212341158266176554
 ROWS_OUT ................ 10
 EST_TOTAL_COST ........... 0.01
 STATEMENT ................ select an from t140 where bn=201 and an is not null;
@@ -624,11 +628,11 @@ DESCRIPTION
   HBASE_SERIALIZATION .... ON
   HBASE_SMALL_SCANNER .... SYSTEM
   HBASE_FILTER_PREDS ..... 2
-  TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
+  TRAF_ALIGNED_ROW_FORMAT  OFF
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 3636762910170544433
+  ObjectUIDs ............. 6419990294398173909
   select_list ............ TRAFODION.SCH.T140.AN
   input_variables ........ %(201)
 
@@ -671,7 +675,7 @@ AN
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212338343610423954
+PLAN_ID .................. 212341158266394629
 ROWS_OUT ................ 67
 EST_TOTAL_COST ........... 0.01
 STATEMENT ................ select an, a from t140 where bn!=501;
@@ -705,11 +709,11 @@ DESCRIPTION
   HBASE_SERIALIZATION .... ON
   HBASE_SMALL_SCANNER .... SYSTEM
   HBASE_FILTER_PREDS ..... 2
-  TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
+  TRAF_ALIGNED_ROW_FORMAT  OFF
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 3636762910170544433
+  ObjectUIDs ............. 6419990294398173909
   select_list ............ TRAFODION.SCH.T140.AN, TRAFODION.SCH.T140.A
 
 
@@ -804,7 +808,7 @@ A
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212338343610685313
+PLAN_ID .................. 212341158266709439
 ROWS_OUT ................ 11
 EST_TOTAL_COST ........... 0.01
 STATEMENT ................ select an from t140 where an between 20 and 40;
@@ -838,11 +842,11 @@ DESCRIPTION
   HBASE_SERIALIZATION .... ON
   HBASE_SMALL_SCANNER .... SYSTEM
   HBASE_FILTER_PREDS ..... 2
-  TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
+  TRAF_ALIGNED_ROW_FORMAT  OFF
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 3636762910170544433
+  ObjectUIDs ............. 6419990294398173909
   select_list ............ TRAFODION.SCH.T140.AN
 
 
@@ -909,7 +913,7 @@ AN
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212338343610965450
+PLAN_ID .................. 212341158267230725
 ROWS_OUT ................. 1
 EST_TOTAL_COST ........... 0.01
 STATEMENT ................ select avg(a) from t140b;
@@ -942,14 +946,14 @@ DESCRIPTION
   HBASE_ASYNC_DROP_TABLE   OFF
   HBASE_SERIALIZATION .... ON
   HBASE_FILTER_PREDS ..... 2
-  TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
+  TRAF_ALIGNED_ROW_FORMAT  OFF
   HBASE_SMALL_SCANNER .... OFF
   PARALLEL_NUM_ESPS ...... 1
   HBASE_DOP_PARALLEL_SCAN  2
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 3636762910170544692
+  ObjectUIDs ............. 6419990294398174249
   select_list ............ cast(cast((cast((cast((cast(sum(TRAFODION.SCH.T140B.
                              A)) * cast(10000 ...0))) / cast(count(1 )))) /
                              cast(10000 ...0))))
@@ -1009,7 +1013,7 @@ DESCRIPTION
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212338343611266473
+PLAN_ID .................. 212341158267953185
 ROWS_OUT ................. 1
 EST_TOTAL_COST ........... 0.01
 STATEMENT ................ select avg(a) from t140b;
@@ -1042,14 +1046,14 @@ DESCRIPTION
   HBASE_ASYNC_DROP_TABLE   OFF
   HBASE_SERIALIZATION .... ON
   HBASE_FILTER_PREDS ..... 2
-  TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
+  TRAF_ALIGNED_ROW_FORMAT  OFF
   HBASE_SMALL_SCANNER .... OFF
   PARALLEL_NUM_ESPS ...... 1
   HBASE_DOP_PARALLEL_SCAN  1
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 3636762910170544692
+  ObjectUIDs ............. 6419990294398174249
   select_list ............ cast(cast((cast((cast((cast(sum(TRAFODION.SCH.T140B.
                              A)) * cast(10000 ...0))) / cast(count(1 )))) /
                              cast(10000 ...0))))
@@ -1105,7 +1109,7 @@ DESCRIPTION
 ------------------------------------------------------------------ PLAN SUMMARY
 MODULE_NAME .............. DYNAMICALLY COMPILED
 STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212338343611266473
+PLAN_ID .................. 212341158267953185
 ROWS_OUT ................. 1
 EST_TOTAL_COST ........... 0.01
 STATEMENT ................ select avg(a) from t140b;
@@ -1138,14 +1142,14 @@ DESCRIPTION
   HBASE_ASYNC_DROP_TABLE   OFF
   HBASE_SERIALIZATION .... ON
   HBASE_FILTER_PREDS ..... 2
-  TRAF_ALIGNED_ROW_FORMAT  OFF
   TRAF_INDEX_CREATE_OPT    ON
   SCHEMA ................. TRAFODION.SCH
+  TRAF_ALIGNED_ROW_FORMAT  OFF
   HBASE_SMALL_SCANNER .... OFF
   PARALLEL_NUM_ESPS ...... 1
   HBASE_DOP_PARALLEL_SCAN  1
   GENERATE_EXPLAIN ....... ON
-  ObjectUIDs ............. 3636762910170544692
+  ObjectUIDs ............. 6419990294398174249
   select_list ............ cast(cast((cast((cast((cast(sum(TRAFODION.SCH.T140B.
                              A)) * cast(10000 ...0))) / cast(count(1 )))) /
                              cast(10000 ...0))))

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/executor/TEST140
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/TEST140 
b/core/sql/regress/executor/TEST140
index e4ef881..06313c7 100644
--- a/core/sql/regress/executor/TEST140
+++ b/core/sql/regress/executor/TEST140
@@ -42,6 +42,8 @@ drop table t140b;
 drop table t140c;
 
 ?section ddl
+cqd traf_aligned_row_format 'OFF';
+
 create table t140helper (a int not null, primary key(a));
 insert into t140helper values(1);
 create table t140 (uniq int not null, uniq2 int not null , a int not null, b 
int not null,

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/qat/eqatddl01
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/eqatddl01 b/core/sql/regress/qat/eqatddl01
index 75c2355..561b248 100755
--- a/core/sql/regress/qat/eqatddl01
+++ b/core/sql/regress/qat/eqatddl01
@@ -11,6 +11,9 @@
 >>--            and manuals); create new datasets (e.g. to test all data
 >>--            types; to allow joins).
 >>---------------------------------------------------------------------
+>>cqd traf_aligned_row_format 'OFF';
+
+--- SQL operation complete.
 >>
 >>---------------------------------------------------------------------
 >>-- Table ORDERS.

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/af1b8e36/core/sql/regress/qat/qatddl01
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/qatddl01 b/core/sql/regress/qat/qatddl01
index 1b11f1f..fe4964c 100755
--- a/core/sql/regress/qat/qatddl01
+++ b/core/sql/regress/qat/qatddl01
@@ -12,6 +12,7 @@ LOG aqatddl01 Clear;
 --            and manuals); create new datasets (e.g. to test all data
 --            types; to allow joins).
 ---------------------------------------------------------------------
+cqd traf_aligned_row_format 'OFF';
 
 ---------------------------------------------------------------------
 -- Table ORDERS.


Reply via email to