Icon View Incident Report

Serious Serious
Reported By: Fernando Monteiro
Reported On: 3/15/2002
For: Version 3.07 Build 1
# 1061 SQL COUNT(*) Returning Incorrect Results when First Column in Source Table is NULL

If I run:

select count(*) from problem where estado = 'CE'

gives a result of 1 and if I run:

select estado, count(*) from problem group by estado

it gives a result of 0 for the 'CE' line. I have tried a lot of different ways to build the second query (the first one is the correct result) and no one have worked. I made some changes on the table structure (add index, remove index, remove primary key, compress indexes, case insensitive/sensitive) and the only one that works was when I deleted the other fields on the table leaving only the group by field.


Comments Comments
Internally DBISAM was looking at the first field for determining whether to count the row or not when it shouldn't have been.


Resolution Resolution
Fixed Problem on 3/15/2002 in version 3.08 build 1
Image