Debian Codegraph @

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

raw
1 #
2 # Check behavior of ACL DDLs when simple and locking SELECTs
3 # are run concurrently with it.
4 #
5 # Usage:
6 # --let $ISOLATION_LEVEL=<isolation level>
7 # --source ../include/acl_tables_locking_tests_big.inc
8
9 --echo # -----------------------------------------------------------------------
10 --echo # Setup
11 --echo # Saving initial values
12 SET @global_start_value = @@global.transaction_isolation;
13 SELECT @global_start_value;
14 SET @session_start_value = @@session.transaction_isolation;
15 SELECT @session_start_value;
16
17 --echo # Setting transaction isolation to '$ISOLATION_LEVEL'
18 --eval SET GLOBAL transaction_isolation = '$ISOLATION_LEVEL'
19
20 --echo # -----------------------------------------------------------------------
21 --echo # ACL DDLs + Simple SELECTs
22
23 --let $EXPECT_ERROR=0
24 --let $SQL=SELECT COUNT(*) FROM mysql.user WHERE user LIKE 'u1'
25 --source acl_tables_locking_tests_helper.inc
26
27 --let $EXPECT_ERROR=0
28 --let $SQL=SELECT COUNT(*) FROM mysql.db WHERE user LIKE 'u1';
29 --source acl_tables_locking_tests_helper.inc
30
31 --let $EXPECT_ERROR=0
32 --let $SQL=SELECT COUNT(*) FROM mysql.default_roles WHERE user LIKE 'u1'
33 --source acl_tables_locking_tests_helper.inc
34
35 --let $EXPECT_ERROR=0
36 --let $SQL=SELECT COUNT(*) FROM mysql.role_edges WHERE from_user LIKE 'u1'
37 --source acl_tables_locking_tests_helper.inc
38
39 --let $EXPECT_ERROR=0
40 --let $SQL=SELECT COUNT(*) FROM mysql.global_grants WHERE user LIKE 'u1'
41 --source acl_tables_locking_tests_helper.inc
42
43 --let $EXPECT_ERROR=0
44 --let $SQL=SELECT COUNT(*) FROM mysql.password_history WHERE user LIKE 'u1'
45 --source acl_tables_locking_tests_helper.inc
46
47 --let $EXPECT_ERROR=0
48 --let $SQL=SELECT COUNT(*) FROM mysql.tables_priv WHERE user LIKE 'u1'
49 --source acl_tables_locking_tests_helper.inc
50
51 --let $EXPECT_ERROR=0
52 --let $SQL=SELECT COUNT(*) FROM mysql.columns_priv WHERE user LIKE 'u1'
53 --source acl_tables_locking_tests_helper.inc
54
55 --let $EXPECT_ERROR=0
56 --let $SQL=SELECT COUNT(*) FROM mysql.procs_priv WHERE user LIKE 'u1'
57 --source acl_tables_locking_tests_helper.inc
58
59 --let $EXPECT_ERROR=0
60 --let $SQL=SELECT COUNT(*) FROM mysql.proxies_priv WHERE user LIKE 'u1'
61 --source acl_tables_locking_tests_helper.inc
62
63 --echo # -----------------------------------------------------------------------
64 --echo # Cleanup
65 --echo # Restore initial values
66
67 --connection default
68 SET @@global.transaction_isolation = @global_start_value;
69 SELECT @@global.transaction_isolation;
70 SET @@session.transaction_isolation = @session_start_value;
71 SELECT @@session.transaction_isolation;