You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by su...@apache.org on 2016/10/24 18:48:58 UTC
[1/5] incubator-trafodion git commit: [TRAFODION-2304] handle zero
records in TOPN sort + regress TEST107 update/cleanup
Repository: incubator-trafodion
Updated Branches:
refs/heads/master 44552d52e -> de82dfbb7
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5ba330e5/core/sql/regress/executor/TEST107
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/TEST107 b/core/sql/regress/executor/TEST107
index 255c70a..234b481 100644
--- a/core/sql/regress/executor/TEST107
+++ b/core/sql/regress/executor/TEST107
@@ -145,50 +145,35 @@ update statistics for table t107t2 on every column sample 1000 rows;
?section dml
-------------
-- Test #1: In memory sort ,double & copy
-control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
-control query default GEN_SORT_MAX_NUM_BUFFERS '40';
prepare xx from SELECT [last 1] c100k from t107100k order by c100k;
execute xx;
--- Test #2: SQL buffer overflow, overflow and merge
-set envvar SCRATCH_IO_PENDING 280;
-control query default EXE_BMO_DISABLE_CMP_HINTS_OVERFLOW_SORT 'ON';
-control query default GEN_SORT_MAX_BUFFER_SIZE '3276800'; -- 200 rows approx NSK
-control query default GEN_SORT_MAX_NUM_BUFFERS '40'; -- total of 8000 rows per run NSK
-prepare xx from SELECT [last 1] c100k, str1 from t107100k order by c100k;
+-- Test #1A: uses TOPN sort
+prepare xx from SELECT [first 10] c100k from t107100k order by c100k;
execute xx;
--- Test #3 - causes intermediate merge
-set envvar SCRATCH_IO_PENDING 50;
-control query default EXE_BMO_DISABLE_CMP_HINTS_OVERFLOW_SORT 'ON';
-control query default GEN_SORT_MAX_BUFFER_SIZE '3276800'; -- 200 rows approx NSK
-control query default GEN_SORT_MAX_NUM_BUFFERS '20'; -- total of 8000 rows per run NSK
-control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
-control query default SORT_MAX_HEAP_SIZE_MB '2';
-prepare xx from SELECT [last 1] c100k, str1 from t107100k order by c100k;
+-- Test#1B: negetive test, zero records to sort.
+prepare xx from SELECT c100k from t107100k where c100k < 0 order by c100k;
execute xx;
-reset envvar SCRATCH_IO_PENDING;
-#ifNSK
--- Test #4 - Test 2 with multiple opens = 4
-control query default GEN_SORT_MAX_BUFFER_SIZE '3276800'; -- 200 rows approx NSK
-control query default GEN_SORT_MAX_NUM_BUFFERS '20'; -- total of 8000 rows per run NSK
-control query default SORT_MEMORY_QUOTA_SYSTEM '';
-control query default SORT_MAX_HEAP_SIZE_MB '';
-control query default SCRATCH_MAX_OPENS_SORT '4';
-prepare xx from SELECT [last 1] c100k, str1 from t107100k order by c100k;
+-- Test#1C: negetive test, zero records to sort, TOPN
+prepare xx from SELECT [first 10] c100k from t107100k where c100k < 0 order by c100k;
execute xx;
--- Test #5 - Test 2 with multiple opens = 4, intermediate merges
-control query default GEN_SORT_MAX_BUFFER_SIZE '3276800'; -- 200 rows approx NSK
-control query default GEN_SORT_MAX_NUM_BUFFERS '20'; -- total of 8000 rows per run NSK
-control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
-control query default SORT_MAX_HEAP_SIZE_MB '2';
-control query default SCRATCH_MAX_OPENS_SORT '4';
-prepare xx from SELECT [last 1] c100k, str1 from t107100k order by c100k;
+-- Test #2: SQL buffer overflow, overflow and merge
+set envvar SCRATCH_IO_PENDING 280;
+control query default GEN_SORT_MAX_NUM_BUFFERS '1';
+prepare xx from SELECT [last 1] c100k, str1 from t107100k order by 1,2;
execute xx;
-#ifNSK
+-- Test #3 - causes intermediate merge
+set envvar SCRATCH_IO_PENDING 50;
+control query default GEN_SORT_MAX_NUM_BUFFERS '20';
+control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
+control query default GEN_SORT_MAX_NUM_BUFFERS '1';
+control query default SORT_MAX_HEAP_SIZE_MB '1';
+prepare xx from SELECT [last 1] c100k, str1 from t107100k order by 1,2;
+execute xx;
?section dml1
-------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5ba330e5/core/sql/sort/SortTopN.cpp
----------------------------------------------------------------------
diff --git a/core/sql/sort/SortTopN.cpp b/core/sql/sort/SortTopN.cpp
index 2e6351b..526e7d2 100644
--- a/core/sql/sort/SortTopN.cpp
+++ b/core/sql/sort/SortTopN.cpp
@@ -157,6 +157,10 @@ void SortTopN::buildHeap()
//Topmost node or root will be the highest.
void SortTopN::satisfyHeap()
{
+ //nothing to do if zero or one record.
+ if(runSize_ <= 1)
+ return;
+
for (int i = (runSize_/2 ); i >= 0; i--)
siftDown(topNKeys_, i, runSize_-1);
}
@@ -212,6 +216,10 @@ Lng32 SortTopN::sortSendEnd()
//----------------------------------------------------------------------
void SortTopN::sortHeap()
{
+ //nothing to do if zero or one record.
+ if(runSize_ <= 1)
+ return;
+
for (int i = runSize_-1; i >= 1; i--)
{
swap(&topNKeys_[0],&topNKeys_[i]);
[2/5] incubator-trafodion git commit: [TRAFODION-2304] handle zero
records in TOPN sort + regress TEST107 update/cleanup
Posted by su...@apache.org.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5ba330e5/core/sql/regress/executor/EXPECTED107.LINUX
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED107.LINUX b/core/sql/regress/executor/EXPECTED107.LINUX
deleted file mode 100644
index 3b37684..0000000
--- a/core/sql/regress/executor/EXPECTED107.LINUX
+++ /dev/null
@@ -1,574 +0,0 @@
->>
->>control query default ATTEMPT_ESP_PARALLELISM 'off';
-
---- SQL operation complete.
->>control query default query_cache '0';
-
---- SQL operation complete.
->>control query default EXE_DIAGNOSTIC_EVENTS 'on';
-
---- SQL operation complete.
->>
->>obey TEST107(setup);
->>---------------
->>create table t107helper (a int not null, primary key(a));
-
---- SQL operation complete.
->>insert into t107helper values (1);
-
---- 1 row(s) inserted.
->>
->>create table t107100k
-+> (uniq int not null,
-+> c100K int,
-+> str1 varchar(4000),
-+> primary key (uniq)
-+> )
-+>#ifndef SEABASE_REGRESS
-+>hash partition by(uniq)
-+>(add location $$partition1$$, add location $$partition2$$, add location $$partition3$$)
-+>#endif
-+>;
-
---- SQL operation complete.
->>
->>#ifdef SEABASE_REGRESS
->>upsert using load into
-+>#else
-+>insert into
-+>#endif
-+>t107100k
-+> select
-+> 0 + (10000 * x10000) + (1000 * x1000) + (100 * x100) + (10 * x10) + (1 * x1),
-+> 0 + (10000 * x10000) + (1000 * x1000) + (100 * x100) + (10 * x10) + (1 * x1),
-+> 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'
-+> from t107helper
-+> transpose 0,1,2,3,4,5,6,7,8,9 as x10000
-+> transpose 0,1,2,3,4,5,6,7,8,9 as x1000
-+> transpose 0,1,2,3,4,5,6,7,8,9 as x100
-+> transpose 0,1,2,3,4,5,6,7,8,9 as x10
-+> transpose 0,1,2,3,4 as x1
-+> ;
-
---- 50000 row(s) inserted.
->>update statistics for table t107100k on every column sample 1000 rows;
-
---- SQL operation complete.
->>#ifLINUX
->>create table t107t2
-+> (uniq int not null,
-+> c100K int,
-+> c100kchar char(10),
-+> vc1 varchar(800),
-+> fc1 char(255),
-+> vc2 varchar(500),
-+> fc2 char(200),
-+> vc3 varchar(600),
-+> int1 INT,
-+> lint1 LARGEINT,
-+> primary key (uniq)
-+> )
-+>#ifndef SEABASE_REGRESS
-+>hash partition by(uniq)
-+>(add location $$partition1$$, add location $$partition2$$, add location $$partition3$$)
-+>#endif
-+>;
-
---- SQL operation complete.
->>
->>control query default comp_bool_140 'on';
-
---- SQL operation complete.
->>#ifdef SEABASE_REGRESS
->>upsert using load into
-+>#else
-+>insert into
-+>#endif
-+>t107t2(uniq,c100k,c100kchar,vc1,fc1,vc2,fc2,vc3,int1,lint1)
-+>select
-+> uniq,
-+> uniq c100k,
-+> lpad(rtrim(cast(uniq as char(10))),10,'0') c100kchar,
-+> case when mod(uniq,2) = 0 then
-+> repeat('xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx',10)
-+> else
-+> repeat('xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx',5)
-+> end vc1,
-+> 'yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy' fc1,
-+> case when mod(uniq,2) =0 then
-+> repeat('zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz',6)
-+> else
-+> repeat('zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz',3)
-+> end vc2,
-+> 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' fc2,
-+>
-+> 'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb' vc3,
-+> uniq + 1000 int1,
-+> uniq*uniq lint1 FROM t107100k;
-
---- 50000 row(s) inserted.
->>
->>control query default comp_bool_140 reset;
-
---- SQL operation complete.
->>update statistics for table t107t2 on every column sample 1000 rows;
-
---- SQL operation complete.
->>#ifLINUX
->>
->>
->>obey TEST107(dml);
->>-------------
->>-- Test #1: In memory sort ,double & copy
->>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
-
---- SQL operation complete.
->>control query default GEN_SORT_MAX_NUM_BUFFERS '40';
-
---- SQL operation complete.
->>prepare xx from SELECT [last 1] c100k from t107100k order by c100k;
-
---- SQL command prepared.
->>execute xx;
-
-C100K
------------
-
- 99994
-
---- 1 row(s) selected.
->>
->>-- Test #2: SQL buffer overflow, overflow and merge
->>set envvar SCRATCH_IO_PENDING 280;
-
---- SQL operation complete.
->>control query default EXE_BMO_DISABLE_CMP_HINTS_OVERFLOW_SORT 'ON';
-
---- SQL operation complete.
->>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
-
---- SQL operation complete.
->> -- 200 rows approx NSK
->>control query default GEN_SORT_MAX_NUM_BUFFERS '40';
-
---- SQL operation complete.
->> -- total of 8000 rows per run NSK
->>prepare xx from SELECT [last 1] c100k, str1 from t107100k order by c100k;
-
---- SQL command prepared.
->>execute xx;
-
-C100K STR1
------------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------
-
- 99994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
-
---- 1 row(s) selected.
->>
->>-- Test #3 - causes intermediate merge
->>set envvar SCRATCH_IO_PENDING 50;
-
---- SQL operation complete.
->>control query default EXE_BMO_DISABLE_CMP_HINTS_OVERFLOW_SORT 'ON';
-
---- SQL operation complete.
->>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
-
---- SQL operation complete.
->> -- 200 rows approx NSK
->>control query default GEN_SORT_MAX_NUM_BUFFERS '20';
-
---- SQL operation complete.
->> -- total of 8000 rows per run NSK
->>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
-
---- SQL operation complete.
->>control query default SORT_MAX_HEAP_SIZE_MB '2';
-
---- SQL operation complete.
->>prepare xx from SELECT [last 1] c100k, str1 from t107100k order by c100k;
-
---- SQL command prepared.
->>execute xx;
-
-C100K STR1
------------ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------
-
- 99994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
-
---- 1 row(s) selected.
->>reset envvar SCRATCH_IO_PENDING;
-
---- SQL operation complete.
->>
->>#ifNSK
->>-- Test #4 - Test 2 with multiple opens = 4
->>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
->> -- 200 rows approx NSK
->>control query default GEN_SORT_MAX_NUM_BUFFERS '20';
->> -- total of 8000 rows per run NSK
->>control query default SORT_MEMORY_QUOTA_SYSTEM '';
->>control query default SORT_MAX_HEAP_SIZE_MB '';
->>control query default SCRATCH_MAX_OPENS_SORT '4';
->>prepare xx from SELECT [last 1] c100k, str1 from t107100k order by c100k;
->>execute xx;
->>
->>-- Test #5 - Test 2 with multiple opens = 4, intermediate merges
->>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
->> -- 200 rows approx NSK
->>control query default GEN_SORT_MAX_NUM_BUFFERS '20';
->> -- total of 8000 rows per run NSK
->>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
->>control query default SORT_MAX_HEAP_SIZE_MB '2';
->>control query default SCRATCH_MAX_OPENS_SORT '4';
->>prepare xx from SELECT [last 1] c100k, str1 from t107100k order by c100k;
->>execute xx;
->>
->>#ifNSK
->>
->>#ifLINUX
->>obey TEST107(cif_dml);
->>---------------------------------------
->>
->>control query default COMPRESSED_INTERNAL_FORMAT 'ON';
-
---- SQL operation complete.
->>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'ON';
-
---- SQL operation complete.
->>
->>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
-
---- SQL operation complete.
->>control query default GEN_SORT_MAX_NUM_BUFFERS '100';
-
---- SQL operation complete.
->>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
-
---- SQL operation complete.
->>control query default SORT_MAX_HEAP_SIZE_MB reset;
-
---- SQL operation complete.
->>
->>prepare s from SELECT [last 1] c100kchar, vc1, vc2,fc1,vc3,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,vc2,fc2;
-
---- SQL command prepared.
->>
->>execute s;
-
-C100KCHAR VC1 VC2
FC1 VC3
FC2 INT1 LINT1
----------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
-
-0000099994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
-
---- 1 row(s) selected.
->>
->>control query default COMPRESSED_INTERNAL_FORMAT 'OFF';
-
---- SQL operation complete.
->>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'OFF';
-
---- SQL operation complete.
->>
->>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
-
---- SQL operation complete.
->> -- 200 rows approx NSK
->>control query default GEN_SORT_MAX_NUM_BUFFERS '100';
-
---- SQL operation complete.
->> -- total of 8000 rows per run NSK
->>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
-
---- SQL operation complete.
->>control query default SORT_MAX_HEAP_SIZE_MB reset;
-
---- SQL operation complete.
->>
->>prepare s from SELECT [last 1] c100kchar, vc1, vc2,fc1,vc3,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,vc2,fc2;
-
---- SQL command prepared.
->>execute s;
-
-C100KCHAR VC1 VC2
FC1 VC3
FC2 INT1 LINT1
----------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
-
-0000099994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
-
---- 1 row(s) selected.
->>
->>control query default COMPRESSED_INTERNAL_FORMAT 'ON';
-
---- SQL operation complete.
->>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'ON';
-
---- SQL operation complete.
->>
->>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
-
---- SQL operation complete.
->>control query default GEN_SORT_MAX_NUM_BUFFERS '20';
-
---- SQL operation complete.
->>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
-
---- SQL operation complete.
->>control query default SORT_MAX_HEAP_SIZE_MB reset;
-
---- SQL operation complete.
->>
->>prepare s from SELECT [last 1] c100kchar, vc1, vc2,fc1,vc3,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,vc2,fc2;
-
---- SQL command prepared.
->>execute s;
-
-C100KCHAR VC1 VC2
FC1 VC3
FC2 INT1 LINT1
----------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
-
-0000099994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
-
---- 1 row(s) selected.
->>
->>control query default COMPRESSED_INTERNAL_FORMAT 'OFF';
-
---- SQL operation complete.
->>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'OFF';
-
---- SQL operation complete.
->>
->>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
-
---- SQL operation complete.
->>control query default GEN_SORT_MAX_NUM_BUFFERS '20';
-
---- SQL operation complete.
->>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
-
---- SQL operation complete.
->>control query default SORT_MAX_HEAP_SIZE_MB reset;
-
---- SQL operation complete.
->>
->>prepare s from SELECT [last 1] c100kchar, vc1, vc2,fc1,vc3,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,vc2,fc2;
-
---- SQL command prepared.
->>execute s;
-
-C100KCHAR VC1 VC2
FC1 VC3
FC2 INT1 LINT1
----------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
-
-0000099994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
-
---- 1 row(s) selected.
->>
->>control query default COMPRESSED_INTERNAL_FORMAT 'ON';
-
---- SQL operation complete.
->>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'ON';
-
---- SQL operation complete.
->>
->>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
-
---- SQL operation complete.
->>control query default GEN_SORT_MAX_NUM_BUFFERS '10';
-
---- SQL operation complete.
->>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
-
---- SQL operation complete.
->>control query default EXE_BMO_DISABLE_CMP_HINTS_OVERFLOW_SORT 'ON';
-
---- SQL operation complete.
->>control query default SORT_MAX_HEAP_SIZE_MB '2';
-
---- SQL operation complete.
->>
->>prepare s from SELECT [last 1] c100kchar, vc1, vc2,fc1,vc3,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,vc2,fc2;
-
---- SQL command prepared.
->>execute s;
-
-C100KCHAR VC1 VC2
FC1 VC3
FC2 INT1 LINT1
----------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
-
-0000099994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
-
---- 1 row(s) selected.
->>
->>control query default COMPRESSED_INTERNAL_FORMAT 'OFF';
-
---- SQL operation complete.
->>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'OFF';
-
---- SQL operation complete.
->>
->>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
-
---- SQL operation complete.
->>control query default GEN_SORT_MAX_NUM_BUFFERS '10';
-
---- SQL operation complete.
->>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
-
---- SQL operation complete.
->>control query default EXE_BMO_DISABLE_CMP_HINTS_OVERFLOW_SORT 'ON';
-
---- SQL operation complete.
->>control query default SORT_MAX_HEAP_SIZE_MB '2';
-
---- SQL operation complete.
->>
->>prepare s from SELECT [last 1] c100kchar, vc1, vc2,fc1,vc3,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,vc2,fc2;
-
---- SQL command prepared.
->>execute s;
-
-C100KCHAR VC1 VC2
FC1 VC3
FC2 INT1 LINT1
----------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
-
-0000099994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
-
---- 1 row(s) selected.
->>
->>control query default COMPRESSED_INTERNAL_FORMAT 'OFF';
-
---- SQL operation complete.
->>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'ON';
-
---- SQL operation complete.
->>
->>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
-
---- SQL operation complete.
->>control query default GEN_SORT_MAX_NUM_BUFFERS '10';
-
---- SQL operation complete.
->>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
-
---- SQL operation complete.
->>control query default EXE_BMO_DISABLE_CMP_HINTS_OVERFLOW_SORT 'ON';
-
---- SQL operation complete.
->>control query default SORT_MAX_HEAP_SIZE_MB '2';
-
---- SQL operation complete.
->>
->>prepare s from SELECT [last 1] c100kchar, vc1, vc2,fc1,vc3,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,vc2,fc2;
-
---- SQL command prepared.
->>execute s;
-
-C100KCHAR VC1 VC2
FC1 VC3
FC2 INT1 LINT1
----------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
-
-0000099994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
-
---- 1 row(s) selected.
->>
->>control query default COMPRESSED_INTERNAL_FORMAT 'ON';
-
---- SQL operation complete.
->>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'OFF';
-
---- SQL operation complete.
->>
->>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
-
---- SQL operation complete.
->>control query default GEN_SORT_MAX_NUM_BUFFERS '10';
-
---- SQL operation complete.
->>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
-
---- SQL operation complete.
->>control query default EXE_BMO_DISABLE_CMP_HINTS_OVERFLOW_SORT 'ON';
-
---- SQL operation complete.
->>control query default SORT_MAX_HEAP_SIZE_MB '2';
-
---- SQL operation complete.
->>
->>prepare s from SELECT [last 1] c100kchar, vc1, vc2,fc1,vc3,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,vc2,fc2;
-
---- SQL command prepared.
->>
->>execute s;
-
-C100KCHAR VC1 VC2
FC1 VC3
FC2 INT1 LINT1
----------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
-
-0000099994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
-
---- 1 row(s) selected.
->>-----------------------------
->>control query default COMPRESSED_INTERNAL_FORMAT 'ON';
-
---- SQL operation complete.
->>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'ON';
-
---- SQL operation complete.
->>
->>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
-
---- SQL operation complete.
->>control query default GEN_SORT_MAX_NUM_BUFFERS '20';
-
---- SQL operation complete.
->>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
-
---- SQL operation complete.
->>control query default SORT_MAX_HEAP_SIZE_MB reset;
-
---- SQL operation complete.
->>
->>prepare s from SELECT [last 1] c100kchar, fc1,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,fc2;
-
---- SQL command prepared.
->>execute s;
-
-C100KCHAR FC1 FC2 INT1 LINT1
----------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
-
-0000099994 yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
-
---- 1
<TRUNCATED>
[5/5] incubator-trafodion git commit: Merge [TRAFODION-2304] PR-779
handle zero records in TOPN sort + regress TEST107 update/cleanup
Posted by su...@apache.org.
Merge [TRAFODION-2304] PR-779 handle zero records in TOPN sort + regress TEST107 update/cleanup
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/de82dfbb
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/de82dfbb
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/de82dfbb
Branch: refs/heads/master
Commit: de82dfbb7c072f6dee369244c2cf7fb75e1f9dff
Parents: 44552d5 5ba330e
Author: Suresh Subbiah <su...@apache.org>
Authored: Mon Oct 24 18:48:38 2016 +0000
Committer: Suresh Subbiah <su...@apache.org>
Committed: Mon Oct 24 18:48:38 2016 +0000
----------------------------------------------------------------------
core/sql/regress/executor/DIFF107.KNOWN.SB | 16 -
core/sql/regress/executor/DIFF107.KNOWN.SB.OS | 14 -
core/sql/regress/executor/EXPECTED107 | 565 ++++++++++++++++++++
core/sql/regress/executor/EXPECTED107.LINUX | 574 ---------------------
core/sql/regress/executor/TEST107 | 51 +-
core/sql/sort/SortTopN.cpp | 8 +
6 files changed, 591 insertions(+), 637 deletions(-)
----------------------------------------------------------------------
[3/5] incubator-trafodion git commit: [TRAFODION-2304] handle zero
records in TOPN sort + regress TEST107 update/cleanup
Posted by su...@apache.org.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5ba330e5/core/sql/regress/executor/EXPECTED107
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/EXPECTED107 b/core/sql/regress/executor/EXPECTED107
new file mode 100644
index 0000000..a3d2f13
--- /dev/null
+++ b/core/sql/regress/executor/EXPECTED107
@@ -0,0 +1,565 @@
+>>
+>>control query default ATTEMPT_ESP_PARALLELISM 'off';
+
+--- SQL operation complete.
+>>control query default query_cache '0';
+
+--- SQL operation complete.
+>>control query default EXE_DIAGNOSTIC_EVENTS 'on';
+
+--- SQL operation complete.
+>>
+>>obey TEST107(setup);
+>>---------------
+>>create table t107helper (a int not null, primary key(a));
+
+--- SQL operation complete.
+>>insert into t107helper values (1);
+
+--- 1 row(s) inserted.
+>>
+>>create table t107100k
++> (uniq int not null,
++> c100K int,
++> str1 varchar(4000),
++> primary key (uniq)
++> )
++>#ifndef SEABASE_REGRESS
++>hash partition by(uniq)
++>(add location $$partition1$$, add location $$partition2$$, add location $$partition3$$)
++>#endif
++>;
+
+--- SQL operation complete.
+>>
+>>#ifdef SEABASE_REGRESS
+>>upsert using load into
++>#else
++>insert into
++>#endif
++>t107100k
++> select
++> 0 + (10000 * x10000) + (1000 * x1000) + (100 * x100) + (10 * x10) + (1 * x1),
++> 0 + (10000 * x10000) + (1000 * x1000) + (100 * x100) + (10 * x10) + (1 * x1),
++> 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'
++> from t107helper
++> transpose 0,1,2,3,4,5,6,7,8,9 as x10000
++> transpose 0,1,2,3,4,5,6,7,8,9 as x1000
++> transpose 0,1,2,3,4,5,6,7,8,9 as x100
++> transpose 0,1,2,3,4,5,6,7,8,9 as x10
++> transpose 0,1,2,3,4 as x1
++> ;
+
+--- 50000 row(s) inserted.
+>>update statistics for table t107100k on every column sample 1000 rows;
+
+--- SQL operation complete.
+>>#ifLINUX
+>>create table t107t2
++> (uniq int not null,
++> c100K int,
++> c100kchar char(10),
++> vc1 varchar(800),
++> fc1 char(255),
++> vc2 varchar(500),
++> fc2 char(200),
++> vc3 varchar(600),
++> int1 INT,
++> lint1 LARGEINT,
++> primary key (uniq)
++> )
++>#ifndef SEABASE_REGRESS
++>hash partition by(uniq)
++>(add location $$partition1$$, add location $$partition2$$, add location $$partition3$$)
++>#endif
++>;
+
+--- SQL operation complete.
+>>
+>>control query default comp_bool_140 'on';
+
+--- SQL operation complete.
+>>#ifdef SEABASE_REGRESS
+>>upsert using load into
++>#else
++>insert into
++>#endif
++>t107t2(uniq,c100k,c100kchar,vc1,fc1,vc2,fc2,vc3,int1,lint1)
++>select
++> uniq,
++> uniq c100k,
++> lpad(rtrim(cast(uniq as char(10))),10,'0') c100kchar,
++> case when mod(uniq,2) = 0 then
++> repeat('xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx',10)
++> else
++> repeat('xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx',5)
++> end vc1,
++> 'yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy' fc1,
++> case when mod(uniq,2) =0 then
++> repeat('zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz',6)
++> else
++> repeat('zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz',3)
++> end vc2,
++> 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' fc2,
++>
++> 'bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb' vc3,
++> uniq + 1000 int1,
++> uniq*uniq lint1 FROM t107100k;
+
+--- 50000 row(s) inserted.
+>>
+>>control query default comp_bool_140 reset;
+
+--- SQL operation complete.
+>>update statistics for table t107t2 on every column sample 1000 rows;
+
+--- SQL operation complete.
+>>#ifLINUX
+>>
+>>
+>>obey TEST107(dml);
+>>-------------
+>>-- Test #1: In memory sort ,double & copy
+>>prepare xx from SELECT [last 1] c100k from t107100k order by c100k;
+
+--- SQL command prepared.
+>>execute xx;
+
+C100K
+-----------
+
+ 99994
+
+--- 1 row(s) selected.
+>>
+>>-- Test #1A: uses TOPN sort
+>>prepare xx from SELECT [first 10] c100k from t107100k order by c100k;
+
+--- SQL command prepared.
+>>execute xx;
+
+C100K
+-----------
+
+ 0
+ 1
+ 2
+ 3
+ 4
+ 10
+ 11
+ 12
+ 13
+ 14
+
+--- 10 row(s) selected.
+>>
+>>-- Test#1B: negetive test, zero records to sort.
+>>prepare xx from SELECT c100k from t107100k where c100k < 0 order by c100k;
+
+--- SQL command prepared.
+>>execute xx;
+
+--- 0 row(s) selected.
+>>
+>>-- Test#1C: negetive test, zero records to sort, TOPN
+>>prepare xx from SELECT [first 10] c100k from t107100k where c100k < 0 order by c100k;
+
+--- SQL command prepared.
+>>execute xx;
+
+--- 0 row(s) selected.
+>>
+>>-- Test #2: SQL buffer overflow, overflow and merge
+>>set envvar SCRATCH_IO_PENDING 280;
+
+--- SQL operation complete.
+>>control query default GEN_SORT_MAX_NUM_BUFFERS '1';
+
+--- SQL operation complete.
+>>prepare xx from SELECT [last 1] c100k, str1 from t107100k order by 1,2;
+
+--- SQL command prepared.
+>>execute xx;
+
+C100K STR1
+----------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------
+
+ 99994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
+
+--- 1 row(s) selected.
+>>
+>>-- Test #3 - causes intermediate merge
+>>set envvar SCRATCH_IO_PENDING 50;
+
+--- SQL operation complete.
+>>control query default GEN_SORT_MAX_NUM_BUFFERS '20';
+
+--- SQL operation complete.
+>>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
+
+--- SQL operation complete.
+>>control query default GEN_SORT_MAX_NUM_BUFFERS '1';
+
+--- SQL operation complete.
+>>control query default SORT_MAX_HEAP_SIZE_MB '1';
+
+--- SQL operation complete.
+>>prepare xx from SELECT [last 1] c100k, str1 from t107100k order by 1,2;
+
+--- SQL command prepared.
+>>execute xx;
+
+C100K STR1
+----------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------
+
+ 99994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
+
+--- 1 row(s) selected.
+>>
+>>#ifLINUX
+>>obey TEST107(cif_dml);
+>>---------------------------------------
+>>
+>>control query default COMPRESSED_INTERNAL_FORMAT 'ON';
+
+--- SQL operation complete.
+>>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'ON';
+
+--- SQL operation complete.
+>>
+>>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
+
+--- SQL operation complete.
+>>control query default GEN_SORT_MAX_NUM_BUFFERS '100';
+
+--- SQL operation complete.
+>>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
+
+--- SQL operation complete.
+>>control query default SORT_MAX_HEAP_SIZE_MB reset;
+
+--- SQL operation complete.
+>>
+>>prepare s from SELECT [last 1] c100kchar, vc1, vc2,fc1,vc3,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,vc2,fc2;
+
+--- SQL command prepared.
+>>
+>>execute s;
+
+C100KCHAR VC1 VC2
FC1 VC3
FC2 INT1 LINT1
+---------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
+
+0000099994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
+
+--- 1 row(s) selected.
+>>
+>>control query default COMPRESSED_INTERNAL_FORMAT 'OFF';
+
+--- SQL operation complete.
+>>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'OFF';
+
+--- SQL operation complete.
+>>
+>>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
+
+--- SQL operation complete.
+>> -- 200 rows approx NSK
+>>control query default GEN_SORT_MAX_NUM_BUFFERS '100';
+
+--- SQL operation complete.
+>> -- total of 8000 rows per run NSK
+>>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
+
+--- SQL operation complete.
+>>control query default SORT_MAX_HEAP_SIZE_MB reset;
+
+--- SQL operation complete.
+>>
+>>prepare s from SELECT [last 1] c100kchar, vc1, vc2,fc1,vc3,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,vc2,fc2;
+
+--- SQL command prepared.
+>>execute s;
+
+C100KCHAR VC1 VC2
FC1 VC3
FC2 INT1 LINT1
+---------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
+
+0000099994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
+
+--- 1 row(s) selected.
+>>
+>>control query default COMPRESSED_INTERNAL_FORMAT 'ON';
+
+--- SQL operation complete.
+>>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'ON';
+
+--- SQL operation complete.
+>>
+>>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
+
+--- SQL operation complete.
+>>control query default GEN_SORT_MAX_NUM_BUFFERS '20';
+
+--- SQL operation complete.
+>>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
+
+--- SQL operation complete.
+>>control query default SORT_MAX_HEAP_SIZE_MB reset;
+
+--- SQL operation complete.
+>>
+>>prepare s from SELECT [last 1] c100kchar, vc1, vc2,fc1,vc3,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,vc2,fc2;
+
+--- SQL command prepared.
+>>execute s;
+
+C100KCHAR VC1 VC2
FC1 VC3
FC2 INT1 LINT1
+---------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
+
+0000099994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
+
+--- 1 row(s) selected.
+>>
+>>control query default COMPRESSED_INTERNAL_FORMAT 'OFF';
+
+--- SQL operation complete.
+>>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'OFF';
+
+--- SQL operation complete.
+>>
+>>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
+
+--- SQL operation complete.
+>>control query default GEN_SORT_MAX_NUM_BUFFERS '20';
+
+--- SQL operation complete.
+>>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
+
+--- SQL operation complete.
+>>control query default SORT_MAX_HEAP_SIZE_MB reset;
+
+--- SQL operation complete.
+>>
+>>prepare s from SELECT [last 1] c100kchar, vc1, vc2,fc1,vc3,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,vc2,fc2;
+
+--- SQL command prepared.
+>>execute s;
+
+C100KCHAR VC1 VC2
FC1 VC3
FC2 INT1 LINT1
+---------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
+
+0000099994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
+
+--- 1 row(s) selected.
+>>
+>>control query default COMPRESSED_INTERNAL_FORMAT 'ON';
+
+--- SQL operation complete.
+>>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'ON';
+
+--- SQL operation complete.
+>>
+>>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
+
+--- SQL operation complete.
+>>control query default GEN_SORT_MAX_NUM_BUFFERS '10';
+
+--- SQL operation complete.
+>>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
+
+--- SQL operation complete.
+>>control query default EXE_BMO_DISABLE_CMP_HINTS_OVERFLOW_SORT 'ON';
+
+--- SQL operation complete.
+>>control query default SORT_MAX_HEAP_SIZE_MB '2';
+
+--- SQL operation complete.
+>>
+>>prepare s from SELECT [last 1] c100kchar, vc1, vc2,fc1,vc3,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,vc2,fc2;
+
+--- SQL command prepared.
+>>execute s;
+
+C100KCHAR VC1 VC2
FC1 VC3
FC2 INT1 LINT1
+---------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
+
+0000099994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
+
+--- 1 row(s) selected.
+>>
+>>control query default COMPRESSED_INTERNAL_FORMAT 'OFF';
+
+--- SQL operation complete.
+>>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'OFF';
+
+--- SQL operation complete.
+>>
+>>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
+
+--- SQL operation complete.
+>>control query default GEN_SORT_MAX_NUM_BUFFERS '10';
+
+--- SQL operation complete.
+>>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
+
+--- SQL operation complete.
+>>control query default EXE_BMO_DISABLE_CMP_HINTS_OVERFLOW_SORT 'ON';
+
+--- SQL operation complete.
+>>control query default SORT_MAX_HEAP_SIZE_MB '2';
+
+--- SQL operation complete.
+>>
+>>prepare s from SELECT [last 1] c100kchar, vc1, vc2,fc1,vc3,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,vc2,fc2;
+
+--- SQL command prepared.
+>>execute s;
+
+C100KCHAR VC1 VC2
FC1 VC3
FC2 INT1 LINT1
+---------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
+
+0000099994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
+
+--- 1 row(s) selected.
+>>
+>>control query default COMPRESSED_INTERNAL_FORMAT 'OFF';
+
+--- SQL operation complete.
+>>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'ON';
+
+--- SQL operation complete.
+>>
+>>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
+
+--- SQL operation complete.
+>>control query default GEN_SORT_MAX_NUM_BUFFERS '10';
+
+--- SQL operation complete.
+>>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
+
+--- SQL operation complete.
+>>control query default EXE_BMO_DISABLE_CMP_HINTS_OVERFLOW_SORT 'ON';
+
+--- SQL operation complete.
+>>control query default SORT_MAX_HEAP_SIZE_MB '2';
+
+--- SQL operation complete.
+>>
+>>prepare s from SELECT [last 1] c100kchar, vc1, vc2,fc1,vc3,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,vc2,fc2;
+
+--- SQL command prepared.
+>>execute s;
+
+C100KCHAR VC1 VC2
FC1 VC3
FC2 INT1 LINT1
+---------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
+
+0000099994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
+
+--- 1 row(s) selected.
+>>
+>>control query default COMPRESSED_INTERNAL_FORMAT 'ON';
+
+--- SQL operation complete.
+>>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'OFF';
+
+--- SQL operation complete.
+>>
+>>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
+
+--- SQL operation complete.
+>>control query default GEN_SORT_MAX_NUM_BUFFERS '10';
+
+--- SQL operation complete.
+>>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
+
+--- SQL operation complete.
+>>control query default EXE_BMO_DISABLE_CMP_HINTS_OVERFLOW_SORT 'ON';
+
+--- SQL operation complete.
+>>control query default SORT_MAX_HEAP_SIZE_MB '2';
+
+--- SQL operation complete.
+>>
+>>prepare s from SELECT [last 1] c100kchar, vc1, vc2,fc1,vc3,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,vc2,fc2;
+
+--- SQL command prepared.
+>>
+>>execute s;
+
+C100KCHAR VC1 VC2
FC1 VC3
FC2 INT1 LINT1
+---------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
+
+0000099994 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
+
+--- 1 row(s) selected.
+>>-----------------------------
+>>control query default COMPRESSED_INTERNAL_FORMAT 'ON';
+
+--- SQL operation complete.
+>>control query default COMPRESSED_INTERNAL_FORMAT_BMO 'ON';
+
+--- SQL operation complete.
+>>
+>>control query default GEN_SORT_MAX_BUFFER_SIZE '3276800';
+
+--- SQL operation complete.
+>>control query default GEN_SORT_MAX_NUM_BUFFERS '20';
+
+--- SQL operation complete.
+>>control query default SORT_MEMORY_QUOTA_SYSTEM 'OFF';
+
+--- SQL operation complete.
+>>control query default SORT_MAX_HEAP_SIZE_MB reset;
+
+--- SQL operation complete.
+>>
+>>prepare s from SELECT [last 1] c100kchar, fc1,fc2,int1,lint1 from t107t2 where c100k <=100000 order by c100kchar,fc2;
+
+--- SQL command prepared.
+>>execute s;
+
+C100KCHAR FC1 FC2 INT1 LINT1
+---------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- --------------------
+
+0000099994 yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 100994 9998800036
+
+--- 1 row(s) selected.
+>>
+>>prepare s from SELECT [last 1] int1,lint1 from t107t2 where c100k <=100000 order by int1;
+
+--- SQL command prepared.
+>>execute s;
+
+INT1 LINT1
+----------- --------------------
+
+ 100994 9998800036
+
+--- 1 row(s) selected.
+>>
+>>prepare s from SELECT [last 1] int1,lint1 from t107t2 where c100k <=100000 order by int1,lint1;
+
+--- SQL command prepared.
+>>execute s;
+
+INT1 LINT1
+----------- --------------------
+
+ 100994 9998800036
+
+--- 1 row(s) selected.
+>>
+>>
+>>prepare s from SELECT [last 1] vc1 || c100kchar, vc2 , vc3 from t107t2 where c100k <=100000 order by 1,2;
+
+--- SQL command prepared.
+>>execute s;
+
+(EXPR)
<TRUNCATED>
[4/5] incubator-trafodion git commit: [TRAFODION-2304] handle zero
records in TOPN sort + regress TEST107 update/cleanup
Posted by su...@apache.org.
[TRAFODION-2304] handle zero records in TOPN sort + regress TEST107 update/cleanup
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/5ba330e5
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/5ba330e5
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/5ba330e5
Branch: refs/heads/master
Commit: 5ba330e5ba2d7fcba9f13ef99776ede4cc02f3a3
Parents: 7092997
Author: Prashant Vasudev <pr...@esgyn.com>
Authored: Sun Oct 23 17:20:04 2016 +0000
Committer: Prashant Vasudev <pr...@esgyn.com>
Committed: Sun Oct 23 17:20:04 2016 +0000
----------------------------------------------------------------------
core/sql/regress/executor/DIFF107.KNOWN.SB | 16 -
core/sql/regress/executor/DIFF107.KNOWN.SB.OS | 14 -
core/sql/regress/executor/EXPECTED107 | 565 ++++++++++++++++++++
core/sql/regress/executor/EXPECTED107.LINUX | 574 ---------------------
core/sql/regress/executor/TEST107 | 51 +-
core/sql/sort/SortTopN.cpp | 8 +
6 files changed, 591 insertions(+), 637 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5ba330e5/core/sql/regress/executor/DIFF107.KNOWN.SB
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/DIFF107.KNOWN.SB b/core/sql/regress/executor/DIFF107.KNOWN.SB
deleted file mode 100644
index 8034822..0000000
--- a/core/sql/regress/executor/DIFF107.KNOWN.SB
+++ /dev/null
@@ -1,16 +0,0 @@
-47c47,51
-< --- SQL operation complete.
----
-> *** ERROR[1002] Catalog SEABASE does not exist or has not been registered on node @system@.
->
-> *** ERROR[4082] Object #CAT.#SCH.T107100K does not exist or is inaccessible.
->
-> --- SQL operation failed with errors.
-98c102,106
-< --- SQL operation complete.
----
-> *** ERROR[1002] Catalog SEABASE does not exist or has not been registered on node @system@.
->
-> *** ERROR[4082] Object #CAT.#SCH.T107T2 does not exist or is inaccessible.
->
-> --- SQL operation failed with errors.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5ba330e5/core/sql/regress/executor/DIFF107.KNOWN.SB.OS
----------------------------------------------------------------------
diff --git a/core/sql/regress/executor/DIFF107.KNOWN.SB.OS b/core/sql/regress/executor/DIFF107.KNOWN.SB.OS
deleted file mode 100644
index 74426ae..0000000
--- a/core/sql/regress/executor/DIFF107.KNOWN.SB.OS
+++ /dev/null
@@ -1,14 +0,0 @@
-47c47,50
-< --- SQL operation complete.
----
-> *** ERROR[4222] The DDL feature is not supported in this software version.
->
-> *** ERROR[8822] The statement was not prepared.
->
-98c101,104
-< --- SQL operation complete.
----
-> *** ERROR[4222] The DDL feature is not supported in this software version.
->
-> *** ERROR[8822] The statement was not prepared.
->