Issue Type: Bug Created: 2006-06-19T23:10:52.000+0000 Last Updated: 2008-03-21T16:25:48.000+0000 Status: Resolved Fix version(s): - 1.5.0 (17/Mar/08)
Reporter: Zend Framework (zend_framework) Assignee: Darby Felton (darby) Tags: - Zend_Db_Select
Related issues: Attachments:
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.
Posted by Gavin (gavin) on 2006-07-06T17:21:43.000+0000
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].
Posted by Bill Karwin (bkarwin) on 2006-11-13T15:14:32.000+0000
Changing fix version to 0.8.0.
Posted by Bill Karwin (bkarwin) on 2007-01-05T17:06:23.000+0000
Recategorize as Zend_Db_Table component.
Posted by Bill Karwin (bkarwin) on 2007-04-17T17:59:13.000+0000
Marking this issue Postponed, to be revisited in a later release of Zend_Db.
Posted by Simon Mundy (peptolab) on 2008-01-18T21:50:56.000+0000
The SQL-only version of this has been resolved in r7508 in trunk.
Have you found an issue?
See the Overview section for more details.