Debian Codegraph @

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

raw
1 SELECT @@global.connection_memory_limit;
2 @@global.connection_memory_limit
3 18446744073709551615
4 SELECT @@session.connection_memory_limit;
5 @@session.connection_memory_limit
6 18446744073709551615
7 SET @@global.connection_memory_limit = 25666777;
8 SELECT @@global.connection_memory_limit;
9 @@global.connection_memory_limit
10 25666777
11 SET @@session.connection_memory_limit = 25666777;
12 SELECT @@session.connection_memory_limit;
13 @@session.connection_memory_limit
14 25666777
15 SET @@global.connection_memory_limit = -5666777;
16 Warnings:
17 Warning 1292 Truncated incorrect connection_memory_limit value: '-5666777'
18 SELECT @@global.connection_memory_limit;
19 @@global.connection_memory_limit
20 2097152
21 SET @@session.connection_memory_limit = -5666777;
22 Warnings:
23 Warning 1292 Truncated incorrect connection_memory_limit value: '-5666777'
24 SELECT @@session.connection_memory_limit;
25 @@session.connection_memory_limit
26 2097152
27 SET @@global.connection_memory_limit = -1;
28 Warnings:
29 Warning 1292 Truncated incorrect connection_memory_limit value: '-1'
30 SELECT @@global.connection_memory_limit;
31 @@global.connection_memory_limit
32 2097152
33 SET @@session.connection_memory_limit = -1;
34 Warnings:
35 Warning 1292 Truncated incorrect connection_memory_limit value: '-1'
36 SELECT @@session.connection_memory_limit;
37 @@session.connection_memory_limit
38 2097152
39 SET @@global.connection_memory_limit = 0;
40 Warnings:
41 Warning 1292 Truncated incorrect connection_memory_limit value: '0'
42 SELECT @@global.connection_memory_limit;
43 @@global.connection_memory_limit
44 2097152
45 SET @@session.connection_memory_limit = 0;
46 Warnings:
47 Warning 1292 Truncated incorrect connection_memory_limit value: '0'
48 SELECT @@session.connection_memory_limit;
49 @@session.connection_memory_limit
50 2097152
51 SET @@global.connection_memory_limit = default;
52 SET @@session.connection_memory_limit = default;
53 SET @@global.connection_memory_limit = NULL;
54 ERROR 42000: Incorrect argument type to variable 'connection_memory_limit'
55 SELECT @@global.connection_memory_limit;
56 @@global.connection_memory_limit
57 18446744073709551615
58 SET @@session.connection_memory_limit = NULL;
59 ERROR 42000: Incorrect argument type to variable 'connection_memory_limit'
60 SELECT @@session.connection_memory_limit;
61 @@session.connection_memory_limit
62 18446744073709551615
63 SET @@global.connection_memory_limit = 'foo';
64 ERROR 42000: Incorrect argument type to variable 'connection_memory_limit'
65 SELECT @@global.connection_memory_limit;
66 @@global.connection_memory_limit
67 18446744073709551615
68 SET @@session.connection_memory_limit = 'foo';
69 ERROR 42000: Incorrect argument type to variable 'connection_memory_limit'
70 SELECT @@session.connection_memory_limit;
71 @@session.connection_memory_limit
72 18446744073709551615