diff options
author | Monty <monty@mariadb.org> | 2018-03-23 18:58:06 +0200 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2018-03-29 13:59:44 +0300 |
commit | 410d09308979f217a3ed07c4d88a502c4798166f (patch) | |
tree | c0caff1971191635fd0b9b5cb6f784842a9f8126 /mysql-test/extra | |
parent | 39018f2a5a56a03769149cbccfb6481ce2af30d4 (diff) | |
download | mariadb-git-410d09308979f217a3ed07c4d88a502c4798166f.tar.gz |
Move extra/rpl_tests/table_index_statistics to suite/innodb
Diffstat (limited to 'mysql-test/extra')
-rw-r--r-- | mysql-test/extra/table_index_statistics.inc | 59 |
1 files changed, 0 insertions, 59 deletions
diff --git a/mysql-test/extra/table_index_statistics.inc b/mysql-test/extra/table_index_statistics.inc deleted file mode 100644 index ba585320fc9..00000000000 --- a/mysql-test/extra/table_index_statistics.inc +++ /dev/null @@ -1,59 +0,0 @@ -# include file to test index and table statstics for specific storage engine -# requires includer set the default strorage engine for the session - -# Bug 602047 (wrong rows_read value) - -FLUSH INDEX_STATISTICS; -FLUSH TABLE_STATISTICS; - -SET @userstat_old= @@userstat; -SET GLOBAL userstat=ON; - -CREATE TABLE t1 (id int(10), PRIMARY KEY (id)); -INSERT INTO t1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10); -SELECT COUNT(*) FROM t1; -SELECT ROWS_READ FROM INFORMATION_SCHEMA.TABLE_STATISTICS WHERE TABLE_NAME='t1'; -SELECT ROWS_READ FROM INFORMATION_SCHEMA.INDEX_STATISTICS WHERE TABLE_NAME='t1'; - -# Test that FLUSH clears one table but not another - -FLUSH TABLE_STATISTICS; - -SELECT ROWS_READ FROM INFORMATION_SCHEMA.TABLE_STATISTICS WHERE TABLE_NAME='t1'; -SELECT ROWS_READ FROM INFORMATION_SCHEMA.INDEX_STATISTICS WHERE TABLE_NAME='t1'; - -# Test that FLUSH clears both tables now - -FLUSH INDEX_STATISTICS; - -SELECT ROWS_READ FROM INFORMATION_SCHEMA.INDEX_STATISTICS WHERE TABLE_NAME='t1'; - -# Test that stats are collected after the FLUSH again - -SELECT COUNT(*) FROM t1; -SELECT ROWS_READ FROM INFORMATION_SCHEMA.TABLE_STATISTICS WHERE TABLE_NAME='t1'; -SELECT ROWS_READ FROM INFORMATION_SCHEMA.INDEX_STATISTICS WHERE TABLE_NAME='t1'; - -DROP TABLE t1; - -# Bug 1183625 (handler::update_global_table_stats crash). - -CREATE TABLE t2 (c1 INT UNSIGNED); - -ALTER TABLE t2 MODIFY c1 FLOAT; - -SELECT * FROM INFORMATION_SCHEMA.TABLE_STATISTICS WHERE TABLE_NAME='t2'; - -DROP TABLE t2; - -# Bug 1183625 (handler::update_global_table_stats crash). - -CREATE TABLE t2 (c1 INT UNSIGNED); - -ALTER TABLE t2 MODIFY c1 FLOAT; - -SELECT * FROM INFORMATION_SCHEMA.TABLE_STATISTICS WHERE TABLE_NAME='t2'; - -DROP TABLE t2; - -SET GLOBAL userstat= @userstat_old; |