Debian Codegraph @

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

raw
1 SELECT @@global.temptable_max_ram;
2 @@global.temptable_max_ram
3 1073741824
4 SELECT @@session.temptable_max_ram;
5 ERROR HY000: Variable 'temptable_max_ram' is a GLOBAL variable
6 SET @@global.temptable_max_ram = 5666777;
7 SELECT @@global.temptable_max_ram;
8 @@global.temptable_max_ram
9 5666777
10 SET @@global.temptable_max_ram = -5666777;
11 Warnings:
12 Warning 1292 Truncated incorrect temptable_max_ram value: '-5666777'
13 SELECT @@global.temptable_max_ram;
14 @@global.temptable_max_ram
15 2097152
16 SET @@global.temptable_max_ram = -1;
17 Warnings:
18 Warning 1292 Truncated incorrect temptable_max_ram value: '-1'
19 SELECT @@global.temptable_max_ram;
20 @@global.temptable_max_ram
21 2097152
22 SET @@global.temptable_max_ram = 0;
23 Warnings:
24 Warning 1292 Truncated incorrect temptable_max_ram value: '0'
25 SELECT @@global.temptable_max_ram;
26 @@global.temptable_max_ram
27 2097152
28 SET @@global.temptable_max_ram = 1;
29 Warnings:
30 Warning 1292 Truncated incorrect temptable_max_ram value: '1'
31 SELECT @@global.temptable_max_ram;
32 @@global.temptable_max_ram
33 2097152
34 SET @@global.temptable_max_ram = default;
35 SET @@global.temptable_max_ram = NULL;
36 ERROR 42000: Incorrect argument type to variable 'temptable_max_ram'
37 SELECT @@global.temptable_max_ram;
38 @@global.temptable_max_ram
39 1073741824
40 SET @@global.temptable_max_ram = 'foo';
41 ERROR 42000: Incorrect argument type to variable 'temptable_max_ram'
42 SELECT @@global.temptable_max_ram;
43 @@global.temptable_max_ram
44 1073741824