php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #60122 PDO_MYSQL: Many multi-row statements gives wrong result
Submitted: 2011-10-24 14:49 UTC Modified: 2020-12-09 15:40 UTC
Votes:1
Avg. Score:4.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: armiksos at gmail dot com Assigned:
Status: Duplicate Package: PDO MySQL
PHP Version: 7.3 OS: windows 7
Private report: No CVE-ID: None
 [2011-10-24 14:49 UTC] armiksos at gmail dot com
Description:
------------
If you create two query of multi-row statements in one .php file and you assign 
them 
to the same variable after processing one of them, the second query will give only 
result of only ONE statement.

If you assign the result of query to another variable, the result will be correct.

So    $another_var_name = $conn->query("SELECT 1 as one; SELECT 2 as two; SELECT 3 
as three;");

will work in Test script, otherwise result will be wrong.

Test script:
---------------
               $q = $conn->query("SELECT 1 as one; SELECT 2 as two; SELECT 3 as three;");
           
                do
                {
                   $r=$q->fetchAll(PDO::FETCH_ASSOC);
                   echo "<br />";
                   print_r($r);       
                   
                }while($q->nextRowset());
                
           
               $q = $conn->query("SELECT 1 as one; SELECT 2 as two; SELECT 3 as three;");
           
                do
                {
                   $r=$q->fetchAll(PDO::FETCH_ASSOC);
                     echo "<br />";
                   print_r($r);       
                   
                }while($q->nextRowset());   

Expected result:
----------------
Array ( [0] => Array ( [one] => 1 ) )
Array ( [0] => Array ( [two] => 2 ) )
Array ( [0] => Array ( [three] => 3 ) )
Array ( [0] => Array ( [one] => 1 ) )
Array ( [0] => Array ( [two] => 2 ) )
Array ( [0] => Array ( [three] => 3 ) ) 

Actual result:
--------------
Array ( [0] => Array ( [one] => 1 ) )
Array ( [0] => Array ( [two] => 2 ) )
Array ( [0] => Array ( [three] => 3 ) )
Array ( [0] => Array ( [one] => 1 ) ) 

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2011-12-04 17:59 UTC] ssufficool@php.net
Which driver are you using (i.e. MySQL, PostgreSQL, DBLIB, SqlServer?)
 [2011-12-05 09:58 UTC] armiksos at gmail dot com
I use MySQL driver.
 [2013-06-12 04:13 UTC] ssufficool@php.net
-Summary: Many multi-row statements gives wrong result +Summary: PDO_MYSQL: Many multi-row statements gives wrong result
 [2014-01-01 12:41 UTC] felipe@php.net
-Package: PDO related +Package: PDO MySQL
 [2018-04-20 15:14 UTC] sladkov at gmail dot com
Still reproduces with PHP 7.1.15 + mysqlnd driver.
Although with PDO::MYSQL_ATTR_USE_BUFFERED_QUERY set to false it works as expected.
 [2020-02-03 08:24 UTC] cmb@php.net
-Status: Open +Status: Verified -PHP Version: 5.3.8 +PHP Version: 7.3
 [2020-12-09 15:40 UTC] nikic@php.net
-Status: Verified +Status: Duplicate
 [2020-12-09 15:40 UTC] nikic@php.net
Same issue as bug #66878, which is now fixed.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Apr 27 08:01:29 2024 UTC