[EMAIL PROTECTED] writes:
> I have included all code needed to prove the bug,
No, you haven't: where are the table declarations?
But I'll take a guess anyway: you declared "distance" as int2, didn't
you? AVG(int2) currently uses an int2 accumulator, and you're suffering
overflow. Try "AVG(dist
[EMAIL PROTECTED] wrote:
>
> Gavin Evans ([EMAIL PROTECTED]) reports a bug with a severity of 1
> The lower the number the more severe it is.
>
> Short Description
> Aggregate Function (AVG) not calculated correctly
>
> Long Description
> Using the following code:
> SELECT airline_code, AVG(dis