----- Original Message -----
From: "bemmel2003"
> My query:
>
> select first(10) name,adress from customers
>
> Using IBOquery
> I get 10 records if "fetchwholerows = true" but I get 20000 records
> if "fetchwholerows = false"
>
> So is this a known IBO-bug, or is it just me ?
>
It's a bug. Apparently a pasring bug.
This is what happens when fetchwholerows=true
/*-------- ENABLED --------*/
/*---
PREPARE STATEMENT
TR_HANDLE = 3784852
STMT_HANDLE = 3785148
SELECT first 10 *
FROM CLIENTI
PLAN (CLIENTI NATURAL)
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 3784852
STMT_HANDLE = 3785148
PARAMS = [ ]
----*/
And this is what happens when fetchwholerows=false
/*---
PREPARE STATEMENT
TR_HANDLE = 21739520
STMT_HANDLE = 3785036
SELECT CLIENTI.ID
FROM CLIENTI
PLAN (CLIENTI NATURAL)