Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/server/mysql/mysql-test/suite/sys_vars/r/

Edit File: replication_sender_observe_commit_only.result

include/assert.inc [Default GLOBAL value is FALSE]
SET @@GLOBAL.replication_sender_observe_commit_only = OFF;
include/assert.inc [Reported value matches the one set (set OFF in GLOBAL scope)]
SET @@GLOBAL.replication_sender_observe_commit_only = FALSE;
include/assert.inc [Reported value matches the one set (set FALSE in GLOBAL scope)]
SET @@GLOBAL.replication_sender_observe_commit_only = 0;
include/assert.inc [Reported value matches the one set (set 0 in GLOBAL scope)]
SET @@GLOBAL.replication_sender_observe_commit_only = ON;
include/assert.inc [Reported value matches the one set (set ON in GLOBAL scope)]
SET @@GLOBAL.replication_sender_observe_commit_only = TRUE;
include/assert.inc [Reported value matches the one set (set TRUE in GLOBAL scope)]
SET @@GLOBAL.replication_sender_observe_commit_only = 1;
include/assert.inc [Reported value matches the one set (set 1 in GLOBAL scope)]
CREATE USER user1;
SET GLOBAL replication_sender_observe_commit_only = 1;
ERROR 42000: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
GRANT SUPER ON *.* TO user1@'%';
FLUSH PRIVILEGES;
SET GLOBAL replication_sender_observe_commit_only = 1;
DROP USER user1;
BEGIN;
SET GLOBAL replication_sender_observe_commit_only = ON;
ROLLBACK;
SET @@global.replication_sender_observe_commit_only = 0;