Description:
Observed once; no replication attempted.
A table containing several fields, one of which was named "references" was exported to file by mysqldump. The exported file did not place the field name in quotation marks. When the dump file was used to reload the table, a syntax error was detected near the field name "references".
Observed behaviour: mysqldump()s of well-formed tables are not successfully reloaded.
Expected behaviour: mysqldump()s of well-formed tables are always successfully reloaded.
Additional observations: MySQLCC reports that the create table command should be of the form
<quotation>
`chemical_decomp` text,
`references` text,
`classification` enum('foo','bar','baz') default 'foo',
</quotation>
whereas the create table command created by mysqldump is of the form
<quotation>
chemical_decomp text,
references text,
classification enum('foo','bar','baz') default 'foo',
</quotation>
Assumption: The field name "references" was being parsed as the keyword "references" because the field name was not set off in quotes.
How to repeat:
Create a table with a references field.
Export with mysqldump
Try to reload the dump-file.
Suggested fix:
mysqldump should emit "create table" commands with fields in quotation marks.
Description: Observed once; no replication attempted. A table containing several fields, one of which was named "references" was exported to file by mysqldump. The exported file did not place the field name in quotation marks. When the dump file was used to reload the table, a syntax error was detected near the field name "references". Observed behaviour: mysqldump()s of well-formed tables are not successfully reloaded. Expected behaviour: mysqldump()s of well-formed tables are always successfully reloaded. Additional observations: MySQLCC reports that the create table command should be of the form <quotation> `chemical_decomp` text, `references` text, `classification` enum('foo','bar','baz') default 'foo', </quotation> whereas the create table command created by mysqldump is of the form <quotation> chemical_decomp text, references text, classification enum('foo','bar','baz') default 'foo', </quotation> Assumption: The field name "references" was being parsed as the keyword "references" because the field name was not set off in quotes. How to repeat: Create a table with a references field. Export with mysqldump Try to reload the dump-file. Suggested fix: mysqldump should emit "create table" commands with fields in quotation marks.