You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When I'm using the IDENTITY function in a update DQL, the table name is not quoted in the resulting SQL.
Current behavior
DQL: UPDATE App\Entity\User u SET u.deletedAt = :now WHERE IDENTITY(u.userIdentifier) IN(1, 2, 3)
Results in this SQL: UPDATE "user" SET deleted_at = ? WHERE user.user_identifier_id IN (1, 2, 3)
Which results in a "syntax error"
Expected behavior
I expect the resulting SQL to be: UPDATE "user" SET deleted_at = ? WHERE "user".user_identifier_id IN (1, 2, 3)
How to reproduce
My examples above is pretty clear, but let me know if you need more info.
I can add that my User entity have the following table attribute: #[ORM\Table(name: '`user`')]
The text was updated successfully, but these errors were encountered:
Bug Report
Summary
When I'm using the
IDENTITY
function in a update DQL, the table name is not quoted in the resulting SQL.Current behavior
DQL:
UPDATE App\Entity\User u SET u.deletedAt = :now WHERE IDENTITY(u.userIdentifier) IN(1, 2, 3)
Results in this SQL:
UPDATE "user" SET deleted_at = ? WHERE user.user_identifier_id IN (1, 2, 3)
Which results in a "syntax error"
Expected behavior
I expect the resulting SQL to be:
UPDATE "user" SET deleted_at = ? WHERE "user".user_identifier_id IN (1, 2, 3)
How to reproduce
My examples above is pretty clear, but let me know if you need more info.
I can add that my
User
entity have the following table attribute:#[ORM\Table(name: '`user`')]
The text was updated successfully, but these errors were encountered: