Reported By: Norbert Liew Reported On: 10/29/2001 For: Version 3.03 Build 1
# 951NULL Values in Records Causing Invalid SQL COUNT Aggregate Values to be Returned Considering the below table entries, if I do the following SQL it will produce incorrect results.
This I suppose is a bug in V3.03.
Table values
NAME(string) TRANSPORT(string)
A CAR
B CAR
C TRUCK
D TRUCK
E
F
G
E,F,G - Blank entries.
SQL to demonstrate problem
select transport,count(transport)
from DBISAMTable1 group by transport
ResolutionFixed Problem on 11/4/2001 in version 3.04 build 1