Debian Codegraph @

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

raw
1
2 # DATA DIRECTORY
3 # Make directory for partition data
4 let $data_dir_path= $MYSQLTEST_VARDIR/mysql-test-data-dir;
5 --mkdir $data_dir_path
6 let $DATA_PATH= DATA DIRECTORY = '$data_dir_path';
7
8 # INDEX DIRECTORY
9 # Make directory for partition index
10 let $idx_dir_path= $MYSQLTEST_VARDIR/mysql-test-idx-dir;
11 --mkdir $idx_dir_path
12 let $INDEX_PATH= INDEX DIRECTORY = '$idx_dir_path';
13
14
15 --echo # Additional tests for WL#5217 by QA, testplan 1.1
16
17 let $TABLENAME= t1;
18 --disable_result_log
19 --disable_query_log
20 --source suite/parts/inc/partition-dml_cr_tab.inc
21 --enable_result_log
22 --enable_query_log
23 --source suite/parts/inc/partition-dml_ins_tab.inc
24
25 --enable_connect_log
26
27 CREATE USER test_user_1 IDENTIFIED BY 'testpw';
28 CREATE USER test_user_2 IDENTIFIED BY 'testpw';
29 GRANT ALL PRIVILEGES ON test.* TO test_user_1;
30 GRANT ALL PRIVILEGES ON test.* TO test_user_2;
31
32 --echo # FILE is needed to use the DATA DIRECTORY or INDEX DIRECTORY option
33 GRANT FILE ON *.* TO test_user_2;
34
35 connect (session1, localhost, test_user_1,'testpw',test);
36 --sorted_result
37 SELECT * FROM t1 PARTITION (`p0-29`);
38 --echo send
39 send
40 UPDATE t1 PARTITION (`p0-29`) SET b='p0-29-upd-1' WHERE a BETWEEN 0 AND 9;
41
42 connect (session2, localhost, test_user_2,'testpw',test);
43 let $wait_condition= SELECT count(*)= 4 FROM t1 WHERE b ='p0-29-upd-1';
44 --source include/wait_condition.inc
45 --sorted_result
46 SELECT * FROM t1 PARTITION (`p30-299`);
47 UPDATE t1 PARTITION (`p30-299`) SET b='p30-299-upd' WHERE a BETWEEN 30 AND 39;
48 --sorted_result
49 SELECT * FROM t1 PARTITION (`p30-299`);
50 --sorted_result
51 SELECT * FROM t1 PARTITION (`p300-2999`);
52 UPDATE t1 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
53 --sorted_result
54 SELECT * FROM t1 PARTITION (`p300-2999`);
55 --sorted_result
56 SELECT * FROM t1 PARTITION (`p3000-299999`);
57 UPDATE t1 PARTITION (`p3000-299999`) SET b='p3000-299999-upd' WHERE a BETWEEN 3000 AND 3009;
58 --sorted_result
59 SELECT * FROM t1 PARTITION (`p3000-299999`);
60 UPDATE t1 PARTITION (`p0-29`) SET b='p0-29-upd-2' WHERE a BETWEEN 0 AND 9;
61 --sorted_result
62 SELECT * FROM t1 PARTITION (`p0-29`);
63 UPDATE t1 PARTITION (subp3) SET b='subp3-upd';
64 UPDATE t1 PARTITION (subp4) SET b='subp4-upd';
65 UPDATE t1 PARTITION (subp5) SET b='subp5-upd';
66 --sorted_result
67 SELECT * FROM t1 PARTITION (subp3);
68 --sorted_result
69 SELECT * FROM t1 PARTITION (subp4);
70 --sorted_result
71 SELECT * FROM t1 PARTITION (subp5);
72 SELECT * FROM t1 PARTITION (subp4,subp5,subp3) order by b,a;
73
74 connection session1;
75 --echo reap
76 reap;
77 --sorted_result
78 SELECT * FROM t1 PARTITION (`p0-29`);
79
80 connection session2;
81 --sorted_result
82 SELECT * FROM t1 PARTITION (`p0-29`);
83 SELECT
84 (SELECT count(*) FROM t1 PARTITION (pneg,`p0-29`,`p30-299`,`p300-2999`,`p3000-299999`)) =
85 (SELECT count(*) FROM t1) as `MUST BE TRUE (1)` ;
86
87 # 2) empty (sub)partitions
88 let $TABLENAME= t2;
89 --disable_result_log
90 --disable_query_log
91 --source suite/parts/inc/partition-dml_cr_tab.inc
92 --enable_result_log
93 --enable_query_log
94
95 SELECT * FROM t2 PARTITION (`p30-299`);
96 UPDATE t2 PARTITION (`p30-299`) SET b='p30-299-upd' WHERE a BETWEEN 30 AND 39;
97 DELETE FROM t2 PARTITION (`p30-299`) WHERE a BETWEEN 30 AND 39;
98 SELECT * FROM t2 PARTITION (`p300-2999`);
99 UPDATE t2 PARTITION (`p300-2999`) SET b='p300-2999-upd' WHERE a BETWEEN 300 AND 309;
100 DELETE FROM t2 PARTITION (`p300-2999`) WHERE a BETWEEN 300 AND 309;
101 SELECT * FROM t2 PARTITION (`p3000-299999`);
102 UPDATE t2 PARTITION (`p3000-299999`) SET b='p3000-299999-upd' WHERE a BETWEEN 3000 AND 3009;
103 DELETE FROM t2 PARTITION (`p3000-299999`) WHERE a BETWEEN 3000 AND 3009;
104 SELECT * FROM t2 PARTITION (`p0-29`);
105 UPDATE t2 PARTITION (`p0-29`) SET b='p0-29-upd-2' WHERE a BETWEEN 0 AND 9;
106 DELETE FROM t2 PARTITION (`p0-29`) WHERE a BETWEEN 0 AND 9;
107 UPDATE t2 PARTITION (subp3) SET b='subp3-upd';
108 DELETE FROM t2 PARTITION (subp3);
109 UPDATE t2 PARTITION (subp4) SET b='subp4-upd';
110 DELETE FROM t2 PARTITION (subp4);
111 UPDATE t2 PARTITION (subp5) SET b='subp5-upd';
112 DELETE FROM t2 PARTITION (subp5);
113 UPDATE t2 PARTITION (subp4,subp5,subp3) SET b='subp-upd';
114 DELETE FROM t2 PARTITION (subp4,subp5,subp3);
115 SELECT * FROM t2 PARTITION (subp3);
116 SELECT * FROM t2 PARTITION (subp4);
117 SELECT * FROM t2 PARTITION (subp5);
118
119 disconnect session1;
120 disconnect session2;
121 connection default;
122 DROP TABLE t1, t2;
123 --error 0,1
124 --rmdir $data_dir_path/test
125 --rmdir $data_dir_path
126 --rmdir $idx_dir_path
127 DROP USER test_user_1;
128 DROP USER test_user_2;
129