Forum: bugs

punctuated comments confuse mysql2pgsql [ reply ]
By: Catherine Devlin on 2011-04-15 15:15

If there are semicolons or escaped single-quotes in a table or column comment in MySQL, mysql2pgsql trips up on converting the DDL.

mysql> create table test (n int) comment 'A test; only Catherine''s test.';

$ mysqldump --no-data mydb test > test.ddl
$ perl mysql2pgsql.perl test.ddl pgtest.ddl

Now pgtest.ddl contains

CREATE TABLE "test" (
"n" int DEFAULT NULL
) 's test.'
;

"SQL-significant punctuation in comments? Don't DO that!" OK, I won't do it again. :)

Thanks for writing a great script and helping me get out of MySQL hell!