| Bug #25586 | Row format is not showing correctly | ||
|---|---|---|---|
| Submitted: | 12 Jan 2007 14:19 | Modified: | 18 Jan 2007 15:58 |
| Reporter: | adarsh | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: Falcon storage engine | Severity: | S3 (Non-critical) |
| Version: | 5.2.0 falcon-alpha-community | OS: | Windows (WinXP with SP2) |
| Assigned to: | CPU Architecture: | Any | |
[18 Jan 2007 15:58]
MySQL Verification Team
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php mysql> show table status from test3\G *************************** 1. row *************************** Name: test1 Engine: Falcon Version: 10 Row_format: Fixed Rows: 1000 Avg_row_length: 0 Data_length: 10000 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: NULL Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: 1 row in set (0.00 sec) mysql> alter table test1 add col2 varchar(500); Query OK, 2 rows affected (0.01 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> show table status from test3\G *************************** 1. row *************************** Name: test1 Engine: Falcon Version: 10 Row_format: Dynamic Rows: 1000 Avg_row_length: 0 Data_length: 10000 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: NULL Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: 1 row in set (0.00 sec) mysql>
Description: create a table engine = falcon or MyISAM and change the row format. execute the following querys. How to repeat: use test3; drop table if exists test1; create table test1 (a int(11)); insert into test1 values('1'),('2'); alter table `test3`.`test1` Engine = Falcon; show table status from `test3`; alter table `test3`.`test1` Engine=InnoDB comment='InnoDB free: 4096 kB' row_format=DYNAMIC; show table status from `test3`; for InnoDB it is working. but for MyISAM and Falcon it is showing like this. but still it is showing old row format in 'Row_format' = 'DYNAMIC' field and in 'Create options' it is showing 'COMPACT';