You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by hz...@apache.org on 2017/07/26 16:02:56 UTC

[3/5] incubator-trafodion git commit: [TRAFODION-2628] Fix for regression test failures compGeneral/TEST001

[TRAFODION-2628] Fix for regression test failures compGeneral/TEST001

This test was using an obsolete CQD.


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/5605fbbd
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/5605fbbd
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/5605fbbd

Branch: refs/heads/master
Commit: 5605fbbdbb339182471f12bf7649b8bc69f76b10
Parents: d17167c
Author: Hans Zeller <hz...@apache.org>
Authored: Tue Jul 11 21:55:48 2017 +0000
Committer: Hans Zeller <hz...@apache.org>
Committed: Tue Jul 11 21:55:48 2017 +0000

----------------------------------------------------------------------
 core/sql/regress/compGeneral/EXPECTED001.SB | 15 ---------------
 core/sql/regress/compGeneral/TEST001        |  9 ---------
 2 files changed, 24 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5605fbbd/core/sql/regress/compGeneral/EXPECTED001.SB
----------------------------------------------------------------------
diff --git a/core/sql/regress/compGeneral/EXPECTED001.SB b/core/sql/regress/compGeneral/EXPECTED001.SB
index 2fb2c8e..cc2a48c 100644
--- a/core/sql/regress/compGeneral/EXPECTED001.SB
+++ b/core/sql/regress/compGeneral/EXPECTED001.SB
@@ -4807,21 +4807,6 @@ LC   RC   OP   OPERATOR              OPT       DESCRIPTION           CARD
 --- SQL command prepared.
 >>
 >>--
->>-- test NAClusterInfo::setUseAggregationNodesOnly only
->>--
->>cqd ESP_ON_AGGREGATION_NODES_ONLY 'on';
-
---- SQL operation complete.
->>
->>prepare x from select s.a from s01 s <<+ cardinality 10e7>>, t01 t <<+ cardinality 10e5>> where s.a = t.b;
-
---- SQL command prepared.
->>
->>cqd ESP_ON_AGGREGATION_NODES_ONLY reset;
-
---- SQL operation complete.
->>
->>--
 >>-- test CQD OPTIMIZER_HEURISTIC_3 'on'
 >>--
 >>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5605fbbd/core/sql/regress/compGeneral/TEST001
----------------------------------------------------------------------
diff --git a/core/sql/regress/compGeneral/TEST001 b/core/sql/regress/compGeneral/TEST001
index dfe4efa..d8f33ca 100755
--- a/core/sql/regress/compGeneral/TEST001
+++ b/core/sql/regress/compGeneral/TEST001
@@ -397,15 +397,6 @@ create table s01(a int not null, b int, c int, primary key(a));
 prepare x from select s.a from s01 s, (select t.b from t01 t group by t.b) x(u);
 
 --
--- test NAClusterInfo::setUseAggregationNodesOnly only
---
-cqd ESP_ON_AGGREGATION_NODES_ONLY 'on';
-
-prepare x from select s.a from s01 s <<+ cardinality 10e7>>, t01 t <<+ cardinality 10e5>> where s.a = t.b;
-
-cqd ESP_ON_AGGREGATION_NODES_ONLY reset;
-
---
 -- test CQD OPTIMIZER_HEURISTIC_3 'on'
 --