Debian Codegraph @

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

raw
1 --source include/have_64bit.inc
2 --source include/load_sysvars.inc
3 --source include/have_nodebug.inc
4
5 SELECT @@global.global_connection_memory_limit;
6
7 -- error ER_INCORRECT_GLOBAL_LOCAL_VAR
8 SELECT @@session.global_connection_memory_limit;
9
10 SET @@global.global_connection_memory_limit = 25666777;
11 SELECT @@global.global_connection_memory_limit;
12
13 SET @@global.global_connection_memory_limit = -5666777;
14 SELECT @@global.global_connection_memory_limit;
15
16 SET @@global.global_connection_memory_limit = -1;
17 SELECT @@global.global_connection_memory_limit;
18
19 SET @@global.global_connection_memory_limit = 0;
20 SELECT @@global.global_connection_memory_limit;
21
22 SET @@global.global_connection_memory_limit = default;
23
24 -- error ER_WRONG_TYPE_FOR_VAR
25 SET @@global.global_connection_memory_limit = NULL;
26 SELECT @@global.global_connection_memory_limit;
27
28 -- error ER_WRONG_TYPE_FOR_VAR
29 SET @@global.global_connection_memory_limit = 'foo';
30 SELECT @@global.global_connection_memory_limit;