ZF-40: Zend_Db_Select SQL: FOR UPDATE

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

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].

Changing fix version to 0.8.0.

Recategorize as Zend_Db_Table component.

Marking this issue Postponed, to be revisited in a later release of Zend_Db.

The SQL-only version of this has been resolved in r7508 in trunk.