DDC-524: Wrong SQL for DQL UPDATE/DELETE statements that use association paths #652

New Issue

admin · 2026-01-22T12:45:43+01:00

admin commented

2026-01-22 12:45:43 +01:00

Originally created by @doctrinebot on GitHub (Apr 15, 2010).

Originally assigned to: @guilhermeblanco on GitHub.

Jira issue originally created by user romanb:

Example:

// u.Group owning side
DELETE FROM User u WHERE u.Group = ?1

SQL:

DELETE FROM users WHERE u0*.group*id = ?

Note the use of a non-existant alias.

UPDATE/DELETE statements can not use aliases, these are only support by some platforms like mysql, not oracle and others.

Originally created by @doctrinebot on GitHub (Apr 15, 2010). Originally assigned to: @guilhermeblanco on GitHub. Jira issue originally created by user romanb: Example: ``` // u.Group owning side DELETE FROM User u WHERE u.Group = ?1 ``` SQL: ``` DELETE FROM users WHERE u0*.group*id = ? ``` Note the use of a non-existant alias. UPDATE/DELETE statements can not use aliases, these are only support by some platforms like mysql, **not** oracle and others.

admin added the Bug label 2026-01-22 12:45:43 +01:00

admin closed this issue

2026-01-22 12:45:43 +01:00

admin commented

2026-01-22 12:45:44 +01:00

@doctrinebot commented on GitHub (Apr 22, 2010):

Comment created by @guilhermeblanco:

Fixed

@doctrinebot commented on GitHub (Apr 22, 2010): Comment created by @guilhermeblanco: Fixed

admin commented

2026-01-22 12:45:44 +01:00

@doctrinebot commented on GitHub (Apr 22, 2010):