DBAL-477: Just doublequote all schema names and field names in PostgreSQL sql command generation, and the same for MySQL #1677

Open
doctrinebot opened this Issue Mar 28, 2013 · 2 comments

2 participants

@doctrinebot

Jira issue originally created by user josdewitte:

Generation of any SQL command to the database (From entities or migration versions) does not quote all the reserved keywords (For example a fieldname right.

Simple fix that always works: double-quote dbname, schemaname and fieldname

e.g "dbsecurity"."userschema"."users" or "tblusers"

MySQL : use the ` sign.

e.g security.users or tblusers (No support for schemas since I last checked some time ago)

@doctrinebot

Comment created by @deeky666:

If those are reserved keywords, they should be added to the "PostgreSQLKeywords" class and they will be quoted by Doctrine. As far as I can see those keywords mentioned are not present in this class. Maybe there is something missing?

@beberlei beberlei was assigned by doctrinebot Dec 6, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment