[DBAL-477] Just doublequote all schema names and field names in PostgreSQL sql command generation, and the same for MySQL Created: 28/Mar/13 Updated: 24/Jun/13
|Component/s:||Platforms, Schema Managers|
|Reporter:||jos de witte||Assignee:||Benjamin Eberlei|
Any PostgreSQL environment
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)
|Comment by Steve Müller [ 24/Jun/13 ]|
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?