1
SET @start_global_value = @@global.log_warnings;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.log_warnings;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_067_01-------------------------#'
10
SET @@global.log_warnings = 100;
11
SET @@global.log_warnings = DEFAULT;
12
SELECT @@global.log_warnings;
15
SET @@session.log_warnings = 200;
16
SET @@session.log_warnings = DEFAULT;
17
SELECT @@session.log_warnings;
18
@@session.log_warnings
20
'#--------------------FN_DYNVARS_067_02-------------------------#'
21
SET @@global.log_warnings = DEFAULT;
22
SELECT @@global.log_warnings = 1;
23
@@global.log_warnings = 1
25
SET @@session.log_warnings = DEFAULT;
26
SELECT @@session.log_warnings = 1;
27
@@session.log_warnings = 1
29
'#--------------------FN_DYNVARS_067_03-------------------------#'
30
SET @@global.log_warnings = 0;
31
SELECT @@global.log_warnings;
34
SET @@global.log_warnings = 1;
35
SELECT @@global.log_warnings;
38
SET @@global.log_warnings = 60020;
39
SELECT @@global.log_warnings;
42
SET @@global.log_warnings = 65535;
43
SELECT @@global.log_warnings;
46
SET @@global.log_warnings = 65536;
47
SELECT @@global.log_warnings;
50
'#--------------------FN_DYNVARS_067_04-------------------------#'
51
SET @@session.log_warnings = 0;
52
SELECT @@session.log_warnings;
53
@@session.log_warnings
55
SET @@session.log_warnings = 1;
56
SELECT @@session.log_warnings;
57
@@session.log_warnings
59
SET @@session.log_warnings = 50050;
60
SELECT @@session.log_warnings;
61
@@session.log_warnings
63
SET @@session.log_warnings = 65535;
64
SELECT @@session.log_warnings;
65
@@session.log_warnings
67
SET @@session.log_warnings = 65550;
68
SELECT @@session.log_warnings;
69
@@session.log_warnings
71
'#------------------FN_DYNVARS_067_05-----------------------#'
72
SET @@global.log_warnings = 100000000000;
74
Warning 1292 Truncated incorrect log-warnings value: '100000000000'
75
SELECT @@global.log_warnings;
78
SET @@global.log_warnings = -1024;
79
SELECT @@global.log_warnings;
82
SET @@global.log_warnings = 65530.34.;
83
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
84
SELECT @@global.log_warnings;
87
SET @@global.log_warnings = test;
88
ERROR 42000: Incorrect argument type to variable 'log_warnings'
89
SELECT @@global.log_warnings;
92
SET @@session.log_warnings = 100000000000;
94
Warning 1292 Truncated incorrect log-warnings value: '100000000000'
95
SELECT @@session.log_warnings;
96
@@session.log_warnings
98
SET @@session.log_warnings = -2;
99
SELECT @@session.log_warnings;
100
@@session.log_warnings
102
SET @@session.log_warnings = 65530.34.;
103
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
104
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
105
SET @@session.log_warnings = test;
106
ERROR 42000: Incorrect argument type to variable 'log_warnings'
107
SELECT @@session.log_warnings;
108
@@session.log_warnings
110
'#------------------FN_DYNVARS_067_06-----------------------#'
111
SELECT @@global.log_warnings = VARIABLE_VALUE
112
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
113
WHERE VARIABLE_NAME='log_warnings';
114
@@global.log_warnings = VARIABLE_VALUE
116
'#------------------FN_DYNVARS_067_07-----------------------#'
117
SELECT @@session.log_warnings = VARIABLE_VALUE
118
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
119
WHERE VARIABLE_NAME='log_warnings';
120
@@session.log_warnings = VARIABLE_VALUE
122
'#------------------FN_DYNVARS_067_08-----------------------#'
123
SET @@global.log_warnings = TRUE;
124
SELECT @@global.log_warnings;
125
@@global.log_warnings
127
SET @@global.log_warnings = FALSE;
128
SELECT @@global.log_warnings;
129
@@global.log_warnings
131
'#---------------------FN_DYNVARS_067_09----------------------#'
132
SET @@global.log_warnings = 10;
133
SELECT @@log_warnings = @@global.log_warnings;
134
@@log_warnings = @@global.log_warnings
136
'#---------------------FN_DYNVARS_067_10----------------------#'
137
SET @@log_warnings = 100;
138
SELECT @@log_warnings = @@local.log_warnings;
139
@@log_warnings = @@local.log_warnings
141
SELECT @@local.log_warnings = @@session.log_warnings;
142
@@local.log_warnings = @@session.log_warnings
144
'#---------------------FN_DYNVARS_067_11----------------------#'
145
SET log_warnings = 1;
146
SELECT @@log_warnings;
149
SELECT local.log_warnings;
150
ERROR 42S02: Unknown table 'local' in field list
151
SELECT session.log_warnings;
152
ERROR 42S02: Unknown table 'session' in field list
153
SELECT log_warnings = @@session.log_warnings;
154
ERROR 42S22: Unknown column 'log_warnings' in 'field list'
155
SET @@global.log_warnings = @start_global_value;
156
SELECT @@global.log_warnings;
157
@@global.log_warnings
159
SET @@session.log_warnings = @start_session_value;
160
SELECT @@session.log_warnings;
161
@@session.log_warnings