--- In firebird-support@yahoogroups.com, "Dmitry Yemanov" <dimitr@...>
wrote:

>
> "Graeme Edwards" <g.edwards@...> wrote:
> >
> > It appears to me that if I now attempt to run a query with a not

in clause

>
> It's a bugfix, actually. NOT IN and ALL don't use indices anymore,

as it may

> cause wrong results in some cases (we had three related bugreports).

But as

> subqueries still executed per every master row, you'll have a very long
> execution time. Sad but true.
>
> A workaround is to use a left outer join with IS NULL clause in the

WHERE

> section.
>
>
> Dmitry
>

Hi Dmitry,

Can the wrong results also occur under FB 1.5?

Adam