Debian Codegraph @

mysql-test/suite/parts/r/partition_exch_qa_4_innodb.result

raw
1 CREATE DATABASE test_2;
2 USE test;
3 USE test;
4 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE test_2.t_10;
5 SELECT * FROM test_2.t_10;
6 a b
7 2 Two
8 4 Four
9 6 Six
10 8 Eight
11 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
12 a b
13 1 One
14 3 Three
15 5 Five
16 9 Nine
17 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE test_2.t_10;
18 SELECT * FROM test_2.t_10;
19 a b
20 1 One
21 3 Three
22 5 Five
23 9 Nine
24 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
25 a b
26 2 Two
27 4 Four
28 6 Six
29 8 Eight
30 ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE test_2.tsp_00;
31 SELECT * FROM test_2.tsp_00;
32 a b
33 SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
34 a b
35 2 Two
36 4 Four
37 5 Five
38 6 Six
39 8 Eight
40 ALTER TABLE tsp EXCHANGE PARTITION sp00 WITH TABLE test_2.tsp_00;
41 SELECT * FROM test_2.tsp_00;
42 a b
43 5 Five
44 SELECT * FROM tsp WHERE a BETWEEN 0 AND 10;
45 a b
46 2 Two
47 4 Four
48 6 Six
49 8 Eight
50 DROP TABLE IF EXISTS t_10;
51 DROP TABLE IF EXISTS t_100;
52 DROP TABLE IF EXISTS t_1000;
53 DROP TABLE IF EXISTS tp;
54 DROP TABLE IF EXISTS tsp;
55 DROP TABLE IF EXISTS tsp_00;
56 DROP TABLE IF EXISTS tsp_01;
57 DROP TABLE IF EXISTS tsp_02;
58 DROP TABLE IF EXISTS tsp_03;
59 DROP TABLE IF EXISTS tsp_04;
60 DROP TABLE IF EXISTS t_empty;
61 DROP TABLE IF EXISTS t_null;
62 USE test_2;
63 DROP TABLE IF EXISTS t_10;
64 DROP TABLE IF EXISTS t_100;
65 DROP TABLE IF EXISTS t_1000;
66 DROP TABLE IF EXISTS tp;
67 DROP TABLE IF EXISTS tsp;
68 DROP TABLE IF EXISTS tsp_00;
69 DROP TABLE IF EXISTS tsp_01;
70 DROP TABLE IF EXISTS tsp_02;
71 DROP TABLE IF EXISTS tsp_03;
72 DROP TABLE IF EXISTS tsp_04;
73 DROP TABLE IF EXISTS t_empty;
74 DROP TABLE IF EXISTS t_null;
75 USE test;
76 DROP DATABASE test_2;