Debian Codegraph @

mysql-test/suite/sysschema/t/v_innodb_buffer_stats_by_schema.test

raw
1 -- source ../include/ps_truncate_all_tables.inc
2 # Tests for sys schema
3 # Verify the sys.innodb_buffer_stats_by_schema view
4
5 # Ensure structure changes don't slip in
6 DESC sys.innodb_buffer_stats_by_schema;
7
8 # Make sure view select does not error, but ignore results
9 --disable_result_log
10 SELECT * FROM sys.innodb_buffer_stats_by_schema;
11 --enable_result_log
12
13
14 # Ensure structure changes don't slip in
15 DESC sys.x$innodb_buffer_stats_by_schema;
16
17 # Make sure view select does not error, but ignore results
18 --disable_result_log
19 SELECT * FROM sys.x$innodb_buffer_stats_by_schema;
20 --enable_result_log