############################################################################### # Verify the impact on JSON column due to combinations of # # various features pertaining to it. # # # ############################################################################### # Save the initial number of concurrent sessions --source include/count_sessions.inc --disable_query_log let $saved_partial_revokes = `SELECT @@global.partial_revokes`; --enable_query_log --echo # --echo # 1. Column must remain intact due to Global GRANT. --echo # SET GLOBAL partial_revokes = ON; CREATE USER foo; SELECT user, user_attributes FROM mysql.user WHERE user = 'foo'; GRANT INSERT ON *.* TO foo; SELECT user, user_attributes FROM mysql.user WHERE user = 'foo'; --echo # --echo # 2. Column must remain intact after Add/Drop partial revokes from user. --echo # REVOKE INSERT ON mysql.* FROM foo; GRANT INSERT ON mysql.* TO foo; SELECT user, user_attributes FROM mysql.user WHERE user = 'foo'; DROP USER foo; --echo # --echo # 3. Adding/removing partial revokes must not impact other attributes --echo # CREATE USER foo@localhost FAILED_LOGIN_ATTEMPTS 4 PASSWORD_LOCK_TIME 6; ALTER USER foo@localhost ATTRIBUTE '{"key":"value"}'; ALTER USER foo@localhost COMMENT 'Added key/value pair'; SELECT user, user_attributes FROM mysql.user WHERE user='foo'; GRANT SELECT ON *.* TO foo@localhost; REVOKE SELECT ON mysql.* FROM foo@localhost; --echo # Pre-existing attributes must not be changed. SELECT user, user_attributes FROM mysql.user WHERE user='foo'; GRANT SELECT ON mysql.* TO foo@localhost; --echo # Partial revoke must be removed. SELECT user, user_attributes FROM mysql.user WHERE user='foo'; DROP USER foo@localhost; # Cleanup --disable_query_log eval SET GLOBAL partial_revokes = $saved_partial_revokes; --enable_query_log # Wait till all disconnects are completed --source include/wait_until_count_sessions.inc