You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by rm...@apache.org on 2016/02/02 17:36:10 UTC
[1/2] incubator-trafodion git commit: Addresses executor TEST131
failure - TRAFODION-1796
Repository: incubator-trafodion
Updated Branches:
refs/heads/master 4f8bbf7e5 -> 94ac0f6f1
Addresses executor TEST131 failure - TRAFODION-1796
Executor TEST131 is failing due to a testware issue on how default
schemas are determined. This delivery fixes the failure by creating
a special schema that is created and dropped by the test.
This does not resolve the problem written up in TRAFODION-1796 but it
allows the test to run correctly in the SQL test environment.
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/8c28e0c1
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/8c28e0c1
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/8c28e0c1
Branch: refs/heads/master
Commit: 8c28e0c143363c7acad11020f7dee9ae392d41cc
Parents: 7a63602
Author: Roberta Marton <ro...@apache.org>
Authored: Mon Feb 1 21:18:17 2016 +0000
Committer: Roberta Marton <ro...@apache.org>
Committed: Mon Feb 1 21:18:17 2016 +0000
----------------------------------------------------------------------
core/sql/regress/executor/EXPECTED131 | 67 +++++++++++++++++++-----------
core/sql/regress/executor/TEST131 | 5 +++
2 files changed, 48 insertions(+), 24 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/8c28e0c1/core/sql/regress/executor/EXPECTED131
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED131 b/core/sql/regress/executor/EXPECTED131
index 63f5859..b730277 100644
--- a/core/sql/regress/executor/EXPECTED131
+++ b/core/sql/regress/executor/EXPECTED131
@@ -1,4 +1,10 @@
>>obey TEST131(setup);
+>>create schema t131sch;
+
+--- SQL operation complete.
+>>set schema t131sch;
+
+--- SQL operation complete.
>>create table t131helper (a int not null, primary key(a));
--- SQL operation complete.
@@ -51,6 +57,9 @@
>>
>>--reload new session to make sure we are not using cached histogram
>>sh sh runmxci.ksh -i "TEST131(dml)";
+>>set schema t131sch;
+
+--- SQL operation complete.
>>-- need set CQD since invoking this section using a new sh session to force statistic to be taken into account
>>-- suspect this is because histogram is cached per session and we are starting a new session, reloading Histogram...
>>cqd hbase_small_scanner 'SYSTEM';
@@ -62,7 +71,7 @@
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212320281474319626
+PLAN_ID .................. 212321106837120815
ROWS_OUT ................. 3
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t1311k where uniq >2 and uniq <5;
@@ -90,12 +99,13 @@ DESCRIPTION
embedded_arkcmp ........ used
IS_SQLCI ............... ON
LDAP_USERNAME
+ SCHEMA ................. T131SCH
HBASE_SMALL_SCANNER .... SYSTEM
GENERATE_EXPLAIN ....... ON
- ObjectUIDs ............. 2727580673292039142
- select_list ............ TRAFODION.SCH.T1311K.UNIQ,
- TRAFODION.SCH.T1311K.C1000,
- TRAFODION.SCH.T1311K.STR1
+ ObjectUIDs ............. 6569714930762029600
+ select_list ............ TRAFODION.T131SCH.T1311K.UNIQ,
+ TRAFODION.T131SCH.T1311K.C1000,
+ TRAFODION.T131SCH.T1311K.STR1
TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
@@ -109,7 +119,7 @@ DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
- scan_type .............. subset scan of table TRAFODION.SCH.T1311K
+ scan_type .............. subset scan of table TRAFODION.T131SCH.T1311K
object_type ............ Trafodion
columns ................ all
begin_keys(excl) ....... 2
@@ -128,7 +138,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212320281474426634
+PLAN_ID .................. 212321106837208060
ROWS_OUT ................ 97
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t1311k where uniq >2 and uniq <99;
@@ -156,12 +166,13 @@ DESCRIPTION
embedded_arkcmp ........ used
IS_SQLCI ............... ON
LDAP_USERNAME
+ SCHEMA ................. T131SCH
HBASE_SMALL_SCANNER .... SYSTEM
GENERATE_EXPLAIN ....... ON
- ObjectUIDs ............. 2727580673292039142
- select_list ............ TRAFODION.SCH.T1311K.UNIQ,
- TRAFODION.SCH.T1311K.C1000,
- TRAFODION.SCH.T1311K.STR1
+ ObjectUIDs ............. 6569714930762029600
+ select_list ............ TRAFODION.T131SCH.T1311K.UNIQ,
+ TRAFODION.T131SCH.T1311K.C1000,
+ TRAFODION.T131SCH.T1311K.STR1
TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
@@ -175,7 +186,7 @@ DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
- scan_type .............. subset scan of table TRAFODION.SCH.T1311K
+ scan_type .............. subset scan of table TRAFODION.T131SCH.T1311K
object_type ............ Trafodion
columns ................ all
begin_keys(excl) ....... 2
@@ -306,7 +317,7 @@ UNIQ C1000
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212320281474599375
+PLAN_ID .................. 212321106837369355
ROWS_OUT ................ 29
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t1311k where uniq >2 and uniq <30;
@@ -334,12 +345,13 @@ DESCRIPTION
embedded_arkcmp ........ used
IS_SQLCI ............... ON
LDAP_USERNAME
+ SCHEMA ................. T131SCH
HBASE_SMALL_SCANNER .... SYSTEM
GENERATE_EXPLAIN ....... ON
- ObjectUIDs ............. 2727580673292039142
- select_list ............ TRAFODION.SCH.T1311K.UNIQ,
- TRAFODION.SCH.T1311K.C1000,
- TRAFODION.SCH.T1311K.STR1
+ ObjectUIDs ............. 6569714930762029600
+ select_list ............ TRAFODION.T131SCH.T1311K.UNIQ,
+ TRAFODION.T131SCH.T1311K.C1000,
+ TRAFODION.T131SCH.T1311K.STR1
TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
@@ -353,7 +365,7 @@ DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
- scan_type .............. subset scan of table TRAFODION.SCH.T1311K
+ scan_type .............. subset scan of table TRAFODION.T131SCH.T1311K
object_type ............ Trafodion
columns ................ all
begin_keys(excl) ....... 2
@@ -372,7 +384,7 @@ DESCRIPTION
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... NOT NAMED
-PLAN_ID .................. 212320281475934791
+PLAN_ID .................. 212321106838405209
ROWS_OUT ................ 29
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from t1311kbis where uniq >2 and uniq <30;
@@ -400,12 +412,13 @@ DESCRIPTION
embedded_arkcmp ........ used
IS_SQLCI ............... ON
LDAP_USERNAME
+ SCHEMA ................. T131SCH
HBASE_SMALL_SCANNER .... SYSTEM
GENERATE_EXPLAIN ....... ON
- ObjectUIDs ............. 2727580673292041379
- select_list ............ TRAFODION.SCH.T1311KBIS.UNIQ,
- TRAFODION.SCH.T1311KBIS.C1000,
- TRAFODION.SCH.T1311KBIS.STR1
+ ObjectUIDs ............. 6569714930762031952
+ select_list ............ TRAFODION.T131SCH.T1311KBIS.UNIQ,
+ TRAFODION.T131SCH.T1311KBIS.C1000,
+ TRAFODION.T131SCH.T1311KBIS.STR1
TRAFODION_SCAN ============================ SEQ_NO 1 NO CHILDREN
@@ -419,7 +432,7 @@ DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
- scan_type .............. subset scan of table TRAFODION.SCH.T1311KBIS
+ scan_type .............. subset scan of table TRAFODION.T131SCH.T1311KBIS
object_type ............ Trafodion
columns ................ all
begin_keys(excl) ....... 2
@@ -439,6 +452,9 @@ DESCRIPTION
End of MXCI Session
>>obey TEST131(clnup);
+>>set schema t131sch;
+
+--- SQL operation complete.
>>drop table t131helper cascade;
--- SQL operation complete.
@@ -448,6 +464,9 @@ End of MXCI Session
>>drop table t1311kbis cascade;
--- SQL operation complete.
+>>drop schema t131sch cascade;
+
+--- SQL operation complete.
>>
>>
>>log;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/8c28e0c1/core/sql/regress/executor/TEST131
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/TEST131 b/core/sql/regress/executor/TEST131
index 898ddbe..2d812c5 100644
--- a/core/sql/regress/executor/TEST131
+++ b/core/sql/regress/executor/TEST131
@@ -39,12 +39,16 @@ exit;
?section clnup
+set schema t131sch;
drop table t131helper cascade;
drop table t1311k cascade;
drop table t1311kbis cascade;
+drop schema t131sch cascade;
?section setup
+create schema t131sch;
+set schema t131sch;
create table t131helper (a int not null, primary key(a));
insert into t131helper values(1);
create table t1311k (uniq int not null,
@@ -81,6 +85,7 @@ update statistics for table t1311kbis on every column sample 10 rows;
?section dml
log LOG131;
+set schema t131sch;
-- need set CQD since invoking this section using a new sh session to force statistic to be taken into account
-- suspect this is because histogram is cached per session and we are starting a new session, reloading Histogram...
cqd hbase_small_scanner 'SYSTEM';
[2/2] incubator-trafodion git commit: Merge [TRAFODION-1796] PR-299
address executor TEST131 failure
Posted by rm...@apache.org.
Merge [TRAFODION-1796] PR-299 address executor TEST131 failure
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/94ac0f6f
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/94ac0f6f
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/94ac0f6f
Branch: refs/heads/master
Commit: 94ac0f6f16f21d411512ef98eee0dbe1759d762f
Parents: 4f8bbf7 8c28e0c
Author: Roberta Marton <ro...@apache.org>
Authored: Tue Feb 2 16:35:45 2016 +0000
Committer: Roberta Marton <ro...@apache.org>
Committed: Tue Feb 2 16:35:45 2016 +0000
----------------------------------------------------------------------
core/sql/regress/executor/EXPECTED131 | 67 +++++++++++++++++++-----------
core/sql/regress/executor/TEST131 | 5 +++
2 files changed, 48 insertions(+), 24 deletions(-)
----------------------------------------------------------------------