Skip Menu |

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 22261
Status: resolved
Worked: 1 min
Priority: 0/
Queue: SQL-Translator

People
Owner: kclark [...] cpan.org
Requestors: elger [...] elexis.nl
Cc:
AdminCc:

Bug Information
Severity: Critical
Broken in: 0.07
Fixed in: (no value)



Subject: MySQL parse
Hi there, After some fighting with perl and etc i got sqlfairy to work \o/. I just came across a bug and also got a feature request. bug: MySQL reserved words are not escaped. Example; If i have a table called table; parseing crashes due to incorrect SQL. Please escape all column/table/field names etc with `` or "" (the latter is only correct if you have some custom mysql settings so backticks are prefered). FRE: I also noted that references in InnoDB tables are not parsed (at least; i didn't see them in the XML output). Regards, Elger
Surely this has been fixed by now. If not, please show examples of SQL that crash.