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 (josh.ribakoff@gmail.com)
    Assignee:
    Ralph Schindler (ralph)
    Tags:
    • Zend_Db
    Related issues:
    Attachments:

    Description

    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

    Comments

    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 (josh.ribakoff@gmail.com) 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.

    http://kamil.klecza.pl/zend/ZF-3107_ZF-9484.patch/

    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.

    http://framework.zend.com/issues/secure/…

    I'm waiting for comments.