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:

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.

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.