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.

Comments

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.