diff options
Diffstat (limited to 'mysql-test/r/win_big.result')
| -rw-r--r-- | mysql-test/r/win_big.result | 54 |
1 files changed, 36 insertions, 18 deletions
diff --git a/mysql-test/r/win_big.result b/mysql-test/r/win_big.result index 7ea044e702c..c8b27b9a1aa 100644 --- a/mysql-test/r/win_big.result +++ b/mysql-test/r/win_big.result @@ -18,9 +18,12 @@ select sum(b) over (order by a rows between 2 preceding and 2 following) as SUM_B from t10; -show status like 'Sort_merge_passes'; -Variable_name Value -Sort_merge_passes 0 +select variable_name, +case when variable_value > 0 then 'WITH PASSES' else 'NO PASSES' end +from information_schema.session_status +where variable_name like 'Sort_merge_passes'; +variable_name case when variable_value > 0 then 'WITH PASSES' else 'NO PASSES' end +SORT_MERGE_PASSES NO PASSES set sort_buffer_size=1024; flush status; create table t22 as @@ -28,9 +31,12 @@ select sum(b) over (order by a rows between 2 preceding and 2 following) as SUM_B from t10; -show status like 'Sort_merge_passes'; -Variable_name Value -Sort_merge_passes 35 +select variable_name, +case when variable_value > 0 then 'WITH PASSES' else 'NO PASSES' end +from information_schema.session_status +where variable_name like 'Sort_merge_passes'; +variable_name case when variable_value > 0 then 'WITH PASSES' else 'NO PASSES' end +SORT_MERGE_PASSES WITH PASSES include/diff_tables.inc [t21, t22] drop table t21, t22; ################################################################# @@ -44,9 +50,12 @@ sum(b) over (order by a rows between 5 preceding and 5 following) as SUM_B2, sum(b) over (order by a rows between 20 preceding and 20 following) as SUM_B3 from t10; -show status like 'Sort_merge_passes'; -Variable_name Value -Sort_merge_passes 0 +select variable_name, +case when variable_value > 0 then 'WITH PASSES' else 'NO PASSES' end +from information_schema.session_status +where variable_name like 'Sort_merge_passes'; +variable_name case when variable_value > 0 then 'WITH PASSES' else 'NO PASSES' end +SORT_MERGE_PASSES NO PASSES set sort_buffer_size=1024; flush status; create table t22 as @@ -56,9 +65,12 @@ sum(b) over (order by a rows between 5 preceding and 5 following) as SUM_B2, sum(b) over (order by a rows between 20 preceding and 20 following) as SUM_B3 from t10; -show status like 'Sort_merge_passes'; -Variable_name Value -Sort_merge_passes 35 +select variable_name, +case when variable_value > 0 then 'WITH PASSES' else 'NO PASSES' end +from information_schema.session_status +where variable_name like 'Sort_merge_passes'; +variable_name case when variable_value > 0 then 'WITH PASSES' else 'NO PASSES' end +SORT_MERGE_PASSES WITH PASSES include/diff_tables.inc [t21, t22] drop table t21, t22; ################################################################# @@ -72,9 +84,12 @@ a, sum(b) over (order by a range between 5000 preceding and 5000 following) as SUM_B1 from t10; -show status like 'Sort_merge_passes'; -Variable_name Value -Sort_merge_passes 0 +select variable_name, +case when variable_value > 0 then 'WITH PASSES' else 'NO PASSES' end +from information_schema.session_status +where variable_name like 'Sort_merge_passes'; +variable_name case when variable_value > 0 then 'WITH PASSES' else 'NO PASSES' end +SORT_MERGE_PASSES NO PASSES set sort_buffer_size=1024; flush status; create table t22 as @@ -83,9 +98,12 @@ a, sum(b) over (order by a range between 5000 preceding and 5000 following) as SUM_B1 from t10; -show status like 'Sort_merge_passes'; -Variable_name Value -Sort_merge_passes 35 +select variable_name, +case when variable_value > 0 then 'WITH PASSES' else 'NO PASSES' end +from information_schema.session_status +where variable_name like 'Sort_merge_passes'; +variable_name case when variable_value > 0 then 'WITH PASSES' else 'NO PASSES' end +SORT_MERGE_PASSES WITH PASSES include/diff_tables.inc [t21, t22] drop table t21, t22; ################################################################# |