[DDC-2090] MultiTableUpdateExecutor works incorrect with query cache enabled Created: 19/Oct/12  Updated: 17/Mar/13  Resolved: 17/Mar/13

Status: Resolved
Project: Doctrine 2 - ORM
Component/s: ORM
Affects Version/s: Git Master
Fix Version/s: 2.4, 2.3.3
Security Level: All

Type: Bug Priority: Major
Reporter: Valera Leontyev Assignee: Fabio B. Silva
Resolution: Fixed Votes: 0
Labels: None


 Description   

Doctrine\ORM\Query\Exec\MultiTableUpdateExecutor works incorrect with query cache enabled.
I execute two similar update-queries with different parameters, but the second query is never executed in database.

There is todo-task in code:

//FIXME (URGENT): With query cache the parameter is out of date. Move to execute() stage.

This is important issue. Much time spent in debugging.



 Comments   
Comment by Valera Leontyev [ 19/Oct/12 ]

Workaround is to disable query cache per every multitable update query: http://stackoverflow.com/questions/12969460/doctrine-query-cache-update

Comment by Fabio B. Silva [ 17/Mar/13 ]

Fixed : https://github.com/doctrine/doctrine2/commit/60b8bc63a1a4819cf112cfbbc7cca06b5792aba6

Comment by Benjamin Eberlei [ 17/Mar/13 ]

Merged into 2.3 for release with 2.3.3

Generated at Thu Oct 02 02:23:41 UTC 2014 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.