summaryrefslogtreecommitdiff
path: root/mysql-test/r/win_big-mdev-11697.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/win_big-mdev-11697.result')
-rw-r--r--mysql-test/r/win_big-mdev-11697.result71
1 files changed, 0 insertions, 71 deletions
diff --git a/mysql-test/r/win_big-mdev-11697.result b/mysql-test/r/win_big-mdev-11697.result
deleted file mode 100644
index e5dc271839c..00000000000
--- a/mysql-test/r/win_big-mdev-11697.result
+++ /dev/null
@@ -1,71 +0,0 @@
-create table test_table (id int, random_data varchar(36), static_int int, static_varchar varchar(10));
-insert into test_table(id, random_data, static_int, static_varchar)
-select id, random_data, 42, 'Hello'
- from (
-with recursive data_generator(id, random_data) as (
-select 1 as id, uuid() as random_data
-union all
-select id + 1, uuid() from data_generator where id < 1000
-)
-select * from data_generator
-) as a;
-commit;
-analyze table test_table;
-Table Op Msg_type Msg_text
-test.test_table analyze status OK
-explain select * from (select id, lead(id) over(order by id) next_id from test_table order by id) a limit 10;
-id select_type table type possible_keys key key_len ref rows Extra
-1 PRIMARY <derived2> ALL NULL NULL NULL NULL 1000
-2 DERIVED test_table ALL NULL NULL NULL NULL 1000 Using temporary; Using filesort
-select * from (select id, lead(id) over(order by id) next_id from test_table order by id) a limit 10;
-id next_id
-1 2
-2 3
-3 4
-4 5
-5 6
-6 7
-7 8
-8 9
-9 10
-10 11
-drop table if exists test_table;
-create table test_table (id int, random_data varchar(36), static_int int, static_varchar varchar(10));
-insert into test_table(id, random_data, static_int, static_varchar)
-select id, random_data, 42, 'Hello'
- from (
-with recursive data_generator(id, random_data) as (
-select 1 as id, uuid() as random_data
-union all
-select id + 1, uuid() from data_generator where id < 100000
-)
-select * from data_generator
-) as a;
-commit;
-analyze table test_table;
-Table Op Msg_type Msg_text
-test.test_table analyze status OK
-explain select * from (select id, lead(id) over(order by id) next_id from test_table order by id) a limit 10;
-id select_type table type possible_keys key key_len ref rows Extra
-1 PRIMARY <derived2> ALL NULL NULL NULL NULL 100000
-2 DERIVED test_table ALL NULL NULL NULL NULL 100000 Using temporary; Using filesort
-flush status;
-select * from (select id, lead(id) over(order by id) next_id from test_table order by id) a limit 10;
-id next_id
-1 2
-2 3
-3 4
-4 5
-5 6
-6 7
-7 8
-8 9
-9 10
-10 11
-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
-drop table test_table;