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
Activity
Benjamin Eberlei
made changes -
| Field | Original Value | New Value |
|---|---|---|
| Status | Open [ 1 ] | Resolved [ 5 ] |
| Resolution | Invalid [ 6 ] |
Benjamin Eberlei
made changes -
| Workflow | jira [ 13648 ] | jira-feedback [ 15327 ] |
Benjamin Eberlei
made changes -
| Workflow | jira-feedback [ 15327 ] | jira-feedback2 [ 17191 ] |
Benjamin Eberlei
made changes -
| Workflow | jira-feedback2 [ 17191 ] | jira-feedback3 [ 19446 ] |
This list may be incomplete, as errors occurred whilst retrieving source from linked applications:
- Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DDC-1790, expand=changesets[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)
This is mysql specific functionality and therefore cannot be supported in DQL.