Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Using IDENTITY in a update does not quote table name #11744

Open
tomme87 opened this issue Dec 3, 2024 · 0 comments
Open

Using IDENTITY in a update does not quote table name #11744

tomme87 opened this issue Dec 3, 2024 · 0 comments

Comments

@tomme87
Copy link

tomme87 commented Dec 3, 2024

Bug Report

Q A
Version 3.3.0
Driver postgresql

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`')]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant