ZF-9484: INSERT DELAYED (mysql adapter)

Issue Type: Improvement Created: 2010-03-19T20:04:06.000+0000 Last Updated: 2011-03-22T23:41:13.000+0000 Status: Open Fix version(s): Reporter: Josh Ribakoff ( Assignee: Ralph Schindler (ralph) Tags: - Zend_Db

Related issues: - ZF-3107

Attachments: - delayed.patch


Mysql has an INSERT DELAYED syntax. Supporting it in Zend_Framework is critical for an application that heavily relies on Mysql.

Will attach an overly simplified (but probably working) patch


Posted by Marc Hodgins (mjh_ca) on 2010-11-10T10:36:01.000+0000

This patch will break non-MySQL adapters. Is there a cross-platform equivalent of DELAYED for the other databases? With your patch, setting delayed=true will cause the query to fail with a syntax error on a PostgreSQL, Oracle, etc. So, this definitely does not belong in the abstract adapter unless there is a way to make it cross-platform.

Posted by Josh Ribakoff ( on 2010-11-10T11:43:54.000+0000

Could you just call it insertDelayed() instead of insert(), and not put it on the abstract adapter? I would think it belongs on the mysql adapter, since it is coupled w/ mysql.

Posted by Kamil Dziedzic (arvenil) on 2011-03-06T17:22:26.000+0000

Here is a patch to resolve this issue and #ZF-3107. If you don't like it please write what's wrong with it so I could fix it.

Posted by Kamil Dziedzic (arvenil) on 2011-03-22T23:41:13.000+0000

Hello again. I've signed CLA and here is updated patch to ZF 1.11.4 and now it also includes changes to one more similar ticket #ZF-7149.…

I'm waiting for comments.

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.