1CREATE TABLE t1(pk INT, PRIMARY KEY(pk)) ENGINE=ROCKSDB; 2SET rocksdb_bulk_load=1; 3INSERT INTO t1 VALUES(10); 4INSERT INTO t1 VALUES(11); 5INSERT INTO t1 VALUES(9); 6ERROR HY000: Rows must be inserted in primary key order during bulk load operation 7SET rocksdb_bulk_load=0; 8SELECT * FROM t1; 9pk 1010 1111 12SET rocksdb_bulk_load=1; 13INSERT INTO t1 VALUES(1); 14INSERT INTO t1 VALUES(2); 15INSERT INTO t1 VALUES(20); 16INSERT INTO t1 VALUES(21); 17SET rocksdb_bulk_load=0; 18ERROR HY000: Rows inserted during bulk load must not overlap existing rows 19SHOW VARIABLES LIKE 'rocksdb_bulk_load'; 20Variable_name Value 21rocksdb_bulk_load OFF 22call mtr.add_suppression('finalizing last SST file while setting bulk loading variable'); 23SELECT * FROM t1; 24pk 2510 2611 27FOUND 1 /RocksDB: Error [0-9]+ finalizing last SST file while setting bulk loading variable/ in rocksdb.bulk_load_errors.1.err 28connect con1,localhost,root,,; 29SET rocksdb_bulk_load=1; 30INSERT INTO t1 VALUES(1); 31INSERT INTO t1 VALUES(2); 32INSERT INTO t1 VALUES(20); 33INSERT INTO t1 VALUES(21); 34connection default; 35disconnect con1; 36SELECT * FROM t1; 37pk 3810 3911 40FOUND 1 /RocksDB: Error [0-9]+ finalizing last SST file while disconnecting/ in rocksdb.bulk_load_errors.2.err 41TRUNCATE TABLE t1; 42SET rocksdb_bulk_load_allow_unsorted=1; 43SET rocksdb_bulk_load=1; 44INSERT INTO t1 VALUES(100); 45INSERT INTO t1 VALUES(101); 46INSERT INTO t1 VALUES(99); 47SET rocksdb_bulk_load=0; 48SELECT * FROM t1; 49pk 5099 51100 52101 53TRUNCATE TABLE t1; 54SET rocksdb_bulk_load=1; 55INSERT INTO t1 VALUES(201); 56INSERT INTO t1 VALUES(200); 57INSERT INTO t1 VALUES(202); 58INSERT INTO t1 VALUES(201); 59ERROR 23000: Failed to insert the record: the key already exists 60SET rocksdb_bulk_load=0; 61SELECT * FROM t1; 62pk 63200 64201 65202 66SET rocksdb_bulk_load_allow_unsorted=DEFAULT; 67DROP TABLE t1; 68CREATE TABLE t1(c1 INT KEY) ENGINE=ROCKSDB; 69SET rocksdb_bulk_load=1; 70INSERT INTO t1 VALUES (),(),(); 71ERROR HY000: Rows must be inserted in primary key order during bulk load operation 72SET rocksdb_bulk_load=0; 73DROP TABLE t1; 74SET @orig_table_open_cache=@@global.table_open_cache; 75CREATE TABLE t1(a INT AUTO_INCREMENT, b INT, PRIMARY KEY (a)) ENGINE=ROCKSDB DEFAULT CHARSET=latin1; 76SET rocksdb_bulk_load=1; 77INSERT INTO t1 VALUES(13, 0); 78INSERT INTO t1 VALUES(2, 'test 2'); 79Warnings: 80Warning 1366 Incorrect integer value: 'test 2' for column `test`.`t1`.`b` at row 1 81INSERT INTO t1 VALUES(@id, @arg04); 82SET @@global.table_open_cache=FALSE; 83Warnings: 84Warning 1292 Truncated incorrect table_open_cache value: '0' 85INSERT INTO t1 VALUES(51479+0.333333333,1); 86DROP TABLE t1; 87SET @@global.table_open_cache=@orig_table_open_cache; 88FOUND 1 /RocksDB: Error [0-9]+ finalizing bulk load while closing handler/ in rocksdb.bulk_load_errors.3.err 89# restart 90CREATE TABLE t1 (pk INT, PRIMARY KEY (pk)) ENGINE=ROCKSDB; 91CREATE TABLE t2 (pk INT, PRIMARY KEY (pk)) ENGINE=ROCKSDB; 92SET rocksdb_bulk_load=1; 93INSERT INTO t1 VALUES (1), (2); 94INSERT INTO t2 VALUES (1), (2); 95INSERT INTO t1 VALUES (1); 96INSERT INTO t2 VALUES (3); 97ERROR HY000: Rows inserted during bulk load must not overlap existing rows 98SET rocksdb_bulk_load=0; 99DROP TABLE t1; 100DROP TABLE t2; 101