Debian Codegraph @

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

raw
1 SET @auto= @@global.autocommit;
2 SET @@global.autocommit= off;
3 SET @iso= @@global.transaction_isolation;
4 SET @@global.transaction_isolation= 'repeatable-read';
5 SET @completion= @@global.completion_type;
6 SET @@global.completion_type= 'no_chain';
7 let $DATA_PATH=;
8 let $INDEX_PATH=;
9
10 --echo # Additional tests for WL#5217 by QA, testplan 1.1
11
12 let $TABLENAME= t1;
13 --source suite/parts/inc/partition-dml_cr_tab.inc
14 --source suite/parts/inc/partition-dml_ins_tab.inc
15
16 --enable_connect_log
17
18 CREATE USER test_user_1 IDENTIFIED BY 'testpw';
19 CREATE USER test_user_2 IDENTIFIED BY 'testpw';
20 CREATE USER test_user_3 IDENTIFIED BY 'testpw';
21 GRANT ALL PRIVILEGES ON test.* TO test_user_1;
22 GRANT ALL PRIVILEGES ON test.* TO test_user_2;
23 GRANT ALL PRIVILEGES ON test.* TO test_user_3;
24
25 connect (session1, localhost, test_user_1,'testpw',test);
26 UPDATE t1 PARTITION (`p0-29`) SET b='p0-29-upd-1' WHERE a BETWEEN 0 AND 9;
27
28 connect (session2, localhost, test_user_2,'testpw',test);
29 UPDATE t1 PARTITION (`p30-299`) SET b='p30-299-upd-1' WHERE a BETWEEN 30 AND 39;
30
31 connection session1;
32 --echo ####### expect only p0-29 is updated
33 --sorted_result
34 SELECT * FROM t1 PARTITION (`p0-29`,`p30-299`);
35
36 connection session2;
37 --echo ####### expect only p30-299 is updated
38 --sorted_result
39 SELECT * FROM t1 PARTITION (`p0-29`,`p30-299`);
40
41 connection session1;
42 COMMIT WORK;
43 --echo ####### expect only p0-29 is updated
44 --sorted_result
45 SELECT * FROM t1 PARTITION (`p0-29`,`p30-299`);
46
47 connection session2;
48 --echo ####### expect only p30-299 is updated
49 --sorted_result
50 SELECT * FROM t1 PARTITION (`p0-29`,`p30-299`);
51
52 connect (session3, localhost, test_user_3,'testpw',test);
53 --echo ####### expect only p0-29 is updated
54 --sorted_result
55 SELECT * FROM t1 PARTITION (`p0-29`,`p30-299`);
56 disconnect session3;
57
58 connection session2;
59 COMMIT WORK;
60 --echo ####### expect p0-29 and p30-299 is updated
61 --sorted_result
62 SELECT * FROM t1 PARTITION (`p0-29`,`p30-299`);
63
64 connection session1;
65 --echo ####### expect only p30-299 is updated
66 --sorted_result
67 SELECT * FROM t1 PARTITION (`p0-29`,`p30-299`);
68 COMMIT WORK;
69 --echo ####### expect p0-29 and p30-299 is updated
70 --sorted_result
71 SELECT * FROM t1 PARTITION (`p0-29`,`p30-299`);
72
73 disconnect session1;
74 disconnect session2;
75 connection default;
76 DROP TABLE t1;
77 DROP USER test_user_1;
78 DROP USER test_user_2;
79 DROP USER test_user_3;
80
81 SET @@global.autocommit= @auto;
82 SET @@global.transaction_isolation= @iso;
83 SET @@global.completion_type= @completion;
84