#38921 [NEW]: pdo lost the first row data:with firebird blob data
| From: | achun dot shx at gmail dot com | Date: | Fri, 22 Sep 2006 09:24:31 +0000 |
| Subject: | #38921 [NEW]: pdo lost the first row data:with firebird blob data | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-102521@lists.php.net to get a copy of this message | ||
From: achun dot shx at gmail dot com
Operating system: windows
PHP version: 5.1.6
PHP Bug Type: InterBase related
Bug description: pdo lost the first row data:with firebird blob data
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 bug report at http://bugs.php.net/?id=38921&edit=1
--
Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=38921&r=trysnapshot44
Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=38921&r=trysnapshot52
Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=38921&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=38921&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=38921&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=38921&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=38921&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=38921&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=38921&r=support
Expected behavior: http://bugs.php.net/fix.php?id=38921&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=38921&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=38921&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=38921&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38921&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=38921&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=38921&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=38921&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=38921&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=38921&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=38921&r=mysqlcfg