--- truncate_table.result 2013-01-22 22:05:05.246633000 +0400 +++ truncate_table.reject 2013-01-23 02:51:07.507403770 +0400 @@ -9,19 +9,19 @@ CREATE TABLE t1 (a KEY AUTO_INCREMENT, c ) ENGINE= ; SHOW TABLE STATUS LIKE 't1'; Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary -t1 # # # # # # # # # 1 # # # # # # # # N +t1 # # # # # # # # # 0 # # # # # # # # N INSERT INTO t1 (c) VALUES ('a'),('b'),('c'); SHOW TABLE STATUS LIKE 't1'; Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary -t1 # # # # # # # # # 4 # # # # # # # # N +t1 # # # # # # # # # 0 # # # # # # # # N TRUNCATE TABLE t1; SHOW TABLE STATUS LIKE 't1'; Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary -t1 # # # # # # # # # 1 # # # # # # # # N +t1 # # # # # # # # # 0 # # # # # # # # N INSERT INTO t1 (c) VALUES ('d'); SHOW TABLE STATUS LIKE 't1'; Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment Max_index_length Temporary -t1 # # # # # # # # # 2 # # # # # # # # N +t1 # # # # # # # # # 0 # # # # # # # # N SELECT a,c FROM t1; a c 1 d @@ -29,13 +29,12 @@ CREATE TABLE t1 (a , b ) ENGINE= ; INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'); HANDLER t1 OPEN AS h1; -HANDLER h1 READ FIRST; -a b -1 a -TRUNCATE TABLE t1; -HANDLER h1 READ NEXT; -ERROR 42S02: Unknown table 'h1' in HANDLER -HANDLER t1 OPEN AS h2; -HANDLER h2 READ FIRST; -a b +ERROR HY000: Storage engine MRG_MyISAM of the table `test`.`t1` doesn't have this option +# ------------ UNEXPECTED RESULT ------------ +# The statement|command finished with ER_ILLEGAL_HA. +# HANDLER or the syntax or the mix could be unsupported. +# You can change the engine code, or create an rdiff, or disable the test by adding it to disabled.def. +# Further in this test, the message might sometimes be suppressed; a part of the test might be skipped. +# Also, this problem may cause a chain effect (more errors of different kinds in the test). +# ------------------------------------------- DROP TABLE t1;