Debian Codegraph @

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

raw
1 include/assert.inc [Default GLOBAL value is 3]
2 include/assert.inc [Default SESSION value 3]
3 SET @@PERSIST_ONLY.binlog_transaction_compression_level_zstd = DEFAULT;
4 include/assert.inc [Reported value matches the one set (set DEFAULT in PERSIST_ONLY scope)]
5 SET @@PERSIST_ONLY.binlog_transaction_compression_level_zstd = 22;
6 include/assert.inc [Reported value matches the one set (set 22 in PERSIST_ONLY scope)]
7 SET @@PERSIST_ONLY.binlog_transaction_compression_level_zstd = 1;
8 include/assert.inc [Reported value matches the one set (set 1 in PERSIST_ONLY scope)]
9 SET GLOBAL binlog_transaction_compression_level_zstd = 0;
10 Warnings:
11 Warning 1292 Truncated incorrect binlog_transaction_compression_level_zstd value: '0'
12 SELECT @@global.binlog_transaction_compression_level_zstd;
13 @@global.binlog_transaction_compression_level_zstd
14 1
15 SET SESSION binlog_transaction_compression_level_zstd = 0;
16 Warnings:
17 Warning 1292 Truncated incorrect binlog_transaction_compression_level_zstd value: '0'
18 SELECT @@session.binlog_transaction_compression_level_zstd;
19 @@session.binlog_transaction_compression_level_zstd
20 1
21 SET GLOBAL binlog_transaction_compression_level_zstd = 23;
22 Warnings:
23 Warning 1292 Truncated incorrect binlog_transaction_compression_level_zstd value: '23'
24 SELECT @@global.binlog_transaction_compression_level_zstd;
25 @@global.binlog_transaction_compression_level_zstd
26 22
27 SET SESSION binlog_transaction_compression_level_zstd = 23;
28 Warnings:
29 Warning 1292 Truncated incorrect binlog_transaction_compression_level_zstd value: '23'
30 SELECT @@session.binlog_transaction_compression_level_zstd;
31 @@session.binlog_transaction_compression_level_zstd
32 22
33 CREATE USER user1;
34 SET GLOBAL binlog_transaction_compression_level_zstd = 10;
35 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
36 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO user1@'%';
37 SET GLOBAL binlog_transaction_compression_level_zstd= 10;
38 DROP USER user1;
39 BEGIN;
40 SET SESSION binlog_transaction_compression_level_zstd=11;
41 ERROR HY000: The system variable binlog_transaction_compression_level_zstd cannot be set when there is an ongoing transaction.
42 SET GLOBAL binlog_transaction_compression_level_zstd=11;
43 SET PERSIST binlog_transaction_compression_level_zstd=11;
44 SET PERSIST_ONLY binlog_transaction_compression_level_zstd=11;
45 ROLLBACK;
46 RESET PERSIST;
47 SET @@session.binlog_transaction_compression_level_zstd = 3;
48 SET @@global.binlog_transaction_compression_level_zstd = 3;