Bug #3917

problems in setSelectedRowRange()

Details

Submitted	2005-03-22 14:14 UTC
From	smith at backendmedia dot com
Status	Wont fix
Package	MDB
PHP Version	Irrelevant
OS	irrelevant
Roadmaps	(Not assigned)

Comments

[2005-03-22 14:14 UTC] smith at backendmedia dot com

Description:
------------
Adding this bug report from Lorenzo so I dont forget. It probably also affects the oci8 driver:

I think I just found a new bug in MDB.
I verified it with ibase but I think it affects all drivers.

Try adding the following code to the bottom
of the MDB_Usage_TestCase::testRanges() method:

====================================================
$this->db->setSelectedRowRange(0, 2);

$query =
'SELECT user_name, user_password, subscribed,
user_id, quota, weight, access_date,
access_time, approved
FROM users
ORDER BY user_id';

$result = $this->db->queryAll(query, $this->types);

//total records = 5, limit = 2 records
$this->assertEquals(2, count($result));
====================================================

It looks like setSelectedRowRange() is only honored
by $db->query(), but completely ignored by the other
get*() and query*() methods. Is this the intended
behaviour? Please don't say yes ;)