1--- suite/storage_engine/optimize_table.result 2012-07-12 19:13:53.741428591 +0400 2+++ suite/storage_engine/optimize_table.reject 2012-07-15 17:50:30.843102510 +0400 3@@ -5,25 +5,32 @@ 4 INSERT INTO t1 (a,b) VALUES (3,'c'),(4,'d'); 5 OPTIMIZE TABLE t1; 6 Table Op Msg_type Msg_text 7+test.t1 optimize note Table does not support optimize, doing recreate + analyze instead 8 test.t1 optimize status OK 9 INSERT INTO t2 (a,b) VALUES (4,'d'); 10 OPTIMIZE NO_WRITE_TO_BINLOG TABLE t2; 11 Table Op Msg_type Msg_text 12+test.t2 optimize note Table does not support optimize, doing recreate + analyze instead 13 test.t2 optimize status OK 14 INSERT INTO t2 (a,b) VALUES (5,'e'); 15 INSERT INTO t1 (a,b) VALUES (6,'f'); 16 OPTIMIZE LOCAL TABLE t1, t2; 17 Table Op Msg_type Msg_text 18+test.t1 optimize note Table does not support optimize, doing recreate + analyze instead 19 test.t1 optimize status OK 20+test.t2 optimize note Table does not support optimize, doing recreate + analyze instead 21 test.t2 optimize status OK 22 OPTIMIZE TABLE t1, t2; 23 Table Op Msg_type Msg_text 24-test.t1 optimize status Table is already up to date 25-test.t2 optimize status Table is already up to date 26+test.t1 optimize note Table does not support optimize, doing recreate + analyze instead 27+test.t1 optimize status OK 28+test.t2 optimize note Table does not support optimize, doing recreate + analyze instead 29+test.t2 optimize status OK 30 DROP TABLE t1, t2; 31 CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>, <CUSTOM_INDEX> (a)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; 32 INSERT INTO t1 (a,b) VALUES (1,'a'),(100,'b'),(2,'c'),(3,'d'); 33 OPTIMIZE TABLE t1; 34 Table Op Msg_type Msg_text 35+test.t1 optimize note Table does not support optimize, doing recreate + analyze instead 36 test.t1 optimize status OK 37 DROP TABLE t1; 38