Bug #71491 [Opn->Ver]: MYSQL_ATTR_USE_BUFFERED_QUERY doesn't work with PDO::prepare()

From: Date: Fri, 11 Dec 2020 10:35:53 +0000
Subject: Bug #71491 [Opn->Ver]: MYSQL_ATTR_USE_BUFFERED_QUERY doesn't work with PDO::prepare()
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-231009@lists.php.net to get a copy of this message
Edit report at https://bugs.php.net/bug.php?id=71491&edit=1 ID: 71491 Updated by: nikic@php.net Reported by: ads at moneymail dot de Summary: MYSQL_ATTR_USE_BUFFERED_QUERY doesn't work with PDO::prepare() -Status: Open +Status: Verified Type: Bug Package: PDO MySQL Operating System: Ubuntu 15.10 PHP Version: 5.6.17 Block user comment: N Private report: N Previous Comments: ------------------------------------------------------------------------ [2017-11-20 13:23:07] 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! ------------------------------------------------------------------------ [2016-07-02 20:16:03] 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. ------------------------------------------------------------------------ [2016-07-01 21:23:50] cmb@php.net Re-report of bug #55003, which had been closed due to no feedback being given. ------------------------------------------------------------------------ [2016-02-01 15:15:22] 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. ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=71491&edit=1

« previous php.bugs (#231009) next »