Debian Codegraph @

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

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