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