#41407 [NEW]: mysql_errno/mysql_error not working on connect failures when another connection

From: david at ols dot es Operating system: any PHP version: 4.4.7 PHP Bug Type: MySQL related Bug description: mysql_errno/mysql_error not working on connect failures when another connection Description: ------------ mysql_errno/mysql_error return valid results on connection failures, but if you try to connect to a second server while the connection to the first one is opened, then they return null results, which is ok, as per doc, the error given is for the last opened connection and not for the last performed mysql operation. I've seen other "bugs" like this closed as bogus because the documentation says what it says but what's really bogus is the current mysql_error/errno implementation. This makes mysql_error/errno not only unuseful in that situations but also makes it behave differently from what it does in another laguages (where is always possible to retrieve error information on connect failures). To be able to catch this errors (as in any other language), mysql_error/errno should report the status of the last mysql operation when no link identifier is given and not report the result of the last operation on the last opened connection. This will be easy to implement by just storing error information when any mysql functions fails. Reproduce code: --------------- $host = "localhost"; $user = "bogus"; $pw = "foo"; $conn = mysql_connect($host, $user, $pw); echo "MySQL status: (". mysql_errno().": '".mysql_error()."')<BR>"; $host = "localhost"; $user = "user_ok"; $pw = "pass_ok"; $conn = mysql_connect($host, $user, $pw); echo "MySQL status: (". mysql_errno().": '".mysql_error()."')<BR>"; $host = "localhost"; $user = "bogus"; $pw = "foo"; $conn = mysql_connect($host, $user, $pw); echo "MySQL status: (". mysql_errno().": '".mysql_error()."')<BR>"; Expected result: ---------------- first connection failed, error reported ok second connection succed third connection failed, error reported ok Actual result: -------------- first connection failed, error reported ok second connection succed third connection failed, error not reported -- Edit bug report at http://bugs.php.net/?id=41407&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=41407&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=41407&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=41407&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=41407&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=41407&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=41407&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=41407&r=needscript Try newer version: http://bugs.php.net/fix.php?id=41407&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=41407&r=support Expected behavior: http://bugs.php.net/fix.php?id=41407&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=41407&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=41407&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=41407&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=41407&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=41407&r=dst IIS Stability: http://bugs.php.net/fix.php?id=41407&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=41407&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=41407&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=41407&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=41407&r=mysqlcfg