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 <[email protected]> Authored: Mon Dec 11 18:54:19 2017 +0800 Committer: EEDY <[email protected]> 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;
