Bug #7087 ANSI QUOTES not consistant in SHOW CREATE TABLE
Submitted: 7 Dec 2004 23:46 Modified: 8 Dec 2004 14:56
Reporter: Michael G. Zinner Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.1 OS:Windows (WinXP)
Assigned to: CPU Architecture:Any

[7 Dec 2004 23:46] Michael G. Zinner
Description:
SHOW CREATE TABLE results in a mixture of " and `.

How to repeat:
SHOW CREATE TABLE bar;

CREATE TABLE "bar" (
  "idbar" int(10) unsigned NOT NULL auto_increment,
  "idfoo" int(10) unsigned NOT NULL default '0',
  "name" varchar(45) NOT NULL default '',
  PRIMARY KEY  ("idbar"),
  KEY "a_FK_to_foo" ("idfoo"),
  CONSTRAINT `a_FK_to_foo` FOREIGN KEY (`idfoo`) REFERENCES `foo` (`idfoo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[7 Dec 2004 23:58] Paul DuBois
Appears to be fixed in 5.0.2...
[8 Dec 2004 1:25] Hartmut Holzgraefe
can't repeat it on 5.0.1/linux either
[8 Dec 2004 14:56] Marko Mäkelä
This is a duplicate of bug #5292, which was fixed in MySQL 4.1.6, and also in 5.0.2.