Mark,

Thank you very much for your advice and support ! The bug described
in CORE-3211 is exactly the one I found and it was resolved in version 2.5.1

On the other hand I will try to get in touch with the package
maintainer in Debian 6.0 in order to ask him to upload the 2.5.1
version, or at least the 2.5.0 final version. I then mean time, I will
replace IN with EXISTS, following your advice.

Thanks again,
Aldo

El 26/02/12 05:46, Mark Rotteveel escribió:

>
> On 25-2-2012 20:11, Aldo Caruso wrote:
> > Mark,
> >
> > I really don't know why, in the Debian stable version, the Firebird
> > SS package isn't the final one but a Release Candidate.
> > On the other hand, your advice worked fine, although I don't figure
> > why.
> > In this context, an EXIST clause is more efficient than a IN
> > clause, but both should be equivalent.
> > Nevertheless, your advice worked.
>
> IN and EXISTS have an equivalent result (if used in the right way), but
> in implementation they are not the same. My advice btw came straight
> from CORE-3211 :)
>
> Mark
> --
> Mark Rotteveel
>
>

[Non-text portions of this message have been removed]