mirror of
https://github.com/doctrine/orm.git
synced 2026-03-23 22:42:18 +01:00
Not escaped keywords in insert statement #4978
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @osavchenko on GitHub (Jan 18, 2016).
Originally assigned to: @Ocramius on GitHub.
I catch error:
An exception occurred while executing 'INSERT INTO product_attribute (multiple, limit, attribute_id, product_attribute_block_id) VALUES (?, ?, ?, ?)' with params [0, null, 1, null]:\n\nSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit, attribute_id, product_attribute_block_id) VALUES (0, NULL, 1, NULL)' at line 1}I have column named
limitand it's not escaped in this request.Database: MySQL 5.6.
If this is a bug I can fix it and create PR if it will be useful.
@Ocramius commented on GitHub (Jan 18, 2016):
Please refer to http://doctrine-orm.readthedocs.org/projects/doctrine-orm/en/latest/reference/limitations-and-known-issues.html#identifier-quoting-and-legacy-databases