Isn't 'used to return' slightly exaggerated? I thought it was only the NULL handling that was incorrect and that Firebird 1.5 got it right if NULLs weren't involved. I'm asking because I never used NOT IN (<subselect>) and don't quite remember whether this was the case or not.

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Dimitry Sibiryakov
Sent: 22. april 2009 16:49
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] FB 1.5 vs. 2.0 optimizer difference

> FB 1.5 takes 0.047 seconds to run and FB 2.0 takes 21 minutes to run.
> It does return the exact same data.

You are lucky because FB1.5 used to return wrong data for NOT IN
predicate.

SY, SD.