Debian Codegraph @

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

raw
1 include/assert.inc [Default GLOBAL value is OFF]
2 include/assert.inc [Default SESSION value is OFF]
3 SET @@PERSIST_ONLY.binlog_transaction_compression = DEFAULT;
4 include/assert.inc [Reported value matches the one set (set DEFAULT in PERSIST_ONLY scope)]
5 SET @@PERSIST_ONLY.binlog_transaction_compression = OFF;
6 include/assert.inc [Reported value matches the one set (set OFF in PERSIST_ONLY scope)]
7 SET @@PERSIST_ONLY.binlog_transaction_compression = FALSE;
8 include/assert.inc [Reported value matches the one set (set FALSE in PERSIST_ONLY scope)]
9 SET @@PERSIST_ONLY.binlog_transaction_compression = 0;
10 include/assert.inc [Reported value matches the one set (set 0 in PERSIST_ONLY scope)]
11 SET @@PERSIST_ONLY.binlog_transaction_compression = ON;
12 include/assert.inc [Reported value matches the one set (set ON in PERSIST_ONLY scope)]
13 SET @@PERSIST_ONLY.binlog_transaction_compression = TRUE;
14 include/assert.inc [Reported value matches the one set (set TRUE in PERSIST_ONLY scope)]
15 SET @@PERSIST_ONLY.binlog_transaction_compression = 1;
16 include/assert.inc [Reported value matches the one set (set 1 in PERSIST_ONLY scope)]
17 CREATE USER user1;
18 SET GLOBAL binlog_transaction_compression = ON;
19 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
20 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO user1@'%';
21 SET GLOBAL binlog_transaction_compression=ON;
22 DROP USER user1;
23 BEGIN;
24 SET SESSION binlog_transaction_compression=ON;
25 ERROR HY000: The system variable binlog_transaction_compression cannot be set when there is an ongoing transaction.
26 SET GLOBAL binlog_transaction_compression=ON;
27 SET PERSIST binlog_transaction_compression=ON;
28 SET PERSIST_ONLY binlog_transaction_compression=ON;
29 ROLLBACK;
30 RESET PERSIST;
31 SET @@session.binlog_transaction_compression = 0;
32 SET @@global.binlog_transaction_compression = 0;