Debian Codegraph @

mysql-test/suite/sysschema/t/v_innodb_buffer_stats_by_table.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_table view
7
8 # Ensure structure changes don't slip in
9 DESC sys.innodb_buffer_stats_by_table;
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_table
17 where object_schema = 'test' and object_name = 't1';
18
19 # Ensure structure changes don't slip in
20 DESC sys.x$innodb_buffer_stats_by_table;
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_table
25 where object_schema = 'test' and object_name = 't1';
26
27 # Drop the table
28 DROP TABLE t1;