Subject | Re: [ib-support] COUNT discrepancy in DSQL & VIEW |
---|---|
Author | Jason Chapman (JAC2) |
Post date | 2002-05-17T06:38:39Z |
No idea...
Have you isolated the row that is different?
JAC
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?