Debian Codegraph @

mysql-test/suite/sys_vars/r/error_count_basic.result

raw
1 '#---------------------BS_STVARS_005_01----------------------#'
2 SELECT COUNT(@@SESSION.error_count);
3 COUNT(@@SESSION.error_count)
4 1
5 1 Expected
6 '#---------------------BS_STVARS_005_02----------------------#'
7 SET @@SESSION.error_count=1;
8 ERROR HY000: Variable 'error_count' is a read only variable
9 Expected error 'Read only variable'
10 SELECT COUNT(@@SESSION.error_count);
11 COUNT(@@SESSION.error_count)
12 1
13 1 Expected
14 '#---------------------BS_STVARS_005_03----------------------#'
15 SELECT @@SESSION.error_count = VARIABLE_VALUE
16 FROM performance_schema.session_variables
17 WHERE VARIABLE_NAME='error_count';
18 @@SESSION.error_count = VARIABLE_VALUE
19 1
20 1 Expected
21 SELECT COUNT(@@SESSION.error_count);
22 COUNT(@@SESSION.error_count)
23 1
24 1 Expected
25 SELECT COUNT(VARIABLE_VALUE)
26 FROM performance_schema.session_variables
27 WHERE VARIABLE_NAME='error_count';
28 COUNT(VARIABLE_VALUE)
29 1
30 1 Expected
31 '#---------------------BS_STVARS_005_04----------------------#'
32 SELECT @@error_count = @@SESSION.error_count;
33 @@error_count = @@SESSION.error_count
34 1
35 1 Expected
36 '#---------------------BS_STVARS_005_05----------------------#'
37 SELECT COUNT(@@error_count);
38 COUNT(@@error_count)
39 1
40 1 Expected
41 SELECT COUNT(@@local.error_count);
42 COUNT(@@local.error_count)
43 1
44 1 Expected
45 SELECT COUNT(@@SESSION.error_count);
46 COUNT(@@SESSION.error_count)
47 1
48 1 Expected
49 SELECT COUNT(@@GLOBAL.error_count);
50 ERROR HY000: Variable 'error_count' is a SESSION variable
51 Expected error 'Variable is a SESSION variable'
52 SELECT COUNT(error_count);
53 ERROR 42S22: Unknown column 'error_count' in 'field list'
54 Expected error 'Unknown column'