1--source include/have_rocksdb.inc 2 3--disable_warnings 4DROP TABLE IF EXISTS t1; 5--enable_warnings 6 7# Create the table and insert some keys 8CREATE TABLE t1 (i INT, PRIMARY KEY (i) COMMENT 'cf_t1') ENGINE = ROCKSDB; 9 10--disable_query_log 11let $max = 1000; 12let $i = 1; 13while ($i <= $max) { 14 let $insert = INSERT INTO t1 VALUES ($i); 15 inc $i; 16 eval $insert; 17} 18--enable_query_log 19 20# Verify table has correct rows 21SELECT COUNT(*) FROM t1; 22 23# Verify the table stats are returned 24--vertical_results 25SELECT * FROM INFORMATION_SCHEMA.TABLE_STATISTICS WHERE TABLE_NAME = "t1"; 26--horizontal_results 27 28#cleanup 29DROP TABLE t1; 30