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 (email@example.com) 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 (firstname.lastname@example.org) 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.