Repository: incubator-trafodion Updated Branches: refs/heads/master 5ee3cb396 -> c855e1fe7
[TRAFODION-2134] Change the overflow_mode to 'DISK' by default Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/675017b0 Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/675017b0 Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/675017b0 Branch: refs/heads/master Commit: 675017b05dcdeb3e6f3c6768517ffb2091fb482d Parents: 5cc5945 Author: selvaganesang <selva.govindara...@esgyn.com> Authored: Fri Jul 29 04:36:30 2016 +0000 Committer: selvaganesang <selva.govindara...@esgyn.com> Committed: Fri Jul 29 04:36:30 2016 +0000 ---------------------------------------------------------------------- core/sql/regress/core/EXPECTEDRTS | 32 ++++++++++++++++---------------- core/sql/sqlcomp/nadefaults.cpp | 2 +- 2 files changed, 17 insertions(+), 17 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/675017b0/core/sql/regress/core/EXPECTEDRTS ---------------------------------------------------------------------- diff --git a/core/sql/regress/core/EXPECTEDRTS b/core/sql/regress/core/EXPECTEDRTS index 025145b..c32ce85 100755 --- a/core/sql/regress/core/EXPECTEDRTS +++ b/core/sql/regress/core/EXPECTEDRTS @@ -311,7 +311,7 @@ Request Message Count 26 Request Message Bytes 40,176 Reply Message Count 15 Reply Message Bytes 38,952 -Scr. Overflow Mode MMAP +Scr. Overflow Mode DISK Scr. File Count 0 Scr. Buffer Blk Size 0 Scr. Buffer Blks Read 0 @@ -381,7 +381,7 @@ Request Message Count 26 Request Message Bytes 40,176 Reply Message Count 15 Reply Message Bytes 38,952 -Scr. Overflow Mode MMAP +Scr. Overflow Mode DISK Scr. File Count 0 Scr. Buffer Blk Size 0 Scr. Buffer Blks Read 0 @@ -452,7 +452,7 @@ Request Message Count 26 Request Message Bytes 40,176 Reply Message Count 15 Reply Message Bytes 38,952 -Scr. Overflow Mode MMAP +Scr. Overflow Mode DISK Scr. File Count 0 Scr. Buffer Blk Size 0 Scr. Buffer Blks Read 0 @@ -522,7 +522,7 @@ Request Message Count 26 Request Message Bytes 40,176 Reply Message Count 15 Reply Message Bytes 38,952 -Scr. Overflow Mode MMAP +Scr. Overflow Mode DISK Scr. File Count 0 Scr. Buffer Blk Size 0 Scr. Buffer Blks Read 0 @@ -2017,7 +2017,7 @@ Request Message Count 28 Request Message Bytes 40,496 Reply Message Count 15 Reply Message Bytes 42,360 -Scr. Overflow Mode MMAP +Scr. Overflow Mode DISK Scr. File Count 0 Scr. Buffer Blk Size 0 Scr. Buffer Blks Read 0 @@ -2087,7 +2087,7 @@ Request Message Count 28 Request Message Bytes 40,496 Reply Message Count 15 Reply Message Bytes 42,360 -Scr. Overflow Mode MMAP +Scr. Overflow Mode DISK Scr. File Count 0 Scr. Buffer Blk Size 0 Scr. Buffer Blks Read 0 @@ -2149,7 +2149,7 @@ Request Message Count 28 Request Message Bytes 40,496 Reply Message Count 15 Reply Message Bytes 42,360 -Scr. Overflow Mode MMAP +Scr. Overflow Mode DISK Scr File Count 0 Scr. Buffer Blk Size 0 Scr. Buffer Blks Read 0 @@ -2214,7 +2214,7 @@ Request Message Count 28 Request Message Bytes 40,496 Reply Message Count 15 Reply Message Bytes 42,360 -Scr. Overflow Mode MMAP +Scr. Overflow Mode DISK Scr File Count 0 Scr. Buffer Blk Size 0 Scr. Buffer Blks Read 0 @@ -2291,7 +2291,7 @@ TRAFODION.SCH.TSTAT 4 4 4 0 9,490 5,576 Id TDB Name Mode CPU Time BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt File Count Scratch Buffer Block Size/Read/Written Scratch IO Count Read/Written - 6 EX_HASH_GRBY MMAP 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0 + 6 EX_HASH_GRBY DISK 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0 --- SQL operation complete. >>get statistics for QID >>MXID11000023543212326038273788301000000000206U3333300_479_S1 PROGRESS; @@ -2351,7 +2351,7 @@ TRAFODION.SCH.TSTAT 4 4 4 0 9,490 5,576 Id TDB Name Mode CPU Time BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt File Count Scratch Buffer Block Size/Read/Written Scratch IO Count Read/Written - 6 EX_HASH_GRBY MMAP 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0 + 6 EX_HASH_GRBY DISK 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0 --- SQL operation complete. >>log; @@ -2567,7 +2567,7 @@ Request Message Count 28 Request Message Bytes 40,496 Reply Message Count 15 Reply Message Bytes 42,360 -Scr. Overflow Mode MMAP +Scr. Overflow Mode DISK Scr. File Count 0 Scr. Buffer Blk Size 0 Scr. Buffer Blks Read 0 @@ -2625,7 +2625,7 @@ Request Message Count 28 Request Message Bytes 40,496 Reply Message Count 15 Reply Message Bytes 42,360 -Scr. Overflow Mode MMAP +Scr. Overflow Mode DISK Scr File Count 0 Scr. Buffer Blk Size 0 Scr. Buffer Blks Read 0 @@ -2698,7 +2698,7 @@ TRAFODION.SCH.TSTAT 4 4 4 0 9,490 5,576 Id TDB Name Mode CPU Time BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt File Count Scratch Buffer Block Size/Read/Written Scratch IO Count Read/Written - 6 EX_HASH_GRBY MMAP 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0 + 6 EX_HASH_GRBY DISK 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0 --- SQL operation complete. >>get statistics for qid current default ; @@ -2866,7 +2866,7 @@ Request Message Count 28 Request Message Bytes 40,496 Reply Message Count 15 Reply Message Bytes 42,360 -Scr. Overflow Mode MMAP +Scr. Overflow Mode DISK Scr. File Count 0 Scr. Buffer Blk Size 0 Scr. Buffer Blks Read 0 @@ -2927,7 +2927,7 @@ Request Message Count 28 Request Message Bytes 40,496 Reply Message Count 15 Reply Message Bytes 42,360 -Scr. Overflow Mode MMAP +Scr. Overflow Mode DISK Scr File Count 0 Scr. Buffer Blk Size 0 Scr. Buffer Blks Read 0 @@ -3003,7 +3003,7 @@ TRAFODION.SCH.TSTAT 4 4 4 0 9,490 5,576 Id TDB Name Mode CPU Time BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt File Count Scratch Buffer Block Size/Read/Written Scratch IO Count Read/Written - 6 EX_HASH_GRBY MMAP 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0 + 6 EX_HASH_GRBY DISK 2,043 4 1,024 7,687 256 0 0 -1 0 0 0 0 --- SQL operation complete. >>set session default statistics_view_type 'pertable' ; http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/675017b0/core/sql/sqlcomp/nadefaults.cpp ---------------------------------------------------------------------- diff --git a/core/sql/sqlcomp/nadefaults.cpp b/core/sql/sqlcomp/nadefaults.cpp index 14e274e..25c5672 100644 --- a/core/sql/sqlcomp/nadefaults.cpp +++ b/core/sql/sqlcomp/nadefaults.cpp @@ -2771,7 +2771,7 @@ SDDkwd__(ISO_MAPPING, (char *)SQLCHARSETSTRING_ISO88591), DDansi_(OUTPUT_DATE_FORMAT, ""), // Overflow mode for scratch files - DDkwd__(OVERFLOW_MODE, "MMAP"), + DDkwd__(OVERFLOW_MODE, "DISK"), // Sequence generator override identity values DDkwd__(OVERRIDE_GENERATED_IDENTITY_VALUES, "OFF"),