Details
-
Type:
New Feature
-
Status:
Resolved
-
Priority:
Major
-
Resolution: Invalid
-
Affects Version/s: 2.1.4
-
Fix Version/s: None
-
Component/s: DQL
-
Labels:None
-
Environment:Symfony2 project using MySQL persistence layer.
Description
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
This is mysql specific functionality and therefore cannot be supported in DQL.