Subject Re: [ib-support] COUNT discrepancy in DSQL & VIEW
Author Jason Chapman (JAC2)
No idea...

Have you isolated the row that is different?

JAC
>
> The DSQL code and VIEW code are identical, yet a COUNT of records
> returned by the VIEW is 8488 and the COUNT of records in the VIEW is
> 8489. Why is there one less record in the VIEW when the code is
> identical, as you can see below?