ZF-11580: Not able to fecth multiple resultsets from stored procedure using mysqli as a driver

Issue Type:
Bug
Created:
2011-07-20T06:45:26.000+0000
Last Updated:
2012-05-17T17:36:59.000+0000
Status:
Open
Fix version(s):
    Reporter:
    Satheesh Kumar (satheeshks80)
    Assignee:
    Ralph Schindler (ralph)
    Tags:
    • Zend_Db
    • db
    • zend
    • zf-crteam-padraic
    • zf-crteam-priority
    Related issues:
    Attachments:

    Description

    I have a stored procedure "test_procedure" which will execute 3 select statements and returns 3 result sets. I can able to get all 3 result sets by using PHP native mysqli methods. But I could not achieve the same using Zend DB.

    Code using Zend DB

    $stmt=$db->prepare("call test_procedure(?,?,?)"); $stmt->execute(array(1,2,3)); $results = $stmt->fetchAll();

    Is there any limitations in Zend DB adapter. then, is it possible to call native mysqli methods through Zend DB adapter.

    Comments

    Posted by Adam Lundrigan (adamlundrigan) on 2012-05-17T17:36:59.000+0000

    Downgrading from blocker to major