Debian Codegraph @

mysql-test/suite/auth_sec/r/flush_privileges.result

raw
1 #
2 # Bug#31491261: ENUM_SP_TYPE TO_SP_TYPE(LONGLONG):
3 # ASSERTION `VAL >= 1 && VAL <= 4' FAILED
4 #
5 # Setup
6 CREATE USER u31491261;
7 CREATE DATABASE db31491261;
8 CREATE PROCEDURE db31491261.p31491261() SELECT 1;
9 GRANT EXECUTE ON PROCEDURE db31491261.p31491261 TO u31491261;
10 CALL mtr.add_suppression("'procs_priv' entry 'p31491261' ignored, bad routine type");
11 # FLUSH PRIVILEGES should succeed
12 FLUSH PRIVILEGES;
13 # SHOW GRANTS should show EXECUTE privilege on db31491261.p31491261
14 SHOW GRANTS FOR 'u31491261';
15 Grants for u31491261@%
16 GRANT USAGE ON *.* TO `u31491261`@`%`
17 GRANT EXECUTE ON PROCEDURE `db31491261`.`p31491261` TO `u31491261`@`%`
18 UPDATE mysql.procs_priv SET Routine_type = '0' WHERE User like 'u31491261';
19 # FLUSH PRIVILEGES should succeed
20 FLUSH PRIVILEGES;
21 # Search for: 'procs_priv' entry 'p31491261' ignored, bad routine type
22 Pattern "'procs_priv' entry 'p31491261' ignored, bad routine type" found
23 # Search completed.
24 # SHOW GRANTS should not show EXECUTE privilege on db31491261.p31491261
25 SHOW GRANTS FOR 'u31491261';
26 Grants for u31491261@%
27 GRANT USAGE ON *.* TO `u31491261`@`%`
28 UPDATE mysql.procs_priv SET Routine_type = 'PROCEDURE' WHERE User like 'u31491261';
29 # FLUSH PRIVILEGES should succeed
30 FLUSH PRIVILEGES;
31 # SHOW GRANTS should show EXECUTE privilege on db31491261.p31491261
32 SHOW GRANTS FOR 'u31491261';
33 Grants for u31491261@%
34 GRANT USAGE ON *.* TO `u31491261`@`%`
35 GRANT EXECUTE ON PROCEDURE `db31491261`.`p31491261` TO `u31491261`@`%`
36 # Cleanup
37 DROP DATABASE db31491261;
38 DROP USER u31491261;
39 # End of 8.0 tests