Edit report at http://bugs.php.net/bug.php?id=40913&edit=1
ID: 40913
Updated by: u...@php.net
Reported by: dennis at inmarket dot lviv dot ua
Summary: PDO::PARAM_LOB does not bind to a stream for
fetching a BLOB
-Status: Verified
+Status: Feedback
Type: Bug
Package: PDO related
Operating System: Win XP
PHP Version: 5.2.6
Assigned To: mysql
Block user comment: N
Private report: N
New Comment:
5.2 only gets security fixes, if at all.
Can this be reproduced with 5.3.4-RC, using libmysql (recent one!),
using mysqlnd?
Previous Comments:
------------------------------------------------------------------------
[2010-10-05 18:10:13] samuel at ingessons dot se
And another reason why I need a stream and not a string is that a string
would consume all the memory for a large object.
------------------------------------------------------------------------
[2010-10-05 17:23:46] samuel at ingessons dot se
The reason why I want to have a stream and not echo it directly is that
I use a function that should return a stream.
------------------------------------------------------------------------
[2010-10-05 17:14:27] samuel at ingessons dot se
Is there a way to solve the problem and get a stream?
I want to make a pipeline directly from a longblob to the client.
------------------------------------------------------------------------
[2010-08-24 11:22:11] david at futuresbright dot com
I have experienced the same issue with Windows 2003 using SQL Server 9.0
and php 5.2.13.
Really disappointing that this bug can have been around for so many
years without being fixed.
------------------------------------------------------------------------
[2010-02-19 21:02:32] jcook at macmillanmarketing dot com
I've just been able to reproduce this bug today running PHP 5.3.1 on
Windows.
Reproduce Code:
$db = db::getConn();
$st = $db->prepare($sql);
$st->execute(array(':id' => $id));
$st->bindColumn(1, $image, PDO::PARAM_LOB);
$st->fetch(PDO::FETCH_BOUND);
header ('Content-type: image/jpeg');
fpassthru($image);// this call fails with 'supplied argument is not a
valid stream resource'
Expected result:
Resource
Actual result:
string
I can work around this error for what I'm trying to do but it would be
nice if this was fixed.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/bug.php?id=40913
--
Edit this bug report at http://bugs.php.net/bug.php?id=40913&edit=1
