1include/assert.inc [Default GLOBAL value is FALSE] 2SET @@GLOBAL.replication_optimize_for_static_plugin_config = OFF; 3include/assert.inc [Reported value matches the one set (set OFF in GLOBAL scope)] 4SET @@GLOBAL.replication_optimize_for_static_plugin_config = FALSE; 5include/assert.inc [Reported value matches the one set (set FALSE in GLOBAL scope)] 6SET @@GLOBAL.replication_optimize_for_static_plugin_config = 0; 7include/assert.inc [Reported value matches the one set (set 0 in GLOBAL scope)] 8SET @@GLOBAL.replication_optimize_for_static_plugin_config = ON; 9include/assert.inc [Reported value matches the one set (set ON in GLOBAL scope)] 10SET @@GLOBAL.replication_optimize_for_static_plugin_config = TRUE; 11include/assert.inc [Reported value matches the one set (set TRUE in GLOBAL scope)] 12SET @@GLOBAL.replication_optimize_for_static_plugin_config = 1; 13include/assert.inc [Reported value matches the one set (set 1 in GLOBAL scope)] 14CREATE USER user1; 15SET GLOBAL replication_optimize_for_static_plugin_config = 1; 16ERROR 42000: Access denied; you need (at least one of) the SUPER privilege(s) for this operation 17GRANT SUPER ON *.* TO user1@'%'; 18FLUSH PRIVILEGES; 19SET GLOBAL replication_optimize_for_static_plugin_config = 1; 20DROP USER user1; 21BEGIN; 22SET GLOBAL replication_optimize_for_static_plugin_config = ON; 23ROLLBACK; 24SET GLOBAL replication_optimize_for_static_plugin_config = 1; 25INSTALL PLUGIN rpl_semi_sync_master SONAME 'SEMISYNC_MASTER_LIB'; 26UNINSTALL PLUGIN rpl_semi_sync_master; 27Warnings: 28Warning 1620 Plugin is busy and will be uninstalled on shutdown 29include/assert.inc [Semi-sync not disposed because it is in use] 30SET GLOBAL replication_optimize_for_static_plugin_config = 0; 31include/assert.inc [Semi-sync disposed because it is no longer in use] 32INSTALL PLUGIN rpl_semi_sync_master SONAME 'SEMISYNC_MASTER_LIB'; 33UNINSTALL PLUGIN rpl_semi_sync_master; 34include/assert.inc [Semi-sync disposed because it is no longer in use] 35SET @@global.replication_optimize_for_static_plugin_config = 0; 36