Reported By: Robert Kaplan Reported On: 5/6/2004 For: Version 4.05 Build 1
# 1690SQL 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
ResolutionFixed Problem on 5/7/2004 in version 4.06 build 1