#41509 [Opn->Bgs]: PDO fetchAll for InterBase missing first row

From: Date: Tue, 29 May 2007 20:40:53 +0000
Subject: #41509 [Opn->Bgs]: PDO fetchAll for InterBase missing first row
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-113166@lists.php.net to get a copy of this message 
 ID:               41509
 Updated by:       tony2001@php.net
 Reported By:      taylor dot ren at gmail dot com
-Status:           Open
+Status:           Bogus
 Bug Type:         PDO related
 Operating System: Vista Business
 PHP Version:      5.2.2
 New Comment:

See bug #35386.


Previous Comments:
------------------------------------------------------------------------

[2007-05-27 02:26:34] taylor dot ren at gmail dot com

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 this bug report at http://bugs.php.net/?id=41509&edit=1

Thread (2 messages)

« previous php.bugs (#113166) next »