php.net |  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
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
Have you experienced this issue?
Rate the importance of this bug to you:

 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved.
Last updated: Tue Mar 19 09:01:30 2024 UTC