Debian Codegraph @

mysql-test/suite/auth_sec/include/acl_tables_row_locking.inc

raw
1 # This file is used by auth_sec.acl_table_read_concurrency added as part of
2 # wl#14087. The test focuses on concurrency tests with read row lock on ACL
3 # tables.
4 #
5 # Does following:
6 # Case 1:
7 # - Run SELECT on ACL table fetching row related to user 'u2'.
8 # - Run a concurrent SELECT ... FOR UPDATE fetch the same row for user 'u2'.
9 #
10 # Case 2:
11 # - Run SELECT ... SHARE MODE on ACL table fetching row related to user # 'u2'.
12 # - Run a concurrent SELECT ... FOR UPDATE fetch the same row for user 'u2'.
13
14 echo # Run the test for all isolation level for table $acl_table;
15 let $c=1;
16 while($c <= 4)
17 {
18 let isolation_level = `$get_next_isolation`;
19
20 connection read_con;
21 echo "Case 1.$c: Start a transaction in $isolation_level";
22 eval SET TRANSACTION ISOLATION LEVEL $isolation_level;
23 START TRANSACTION;
24 eval SELECT $column_name FROM $acl_table WHERE $column_name='u2';
25
26 echo # Make sure no read row lock is held on row 'u2'.
27 eval $query_row_locks;
28
29 echo "Allow the same row to be read for update by SELECT FOR UPDATE"
30 connection update_con;
31 eval SELECT $column_name FROM $acl_table
32 WHERE $column_name='u2' FOR UPDATE;
33
34 echo # Make sure X record locks are held on row 'u2';
35 eval $query_row_locks;
36
37 connection read_con;
38 COMMIT;
39
40 echo "Case 1.$c: Using $isolation_level with SELECT LOCK IN SHARE MODE";
41 connection read_con;
42 eval SET TRANSACTION ISOLATION LEVEL $isolation_level;
43 START TRANSACTION;
44 eval SELECT $column_name FROM $acl_table
45 WHERE $column_name='u2' LOCK IN SHARE MODE;
46
47 echo # Make sure no read row lock is held on row 'u2'.
48 eval $query_row_locks;
49
50 echo "Allow the same row to be read for update by SELECT FOR UPDATE"
51 connection update_con;
52 eval SELECT $column_name FROM $acl_table
53 WHERE $column_name='u2' FOR UPDATE;
54
55 echo # Make sure X record locks are held on row 'u2';
56 eval $query_row_locks;
57
58 connection read_con;
59 COMMIT;
60
61 inc $c;
62 }