|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #54978 mysql_query() returns true with a SELECT statement
Submitted: 2011-06-02 17:38 UTC Modified: 2013-02-18 00:34 UTC
Avg. Score:4.8 ± 0.6
Reproduced:8 of 8 (100.0%)
Same Version:2 (25.0%)
Same OS:7 (87.5%)
From: radu dot dineiu at gmail dot com Assigned: mysql (profile)
Status: No Feedback Package: MySQL related
PHP Version: 5.3.6 OS: Any
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2011-06-02 17:38 UTC] radu dot dineiu at gmail dot com
This doesn't happen often, but it does happen sometimes when the database server 
interrupts the connection during a query. Seems to be related to the fact that 
libmysqlclient's mysql_query() may return success, even if an error occurred, as 
described at:

Test script:
$resource = mysql_query('SELECT test FROM test');
if ($resource === true) {
    throw new Exception('mysql_query() returned true for SELECT');

Expected result:
An exception should not be thrown, because the documentation for mysql_query() at clearly states that a SELECT query will only ever return false or a 

Actual result:
An exception is thrown, because mysql_query() returns true with a SELECT query.


mysql_query_true_patch.txt (last revision 2011-06-02 15:39 UTC by radu dot dineiu at gmail dot com)

Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2011-07-20 10:55 UTC]
-Status: Open +Status: Feedback -Assigned To: +Assigned To: mysql
 [2011-07-20 10:55 UTC]
Are you using libmysql, if so, which version? Can you reproduce with mysqlnd? 

And, yes, looks like we need the patch. I wonder if its libmysql version dependent.

 [2011-07-24 03:57 UTC] radu dot dineiu at gmail dot com
Yes, this happens with PHP's mysql_* functions using libmysqlclient, not mysqlnd. 
I don't know if it happens with mysqlnd as well, I couldn't test that, and now I 
can't get the same environment again.
 [2013-02-18 00:34 UTC] php-bugs at lists dot php dot net
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Wed Jul 24 16:01:28 2024 UTC