Invalid InnoDB FTS Doc ID during INSERT
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
Medium
|
Unassigned | |||
5.7 |
Fix Released
|
Medium
|
Unassigned |
Bug Description
Attempts to insert into an InnoDB table that contains a FULLTEXT KEY and a FTS_DOC_ID column fail when the FTS_DOC_ID is not specified.
CREATE TABLE `fts` (
`id` varchar(36) NOT NULL,
`reason` varchar(500) NOT NULL,
`FTS_DOC_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`),
UNIQUE KEY `FTS_DOC_ID_INDEX` (`FTS_DOC_ID`),
FULLTEXT KEY `reason` (`reason`)
) ENGINE=InnoDB AUTO_INCREMENT=
mysql> INSERT IGNORE INTO fts (id, reason) VALUES (UUID(), 'unknown');
ERROR 182 (HY000): Invalid InnoDB FTS Doc ID
mysql> INSERT INTO fts (id, reason) VALUES (UUID(), 'unknown');
ERROR 182 (HY000): Invalid InnoDB FTS Doc ID
tags: | added: innodb upstream |
mysql Ver 14.14 Distrib 5.6.25-73.1, for Linux (x86_64) using 6.0
Server version: 5.6.25-73.1-log Percona Server (GPL), Release 73.1, Revision 07b797f
CentOS release 6.7 (Final)