Debian Codegraph @

mysql-test/suite/innodb/t/innodb_information_schema_tables.test

raw
1 -- source include/have_innodb.inc
2 -- source include/not_embedded.inc
3
4 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.1.err;
5 let SEARCH_PATTERN= \[Warning\] InnoDB: innodb_open_files 1000000 should not be greater than the open_files_limit [0-9]+;
6 --source include/search_pattern_in_file.inc
7
8 #
9 # MDEV-7762 InnoDB: Failing assertion: block->page.buf_fix_count > 0 in buf0buf.ic line 730
10 #
11 # Make sure that all supported information_schema tables are readable
12 # (actual result sets are not important).
13 #
14 CREATE TABLE t1 ENGINE=InnoDB AS SELECT * FROM mysql.help_topic;
15
16 --disable_query_log
17 --disable_result_log
18 BEGIN;
19 SELECT * FROM t1 FOR UPDATE;
20 SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;
21 SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
22 SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
23 SELECT * FROM INFORMATION_SCHEMA.INNODB_CMP;
24 SELECT * FROM INFORMATION_SCHEMA.INNODB_CMP_RESET;
25 SELECT * FROM INFORMATION_SCHEMA.INNODB_CMPMEM;
26 SELECT * FROM INFORMATION_SCHEMA.INNODB_CMPMEM_RESET;
27 SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE;
28 SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE_LRU;
29 --error 0,1109
30 SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_STATS;
31 --error 0,1109
32 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES;
33 --error 0,1109
34 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS;
35 --error 0,1109
36 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_INDEXES;
37 --error 0,1109
38 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS;
39 --error 0,1109
40 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS;
41 --error 0,1109
42 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN;
43 --error 0,1109
44 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS;
45 --error 0,1109
46 SELECT * FROM INFORMATION_SCHEMA.INNODB_RSEG;
47 --error 0,1109
48 SELECT * FROM INFORMATION_SCHEMA.INNODB_UNDO_LOGS;
49 --error 0,1109
50 SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_STATS;
51 --error 0,1109
52 SELECT * FROM INFORMATION_SCHEMA.INNODB_TABLE_STATS;
53 --error 0,1109
54 SELECT * FROM INFORMATION_SCHEMA.INNODB_INDEX_STATS;
55 --error 0,1109
56 SELECT * FROM INFORMATION_SCHEMA.INNODB_ADMIN_COMMAND;
57 --error 0,1109
58 SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES;
59 --error 0,1109
60 SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES_INDEX;
61 --error 0,1109
62 SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES_BLOB;
63 --error 0,1109
64 SELECT * FROM INFORMATION_SCHEMA.INNODB_CHANGED_PAGES;
65 COMMIT;
66 --enable_query_log
67 --enable_result_log
68 DROP TABLE t1;