Icon View Incident Report

Serious Serious
Reported By: Robert Kaplan
Reported On: 5/6/2004
For: Version 4.05 Build 1
# 1690 SQL UNION and UNION ALL Operators Resulting in Incorrect Results

There is a bug in UNION (and UNION ALL) that results in the incorrect records being added to the result set.

select test_id, count(*) cnt1 into memory\tmp from bugunion group by test_id
union all
select test_id, count(*) from bugunion group by test_id;
select * from memory\tmp

Resolution Resolution
Fixed Problem on 5/7/2004 in version 4.06 build 1