- marked as major
- removed milestone
MySQL fails on "create table log(" - needs "log (" instead
Issue #206
resolved
In source:/sqlalchemy/trunk/lib/sqlalchemy/ansisql.py ANSISchemaGenerator.visit_table "create table" is appended with the table name and a parenthesis "(". MySQL seems to raise a syntax error on this if the table name is "log".
Adding a space character between the table name and the parenthesis fixes the problem.
Comments (3)
-
repo owner -
Account Deleted Yes, backtick-quoting solves the problem too.
-
repo owner - changed status to resolved
quoting is a bigger headache...i just added the single space in changeset:1643....mysql is just so dumb....
- Log in to comment
per http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html , quotes are a more general solution.
please let me know if quoting the identifier works as well.