diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb/r/drop_table.result')
-rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/r/drop_table.result | 79 |
1 files changed, 79 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/r/drop_table.result b/storage/rocksdb/mysql-test/rocksdb/r/drop_table.result new file mode 100644 index 00000000000..4d20242f43e --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/r/drop_table.result @@ -0,0 +1,79 @@ +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"); +call mtr.add_suppression("LibRocksDB"); +set global rocksdb_compact_cf = 'cf1'; +set global rocksdb_compact_cf = 'rev:cf2'; +set global rocksdb_signal_drop_index_thread = 1; +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; +drop table t2; +DELETE FROM t1; +DELETE FROM t4; +drop table t3; +DELETE FROM t1; +DELETE FROM t4; +SET GLOBAL rocksdb_max_manual_compactions = 2; +SET GLOBAL rocksdb_debug_manual_compaction_delay = 3600; +connect con1, localhost, root,,; +connect con2, localhost, root,,; +connect con3, localhost, root,,; +connection con1; +SET GLOBAL rocksdb_compact_cf='cf1'; +connection con2; +SET GLOBAL rocksdb_compact_cf='rev:cf2'; +connection default; +select * from information_schema.global_status where variable_name='rocksdb_manual_compactions_running'; +VARIABLE_NAME VARIABLE_VALUE +ROCKSDB_MANUAL_COMPACTIONS_RUNNING 1 +connection con3; +SET GLOBAL rocksdb_compact_cf='cf1'; +ERROR HY000: Internal error: Can't schedule more manual compactions. Increase rocksdb_max_manual_compactions or stop issuing more manual compactions. +SET GLOBAL rocksdb_compact_cf='rev:cf2'; +ERROR HY000: Internal error: Can't schedule more manual compactions. Increase rocksdb_max_manual_compactions or stop issuing more manual compactions. +connection default; +drop table t4; +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; +drop table t5; +set global rocksdb_compact_cf = 'cf1'; +set global rocksdb_compact_cf = 'rev:cf2'; +set global rocksdb_signal_drop_index_thread = 1; +drop table t1; |