1'#---------------------BS_STVARS_057_01----------------------#'
2SELECT COUNT(@@SESSION.warning_count);
3COUNT(@@SESSION.warning_count)
41
51 Expected
6'#---------------------BS_STVARS_057_02----------------------#'
7SET @@SESSION.warning_count=1;
8ERROR HY000: Variable 'warning_count' is a read only variable
9Expected error 'Read only variable'
10SELECT COUNT(@@SESSION.warning_count);
11COUNT(@@SESSION.warning_count)
121
131 Expected
14'#---------------------BS_STVARS_057_03----------------------#'
15SELECT @@SESSION.warning_count = VARIABLE_VALUE
16FROM INFORMATION_SCHEMA.SESSION_VARIABLES
17WHERE VARIABLE_NAME='warning_count';
18@@SESSION.warning_count = VARIABLE_VALUE
191
201 Expected
21SELECT COUNT(@@SESSION.warning_count);
22COUNT(@@SESSION.warning_count)
231
241 Expected
25SELECT COUNT(VARIABLE_VALUE)
26FROM INFORMATION_SCHEMA.SESSION_VARIABLES
27WHERE VARIABLE_NAME='warning_count';
28COUNT(VARIABLE_VALUE)
291
301 Expected
31'#---------------------BS_STVARS_057_04----------------------#'
32SELECT @@warning_count = @@SESSION.warning_count;
33@@warning_count = @@SESSION.warning_count
341
351 Expected
36'#---------------------BS_STVARS_057_05----------------------#'
37SELECT COUNT(@@warning_count);
38COUNT(@@warning_count)
391
401 Expected
41SELECT COUNT(@@local.warning_count);
42COUNT(@@local.warning_count)
431
441 Expected
45SELECT COUNT(@@SESSION.warning_count);
46COUNT(@@SESSION.warning_count)
471
481 Expected
49SELECT COUNT(@@GLOBAL.warning_count);
50ERROR HY000: Variable 'warning_count' is a SESSION variable
51Expected error 'Variable is a SESSION variable'
52SELECT COUNT(warning_count = @@GLOBAL.warning_count);
53ERROR 42S22: Unknown column 'warning_count' in 'field list'
54Expected error 'Readonly variable'
55