Icon View Incident Report

Serious Serious
Reported By: Anthony Taylor
Reported On: 2/12/1999
For: Version 1.11 Build 1
# 296 Multiple Single-Field Aggregate Functions in Column List Causes a GROUP BY Error

When trying to issue the following query:

SELECT sum(itemstotal), avg(itemstotal) FROM items

and error is received saying that a GROUP BY clause is required.

Comments Comments
DBISAM was only looking at the first aggregate when determining whether it needs a GROUP BY or not.

Resolution Resolution
Fixed Problem on 2/15/1999 in version 1.12 build 1