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