You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by an...@apache.org on 2016/09/22 01:04:35 UTC
[3/6] incubator-trafodion git commit: jira TRAFODION-2234 turn
aligned format on, phase 1
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.