1include/assert.inc [Default GLOBAL value is FALSE]
2SET @@GLOBAL.replication_sender_observe_commit_only = OFF;
3include/assert.inc [Reported value matches the one set (set OFF in GLOBAL scope)]
4SET @@GLOBAL.replication_sender_observe_commit_only = FALSE;
5include/assert.inc [Reported value matches the one set (set FALSE in GLOBAL scope)]
6SET @@GLOBAL.replication_sender_observe_commit_only = 0;
7include/assert.inc [Reported value matches the one set (set 0 in GLOBAL scope)]
8SET @@GLOBAL.replication_sender_observe_commit_only = ON;
9include/assert.inc [Reported value matches the one set (set ON in GLOBAL scope)]
10SET @@GLOBAL.replication_sender_observe_commit_only = TRUE;
11include/assert.inc [Reported value matches the one set (set TRUE in GLOBAL scope)]
12SET @@GLOBAL.replication_sender_observe_commit_only = 1;
13include/assert.inc [Reported value matches the one set (set 1 in GLOBAL scope)]
14CREATE USER user1;
15SET GLOBAL replication_sender_observe_commit_only = 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_sender_observe_commit_only = 1;
20DROP USER user1;
21BEGIN;
22SET GLOBAL replication_sender_observe_commit_only = ON;
23ROLLBACK;
24SET @@global.replication_sender_observe_commit_only = 0;
25