Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.new_mode;
2 SELECT @global_start_value;
3 @global_start_value
4
5 SET @session_start_value = @@session.new_mode;
6 SELECT @session_start_value;
7 @session_start_value
8
9 SET @@global.new_mode = "FIX_DISK_TMPTABLE_COSTS";
10 SELECT @@global.new_mode;
11 @@global.new_mode
12 FIX_DISK_TMPTABLE_COSTS
13 SELECT @@session.new_mode;
14 @@session.new_mode
15
16 SET @@global.new_mode = DEFAULT;
17 SELECT @@global.new_mode;
18 @@global.new_mode
19
20 SELECT @@session.new_mode;
21 @@session.new_mode
22
23 SET @@session.new_mode = "FIX_DISK_TMPTABLE_COSTS,TEST_WARNING1";
24 Warnings:
25 Warning 4200 The setting 'new_mode=TEST_WARNING1' is ignored. It only exists for compatibility with old installations and will be removed in a future release
26 SET @@session.new_mode = "FIX_DISK_TMPTABLE_COSTS,TEST_WARNING1,TEST_WARNING2";
27 Warnings:
28 Warning 4200 The setting 'new_mode=TEST_WARNING1' is ignored. It only exists for compatibility with old installations and will be removed in a future release
29 Warning 4200 The setting 'new_mode=TEST_WARNING2' is ignored. It only exists for compatibility with old installations and will be removed in a future release
30 SET @@session.new_mode = "FIX_DISK_TMPTABLE_COSTS,TEST_WARNING1,TEST_WARNING2,TEST_WARNING3";
31 ERROR 42000: Variable 'new_mode' can't be set to the value of 'TEST_WARNING3'
32 SET @@session.new_mode = "ALL";
33 select @@session.new_mode;
34 @@session.new_mode
35 FIX_DISK_TMPTABLE_COSTS,FIX_INDEX_STATS_FOR_ALL_NULLS,FIX_INDEX_LOOKUP_COST
36 SET @@global.new_mode = NULL;
37 ERROR 42000: Variable 'new_mode' can't be set to the value of 'NULL'
38 SET @@global.new_mode = '';
39 SELECT @@global.new_mode;
40 @@global.new_mode
41
42 SET @@global.new_mode = ' ';
43 SELECT @@global.new_mode;
44 @@global.new_mode
45
46 SET @@session.new_mode = NULL;
47 ERROR 42000: Variable 'new_mode' can't be set to the value of 'NULL'
48 SET @@session.new_mode = '';
49 SELECT @@session.new_mode;
50 @@session.new_mode
51
52 SET @@session.new_mode = ' ';
53 SELECT @@session.new_mode;
54 @@session.new_mode
55
56 SET @@global.new_mode = OFF;
57 ERROR 42000: Variable 'new_mode' can't be set to the value of 'OFF'
58 SET @@session.new_mode = OFF;
59 ERROR 42000: Variable 'new_mode' can't be set to the value of 'OFF'
60 SET @@global.new_mode = @global_start_value;
61 SELECT @@global.new_mode;
62 @@global.new_mode
63
64 SET @@session.new_mode = @session_start_value;
65 SELECT @@session.new_mode;
66 @@session.new_mode
67