1
SET @global_start_value = @@global.old_mode;
2
SELECT @global_start_value;
5
SET @session_start_value = @@session.old_mode;
6
SELECT @session_start_value;
9
'#--------------------FN_DYNVARS_152_01------------------------#'
10
SET @@global.old_mode = "NO_PROGRESS_INFO";
11
SET @@global.old_mode = DEFAULT;
12
SELECT @@global.old_mode;
15
SET @@session.old_mode = "NO_PROGRESS_INFO";
16
SET @@session.old_mode = DEFAULT;
17
SELECT @@session.old_mode;
20
'#---------------------FN_DYNVARS_152_02-------------------------#'
21
SET @@global.old_mode = NULL;
22
ERROR 42000: Variable 'old_mode' can't be set to the value of 'NULL'
23
SET @@global.old_mode = '';
24
SELECT @@global.old_mode;
27
SET @@global.old_mode = ' ';
28
SELECT @@global.old_mode;
31
SET @@session.old_mode = NULL;
32
ERROR 42000: Variable 'old_mode' can't be set to the value of 'NULL'
33
SET @@session.old_mode = '';
34
SELECT @@session.old_mode;
37
SET @@session.old_mode = ' ';
38
SELECT @@session.old_mode;
41
'#--------------------FN_DYNVARS_152_03------------------------#'
42
SET @@global.old_mode = NO_PROGRESS_INFO;
43
SELECT @@global.old_mode;
46
SET @@global.old_mode = NO_DUP_KEY_WARNINGS_WITH_IGNORE;
47
SELECT @@global.old_mode;
49
NO_DUP_KEY_WARNINGS_WITH_IGNORE
50
SET @@global.old_mode = OFF;
51
ERROR 42000: Variable 'old_mode' can't be set to the value of 'OFF'
52
SET @@session.old_mode = NO_PROGRESS_INFO;
53
SELECT @@session.old_mode;
56
SET @@session.old_mode = NO_DUP_KEY_WARNINGS_WITH_IGNORE;
57
SELECT @@session.old_mode;
59
NO_DUP_KEY_WARNINGS_WITH_IGNORE
60
SET @@session.old_mode = OFF;
61
ERROR 42000: Variable 'old_mode' can't be set to the value of 'OFF'
62
SET @@global.old_mode = '?';
63
ERROR 42000: Variable 'old_mode' can't be set to the value of '?'
64
SELECT @@global.old_mode;
66
NO_DUP_KEY_WARNINGS_WITH_IGNORE
67
'#--------------------FN_DYNVARS_152_04-------------------------#'
68
SET @@global.old_mode = -1;
69
ERROR 42000: Variable 'old_mode' can't be set to the value of '-1'
70
SET @@global.old_mode = ASCII;
71
ERROR 42000: Variable 'old_mode' can't be set to the value of 'ASCII'
72
SET @@global.old_mode = NON_TRADITIONAL;
73
ERROR 42000: Variable 'old_mode' can't be set to the value of 'NON_TRADITIONAL'
74
SET @@global.old_mode = 'OF';
75
ERROR 42000: Variable 'old_mode' can't be set to the value of 'OF'
76
SET @@global.old_mode = NONE;
77
ERROR 42000: Variable 'old_mode' can't be set to the value of 'NONE'
78
SET @@session.old_mode = -1;
79
ERROR 42000: Variable 'old_mode' can't be set to the value of '-1'
80
SET @@session.old_mode = ANSI_SINGLE_QUOTES;
81
ERROR 42000: Variable 'old_mode' can't be set to the value of 'ANSI_SINGLE_QUOTES'
82
SET @@session.old_mode = 'ON';
83
ERROR 42000: Variable 'old_mode' can't be set to the value of 'ON'
84
SET @@session.old_mode = 'OF';
85
ERROR 42000: Variable 'old_mode' can't be set to the value of 'OF'
86
SET @@session.old_mode = DISABLE;
87
ERROR 42000: Variable 'old_mode' can't be set to the value of 'DISABLE'
88
'#-------------------FN_DYNVARS_152_05----------------------------#'
89
SELECT @@session.old_mode = VARIABLE_VALUE
90
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
91
WHERE VARIABLE_NAME='old_mode';
92
@@session.old_mode = VARIABLE_VALUE
94
'#----------------------FN_DYNVARS_152_06------------------------#'
95
SELECT @@global.old_mode = VARIABLE_VALUE
96
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
97
WHERE VARIABLE_NAME='old_mode';
98
@@global.old_mode = VARIABLE_VALUE
100
'#---------------------FN_DYNVARS_152_07-------------------------#'
101
SET @@global.old_mode = 0;
102
SELECT @@global.old_mode;
105
SET @@global.old_mode = 1;
106
SELECT @@global.old_mode;
108
NO_DUP_KEY_WARNINGS_WITH_IGNORE
109
SET @@global.old_mode = 2;
110
SELECT @@global.old_mode;
113
SET @@global.old_mode = 4;
114
ERROR 42000: Variable 'old_mode' can't be set to the value of '4'
115
SELECT @@global.old_mode;
118
SET @@global.old_mode = 0.4;
119
ERROR 42000: Incorrect argument type to variable 'old_mode'
120
'#---------------------FN_DYNVARS_152_08----------------------#'
121
SET @@global.old_mode = TRUE;
122
SELECT @@global.old_mode;
124
NO_DUP_KEY_WARNINGS_WITH_IGNORE
125
SET @@global.old_mode = FALSE;
126
SELECT @@global.old_mode;
129
'#---------------------FN_DYNVARS_152_09----------------------#'
130
SET old_mode = 'NO_PROGRESS_INFO';
131
SET session.old_mode = 'ANSI';
132
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'old_mode = 'ANSI'' at line 1
133
SET global.old_mode = 'ANSI';
134
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'old_mode = 'ANSI'' at line 1
135
SET session old_mode = 1;
138
NO_DUP_KEY_WARNINGS_WITH_IGNORE
139
SET global old_mode = 0;
140
SELECT @@global.old_mode;
143
'#---------------------FN_DYNVARS_152_10----------------------#'
144
SET @@session.old_mode = 'NO_PROGRESS_INFO,NO_DUP_KEY_WARNINGS_WITH_IGNORE';
145
SELECT @@session.old_mode;
147
NO_DUP_KEY_WARNINGS_WITH_IGNORE,NO_PROGRESS_INFO
148
SET @@global.old_mode = 'NO_DUP_KEY_WARNINGS_WITH_IGNORE,NO_PROGRESS_INFO';
149
SELECT @@global.old_mode;
151
NO_DUP_KEY_WARNINGS_WITH_IGNORE,NO_PROGRESS_INFO
152
SET @@session.old_mode = 'NO_PROGRESS_INFO,NO_SUCH_MODE';
153
ERROR 42000: Variable 'old_mode' can't be set to the value of 'NO_SUCH_MODE'
158
SET @@old_mode=',,,,NO_PROGRESS_INFO,,,';
162
SET @@old_mode=',,,,FOOBAR,,,,,';
163
ERROR 42000: Variable 'old_mode' can't be set to the value of 'FOOBAR'
167
SET @@global.old_mode = @global_start_value;
168
SELECT @@global.old_mode;
171
SET @@session.old_mode = @session_start_value;
172
SELECT @@session.old_mode;