Details
-
Type:
Bug
-
Status:
Resolved
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 0.1.3, 0.1.4, 0.1.5
-
Fix Version/s: 1.5.0
-
Component/s: Zend_Db_Select
-
Labels:None
-
Fix Version Priority:Nice to Have
Description
When Zend_Db_Select::toString() is called the FOR UPDATE syntax should be processed by the Zend_Db_Adapter* that it belongs to. The current method generates a syntax that is incompatible with MySQL. Allowing the Zend_Db_Adapter_*::limit() method to process a $forUpdate flag would solve the problem.
There should also be support for SELECT ... LOCK IN SHARE, and the corresponding locking modes in SQLite ( http://www.sqlite.org/lockingv3.html ), and similar for the other adapters. This issue overlaps with
ZF-39.ZF-39.