Debian Codegraph @

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

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