diff options
| author | unknown <istruewing@chilla.local> | 2006-10-09 22:16:22 +0200 |
|---|---|---|
| committer | unknown <istruewing@chilla.local> | 2006-10-09 22:16:22 +0200 |
| commit | 8f8340ab65e55dd0a7d2899728c6e0e707fca241 (patch) | |
| tree | 563903b3892f4d71d055ac1ccacd081eaa187a75 /mysql-test/r/myisam.result | |
| parent | 91be4f6f0c0771bc18f46dfd63e01b116ec7cf62 (diff) | |
| download | mariadb-git-8f8340ab65e55dd0a7d2899728c6e0e707fca241.tar.gz | |
Bug#8283 - OPTIMIZE TABLE causes data loss
After merge fix. MyISAM version 10.
Diffstat (limited to 'mysql-test/r/myisam.result')
| -rw-r--r-- | mysql-test/r/myisam.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index e514867ee43..b85d834420e 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -841,7 +841,7 @@ _id DELETE FROM t1 WHERE _id < 8; 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 -t1 MyISAM 9 Dynamic 2 # # # # 140 # # # # # # +t1 MyISAM 10 Dynamic 2 # # # # 140 # # # # # # CHECK TABLE t1 EXTENDED; Table Op Msg_type Msg_text test.t1 check status OK @@ -853,7 +853,7 @@ Table Op Msg_type Msg_text test.t1 check status OK 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 -t1 MyISAM 9 Dynamic 2 # # # # 0 # # # # # # +t1 MyISAM 10 Dynamic 2 # # # # 0 # # # # # # SELECT _id FROM t1; _id 8 @@ -900,7 +900,7 @@ _id DELETE FROM t1 WHERE _id < 8; 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 -t1 MyISAM 9 Dynamic 2 # # # # 140 # # # # # # +t1 MyISAM 10 Dynamic 2 # # # # 140 # # # # # # CHECK TABLE t1 EXTENDED; Table Op Msg_type Msg_text test.t1 check status OK @@ -912,7 +912,7 @@ Table Op Msg_type Msg_text test.t1 check status OK 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 -t1 MyISAM 9 Dynamic 2 # # # # 140 # # # # # # +t1 MyISAM 10 Dynamic 2 # # # # 140 # # # # # # SELECT _id FROM t1; _id 8 |