ZF-40: Zend_Db_Select SQL: FOR UPDATE

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 ( ), 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.


© 2006-2018 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.