Description:
See "how to repeat". The fields in the Key column of DESCRIBE seem to be aligned incorrectly, based on the SHOW CREATE TABLE output.
How to repeat:
mysql> SHOW CREATE TABLE desc_bug \G
*************************** 1. row ***************************
Table: desc_bug
Create Table: CREATE TABLE `desc_bug` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`just_vers` varchar(15) NOT NULL,
`full_vers` varchar(44) NOT NULL,
`dy` date DEFAULT NULL,
`ft` text NOT NULL,
`html` blob NOT NULL,
PRIMARY KEY (`id`),
KEY `dy` (`dy`,`just_vers`),
FULLTEXT KEY `ft` (`ft`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
mysql> DESCRIBE desc_bug;
+-----------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+----------------------+------+-----+---------+----------------+
| id | smallint(5) unsigned | NO | PRI | NULL | auto_increment |
| just_vers | varchar(15) | NO | | NULL | |
| full_vers | varchar(44) | NO | | NULL | |
| dy | date | YES | MUL | NULL | |
| ft | text | NO | MUL | NULL | |
| html | blob | NO | | NULL | |
+-----------+----------------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
Suggested fix:
I wonder if adding FULLTEXT to InnoDB created this bug.
Description: See "how to repeat". The fields in the Key column of DESCRIBE seem to be aligned incorrectly, based on the SHOW CREATE TABLE output. How to repeat: mysql> SHOW CREATE TABLE desc_bug \G *************************** 1. row *************************** Table: desc_bug Create Table: CREATE TABLE `desc_bug` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `just_vers` varchar(15) NOT NULL, `full_vers` varchar(44) NOT NULL, `dy` date DEFAULT NULL, `ft` text NOT NULL, `html` blob NOT NULL, PRIMARY KEY (`id`), KEY `dy` (`dy`,`just_vers`), FULLTEXT KEY `ft` (`ft`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> DESCRIBE desc_bug; +-----------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+----------------------+------+-----+---------+----------------+ | id | smallint(5) unsigned | NO | PRI | NULL | auto_increment | | just_vers | varchar(15) | NO | | NULL | | | full_vers | varchar(44) | NO | | NULL | | | dy | date | YES | MUL | NULL | | | ft | text | NO | MUL | NULL | | | html | blob | NO | | NULL | | +-----------+----------------------+------+-----+---------+----------------+ 6 rows in set (0.00 sec) Suggested fix: I wonder if adding FULLTEXT to InnoDB created this bug.