Debian Codegraph @

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

raw
1 # This file is used by auth_sec.acl_tables_locking_tests_big added as part
2 # of wl#14084. The test focuses on concurrency test with MDL locking on ACL
3 # tables.
4 #
5 # Check behavior of ACL DDLs when simple and locking SELECTs
6 # are run concurrently with it.
7 #
8 # Usage:
9 # --let $ISOLATION_LEVEL=<isolation level>
10 # --source ../include/acl_tables_locking_tests_big.inc
11
12 --echo # -----------------------------------------------------------------------
13 --echo # Setup
14 --echo # Saving initial values
15 SET @global_start_value = @@global.transaction_isolation;
16 SELECT @global_start_value;
17 SET @session_start_value = @@session.transaction_isolation;
18 SELECT @session_start_value;
19
20 --echo # Setting transaction isolation to '$ISOLATION_LEVEL'
21 --eval SET GLOBAL transaction_isolation = '$ISOLATION_LEVEL'
22
23 --echo # -----------------------------------------------------------------------
24 --echo # ACL DDLs + Blocking READs
25
26 --let $EXPECT_ERROR=1
27 --let $EXPECTED_ERROR_NUMBER=ER_LOCK_WAIT_TIMEOUT
28 --let $SQL=SELECT COUNT(*) FROM mysql.user WHERE user LIKE 'u1' FOR UPDATE;
29 --source acl_tables_locking_tests_helper.inc
30
31 --let $EXPECT_ERROR=1
32 --let $EXPECTED_ERROR_NUMBER=ER_LOCK_WAIT_TIMEOUT
33 --let $SQL=SELECT COUNT(*) FROM mysql.db WHERE user LIKE 'u1' FOR UPDATE;
34 --source acl_tables_locking_tests_helper.inc
35
36 --let $EXPECT_ERROR=1
37 --let $EXPECTED_ERROR_NUMBER=ER_LOCK_WAIT_TIMEOUT
38 --let $SQL=SELECT COUNT(*) FROM mysql.default_roles WHERE user LIKE 'u1' FOR UPDATE;
39 --source acl_tables_locking_tests_helper.inc
40
41 --let $EXPECT_ERROR=1
42 --let $EXPECTED_ERROR_NUMBER=ER_LOCK_WAIT_TIMEOUT
43 --let $SQL=SELECT COUNT(*) FROM mysql.role_edges WHERE from_user LIKE 'u1' FOR UPDATE;
44 --source acl_tables_locking_tests_helper.inc
45
46 --let $EXPECT_ERROR=1
47 --let $EXPECTED_ERROR_NUMBER=ER_LOCK_WAIT_TIMEOUT
48 --let $SQL=SELECT COUNT(*) FROM mysql.global_grants WHERE user LIKE 'u1' FOR UPDATE;
49 --source acl_tables_locking_tests_helper.inc
50
51 --let $EXPECT_ERROR=1
52 --let $EXPECTED_ERROR_NUMBER=ER_LOCK_WAIT_TIMEOUT
53 --let $SQL=SELECT COUNT(*) FROM mysql.global_grants WHERE user LIKE 'u1' FOR UPDATE;
54 --source acl_tables_locking_tests_helper.inc
55
56 --let $EXPECT_ERROR=1
57 --let $EXPECTED_ERROR_NUMBER=ER_LOCK_WAIT_TIMEOUT
58 --let $SQL=SELECT COUNT(*) FROM mysql.password_history WHERE user LIKE 'u1' FOR UPDATE;
59 --source acl_tables_locking_tests_helper.inc
60
61 --let $EXPECT_ERROR=1
62 --let $EXPECTED_ERROR_NUMBER=ER_LOCK_WAIT_TIMEOUT
63 --let $SQL=SELECT COUNT(*) FROM mysql.tables_priv WHERE user LIKE 'u1' FOR UPDATE;
64 --source acl_tables_locking_tests_helper.inc
65
66 --let $EXPECT_ERROR=1
67 --let $EXPECTED_ERROR_NUMBER=ER_LOCK_WAIT_TIMEOUT
68 --let $SQL=SELECT COUNT(*) FROM mysql.columns_priv WHERE user LIKE 'u1' FOR UPDATE;
69 --source acl_tables_locking_tests_helper.inc
70
71 --let $EXPECT_ERROR=1
72 --let $EXPECTED_ERROR_NUMBER=ER_LOCK_WAIT_TIMEOUT
73 --let $SQL=SELECT COUNT(*) FROM mysql.procs_priv WHERE user LIKE 'u1' FOR UPDATE;
74 --source acl_tables_locking_tests_helper.inc
75
76 --let $EXPECT_ERROR=1
77 --let $EXPECTED_ERROR_NUMBER=ER_LOCK_WAIT_TIMEOUT
78 --let $SQL=SELECT COUNT(*) FROM mysql.proxies_priv WHERE user LIKE 'u1' FOR UPDATE;
79 --source acl_tables_locking_tests_helper.inc
80
81 --echo # -----------------------------------------------------------------------
82 --echo # Cleanup
83 --echo # Restore initial values
84
85 --connection default
86 SET @@global.transaction_isolation = @global_start_value;
87 SELECT @@global.transaction_isolation;
88 SET @@session.transaction_isolation = @session_start_value;
89 SELECT @@session.transaction_isolation;