Debian Codegraph @

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

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