Debian Codegraph @

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

raw
1 --source include/load_sysvars.inc
2 --source include/have_debug.inc
3
4 SET @global_start_value = @@global.new_mode;
5 SELECT @global_start_value;
6
7 SET @session_start_value = @@session.new_mode;
8 SELECT @session_start_value;
9
10 SET @@global.new_mode = "FIX_DISK_TMPTABLE_COSTS";
11 SELECT @@global.new_mode;
12 SELECT @@session.new_mode;
13 SET @@global.new_mode = DEFAULT;
14 SELECT @@global.new_mode;
15 SELECT @@session.new_mode;
16
17 SET @@session.new_mode = "FIX_DISK_TMPTABLE_COSTS,TEST_WARNING1";
18 SET @@session.new_mode = "FIX_DISK_TMPTABLE_COSTS,TEST_WARNING1,TEST_WARNING2";
19 --Error ER_WRONG_VALUE_FOR_VAR
20 SET @@session.new_mode = "FIX_DISK_TMPTABLE_COSTS,TEST_WARNING1,TEST_WARNING2,TEST_WARNING3";
21
22 SET @@session.new_mode = "ALL";
23 select @@session.new_mode;
24
25 --Error ER_WRONG_VALUE_FOR_VAR
26 SET @@global.new_mode = NULL;
27
28 SET @@global.new_mode = '';
29 SELECT @@global.new_mode;
30
31 SET @@global.new_mode = ' ';
32 SELECT @@global.new_mode;
33
34 --Error ER_WRONG_VALUE_FOR_VAR
35 SET @@session.new_mode = NULL;
36
37 SET @@session.new_mode = '';
38 SELECT @@session.new_mode;
39
40 SET @@session.new_mode = ' ';
41 SELECT @@session.new_mode;
42
43 --Error ER_WRONG_VALUE_FOR_VAR
44 SET @@global.new_mode = OFF;
45
46 --Error ER_WRONG_VALUE_FOR_VAR
47 SET @@session.new_mode = OFF;
48
49 SET @@global.new_mode = @global_start_value;
50 SELECT @@global.new_mode;
51
52 SET @@session.new_mode = @session_start_value;
53 SELECT @@session.new_mode;