|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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
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 Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: ads at moneymail dot de
New email:
PHP Version: OS:


 [2016-02-01 15:15 UTC] ads at moneymail dot de
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.


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2016-07-01 21:23 UTC]
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]
-Package: PDO related +Package: PDO MySQL
 [2017-11-20 13:23 UTC] mkroese at eljakim dot nl
Also note that this ( 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 ( is correct!
 [2020-12-11 10:35 UTC]
-Status: Open +Status: Verified
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Tue Apr 23 05:01:28 2024 UTC