You are viewing a plain text version of this content. The canonical link for it is here.
Posted to bugs@httpd.apache.org by bu...@apache.org on 2008/06/23 07:37:42 UTC

DO NOT REPLY [Bug 45251] New: DBD MySQL driver doesn' t support multiple resultsets

https://issues.apache.org/bugzilla/show_bug.cgi?id=45251

           Summary: DBD MySQL driver doesn't support multiple resultsets
           Product: Apache httpd-2
           Version: 2.3-HEAD
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: Core
        AssignedTo: bugs@httpd.apache.org
        ReportedBy: zhihong@gmail.com


When calling stored procedure returning multiple result sets, I am getting this
error from MySQL,

   ROCEDURE get_all_by_username can't return a result set in the given context

MySQL needs flag CLIENT_MULTI_RESULTS but there is no way to set this flag in
DBDParam. I added following change to apr_dbd_mysql.c so it takes any number
value to solve my problem,


    if (fields[6].value != NULL) {
        if (!strcmp(fields[6].value, "CLIENT_FOUND_ROWS"))
           flags |= CLIENT_FOUND_ROWS; /* only option we know */
        else
           flags |= atol(fields[6].value);
    }

Can someone add this feature in the driver?


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org


DO NOT REPLY [Bug 45251] DBD MySQL driver doesn't support multiple resultsets

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45251


Nick Kew <ni...@webthing.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|Core                        |APR
           Platform|PC                          |All
            Version|2.3-HEAD                    |HEAD
         AssignedTo|bugs@httpd.apache.org       |bugs@apr.apache.org
            Product|Apache httpd-2              |APR
         OS/Version|Linux                       |All


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: bugs-unsubscribe@httpd.apache.org
For additional commands, e-mail: bugs-help@httpd.apache.org