Debian Codegraph @

mysql-test/suite/sys_vars/t/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.connection_memory_limit;
6 SELECT @@session.connection_memory_limit;
7
8 SET @@global.connection_memory_limit = 25666777;
9 SELECT @@global.connection_memory_limit;
10
11 SET @@session.connection_memory_limit = 25666777;
12 SELECT @@session.connection_memory_limit;
13
14 SET @@global.connection_memory_limit = -5666777;
15 SELECT @@global.connection_memory_limit;
16
17 SET @@session.connection_memory_limit = -5666777;
18 SELECT @@session.connection_memory_limit;
19
20 SET @@global.connection_memory_limit = -1;
21 SELECT @@global.connection_memory_limit;
22
23 SET @@session.connection_memory_limit = -1;
24 SELECT @@session.connection_memory_limit;
25
26 SET @@global.connection_memory_limit = 0;
27 SELECT @@global.connection_memory_limit;
28
29 SET @@session.connection_memory_limit = 0;
30 SELECT @@session.connection_memory_limit;
31
32 SET @@global.connection_memory_limit = default;
33 SET @@session.connection_memory_limit = default;
34
35 -- error ER_WRONG_TYPE_FOR_VAR
36 SET @@global.connection_memory_limit = NULL;
37 SELECT @@global.connection_memory_limit;
38
39 -- error ER_WRONG_TYPE_FOR_VAR
40 SET @@session.connection_memory_limit = NULL;
41 SELECT @@session.connection_memory_limit;
42
43
44 -- error ER_WRONG_TYPE_FOR_VAR
45 SET @@global.connection_memory_limit = 'foo';
46 SELECT @@global.connection_memory_limit;
47
48 -- error ER_WRONG_TYPE_FOR_VAR
49 SET @@session.connection_memory_limit = 'foo';
50 SELECT @@session.connection_memory_limit;