diff options
Diffstat (limited to '')
-rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/r/insert_optimized_config.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/r/insert_optimized_config.result b/storage/rocksdb/mysql-test/rocksdb/r/insert_optimized_config.result new file mode 100644 index 00000000..ded48057 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/r/insert_optimized_config.result @@ -0,0 +1,16 @@ +DROP TABLE IF EXISTS t1; +create table t1( +id bigint not null primary key, +i1 bigint, #unique +i2 bigint, #repeating +c1 varchar(20), #unique +c2 varchar(20), #repeating +index t1_2(i1) +) engine=rocksdb; +select count(*), sum(id), sum(i1), sum(i2) from t1; +count(*) sum(id) sum(i1) sum(i2) +50000 1250025000 1250025000 124980000 +select count(*), sum(id), sum(i1), sum(i2) from t1; +count(*) sum(id) sum(i1) sum(i2) +50000 1250025000 1250025000 124980000 +drop table t1; |