#41158 [Fbk->Opn]: Add MYSQL_CLIENT_MULTI_RESULTS constant

ID: 41158 User updated by: zizka at seznam dot cz Reported By: zizka at seznam dot cz -Status: Feedback +Status: Open Bug Type: Feature/Change Request Operating System: All PHP Version: 5.2.1 New Comment: For instance, in case of use of Stored Procedure which uses PREPARED statement which surely can not return a result (not SELECT or SHOW), but MySQL does not know it and marks the Stored Procedure as returning a record set, and then throws an exception "can t return a result set in the given context". With the flag MYSQL_CLIENT_MULTI_RESULTS, PHP is able to handle a "CALL ..." query without harming anything (tested). I've seen some other cases when people on the forums use this flag to allow PHP's MySQL extension use Stored Procedures which for some similar reason marked as returning a result set but they do not. This would be needed to document, that the constant is just for such purposes and the extension is not able to handle multiple results. That would also bring the information about such MySQL's behavior right into the PHP manual, what could, in my oppinion, help some programmers finding their 'bug' causing "can t return a result set in the given context". Previous Comments: ------------------------------------------------------------------------ [2007-04-23 09:08:26] tony2001@php.net >Sometimes a situation arises that this constant is needed even >though multiple results support is not needed. For instance? ------------------------------------------------------------------------ [2007-04-22 02:28:31] zizka at seznam dot cz Description: ------------ Please add MYSQL_CLIENT_MULTI_RESULTS to MySQL extension. Sometimes a situation arises that this constant is needed even though multiple results support is not needed. Currently everyone has to add define('MYSQL_CLIENT_MULTI_RESULTS', 131072); to his code. Reproduce code: --------------- <?php $conn = mysql_connect("localhost", "root", "", 1, MYSQL_CLIENT_MULTI_RESULTS); ?> Expected result: ---------------- ... Actual result: -------------- ... ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=41158&edit=1