Bug #13883 SHOW CREATE TABLE shows one space too much
Submitted: 9 Oct 2005 20:09 Modified: 28 Feb 2006 2:17
Reporter: Bugs System Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0.13-rc OS:Windows (Windows XP)
Assigned to: Jim Winstead CPU Architecture:Any

[9 Oct 2005 20: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`;
[9 Oct 2005 22:02] Hartmut Holzgraefe
hardly a bug, a cosmetic issue at most,
changed to low priority feature request
[8 Nov 2005 14:14] MySQL-Front Team
The developers are not interessed about our bug messages.
[2 Feb 2006 21: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 22:45] Jim Winstead
Fixed in 5.1.8.
[28 Feb 2006 2: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)