Debian Codegraph @

mysql-test/suite/parts/inc/part_exch_qa_4.inc

raw
1 --source include/default_charset.inc
2
3 CREATE DATABASE test_2;
4
5 USE test;
6 --disable_result_log
7 --disable_query_log
8 --source suite/parts/inc/part_exch_tabs.inc
9
10 USE test_2;
11 --source suite/parts/inc/part_exch_tabs.inc
12
13 --enable_result_log
14 --enable_query_log
15
16 USE test;
17 # 10) Exchanges with different databases.
18 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE test_2.t_10;
19 --sorted_result
20 SELECT * FROM test_2.t_10;
21 --sorted_result
22 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
23 # Back to former values.
24 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE test_2.t_10;
25 --sorted_result
26 SELECT * FROM test_2.t_10;
27 --sorted_result
28 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
29 ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE test_2.tsp_00;
30 --sorted_result
31 SELECT * FROM test_2.tsp_00;
32 --sorted_result
33 SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
34 # Back to former values.
35 ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE test_2.tsp_00;
36 --sorted_result
37 SELECT * FROM test_2.tsp_00;
38 --sorted_result
39 SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
40
41 --source suite/parts/inc/part_exch_drop_tabs.inc
42 USE test_2;
43 --source suite/parts/inc/part_exch_drop_tabs.inc
44 USE test;
45
46 DROP DATABASE test_2;
47