It is not intended behavior. I think what it should do is impose a fetchall
or raise an exception that it cannot determine the count.

Logged as a bug.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Svein Erling Tysvær" <svein.erling.tysvaer@...>
To: <ibobjects@yahoogroups.com>
Sent: Monday, August 06, 2001 3:51 AM
Subject: [IBO] Strange behaviour of IB_SQL


> I have a query which fetches 65 rows when executed through IB_SQL.
However,
> if I click the sigma sign to count the number of rows the result is 88!
> After inspection, I suspect the reason to be because I have DISTINCT in my
> query. Removing the DISTINCT I do indeed get 88 rows. I thought about
> including my SQL in this mail, but the result is 100% reproducable using
> any query.
>
> Is it intended behaviour that the "sigma count" does not care about
> DISTINCT, and if so why?
>
> Set