Debian Codegraph @

mysql-test/suite/innodb/r/innodb_stats_create_table.result

raw
1 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE
2 database_name = 'test' AND
3 table_name = 'test_ps_create_table';
4 COUNT(*) 0
5 CREATE TABLE test_ps_create_table (a INT, PRIMARY KEY (a))
6 ENGINE=INNODB STATS_PERSISTENT=0;
7 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE
8 database_name = 'test' AND
9 table_name = 'test_ps_create_table';
10 COUNT(*) 0
11 DROP TABLE test_ps_create_table;
12 CREATE TABLE test_ps_create_table (a INT, PRIMARY KEY (a))
13 ENGINE=INNODB;
14 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE
15 database_name = 'test' AND
16 table_name = 'test_ps_create_table';
17 COUNT(*) 1
18 DROP TABLE test_ps_create_table;
19 CREATE TABLE test_ps_create_table (a INT, PRIMARY KEY (a))
20 ENGINE=INNODB STATS_PERSISTENT=default;
21 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE
22 database_name = 'test' AND
23 table_name = 'test_ps_create_table';
24 COUNT(*) 1
25 DROP TABLE test_ps_create_table;
26 CREATE TABLE test_ps_create_table (a INT, PRIMARY KEY (a))
27 ENGINE=INNODB STATS_PERSISTENT=1;
28 SELECT COUNT(*) FROM mysql.innodb_table_stats WHERE
29 database_name = 'test' AND
30 table_name = 'test_ps_create_table';
31 COUNT(*) 1
32 DROP TABLE test_ps_create_table;