1# 2# CHECK TABLE statements 3# 4# Note: the output is likely to be different for the engine under test, 5# in which case rdiff will be needed. Or, the output might say that 6# the storage engine does not support CHECK. 7# 8 9--disable_warnings 10DROP TABLE IF EXISTS t1,t2; 11--enable_warnings 12 13CREATE TABLE t1 (a INT, b CHAR(8), pk INT AUTO_INCREMENT PRIMARY KEY) ENGINE=rocksdb; 14INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'); 15 16CREATE TABLE t2 (a INT, b CHAR(8), pk INT AUTO_INCREMENT PRIMARY KEY) ENGINE=rocksdb; 17 18CHECK TABLE t1; 19INSERT INTO t1 (a,b) VALUES (3,'c'); 20INSERT INTO t2 (a,b) VALUES (4,'d'); 21CHECK TABLE t1, t2 FOR UPGRADE; 22INSERT INTO t2 (a,b) VALUES (5,'e'); 23CHECK TABLE t2 QUICK; 24INSERT INTO t1 (a,b) VALUES (6,'f'); 25CHECK TABLE t1 FAST; 26INSERT INTO t1 (a,b) VALUES (7,'g'); 27INSERT INTO t2 (a,b) VALUES (8,'h'); 28CHECK TABLE t2, t1 MEDIUM; 29INSERT INTO t1 (a,b) VALUES (9,'i'); 30INSERT INTO t2 (a,b) VALUES (10,'j'); 31CHECK TABLE t1, t2 EXTENDED; 32INSERT INTO t1 (a,b) VALUES (11,'k'); 33CHECK TABLE t1 CHANGED; 34 35DROP TABLE t1, t2; 36 37 38CREATE TABLE t1 (a INT, b CHAR(8), pk INT AUTO_INCREMENT PRIMARY KEY, KEY(a)) ENGINE=rocksdb; 39INSERT INTO t1 (a) VALUES (1),(2),(5); 40CHECK TABLE t1; 41INSERT INTO t1 (a) VALUES (6),(8),(12); 42CHECK TABLE t1 FOR UPGRADE; 43INSERT INTO t1 (a) VALUES (13),(15),(16); 44CHECK TABLE t1 QUICK; 45INSERT INTO t1 (a) VALUES (17),(120),(132); 46CHECK TABLE t1 FAST; 47INSERT INTO t1 (a) VALUES (801),(900),(7714); 48CHECK TABLE t1 MEDIUM; 49INSERT INTO t1 (a) VALUES (8760),(10023),(12000); 50CHECK TABLE t1 EXTENDED; 51INSERT INTO t1 (a) VALUES (13345),(24456),(78302),(143028); 52CHECK TABLE t1 CHANGED; 53DROP TABLE t1; 54 55