Debian Codegraph @

mysql-test/suite/parts/inc/partition-dml-1-1-modes.inc

raw
1 let $DATA_PATH=;
2 let $INDEX_PATH=;
3
4 --echo # Additional tests for WL#5217 by QA, testplan 1.1
5
6 let $TABLENAME= t1;
7 --source suite/parts/inc/partition-dml_cr_tab.inc
8 --source suite/parts/inc/partition-dml_ins_tab.inc
9
10 --enable_connect_log
11
12 CREATE USER test_user_1 IDENTIFIED BY 'testpw';
13 CREATE USER test_user_2 IDENTIFIED BY 'testpw';
14 GRANT ALL PRIVILEGES ON test.* TO test_user_1 ;
15 GRANT ALL PRIVILEGES ON test.* TO test_user_2 ;
16
17 --echo # Run in empty mode
18 set @@global.sql_mode= '';
19 --echo #######################################################
20 --echo # UPDATE without partition selection
21
22 connect (session1, localhost, test_user_1,'testpw',test);
23 --sorted_result
24 SELECT * FROM t1 PARTITION (`p0-29`);
25 --echo send
26 send
27 UPDATE t1 SET b='table-upd-1' WHERE a BETWEEN 0 AND 9;
28
29 connect (session2, localhost, test_user_2,'testpw',test);
30 let $wait_condition= SELECT count(*)= 4 FROM t1 WHERE b ='table-upd-1';
31 --source include/wait_condition.inc
32 UPDATE t1 SET b='table-upd-2' WHERE a BETWEEN 0 AND 9;
33 --sorted_result
34 SELECT * FROM t1 PARTITION (`p0-29`);
35 INSERT INTO t1 VALUES (11, 'table-ins');
36 INSERT INTO t1 VALUES (12, 'table-ins');
37 --sorted_result
38 SELECT * FROM t1 PARTITION (`p0-29`);
39 DELETE FROM t1 WHERE b= 'table-ins';
40 --sorted_result
41 SELECT * FROM t1 PARTITION (`p0-29`);
42
43 connection session1;
44 --echo reap
45 reap;
46 --sorted_result
47 SELECT * FROM t1 PARTITION (`p0-29`);
48
49 connection session2;
50 --sorted_result
51 SELECT * FROM t1 PARTITION (`p0-29`);
52
53 --echo #######################################################
54 --echo # UPDATE with partition selection
55 #connect (session1, localhost, test_user_1,'testpw',test);
56 connection session1;
57 --sorted_result
58 SELECT * FROM t1 PARTITION (`p0-29`);
59 --echo send
60 send
61 UPDATE t1 PARTITION (`p0-29`) SET b='p0-29-upd-1' WHERE a BETWEEN 0 AND 9;
62
63 #connect (session2, localhost, test_user_2,'testpw',test);
64 connection session2;
65 let $wait_condition= SELECT count(*)= 4 FROM t1 WHERE b ='p0-29-upd-1';
66 --source include/wait_condition.inc
67 UPDATE t1 PARTITION (`p0-29`) SET b='p0-29-upd-2' WHERE a BETWEEN 0 AND 9;
68 --sorted_result
69 SELECT * FROM t1 PARTITION (`p0-29`);
70 INSERT INTO t1 PARTITION (`p0-29`, subp4) VALUES (11, '(p0-29-)ins');
71 INSERT INTO t1 PARTITION (`p0-29`, subp4) VALUES (12, '(p0-29-)ins');
72 --sorted_result
73 SELECT * FROM t1 PARTITION (`p0-29`);
74 DELETE FROM t1 PARTITION (`p0-29`,subp5) WHERE b= '(p0-29-)ins';
75 --sorted_result
76 SELECT * FROM t1 PARTITION (`p0-29`);
77
78 connection session1;
79 --echo reap
80 reap;
81 --sorted_result
82 SELECT * FROM t1 PARTITION (`p0-29`);
83
84 connection session2;
85 --sorted_result
86 SELECT * FROM t1 PARTITION (`p0-29`);
87
88 disconnect session1;
89 disconnect session2;
90
91 connection default;
92 DROP TABLE t1;
93 --source suite/parts/inc/partition-dml_cr_tab.inc
94 --source suite/parts/inc/partition-dml_ins_tab.inc
95 --echo # Run in ANSI mode
96 set @@global.sql_mode= ansi;
97 --echo #######################################################
98 --echo # UPDATE without partition selection
99
100 connect (session1, localhost, test_user_1,'testpw',test);
101 --sorted_result
102 SELECT * FROM t1 PARTITION (`p0-29`);
103 --echo send
104 send
105 UPDATE t1 SET b='table-upd-1' WHERE a BETWEEN 0 AND 9;
106
107 connect (session2, localhost, test_user_2,'testpw',test);
108 let $wait_condition= SELECT count(*)= 4 FROM t1 WHERE b ='table-upd-1';
109 --source include/wait_condition.inc
110 UPDATE t1 SET b='table-upd-2' WHERE a BETWEEN 0 AND 9;
111 --sorted_result
112 SELECT * FROM t1 PARTITION (`p0-29`);
113 INSERT INTO t1 VALUES (11, 'table-ins');
114 INSERT INTO t1 VALUES (12, 'table-ins');
115 --sorted_result
116 SELECT * FROM t1 PARTITION (`p0-29`);
117 DELETE FROM t1 WHERE b= 'table-ins';
118 --sorted_result
119 SELECT * FROM t1 PARTITION (`p0-29`);
120
121 connection session1;
122 --echo reap
123 reap;
124 --sorted_result
125 SELECT * FROM t1 PARTITION (`p0-29`);
126
127 connection session2;
128 --sorted_result
129 SELECT * FROM t1 PARTITION (`p0-29`);
130
131 --echo #######################################################
132 --echo # UPDATE with partition selection
133 #connect (session1, localhost, test_user_1,'testpw',test);
134 connection session1;
135 --sorted_result
136 SELECT * FROM t1 PARTITION (`p0-29`);
137 --echo send
138 send
139 UPDATE t1 PARTITION (`p0-29`) SET b='p0-29-upd-1' WHERE a BETWEEN 0 AND 9;
140
141 #connect (session2, localhost, test_user_2,'testpw',test);
142 connection session2;
143 let $wait_condition= SELECT count(*)= 4 FROM t1 WHERE b ='p0-29-upd-1';
144 --source include/wait_condition.inc
145 UPDATE t1 PARTITION (`p0-29`) SET b='p0-29-upd-2' WHERE a BETWEEN 0 AND 9;
146 --sorted_result
147 SELECT * FROM t1 PARTITION (`p0-29`);
148 INSERT INTO t1 PARTITION (`p0-29`, subp4) VALUES (11, '(p0-29-)ins');
149 INSERT INTO t1 PARTITION (`p0-29`, subp4) VALUES (12, '(p0-29-)ins');
150 --sorted_result
151 SELECT * FROM t1 PARTITION (`p0-29`);
152 DELETE FROM t1 PARTITION (`p0-29`,subp5) WHERE b= '(p0-29-)ins';
153 --sorted_result
154 SELECT * FROM t1 PARTITION (`p0-29`);
155
156 connection session1;
157 --echo reap
158 reap;
159 --sorted_result
160 SELECT * FROM t1 PARTITION (`p0-29`);
161
162 connection session2;
163 --sorted_result
164 SELECT * FROM t1 PARTITION (`p0-29`);
165
166 disconnect session1;
167 disconnect session2;
168
169 connection default;
170 DROP TABLE t1;
171 --source suite/parts/inc/partition-dml_cr_tab.inc
172 --source suite/parts/inc/partition-dml_ins_tab.inc
173 --echo # Run in traditional mode
174 set @@global.sql_mode= traditional;
175 --echo #######################################################
176 --echo # UPDATE without partition selection
177
178 connect (session1, localhost, test_user_1,'testpw',test);
179 --sorted_result
180 SELECT * FROM t1 PARTITION (`p0-29`);
181 --echo send
182 send
183 UPDATE t1 SET b='table-upd-1' WHERE a BETWEEN 0 AND 9;
184
185 connect (session2, localhost, test_user_2,'testpw',test);
186 let $wait_condition= SELECT count(*)= 4 FROM t1 WHERE b ='table-upd-1';
187 --source include/wait_condition.inc
188 UPDATE t1 SET b='table-upd-2' WHERE a BETWEEN 0 AND 9;
189 --sorted_result
190 SELECT * FROM t1 PARTITION (`p0-29`);
191 INSERT INTO t1 VALUES (11, 'table-ins');
192 INSERT INTO t1 VALUES (12, 'table-ins');
193 --sorted_result
194 SELECT * FROM t1 PARTITION (`p0-29`);
195 DELETE FROM t1 WHERE b= 'table-ins';
196 --sorted_result
197 SELECT * FROM t1 PARTITION (`p0-29`);
198
199 connection session1;
200 --echo reap
201 reap;
202 --sorted_result
203 SELECT * FROM t1 PARTITION (`p0-29`);
204
205 connection session2;
206 --sorted_result
207 SELECT * FROM t1 PARTITION (`p0-29`);
208
209 --echo #######################################################
210 --echo # UPDATE with partition selection
211 #connect (session1, localhost, test_user_1,'testpw',test);
212 connection session1;
213 --sorted_result
214 SELECT * FROM t1 PARTITION (`p0-29`);
215 --echo send
216 send
217 UPDATE t1 PARTITION (`p0-29`) SET b='p0-29-upd-1' WHERE a BETWEEN 0 AND 9;
218
219 #connect (session2, localhost, test_user_2,'testpw',test);
220 connection session2;
221 let $wait_condition= SELECT count(*)= 4 FROM t1 WHERE b ='p0-29-upd-1';
222 --source include/wait_condition.inc
223 UPDATE t1 PARTITION (`p0-29`) SET b='p0-29-upd-2' WHERE a BETWEEN 0 AND 9;
224 --sorted_result
225 SELECT * FROM t1 PARTITION (`p0-29`);
226 INSERT INTO t1 PARTITION (`p0-29`, subp4) VALUES (11, '(p0-29-)ins');
227 INSERT INTO t1 PARTITION (`p0-29`, subp4) VALUES (12, '(p0-29-)ins');
228 --sorted_result
229 SELECT * FROM t1 PARTITION (`p0-29`);
230 DELETE FROM t1 PARTITION (`p0-29`,subp5) WHERE b= '(p0-29-)ins';
231 --sorted_result
232 SELECT * FROM t1 PARTITION (`p0-29`);
233
234 connection session1;
235 --echo reap
236 reap;
237 --sorted_result
238 SELECT * FROM t1 PARTITION (`p0-29`);
239
240 connection session2;
241 --sorted_result
242 SELECT * FROM t1 PARTITION (`p0-29`);
243
244 disconnect session1;
245 disconnect session2;
246 connection default;
247 DROP TABLE t1;
248 DROP USER test_user_1;
249 DROP USER test_user_2;
250