Debian Codegraph @

mysql-test/suite/parts/inc/partition-dml-1-1.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 connect (session1, localhost, test_user_1,'testpw',test);
18 --sorted_result
19 SELECT * FROM t1 PARTITION (`p0-29`);
20 --echo send
21 send
22 UPDATE t1 PARTITION (`p0-29`) SET b='p0-29-upd-1' WHERE a BETWEEN 0 AND 9;
23
24 connect (session2, localhost, test_user_2,'testpw',test);
25 let $wait_condition= SELECT count(*)= 4 FROM t1 WHERE b ='p0-29-upd-1';
26 --source include/wait_condition.inc
27 --sorted_result
28 SELECT * FROM t1 PARTITION (`p30-299`);
29 UPDATE t1 PARTITION (`p30-299`) SET b='p30-299-upd' WHERE a BETWEEN 30 AND 39;
30 --sorted_result
31 SELECT * FROM t1 PARTITION (`p30-299`);
32 --sorted_result
33 SELECT * FROM t1 PARTITION (`p300-2999`);
34 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
35 --sorted_result
36 SELECT * FROM t1 PARTITION (`p300-2999`);
37 --sorted_result
38 SELECT * FROM t1 PARTITION (`p3000-299999`);
39 UPDATE t1 PARTITION (`p3000-299999`) SET b='p3000-299999-upd' WHERE a BETWEEN 3000 AND 3009;
40 --sorted_result
41 SELECT * FROM t1 PARTITION (`p3000-299999`);
42 UPDATE t1 PARTITION (`p0-29`) SET b='p0-29-upd-2' WHERE a BETWEEN 0 AND 9;
43 --sorted_result
44 SELECT * FROM t1 PARTITION (`p0-29`);
45 UPDATE t1 PARTITION (subp3) SET b='subp3-upd';
46 UPDATE t1 PARTITION (subp4) SET b='subp4-upd';
47 UPDATE t1 PARTITION (subp5) SET b='subp5-upd';
48 --sorted_result
49 SELECT * FROM t1 PARTITION (subp3);
50 --sorted_result
51 SELECT * FROM t1 PARTITION (subp4);
52 --sorted_result
53 SELECT * FROM t1 PARTITION (subp5);
54 SELECT * FROM t1 PARTITION (subp4,subp5,subp3) order by b,a;
55
56 connection session1;
57 --echo reap
58 reap;
59 --sorted_result
60 SELECT * FROM t1 PARTITION (`p0-29`);
61
62 connection session2;
63 --sorted_result
64 SELECT * FROM t1 PARTITION (`p0-29`);
65 SELECT
66 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
67 (SELECT count(*) FROM t1) as `MUST BE TRUE (1)` ;
68
69 # 2) empty (sub)partitions
70 let $TABLENAME= t2;
71 --source suite/parts/inc/partition-dml_cr_tab.inc
72
73 SELECT * FROM t2 PARTITION (`p30-299`);
74 UPDATE t2 PARTITION (`p30-299`) SET b='p30-299-upd' WHERE a BETWEEN 30 AND 39;
75 DELETE FROM t2 PARTITION (`p30-299`) WHERE a BETWEEN 30 AND 39;
76 SELECT * FROM t2 PARTITION (`p300-2999`);
77 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
78 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
79 SELECT * FROM t2 PARTITION (`p3000-299999`);
80 UPDATE t2 PARTITION (`p3000-299999`) SET b='p3000-299999-upd' WHERE a BETWEEN 3000 AND 3009;
81 DELETE FROM t2 PARTITION (`p3000-299999`) WHERE a BETWEEN 3000 AND 3009;
82 SELECT * FROM t2 PARTITION (`p0-29`);
83 UPDATE t2 PARTITION (`p0-29`) SET b='p0-29-upd-2' WHERE a BETWEEN 0 AND 9;
84 DELETE FROM t2 PARTITION (`p0-29`) WHERE a BETWEEN 0 AND 9;
85 UPDATE t2 PARTITION (subp3) SET b='subp3-upd';
86 DELETE FROM t2 PARTITION (subp3);
87 UPDATE t2 PARTITION (subp4) SET b='subp4-upd';
88 DELETE FROM t2 PARTITION (subp4);
89 UPDATE t2 PARTITION (subp5) SET b='subp5-upd';
90 DELETE FROM t2 PARTITION (subp5);
91 UPDATE t2 PARTITION (subp4,subp5,subp3) SET b='subp-upd';
92 DELETE FROM t2 PARTITION (subp4,subp5,subp3);
93 SELECT * FROM t2 PARTITION (subp3);
94 SELECT * FROM t2 PARTITION (subp4);
95 SELECT * FROM t2 PARTITION (subp5);
96
97 disconnect session1;
98 disconnect session2;
99 connection default;
100 DROP TABLE t1, t2;
101 DROP USER test_user_1;
102 DROP USER test_user_2;
103