Debian Codegraph @

mysql-test/suite/perfschema/t/start_server_disable_errors.test

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --source ../include/start_server_common.inc
4
5 # Expect no enabled error instruments
6 select * from performance_schema.setup_instruments
7 where name in ('error') and enabled='YES';
8
9 # Run some statement which are supposed to give errors
10 --error ER_BAD_DB_ERROR
11 use non_existing_db;
12 --error ER_NO_SUCH_TABLE
13 SELECT * from non_existing_table;
14
15 # Expect no error statistics collected
16
17 select * from performance_schema.events_errors_summary_global_by_error
18 where SUM_ERROR_RAISED > 0 OR SUM_ERROR_HANDLED > 0;
19
20 select * from performance_schema.events_errors_summary_by_thread_by_error
21 where SUM_ERROR_RAISED > 0 OR SUM_ERROR_HANDLED > 0;
22
23 select * from performance_schema.events_errors_summary_by_user_by_error
24 where SUM_ERROR_RAISED > 0 OR SUM_ERROR_HANDLED > 0;
25
26 select * from performance_schema.events_errors_summary_by_host_by_error
27 where SUM_ERROR_RAISED > 0 OR SUM_ERROR_HANDLED > 0;
28
29 select * from performance_schema.events_errors_summary_by_account_by_error
30 where SUM_ERROR_RAISED > 0 OR SUM_ERROR_HANDLED > 0;
31