diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb/t/table_stats.test')
-rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/t/table_stats.test | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/t/table_stats.test b/storage/rocksdb/mysql-test/rocksdb/t/table_stats.test new file mode 100644 index 00000000..3eb58098 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/t/table_stats.test @@ -0,0 +1,29 @@ +--source include/have_rocksdb.inc + +--disable_warnings +DROP TABLE IF EXISTS t1; +--enable_warnings + +# Create the table and insert some keys +CREATE TABLE t1 (i INT, PRIMARY KEY (i) COMMENT 'cf_t1') ENGINE = ROCKSDB; + +--disable_query_log +let $max = 1000; +let $i = 1; +while ($i <= $max) { + let $insert = INSERT INTO t1 VALUES ($i); + inc $i; + eval $insert; +} +--enable_query_log + +# Verify table has correct rows +SELECT COUNT(*) FROM t1; + +# Verify the table stats are returned +--vertical_results +SELECT * FROM INFORMATION_SCHEMA.TABLE_STATISTICS WHERE TABLE_NAME = "t1"; +--horizontal_results + +#cleanup +DROP TABLE t1; |