#38921 [Com]: pdo lost the first row data:with firebird blob data
| From: | drew dot winther at netce dot com | Date: | Sat, 27 Jan 2007 00:50:58 +0000 |
| Subject: | #38921 [Com]: pdo lost the first row data:with firebird blob data | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-108120@lists.php.net to get a copy of this message | ||
ID: 38921
Comment by: drew dot winther at netce dot com
Reported By: achun dot shx at gmail dot com
Status: Open
Bug Type: InterBase related
Operating System: windows
PHP Version: 5.1.6
New Comment:
This is a dupe of http://bugs.php.net/bug.php?id=35386
Previous Comments:
------------------------------------------------------------------------
[2006-09-22 09:24:31] achun dot shx at gmail dot com
Description:
------------
on firebird/interbase table.
pdo fetch data .
lost the first row data when the field type is blob.
php 5.11/5.12 too
Reproduce code:
---------------
//sql code
CREATE TABLE test (
ID INTEGER,
DAT BLOB SUB_TYPE 1 SEGMENT SIZE 80
);
//inset any data
INSERT INTO test (ID,DAT) VALUES (1,'aaa');
INSERT INTO test (ID,DAT) VALUES (2,'bbb');
//php code
$dbh = new PDO("firebird:dbname=xxx",'SYSDBA','masterkey');
$sth=$dbh->query('SELECT * from test;');
while ($row=$sth->fetch(2)){
print_r($row);
}
//lost the first row data VALUES (1,'aaa')
Array
(
[ID] =>
[DAT] =>
)
Array
(
[ID] => 2
[DAT] => bbb
)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=38921&edit=1