From: taylor dot ren at gmail dot com Operating system: Vista Business PHP version: 5.2.2 PHP Bug Type: PDO related Bug description: PDO fetchAll for InterBase missing first row
Description: ------------ The code is simple: I just want to select 5 rows from my InterBase database using PDO. A live demo can be found: http://www.rsywx.net/smarty/test01.php. It is very clear that the first row is not fetched (or missing) so the output is missing BOOKID=00001 and related information. Same mechanism works fine for MySQL. Reproduce code: --------------- $PDO1=new PDO("firebird:dbname=localhost:f:\\data\\book.ib", "iis", "iis"); print_r($PDO1->query('SELECT bookid, title, author FROM book order by bookid rows 5')->fetchAll(PDO::FETCH_ASSOC)); Expected result: ---------------- Should have 5 records with BOOKID from 00001 to 00005. Actual result: -------------- Now 00001 is missing. -- Edit bug report at http://bugs.php.net/?id=41509&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=41509&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=41509&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=41509&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=41509&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=41509&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=41509&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=41509&r=needscript Try newer version: http://bugs.php.net/fix.php?id=41509&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=41509&r=support Expected behavior: http://bugs.php.net/fix.php?id=41509&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=41509&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=41509&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=41509&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=41509&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=41509&r=dst IIS Stability: http://bugs.php.net/fix.php?id=41509&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=41509&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=41509&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=41509&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=41509&r=mysqlcfg