Bug #13883 SHOW CREATE TABLE shows one space too much
Submitted: 9 Oct 2005 22:09 Modified: 28 Feb 2006 3:17
Reporter: Bugs System
Status: Closed
Category:Server Severity:S4 (Feature request)
Version:5.0.13-rc OS:Microsoft Windows (Windows XP)
Assigned to: Jim Winstead Target Version:
Triage: D5 (Feature request)

[9 Oct 2005 22:09] Bugs System 
Description:
The result of SHOW CREATE TABLE shows two spaces after "PRIMARY KEY":

CREATE TABLE `test` (
  `Id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

But it should be:
CREATE TABLE `test` (
  `Id` int(11) NOT NULL auto_increment,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

... indeed this bug is not really important ... ;-)

How to repeat:
CREATE TABLE `test` (
  `Id` int(11) NOT NULL auto_increment,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

SHOW CREATE TABLE `test`;
[10 Oct 2005 0:02] Hartmut Holzgraefe 
hardly a bug, a cosmetic issue at most,
changed to low priority feature request
[8 Nov 2005 15:14] MySQL-Front Team 
The developers are not interessed about our bug messages.
[2 Feb 2006 22:40] Jim Winstead 
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/2088
[17 Feb 2006 23:45] Jim Winstead 
Fixed in 5.1.8.
[28 Feb 2006 3:17] Paul DuBois 
Noted in 5.1.7 changelog.

<literal>SHOW CREATE TABLE</literal> produced extraneous
spaces after the <literal>PRIMARY KEY</literal> keywords. (Bug
#13883)