Debian Codegraph @

mysql-test/suite/sys_vars/r/replication_optimize_for_static_plugin_config.result

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