Icon View Incident Report

Serious Serious
Reported By: Elevate Software
Reported On: 2/7/1999
For: Version 1.09 Build 1
# 286 Single-Field Aggregate Functions in SQL Columns with No GROUP BY Clause Causes an Error

Using a single-field aggregate in an SQL statement with no GROUP BY results in an error, when in fact it should return a single-row result set.

Comments Comments
This has been fixed, and also Count(*) in such a situation has been optimized to return just the record count and not to actually count the records.

Resolution Resolution
Fixed Problem on 2/7/1999 in version 1.10 build 1