View Incident Report

Serious

Reported By: Arnd Baranowski
Reported On: 10/12/2004
For: Version 4.12 Build 1

# 1867 SQL INSERT Statements with Aggregated Sub-Queries Cause a Type Mismatch Error

Your parser does not permit the following SQL. It does not recognize Count(CarrierCode) as Integer value.

Insert into RC_Analyse_M
(Carrierid, Datum, Carrier, Destination,CodesAnzahl)
Select
Carrierid, Gueltigab, Carrier, Destination,Count(CarrierCode)
from
RC_Analyse
WHERE Carrierid = 86
Group by Destination, Gueltigab
Order by Destination, Gueltigab

Resolution

Fixed Problem on 10/13/2004 in version 4.13 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap