#38015 [Opn->Bgs]: Can not set PDO_MYSQL_ATTR_MAX_BUFFER_SIZE

ID: 38015 Updated by: tony2001@php.net Reported By: sunaoka+bugs dot php dot net at gmail dot com -Status: Open +Status: Bogus Bug Type: PDO related Operating System: Solaris PHP Version: 5.1.4 New Comment: >But, I do not understand why the result doesn't become `int(10485760)'. Why should it become equal to the size of the buffer? Buffer is used to read the data by pieces and you can change size of of these pieces. This is why it's called "PDO_MYSQL_ATTR_MAX_BUFFER_SIZE" and not "PDO_MYSQL_ATTR_MAX_DATA_SIZE". Previous Comments: ------------------------------------------------------------------------ [2006-07-07 06:17:08] sunaoka+bugs dot php dot net at gmail dot com Thank you for your comment. But, I do not understand why the result doesn't become `int(10485760)'. I load `FileData' only 1MB. I am using php5.2-200607060030. Reproduce code: --------------- try { $db = new PDO('mysql:host=localhost;dbname=test', 'user', 'pass'); $db->setAttribute(PDO::MYSQL_ATTR_MAX_BUFFER_SIZE, 1024 * 1024 * 10); $sql = 'SELECT LENGTH(FileData) FROM FileInfo WHERE Id = ?'; $stmt = $db->prepare($sql); $stmt->execute(array(1)); $result = $stmt->fetch(); $stmt->closeCursor(); echo 'LENGTH(FileData): ', $result[0], "\n"; $sql = 'SELECT FileData FROM FileInfo WHERE Id = ?'; $stmt = $db->prepare($sql); $stmt->execute(array(1)); $stmt->bindColumn('FileData', $lob, PDO::PARAM_LOB); $result = $stmt->fetch(PDO::FETCH_BOUND); file_put_contents('/tmp/foo', $lob); echo "filesize('/tmp/foo'): ", filesize('/tmp/foo'), "\n"; } catch (PDOException $exception) { echo $exception->getMessage(), "\n"; } Expected result: ---------------- LENGTH(FileData): 6971569 filesize('/tmp/foo'): 1048576 ------------------------------------------------------------------------ [2006-07-06 20:12:51] tony2001@php.net Expected result: ---------------- int(1048576) bool(true) int(1048576) Right, this is the expected and ACTUAL result. I don't see any problems there. ------------------------------------------------------------------------ [2006-07-06 08:41:22] sunaoka+bugs dot php dot net at gmail dot com Thank you for your comment. I try using CVS snapshot, but I have another problem. So, I can set PDO_MYSQL_ATTR_MAX_BUFFER_SIZE, but it can not set the value. Reproduce code: --------------- $db = new PDO('mysql:host=localhost;dbname=test', 'user', 'pass'); var_dump($db->getAttribute(PDO::MYSQL_ATTR_MAX_BUFFER_SIZE)); var_dump($db->setAttribute(PDO::MYSQL_ATTR_MAX_BUFFER_SIZE, 1024 * 1024 * 10)); var_dump($db->getAttribute(PDO::MYSQL_ATTR_MAX_BUFFER_SIZE)); Expected result: ---------------- int(1048576) bool(true) int(1048576) ------------------------------------------------------------------------ [2006-07-05 17:32:50] iliaa@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.2-win32-latest.zip ------------------------------------------------------------------------ [2006-07-05 13:28:41] sunaoka+bugs dot php dot net at gmail dot com Description: ------------ I'm using pdo_mysql client library 4.1.20. I need treat the data of 1MB or more. But I can not set PDO_MYSQL_ATTR_MAX_BUFFER_SIZE. Reproduce code: --------------- $db = new PDO('mysql:host=localhost;dbname=test', 'user', 'pass'); var_dump($db->setAttribute(PDO::MYSQL_ATTR_MAX_BUFFER_SIZE, 1024 * 1024 * 10)); Expected result: ---------------- bool(false) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=38015&edit=1