Firebird 1.5 latest build.
Tested on Windows Me or Windows 2000 pro
this update :
update contacts_guest cg set
cg.frequency = (select count(md.record_no)
from master_detail md
where md.contact_code = cg.contact_code and
md.reservation_type in (9, 16)) ^
will create this error :
VP_MINGUS (Client) Wed Mar 03 10:42:49 2004
C:\PROGRAM FILES\FIREBIRD\FIREBIRD_1_5\bin\fbserver.exe: terminated
abnormally (3221225477)

This select will create the same problem :
select md.contact_code, count(md.record_no)
from master_detail md
where md.reservation_type in (9, 16)
group by md.contact_code^