php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #71491 MYSQL_ATTR_USE_BUFFERED_QUERY doesn't work with PDO::prepare()
Submitted: 2016-02-01 15:15 UTC Modified: 2020-12-11 10:35 UTC
Votes:9
Avg. Score:4.6 ± 0.7
Reproduced:9 of 9 (100.0%)
Same Version:1 (11.1%)
Same OS:2 (22.2%)
From: ads at moneymail dot de Assigned:
Status: Verified Package: PDO MySQL
PHP Version: 5.6.17 OS: Ubuntu 15.10
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: ads at moneymail dot de
New email:
PHP Version: OS:

 

 [2016-02-01 15:15 UTC] ads at moneymail dot de 
Description:
------------
To keep long things short:

This is just a reopening of #55003: PDO prepare() ignores MYSQL_ATTR_USE_BUFFERED_QUERY

The very same behaviour described in #55003 can still be observed.

Setting the attribute on PDO instance level however works as expected, but obviously leaks the convenience of native support of setting it on query level.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2016-07-01 21:23 UTC] cmb@php.net 
Re-report of bug #55003, which had been closed due to no feedback
being given.
 [2016-07-02 20:16 UTC] ads at moneymail dot de 
The other bug's reporter was told to test some PHP 5.4 snapshot.
I for myself noticed the same bug under PHP 5.6.17 which should be enough to prove the bug is still existent.
Please also compare the dates both bugs were filed.
 [2017-04-24 19:21 UTC] adambaratz@php.net
-Package: PDO related +Package: PDO MySQL
 [2017-11-20 13:23 UTC] mkroese at eljakim dot nl 
Also note that this (http://php.net/manual/en/ref.pdo-mysql.php#75583) has been a valid comment on the documentation page for just 10 years, while the example given on that very same documentation page simply does *not* work.

The documentation should be updated OR the bug should be fixed.

The example on the documentation page dedicated to this subject (http://php.net/mysqlinfo.concepts.buffering#example-1812) is correct!
 [2020-12-11 10:35 UTC] nikic@php.net
-Status: Open +Status: Verified
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Fri Oct 31 00:00:01 2025 UTC