diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb/r/drop_table2.result')
-rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/r/drop_table2.result | 66 |
1 files changed, 66 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/r/drop_table2.result b/storage/rocksdb/mysql-test/rocksdb/r/drop_table2.result new file mode 100644 index 00000000..aec4138c --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/r/drop_table2.result @@ -0,0 +1,66 @@ +call mtr.add_suppression("Column family 'cf1' not found"); +call mtr.add_suppression("Column family 'rev:cf2' not found"); +DROP TABLE IF EXISTS t1; +DROP TABLE IF EXISTS t2; +DROP TABLE IF EXISTS t3; +DROP TABLE IF EXISTS t4; +DROP TABLE IF EXISTS t5; +call mtr.add_suppression("Column family 'cf1' not found"); +call mtr.add_suppression("Column family 'rev:cf2' not found"); +set global rocksdb_compact_cf = 'cf1'; +set global rocksdb_compact_cf = 'rev:cf2'; +set global rocksdb_signal_drop_index_thread = 1; +# restart +CREATE TABLE t1 ( +a int not null, +b int not null, +primary key (a,b) comment 'cf1', +key (b) comment 'rev:cf2' +) ENGINE=RocksDB; +CREATE TABLE t2 ( +a int not null, +b int not null, +primary key (a,b) comment 'cf1', +key (b) comment 'rev:cf2' +) ENGINE=RocksDB; +CREATE TABLE t3 ( +a int not null, +b int not null, +primary key (a,b) comment 'cf1', +key (b) comment 'rev:cf2' +) ENGINE=RocksDB; +CREATE TABLE t4 ( +a int not null, +b int not null, +primary key (a,b) comment 'cf1', +key (b) comment 'rev:cf2' +) ENGINE=RocksDB; +DELETE FROM t1; +DELETE FROM t2; +DELETE FROM t3; +DELETE FROM t4; +# restart +DELETE FROM t1; +DELETE FROM t4; +DELETE FROM t1; +DELETE FROM t4; +# restart +CREATE TABLE t5 ( +a int not null, +b int not null, +primary key (a,b) comment 'cf1', +key (b) comment 'rev:cf2' +) ENGINE=RocksDB; +DELETE FROM t5; +set @@global.rocksdb_compact_cf = 'cf1'; +set @@global.rocksdb_compact_cf = 'rev:cf2'; +set @@global.rocksdb_compact_cf = 'default'; +drop table t1; +drop table t2; +drop table t3; +drop table t4; +drop table t5; +set @@global.rocksdb_compact_cf = 'cf1'; +set @@global.rocksdb_compact_cf = 'rev:cf2'; +set @@global.rocksdb_compact_cf = 'default'; +Compacted |