Reported By: Scott Carter Reported On: 12/13/2000 For: Version 2.05 Build 1
# 685SQL 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)
TABLE2 b ON (a.T1_KEY = b.T2_KEY1)
(a.T1_KEY BETWEEN :P_START AND :P_STOP)
ResolutionFixed Problem on 12/14/2000 in version 2.06 build 1