Debian Codegraph @

mysql-test/suite/archive/rnd_pos.test

raw
1 #
2 # MDEV-14500 Support engines without rnd_pos
3 #
4 source include/have_archive.inc;
5 source include/have_sequence.inc;
6 source include/have_partition.inc;
7
8 create table t1(c1 int not null, c2 double not null, c3 char(255) not null) engine=archive charset=latin1;
9 insert t1 select seq, seq+0.7, concat('row with c1 = ', seq) from seq_1_to_10;
10 explain partitions select c1,c3 from t1 order by c2;
11 set max_length_for_sort_data = 4;
12 explain partitions select c1,c3 from t1 order by c2;
13 flush status;
14 --disable_cursor_protocol
15 --disable_ps2_protocol
16 select c1,c3 from t1 order by c2;
17 --enable_ps2_protocol
18 --enable_cursor_protocol
19 set max_length_for_sort_data = default;
20 --disable_ps_protocol
21 show status where variable_name like '%tmp%' and value != 0;
22 --enable_ps_protocol
23
24 alter table t1 partition by hash (c1) partitions 3;
25 explain partitions select c1,c3 from t1 order by c2;
26 set max_length_for_sort_data = 4;
27 explain partitions select c1,c3 from t1 order by c2;
28 flush status;
29 --disable_cursor_protocol
30 --disable_ps2_protocol
31 select c1,c3 from t1 order by c2;
32 --enable_ps2_protocol
33 --enable_cursor_protocol
34 set max_length_for_sort_data = default;
35 --disable_ps_protocol
36 show status where variable_name like '%tmp%' and value != 0;
37 --enable_ps_protocol
38
39 drop table t1;