View Incident Report

Serious

Reported By: Chris Erdal
Reported On: 3/7/2006
For: Version 4.22 Build 6

# 2174 Using Aggregate Expressions in SELECT Statement With UNION/INTERSECT/EXCEPT Causes Error

I get a complaint when doing the following union, but each SELECT on its own gives 5 columns.

SELECT locNum, amoY100M, tarMensuelTTC,
Reglements, CAST(0.0 AS MONEY) Solde
FROM memory\LocEtRgl
UNION 
SELECT locNum, MAX(amoY100M) amoY100M,
SUM(tarMensuelTTC) tarMensuelTTC, 
SUM(Reglements) Reglements, 
CASE WHEN SUM(Reglements) = NULL THEN (SUM(tarMensuelTTC))
ELSE (SUM(tarMensuelTTC)- SUM(Reglements)) END Solde
FROM memory\LocEtRgl
GROUP BY locNum
ORDER BY locNum, amoY100M

Resolution

Fixed Problem on 3/16/2006 in version 4.23 build 1

Products Affected

DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap