Debian Codegraph @

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

raw
1 --source include/load_sysvars.inc
2
3 SELECT @@global.global_connection_memory_tracking;
4 SELECT @@session.global_connection_memory_tracking;
5
6 SET @@global.global_connection_memory_tracking = ON;
7 SELECT @@global.global_connection_memory_tracking;
8
9 SET @@session.global_connection_memory_tracking = ON;
10 SELECT @@session.global_connection_memory_tracking;
11
12 -- error ER_WRONG_VALUE_FOR_VAR
13 SET @@global.global_connection_memory_tracking = -5666777;
14 SELECT @@global.global_connection_memory_tracking;
15
16 -- error ER_WRONG_VALUE_FOR_VAR
17 SET @@session.global_connection_memory_tracking = -5666777;
18 SELECT @@session.global_connection_memory_tracking;
19
20 -- error ER_WRONG_VALUE_FOR_VAR
21 SET @@global.global_connection_memory_tracking = -1;
22 SELECT @@global.global_connection_memory_tracking;
23
24 -- error ER_WRONG_VALUE_FOR_VAR
25 SET @@session.global_connection_memory_tracking = -1;
26 SELECT @@session.global_connection_memory_tracking;
27
28 SET @@global.global_connection_memory_tracking = OFF;
29 SELECT @@global.global_connection_memory_tracking;
30
31 SET @@session.global_connection_memory_tracking = OFF;
32 SELECT @@session.global_connection_memory_tracking;
33
34 SET @@global.global_connection_memory_tracking = default;
35 SET @@session.global_connection_memory_tracking = default;
36
37 -- error ER_WRONG_VALUE_FOR_VAR
38 SET @@global.global_connection_memory_tracking = NULL;
39 SELECT @@global.global_connection_memory_tracking;
40
41 -- error ER_WRONG_VALUE_FOR_VAR
42 #SET @@session.global_connection_memory_tracking = NULL;
43 #SELECT @@session.global_connection_memory_tracking;
44
45
46 -- error ER_WRONG_VALUE_FOR_VAR
47 SET @@global.global_connection_memory_tracking = 'foo';
48 SELECT @@global.global_connection_memory_tracking;
49
50 -- error ER_WRONG_VALUE_FOR_VAR
51 SET @@session.global_connection_memory_tracking = 'foo';
52 SELECT @@session.global_connection_memory_tracking;