Debian Codegraph @

mysql-test/suite/sys_vars/t/mysqlx_max_allowed_packet_basic.test

raw
1 # Variable: mysqlx_max_allowed_packet
2 # Default : 1048576
3 # Scope : GLOBAL
4 # Dynamic : Yes
5
6 SET @mysqlx_max_allowed_packet_sav= @@global.mysqlx_max_allowed_packet;
7
8 ## Valid cases
9 SET GLOBAL mysqlx_max_allowed_packet=5000000;
10 SET @@global.mysqlx_max_allowed_packet=7000000;
11 show variables like 'mysqlx_max_allowed_packet';
12
13 ## Invalid cases
14 --error ER_GLOBAL_VARIABLE
15 SET mysqlx_max_allowed_packet=5000000;
16 --error ER_GLOBAL_VARIABLE
17 SET @@local.mysqlx_max_allowed_packet=5000000;
18 --error ER_GLOBAL_VARIABLE
19 SET @@mysqlx_max_allowed_packet=5000000;
20 --error ER_GLOBAL_VARIABLE
21 SET @@session.mysqlx_max_allowed_packet=5000000;
22 --error ER_GLOBAL_VARIABLE
23 SET SESSION mysqlx_max_allowed_packet=5000000;
24
25 SET @@global.mysqlx_max_allowed_packet=0;
26
27 # Setting negative value for mysqlx_max_allowed_packet
28 # is assinging 512 packet size automaticaly.
29 SET @@global.mysqlx_max_allowed_packet=-123;
30 --error ER_WRONG_TYPE_FOR_VAR
31 SET @@global.mysqlx_max_allowed_packet='crash#$%';
32
33 show variables like 'mysqlx_max_allowed_packet';
34 SET @@global.mysqlx_max_allowed_packet=1048576;
35
36 SET @@global.mysqlx_max_allowed_packet= @mysqlx_max_allowed_packet_sav;