Debian Codegraph @

mysql-test/suite/auth_sec/t/flush_privileges.test

raw
1 # Save the initial number of concurrent sessions
2 --source include/count_sessions.inc
3
4 --echo #
5 --echo # Bug#31491261: ENUM_SP_TYPE TO_SP_TYPE(LONGLONG):
6 --echo # ASSERTION `VAL >= 1 && VAL <= 4' FAILED
7 --echo #
8
9 --echo # Setup
10 CREATE USER u31491261;
11 CREATE DATABASE db31491261;
12 CREATE PROCEDURE db31491261.p31491261() SELECT 1;
13 GRANT EXECUTE ON PROCEDURE db31491261.p31491261 TO u31491261;
14 CALL mtr.add_suppression("'procs_priv' entry 'p31491261' ignored, bad routine type");
15
16 --echo # FLUSH PRIVILEGES should succeed
17 FLUSH PRIVILEGES;
18
19 --echo # SHOW GRANTS should show EXECUTE privilege on db31491261.p31491261
20 SHOW GRANTS FOR 'u31491261';
21
22 UPDATE mysql.procs_priv SET Routine_type = '0' WHERE User like 'u31491261';
23
24 --echo # FLUSH PRIVILEGES should succeed
25 FLUSH PRIVILEGES;
26
27 --echo # Search for: 'procs_priv' entry 'p31491261' ignored, bad routine type
28 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err;
29 let SEARCH_PATTERN= 'procs_priv' entry 'p31491261' ignored, bad routine type;
30 --source include/search_pattern.inc
31 --echo # Search completed.
32
33 --echo # SHOW GRANTS should not show EXECUTE privilege on db31491261.p31491261
34 SHOW GRANTS FOR 'u31491261';
35
36 UPDATE mysql.procs_priv SET Routine_type = 'PROCEDURE' WHERE User like 'u31491261';
37
38 --echo # FLUSH PRIVILEGES should succeed
39 FLUSH PRIVILEGES;
40
41 --echo # SHOW GRANTS should show EXECUTE privilege on db31491261.p31491261
42 SHOW GRANTS FOR 'u31491261';
43
44 --echo # Cleanup
45 DROP DATABASE db31491261;
46 DROP USER u31491261;
47
48 # Wait till we reached the initial number of concurrent sessions
49 --source include/wait_until_count_sessions.inc
50
51 --echo # End of 8.0 tests