#50483 [Opn->Bgs]: mysqli_error() does not return error while using with mysqli_real_query()

[andrey]

 ID:               50483
 Updated by:       and...@php.net
 Reported By:      pcdinh at gmail dot com
-Status:           Open
+Status:           Bogus
 Bug Type:         MySQLi related
 Operating System: Windows XP
 PHP Version:      5.3.1
 New Comment:

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to report
a bug at http://bugs.php.net/how-to-report.php

Hi, 
I checked your script and found out that there is a bug in it.
You need to check for an error after the loop. If you do a
var_dump(mysqli_error($conn)); you will get the error, like here:
string(40) "Table 'test.non_existent_' doesn't exist"

As after the third query there is no result set the loop ends and you
can check whether there was an error.

Thanks!


Previous Comments:
------------------------------------------------------------------------

[2009-12-21 16:06:38] pcdinh at gmail dot com

Could someone look at this issue please?

------------------------------------------------------------------------

[2009-12-15 16:28:05] pcdinh at gmail dot com

Description:
------------
mysqi_error() and mysqli_errno() does not capture last error message 
and error code if mysqli_real_query() executes on a stored procedure 
that returns multiple result sets but one of them is an error. 

As you can see from the below code, I have a SP that basically a set 
of SELECTs but the last one is invalid by intention. If executing the 
SP (e.x: CALL p2(2, 5) ) in a MySQL Query Manager, the following 
warning will show up:

(1 row(s) returned)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(1 row(s) returned)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(1 row(s) returned)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

Query : CALL p2(2, 5) 
Error Code : 1146
Table 'test.non_existent_' doesn't exist
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

However, mysqli does not work that way. It does not know what happens 
with the last query. It simply knows the last query does not return a 
result set.



Reproduce code:
---------------
<?php

/*

DELIMITER $$

CREATE PROCEDURE p2(X INT, Y INT)
        DETERMINISTIC
        BEGIN
                SELECT
                X ;
                SELECT
                X AS first_param,
                Y AS second_param;
                SELECT
                X,
                Y,
                        X + Y AS sum_xy,
                X * Y AS prod_xy;
                SELECT 1 FROM non_existent_; -- Intentional error
        END$$

DELIMITER ;
*/


$conn = mysqli_connect("localhost", "root", "123456", "test");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

$query   = "CALL p2(2, 5)";
$success = mysqli_real_query($conn, $query);

if (false === $success)
{
    var_dump(mysqli_error($conn));
}

$i = 0;
do
{
    $result = mysqli_store_result($conn);
    if (false !== $result)
    {
        echo ++$i."\n";
    }
    else
    {
        var_dump(mysqli_error($conn));
    }

} while (mysqli_more_results($conn) && mysqli_next_result($conn));

/* close connection */
mysqli_close($conn);

?>

Expected result:
----------------
1
2
3
string(0) "Table 'test.non_existent_' doesn't exist"

Actual result:
--------------
1
2
3


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=50483&edit=1