Debian Codegraph @

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

raw
1 SET @mysqlx_max_allowed_packet_sav= @@global.mysqlx_max_allowed_packet;
2 SET GLOBAL mysqlx_max_allowed_packet=5000000;
3 SET @@global.mysqlx_max_allowed_packet=7000000;
4 show variables like 'mysqlx_max_allowed_packet';
5 Variable_name Value
6 mysqlx_max_allowed_packet 7000000
7 SET mysqlx_max_allowed_packet=5000000;
8 ERROR HY000: Variable 'mysqlx_max_allowed_packet' is a GLOBAL variable and should be set with SET GLOBAL
9 SET @@local.mysqlx_max_allowed_packet=5000000;
10 ERROR HY000: Variable 'mysqlx_max_allowed_packet' is a GLOBAL variable and should be set with SET GLOBAL
11 SET @@mysqlx_max_allowed_packet=5000000;
12 ERROR HY000: Variable 'mysqlx_max_allowed_packet' is a GLOBAL variable and should be set with SET GLOBAL
13 SET @@session.mysqlx_max_allowed_packet=5000000;
14 ERROR HY000: Variable 'mysqlx_max_allowed_packet' is a GLOBAL variable and should be set with SET GLOBAL
15 SET SESSION mysqlx_max_allowed_packet=5000000;
16 ERROR HY000: Variable 'mysqlx_max_allowed_packet' is a GLOBAL variable and should be set with SET GLOBAL
17 SET @@global.mysqlx_max_allowed_packet=0;
18 Warnings:
19 Warning 1292 Truncated incorrect mysqlx_max_allowed_packet value: '0'
20 SET @@global.mysqlx_max_allowed_packet=-123;
21 Warnings:
22 Warning 1292 Truncated incorrect mysqlx_max_allowed_packet value: '-123'
23 SET @@global.mysqlx_max_allowed_packet='crash#$%';
24 ERROR 42000: Incorrect argument type to variable 'mysqlx_max_allowed_packet'
25 show variables like 'mysqlx_max_allowed_packet';
26 Variable_name Value
27 mysqlx_max_allowed_packet 512
28 SET @@global.mysqlx_max_allowed_packet=1048576;
29 SET @@global.mysqlx_max_allowed_packet= @mysqlx_max_allowed_packet_sav;