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/12/12 18:16:32 UTC
[5/6] incubator-trafodion git commit: fix potential result mismatch
caused by result order
fix potential result mismatch caused by result order
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/6cf245b8
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/6cf245b8
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/6cf245b8
Branch: refs/heads/master
Commit: 6cf245b873e784fe84edc2ce18bff2ca3246efb3
Parents: 23f578d
Author: EEDY <cq...@gmail.com>
Authored: Mon Dec 11 18:54:19 2017 +0800
Committer: EEDY <cq...@gmail.com>
Committed: Mon Dec 11 18:54:19 2017 +0800
----------------------------------------------------------------------
core/sql/regress/compGeneral/EXPECTED045 | 63 ++++++++-------------------
core/sql/regress/compGeneral/TEST045 | 4 +-
2 files changed, 19 insertions(+), 48 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6cf245b8/core/sql/regress/compGeneral/EXPECTED045
----------------------------------------------------------------------
diff --git a/core/sql/regress/compGeneral/EXPECTED045 b/core/sql/regress/compGeneral/EXPECTED045
index ab607a0..201b2a3 100644
--- a/core/sql/regress/compGeneral/EXPECTED045
+++ b/core/sql/regress/compGeneral/EXPECTED045
@@ -560,52 +560,23 @@ Task: COMPLETION Status: Ended Elapsed Time:
--- 16 row(s) loaded.
>>
->>select * from sub_limit_02 order by a,b,c ;
-
-A B C
------------ ------------------------------ ----------
-
- 1 Limit_str_01 11.23
- 1 Limit_str_01 11.23
- 1 Limit_str_01 11.23
- 1 Limit_str_01 11.23
- 1 Limit_str_01 11.23
- 1 Limit_str_01 11.23
- 1 Limit_str_01 ?
- 2 Limit_str_02 12.23
- 2 Limit_str_02 12.23
- 2 Limit_str_02 12.23
- 2 Limit_str_02 12.23
- 2 Limit_str_02 12.23
- 2 Limit_str_02 ?
-
---- 13 row(s) selected.
->>
->>select * from sub_limit_03 order by a,b,c ;
-
-A B C
------------ ------------------------------ ----------
-
- 1 Limit_str_01 11.23
- 1 Limit_str_01 11.23
- 2 Limit_str_02 12.23
- 2 Limit_str_02 12.23
- 3 Limit_str_03 13.23
- 4 Limit_str_04 14.23
- 5 Limit_str_05 15.23
- 6 Limit_str_06 16.23
- 7 Limit_str_07 17.23
- 8 Limit_str_08 18.23
- 9 Limit_str_09 19.23
- 10 Limit_str_10 20.23
- 11 Limit_str_11 21.23
- 12 Limit_str_12 22.23
- 13 Limit_str_13 23.23
- 14 Limit_str_14 24.23
- 15 Limit_str_15 25.23
- 16 Limit_str_16 26.23
-
---- 18 row(s) selected.
+>>select count(*) from sub_limit_02;
+
+(EXPR)
+--------------------
+
+ 13
+
+--- 1 row(s) selected.
+>>
+>>select count(*) from sub_limit_03;
+
+(EXPR)
+--------------------
+
+ 18
+
+--- 1 row(s) selected.
>>
>>
>>
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6cf245b8/core/sql/regress/compGeneral/TEST045
----------------------------------------------------------------------
diff --git a/core/sql/regress/compGeneral/TEST045 b/core/sql/regress/compGeneral/TEST045
index 605051c..f2d7c72 100644
--- a/core/sql/regress/compGeneral/TEST045
+++ b/core/sql/regress/compGeneral/TEST045
@@ -534,9 +534,9 @@ insert NOMVLOG into sub_limit_02 (a, b) select a, b from sub_limit_01 order by a
load into sub_limit_03 select * from sub_limit_01 limit 16;
-select * from sub_limit_02 order by a,b,c ;
+select count(*) from sub_limit_02;
-select * from sub_limit_03 order by a,b,c ;
+select count(*) from sub_limit_03;