mirror of
https://github.com/doctrine/orm.git
synced 2026-03-24 06:52:09 +01:00
DDC-1790: Allow ORDER BY and LIMIT for UPDATE queries #2255
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 @doctrinebot on GitHub (Apr 19, 2012).
Originally assigned to: @beberlei on GitHub.
Jira issue originally created by user themming:
I'm trying to update n-number of rows from a table (ordered by created timestamp) but the update query (built in either DQL or using the query builder) does not support ORDER BY or LIMIT on UPDATE statements.
Is it possible to allow these two clauses in UPDATE statements?
Example DQL is:
UPDATE ICFeederBundle:QueuedLead l SET l.lockId=:lockId WHERE l.lockId IS NULL ORDER BY l.created ASC LIMIT 10
@doctrinebot commented on GitHub (Apr 19, 2012):
Comment created by @beberlei:
This is mysql specific functionality and therefore cannot be supported in DQL.
@doctrinebot commented on GitHub (Apr 19, 2012):
Issue was closed with resolution "Invalid"