| Bug #23404 | ROW_FORMAT=FIXED option is lost is an index is added to the table | ||
|---|---|---|---|
| Submitted: | 18 Oct 2006 4:06 | Modified: | 24 Jan 2007 21:50 |
| Reporter: | Lachlan Mulcahy | ||
| Status: | Closed | ||
| Category: | Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.24a | OS: | Any (Any) |
| Assigned to: | Sergey Vojtovich | Target Version: | |
| Tags: | bfsm_2006_11_02 | ||
[7 Dec 2006 15:32]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/16595 ChangeSet@1.2563, 2006-12-07 18:32:40+04:00, svoj@mysql.com +3 -0 BUG#23404 - ROW_FORMAT=FIXED option is lost is an index is added to the table ROW_FORMAT option is lost during CREATE/DROP INDEX. This fix forces CREATE/DROP INDEX to retain ROW_FORMAT by instructing mysql_alter_table() that ROW_FORMAT is not used during creating/dropping indexes.
[11 Dec 2006 13:11]
Alexander Barkov
The patch "bk commit into 4.1 tree (svoj:1.2563) BUG#23404" is ok to push.
[27 Dec 2006 1:12]
Antony Curtis
Pushed to 5.1.15-beta repository
[27 Dec 2006 3:24]
Antony Curtis
Pushed to 5.0.34 repository
[27 Dec 2006 10:59]
Antony Curtis
Pushed to 4.1.23 repository
[24 Jan 2007 21:50]
Paul DuBois
Noted in 4.1.23, 5.0.34, 5.1.15 changelogs. A table created with the ROW_FORMAT=FIXED table option loses the option if an index is added or dropped with CREATE INDEX or DROP INDEX.
Description: A table created with ROW_FORMAT=FIXED will lose the option if an index is added to the table with CREATE INDEX -- it is not lost with ALTER TABLE ADD INDEX... How to repeat: mysql> create table t1 (a char(20)) ROW_FORMAT=FIXED; Query OK, 0 rows affected (0.01 sec) mysql> show create table t1\G *************************** 1. row *************************** Table: t1 Create Table: CREATE TABLE `t1` ( `a` char(20) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED 1 row in set (0.00 sec) mysql> create index i1 on t1 (a); Query OK, 0 rows affected (0.04 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> show create table t1\G *************************** 1. row *************************** Table: t1 Create Table: CREATE TABLE `t1` ( `a` char(20) default NULL, KEY `i1` (`a`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1 row in set (0.00 sec) Suggested fix: Retain the option when CREATE INDEX command is used.