Debian Codegraph @

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

raw
1 -- source include/not_embedded.inc
2 -- source ../include/ps_truncate_all_tables.inc
3 -- source include/have_innodb.inc
4
5 # Tests for sys schema
6 # Verify the sys.innodb_buffer_stats_by_schema view
7
8 # Ensure structure changes don't slip in
9 DESC sys.innodb_buffer_stats_by_schema;
10
11 # Create an Empty table
12 CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB;
13
14 # Make sure view select does not error, and
15 # is_hashed & is_old is 0 for empty table
16 SELECT * FROM sys.innodb_buffer_stats_by_schema
17 where object_schema = 'test';
18
19 # Ensure structure changes don't slip in
20 DESC sys.x$innodb_buffer_stats_by_schema;
21
22 # Make sure view select does not error, and
23 # is_hashed & is_old is 0 for empty table
24 SELECT * FROM sys.x$innodb_buffer_stats_by_schema
25 where object_schema = 'test';
26
27 # Drop the table
28 DROP TABLE t1;