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