1# 2# MDEV-21704 Add a new JSON field "version_id" into mysql.global_priv.priv 3# 4SET @super_acl_100500= 1 << 15; 5SELECT HEX(@super_acl_100500); 6HEX(@super_acl_100500) 78000 8SET @all_known_privileges_100500= (1 << 30) - 1; 9SELECT HEX(@all_known_privileges_100500); 10HEX(@all_known_privileges_100500) 113FFFFFFF 12CREATE USER user1@localhost; 13GRANT ALL PRIVILEGES ON *.* TO user1@localhost WITH GRANT OPTION; 14SET @all_known_privileges_current=(SELECT CAST(json_value(Priv, '$.access') AS UNSIGNED) FROM mysql.global_priv WHERE host='localhost' and user='user1'); 15DROP USER user1@localhost; 16SELECT HEX(@all_known_privileges_current); 17HEX(@all_known_privileges_current) 187FFFFFFFFF 19CREATE USER bad_access1@localhost; 20UPDATE 21mysql.global_priv 22SET 23Priv=json_set(Priv, '$.access',@all_known_privileges_current+1) 24WHERE 25host='localhost' and user='bad_access1'; 26FLUSH PRIVILEGES; 27SHOW GRANTS FOR bad_access1@localhost; 28Grants for bad_access1@localhost 29GRANT USAGE ON *.* TO `bad_access1`@`localhost` 30DROP USER bad_access1@localhost; 31CREATE USER bad_version_id_1000000@localhost; 32GRANT ALL PRIVILEGES ON *.* to bad_version_id_1000000@localhost; 33SHOW GRANTS FOR bad_version_id_1000000@localhost; 34Grants for bad_version_id_1000000@localhost 35GRANT ALL PRIVILEGES ON *.* TO `bad_version_id_1000000`@`localhost` 36UPDATE 37mysql.global_priv 38SET 39Priv=json_set(Priv, '$.version_id',1000000) 40WHERE 41host='localhost' and user='bad_version_id_1000000'; 42FLUSH PRIVILEGES; 43SHOW GRANTS FOR bad_version_id_1000000@localhost; 44Grants for bad_version_id_1000000@localhost 45GRANT USAGE ON *.* TO `bad_version_id_1000000`@`localhost` 46DROP USER bad_version_id_1000000@localhost; 47CREATE USER bad_version_id_minus_3@localhost; 48GRANT ALL PRIVILEGES ON *.* to bad_version_id_minus_3@localhost; 49SHOW GRANTS FOR bad_version_id_minus_3@localhost; 50Grants for bad_version_id_minus_3@localhost 51GRANT ALL PRIVILEGES ON *.* TO `bad_version_id_minus_3`@`localhost` 52UPDATE 53mysql.global_priv 54SET 55Priv=json_set(Priv, '$.version_id',-3) 56WHERE 57host='localhost' and user='bad_version_id_minus_3'; 58FLUSH PRIVILEGES; 59SHOW GRANTS FOR bad_version_id_minus_3@localhost; 60Grants for bad_version_id_minus_3@localhost 61GRANT USAGE ON *.* TO `bad_version_id_minus_3`@`localhost` 62DROP USER bad_version_id_minus_3@localhost; 63CREATE USER bad_version_id_100300@localhost; 64GRANT ALL PRIVILEGES ON *.* to bad_version_id_100300@localhost; 65SHOW GRANTS FOR bad_version_id_100300@localhost; 66Grants for bad_version_id_100300@localhost 67GRANT ALL PRIVILEGES ON *.* TO `bad_version_id_100300`@`localhost` 68UPDATE 69mysql.global_priv 70SET 71Priv=json_set(Priv, '$.version_id',100300) 72WHERE 73host='localhost' and user='bad_version_id_100300'; 74FLUSH PRIVILEGES; 75SHOW GRANTS FOR bad_version_id_100300@localhost; 76Grants for bad_version_id_100300@localhost 77GRANT USAGE ON *.* TO `bad_version_id_100300`@`localhost` 78DROP USER bad_version_id_100300@localhost; 79CREATE USER good_version_id_100400@localhost; 80GRANT ALL PRIVILEGES ON *.* to good_version_id_100400@localhost; 81SHOW GRANTS FOR good_version_id_100400@localhost; 82Grants for good_version_id_100400@localhost 83GRANT ALL PRIVILEGES ON *.* TO `good_version_id_100400`@`localhost` 84UPDATE 85mysql.global_priv 86SET 87Priv=json_set(Priv, '$.version_id',100400, '$.access', @all_known_privileges_100500) 88WHERE 89host='localhost' and user='good_version_id_100400'; 90FLUSH PRIVILEGES; 91SHOW GRANTS FOR good_version_id_100400@localhost; 92Grants for good_version_id_100400@localhost 93GRANT ALL PRIVILEGES ON *.* TO `good_version_id_100400`@`localhost` WITH GRANT OPTION 94GRANT REPLICATION MASTER ADMIN ON *.* TO good_version_id_100400@localhost; 95SHOW GRANTS FOR good_version_id_100400@localhost; 96Grants for good_version_id_100400@localhost 97GRANT ALL PRIVILEGES ON *.* TO `good_version_id_100400`@`localhost` WITH GRANT OPTION 98DROP USER good_version_id_100400@localhost; 99CREATE USER good_version_id_100500@localhost; 100GRANT SUPER ON *.* to good_version_id_100500@localhost; 101SHOW GRANTS FOR good_version_id_100500@localhost; 102Grants for good_version_id_100500@localhost 103GRANT SUPER ON *.* TO `good_version_id_100500`@`localhost` 104UPDATE 105mysql.global_priv 106SET 107Priv=json_set(Priv, '$.version_id',100500) 108WHERE 109host='localhost' and user='good_version_id_100500'; 110FLUSH PRIVILEGES; 111SHOW GRANTS FOR good_version_id_100500@localhost; 112Grants for good_version_id_100500@localhost 113GRANT SUPER, SET USER, FEDERATED ADMIN, CONNECTION ADMIN, READ_ONLY ADMIN, REPLICATION SLAVE ADMIN, BINLOG ADMIN, BINLOG REPLAY ON *.* TO `good_version_id_100500`@`localhost` 114DROP USER good_version_id_100500@localhost; 115FOUND 1 /Warning.*'user' entry 'bad_access1@localhost' has a wrong 'access' value.*version_id=/ in system_mysql_db_error_log.err 116FOUND 1 /Warning.*'user' entry 'bad_version_id_1000000@localhost' has a wrong 'version_id' value 1000000/ in system_mysql_db_error_log.err 117FOUND 1 /Warning.*'user' entry 'bad_version_id_minus_3@localhost' has a wrong 'version_id' value -3/ in system_mysql_db_error_log.err 118FOUND 1 /Warning.*'user' entry 'bad_version_id_100300@localhost' has a wrong 'version_id' value 100300/ in system_mysql_db_error_log.err 119