Bug #13396 SHOW CREATE TABLE omits PARSER clause
Submitted: 22 Sep 2005 4:05 Modified: 23 Sep 2005 8:47
Reporter: Kolbe Kegel Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:5.0 OS:Linux (Linux)
Assigned to: Sergey Vojtovich CPU Architecture:Any

[22 Sep 2005 4:05] Kolbe Kegel 
Description:
SHOW CREATE TABLE does not include a PARSER clause when such has been specified for a FULLTEXT index in the CREATE TABLE statement.

How to repeat:
Create a table such as the following:

CREATE TABLE table1 (
    col1 VARCHAR(12),
    FULLTEXT INDEX index1 (col1) WITH PARSER myparser
)

And then do:

SHOW CREATE TABLE table1

Suggested fix:
Include a PARSER clause in the output of SHOW CREATE TABLE.
[22 Sep 2005 16:24] 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/internals/30227
[23 Sep 2005 8:27] 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/internals/30253