Debian Codegraph @

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

raw
1 CREATE USER test_2@localhost;
2 send
3 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
4 connect (test_2,localhost,test_2,,test,MASTER_MYPORT,MASTER_MYSOCK);
5 SELECT * FROM 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 INSERT INTO tp VALUES (7,"Seven");
18 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
19 a b
20 1 One
21 3 Three
22 5 Five
23 7 Seven
24 9 Nine
25 ALTER TABLE tp EXCHANGE PARTITION p0 WITH TABLE t_10;
26 connection default;
27 reap;
28 SELECT * FROM t_10;
29 a b
30 1 One
31 3 Three
32 5 Five
33 7 Seven
34 9 Nine
35 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
36 a b
37 2 Two
38 4 Four
39 6 Six
40 8 Eight
41 connection test_2;
42 SELECT * FROM t_10;
43 a b
44 1 One
45 3 Three
46 5 Five
47 7 Seven
48 9 Nine
49 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
50 a b
51 2 Two
52 4 Four
53 6 Six
54 8 Eight
55 disconnect test_2;
56 connection default;
57 SELECT * FROM t_10;
58 a b
59 1 One
60 3 Three
61 5 Five
62 7 Seven
63 9 Nine
64 SELECT * FROM tp WHERE a BETWEEN 0 AND 10;
65 a b
66 2 Two
67 4 Four
68 6 Six
69 8 Eight
70 DROP TABLE IF EXISTS t_10;
71 DROP TABLE IF EXISTS t_100;
72 DROP TABLE IF EXISTS t_1000;
73 DROP TABLE IF EXISTS tp;
74 DROP TABLE IF EXISTS tsp;
75 DROP TABLE IF EXISTS tsp_00;
76 DROP TABLE IF EXISTS tsp_01;
77 DROP TABLE IF EXISTS tsp_02;
78 DROP TABLE IF EXISTS tsp_03;
79 DROP TABLE IF EXISTS tsp_04;
80 DROP TABLE IF EXISTS t_empty;
81 DROP TABLE IF EXISTS t_null;
82 DROP USER test_2@localhost;