Icon View Incident Report

Serious Serious
Reported By: Norbert Liew
Reported On: 10/29/2001
For: Version 3.03 Build 1
# 951 NULL 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



Resolution Resolution
Fixed Problem on 11/4/2001 in version 3.04 build 1
Image