Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
DBISAM Technical Support
»
Incident Reports
»
Incident Reports Addressed for Version 1.12
»
View Incident Report
View Incident Report
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
DBISAM was only looking at the first aggregate when determining whether it needs a GROUP BY or not.
Resolution
Fixed Problem on 2/15/1999 in version 1.12 build 1
More Support Options
Search Incident Reports
Support Forums
Frequently Asked Questions
Technical Bulletins
Technical Articles
Product Manuals
Roadmap