View Incident Report

Serious

Reported By: Scott Carter
Reported On: 12/13/2000
For: Version 2.05 Build 1

# 685 SQL Aggregate Functions Not Processing Consistently and Depending Upon Number of Rows Processed

Here is my confusion. Using DBSys...all of Table2's T2_SFLD1 values are null, yet COUNT returns 0 for some records and null for others. Specifically, why is BURNTWOOD's COUNT null and CANNOCK have a COUNT of 0? The pattern I see is that when T1_SFLD2's value appears multiple times, COUNT is 0 and when T1_SFLD's value appears only once it returns null.

(referring to the benchmark query #14 available on our web site)

SELECT 
  a.T1_SFLD2, 
  COUNT(b.T2_SFLD1) 
FROM 
  TABLE1 a 
INNER JOIN 
  TABLE2 b ON (a.T1_KEY = b.T2_KEY1) 
WHERE 
  (a.T1_KEY BETWEEN :P_START AND :P_STOP) 
GROUP BY 
  a.T1_SFLD2

Resolution

Fixed Problem on 12/14/2000 in version 2.06 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap