1SET @start_global_value = @@global.log_warnings;
2SELECT @start_global_value;
3@start_global_value
42
5SET @start_session_value = @@session.log_warnings;
6SELECT @start_session_value;
7@start_session_value
82
9'#--------------------FN_DYNVARS_067_01-------------------------#'
10SET @@global.log_warnings = 100;
11SET @@global.log_warnings = DEFAULT;
12SELECT @@global.log_warnings;
13@@global.log_warnings
142
15SET @@session.log_warnings = 200;
16SET @@session.log_warnings = DEFAULT;
17SELECT @@session.log_warnings;
18@@session.log_warnings
192
20'#--------------------FN_DYNVARS_067_02-------------------------#'
21SET @@global.log_warnings = DEFAULT;
22SELECT @@global.log_warnings = 1;
23@@global.log_warnings = 1
240
25SET @@session.log_warnings = DEFAULT;
26SELECT @@session.log_warnings = 1;
27@@session.log_warnings = 1
280
29'#--------------------FN_DYNVARS_067_03-------------------------#'
30SET @@global.log_warnings = 0;
31SELECT @@global.log_warnings;
32@@global.log_warnings
330
34SET @@global.log_warnings = 1;
35SELECT @@global.log_warnings;
36@@global.log_warnings
371
38SET @@global.log_warnings = 60020;
39SELECT @@global.log_warnings;
40@@global.log_warnings
4160020
42SET @@global.log_warnings = 65535;
43SELECT @@global.log_warnings;
44@@global.log_warnings
4565535
46SET @@global.log_warnings = 65536;
47SELECT @@global.log_warnings;
48@@global.log_warnings
4965536
50'#--------------------FN_DYNVARS_067_04-------------------------#'
51SET @@session.log_warnings = 0;
52SELECT @@session.log_warnings;
53@@session.log_warnings
540
55SET @@session.log_warnings = 1;
56SELECT @@session.log_warnings;
57@@session.log_warnings
581
59SET @@session.log_warnings = 50050;
60SELECT @@session.log_warnings;
61@@session.log_warnings
6250050
63SET @@session.log_warnings = 65535;
64SELECT @@session.log_warnings;
65@@session.log_warnings
6665535
67SET @@session.log_warnings = 65550;
68SELECT @@session.log_warnings;
69@@session.log_warnings
7065550
71'#------------------FN_DYNVARS_067_05-----------------------#'
72SET @@global.log_warnings = 100000000000;
73Warnings:
74Warning	1292	Truncated incorrect log_warnings value: '100000000000'
75SELECT @@global.log_warnings;
76@@global.log_warnings
774294967295
78SET @@global.log_warnings = -1024;
79Warnings:
80Warning	1292	Truncated incorrect log_warnings value: '-1024'
81SELECT @@global.log_warnings;
82@@global.log_warnings
830
84SET @@global.log_warnings = 65530.34;
85ERROR 42000: Incorrect argument type to variable 'log_warnings'
86SELECT @@global.log_warnings;
87@@global.log_warnings
880
89SET @@global.log_warnings = test;
90ERROR 42000: Incorrect argument type to variable 'log_warnings'
91SELECT @@global.log_warnings;
92@@global.log_warnings
930
94SET @@session.log_warnings = 100000000000;
95Warnings:
96Warning	1292	Truncated incorrect log_warnings value: '100000000000'
97SELECT @@session.log_warnings;
98@@session.log_warnings
994294967295
100SET @@session.log_warnings = -2;
101Warnings:
102Warning	1292	Truncated incorrect log_warnings value: '-2'
103SELECT @@session.log_warnings;
104@@session.log_warnings
1050
106SET @@session.log_warnings = 65530.34;
107ERROR 42000: Incorrect argument type to variable 'log_warnings'
108SET @@session.log_warnings = test;
109ERROR 42000: Incorrect argument type to variable 'log_warnings'
110SELECT @@session.log_warnings;
111@@session.log_warnings
1120
113'#------------------FN_DYNVARS_067_06-----------------------#'
114SELECT @@global.log_warnings = VARIABLE_VALUE
115FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
116WHERE VARIABLE_NAME='log_warnings';
117@@global.log_warnings = VARIABLE_VALUE
1181
119'#------------------FN_DYNVARS_067_07-----------------------#'
120SELECT @@session.log_warnings = VARIABLE_VALUE
121FROM INFORMATION_SCHEMA.SESSION_VARIABLES
122WHERE VARIABLE_NAME='log_warnings';
123@@session.log_warnings = VARIABLE_VALUE
1241
125'#------------------FN_DYNVARS_067_08-----------------------#'
126SET @@global.log_warnings = TRUE;
127SELECT @@global.log_warnings;
128@@global.log_warnings
1291
130SET @@global.log_warnings = FALSE;
131SELECT @@global.log_warnings;
132@@global.log_warnings
1330
134'#---------------------FN_DYNVARS_067_09----------------------#'
135SET @@global.log_warnings = 10;
136SELECT @@log_warnings = @@global.log_warnings;
137@@log_warnings = @@global.log_warnings
1380
139'#---------------------FN_DYNVARS_067_10----------------------#'
140SET @@log_warnings = 100;
141SELECT @@log_warnings = @@local.log_warnings;
142@@log_warnings = @@local.log_warnings
1431
144SELECT @@local.log_warnings = @@session.log_warnings;
145@@local.log_warnings = @@session.log_warnings
1461
147'#---------------------FN_DYNVARS_067_11----------------------#'
148SET log_warnings = 1;
149SELECT @@log_warnings;
150@@log_warnings
1511
152SELECT local.log_warnings;
153ERROR 42S02: Unknown table 'local' in field list
154SELECT session.log_warnings;
155ERROR 42S02: Unknown table 'session' in field list
156SELECT log_warnings = @@session.log_warnings;
157ERROR 42S22: Unknown column 'log_warnings' in 'field list'
158SET @@global.log_warnings = @start_global_value;
159SELECT @@global.log_warnings;
160@@global.log_warnings
1612
162SET @@session.log_warnings = @start_session_value;
163SELECT @@session.log_warnings;
164@@session.log_warnings
1652
166