Debian Codegraph @

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

raw
1 use test;
2 SELECT * FROM t_10;
3 a b
4 1 One
5 3 Three
6 5 Five
7 9 Nine
8 SELECT * FROM t_100;
9 a b
10 11 Eleven
11 13 Thirdteen
12 15 Fifeteen
13 19 Nineteen
14 91 Ninety-one
15 93 Ninety-three
16 95 Ninety-five
17 99 Ninety-nine
18 SELECT * FROM t_1000;
19 a b
20 111 Hundred elven
21 113 Hundred thirdteen
22 115 Hundred fiveteen
23 119 Hundred nineteen
24 131 Hundred thirty-one
25 133 Hundred thirty-three
26 135 Hundred thirty-five
27 139 Hundred thirty-nine
28 151 Hundred fifty-one
29 153 Hundred fifty-three
30 155 Hundred fity-five
31 159 Hundred fifty-nine
32 191 Hundred ninety-one
33 193 Hundred ninety-three
34 195 Hundred ninety-five
35 199 Hundred ninety-nine
36 SELECT * FROM tp;
37 a b
38 112 Hundred twelve
39 114 Hundred fourteen
40 116 Hundred sixteen
41 118 Hundred eightteen
42 12 twelve
43 122 Hundred twenty-two
44 124 Hundred twenty-four
45 126 Hundred twenty-six
46 128 Hundred twenty-eight
47 14 Fourteen
48 16 Sixteen
49 162 Hundred sixty-two
50 164 Hundred sixty-four
51 166 Hundred sixty-six
52 168 Hundred sixty-eight
53 18 Eightteen
54 182 Hundred eighty-two
55 184 Hundred eighty-four
56 186 Hundred eighty-six
57 188 Hundred eighty-eight
58 2 Two
59 4 Four
60 6 Six
61 8 Eight
62 SELECT * FROM tsp;
63 a b
64 112 Hundred twelve
65 114 Hundred fourteen
66 116 Hundred sixteen
67 118 Hundred eightteen
68 12 twelve
69 122 Hundred twenty-two
70 124 Hundred twenty-four
71 126 Hundred twenty-six
72 128 Hundred twenty-eight
73 14 Fourteen
74 16 Sixteen
75 162 Hundred sixty-two
76 164 Hundred sixty-four
77 166 Hundred sixty-six
78 168 Hundred sixty-eight
79 18 Eightteen
80 182 Hundred eight-two
81 184 Hundred eighty-four
82 186 Hundred eighty-six
83 188 Hundred eighty-eight
84 2 Two
85 4 Four
86 6 Six
87 8 Eight
88 SELECT * FROM tsp_00;
89 a b
90 5 Five
91 SELECT * FROM tsp_01;
92 a b
93 1 One
94 SELECT * FROM tsp_02;
95 a b
96 SELECT * FROM tsp_03;
97 a b
98 3 Three
99 SELECT * FROM tsp_04;
100 a b
101 9 Nine
102 SELECT TABLE_NAME, ROW_FORMAT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test'
103 AND TABLE_NAME IN ('tp', 't_100');
104 TABLE_NAME ROW_FORMAT
105 t_100 Compressed
106 tp Dynamic
107 ALTER TABLE tp EXCHANGE PARTITION p1 WITH TABLE t_100;
108 ERROR HY000: Non matching attribute 'ROW_FORMAT' between partition and table
109 ALTER TABLE tp EXCHANGE PARTITION p1 WITH TABLE t_1000;
110 ERROR HY000: Non matching attribute 'MAX_ROWS' between partition and table
111 DROP TABLE IF EXISTS t_10;
112 DROP TABLE IF EXISTS t_100;
113 DROP TABLE IF EXISTS t_1000;
114 DROP TABLE IF EXISTS tp;
115 DROP TABLE IF EXISTS tsp;
116 DROP TABLE IF EXISTS tsp_00;
117 DROP TABLE IF EXISTS tsp_01;
118 DROP TABLE IF EXISTS tsp_02;
119 DROP TABLE IF EXISTS tsp_03;
120 DROP TABLE IF EXISTS tsp_04;
121 DROP TABLE IF EXISTS t_empty;
122 DROP TABLE IF EXISTS t_null;