View Incident Report

Serious

Reported By: Jorn Rasmussen
Reported On: 11/25/2000
For: Version 2.04 Build 1

# 666 SQL AVG Function Causes Sum of Column for Last Record in Result Set Instead of the Average

When you make a query with AVG the last result is a sum.

group idx

1    1
1    2
1    3

avg of 1 =   2   true

2    4
2    5

avg of 2 = 4,5  true

3    6
3    7
3    8

avg of 3 = 21  false

Resolution

Fixed Problem on 11/25/2000 in version 2.05 build 1

More Support Options