Subject Re: Fwd: SQL error in the NOT IN operator => bug ?
Author Adam
--- In firebird-support@yahoogroups.com, "João Luiz de Souza Torres"
<joaoluiz.unifar@...> wrote:
>
> ---------- Forwarded message ----------
> From: João Luiz de Souza Torres <joaoluiz.unifar@...>
> Date: 01/04/2006 09:14
> Subject: SQL error in the NOT IN operator => bug ?
> To: firebird-support@yahoogroups.com, ib_sql@...
>
> Dear Sirs,
>
> We are a problem in our system using "Firebird 1.5.3.4870".
> We are thinking about a "SQL Bug" in the Firebird.
> We ask for your help for testing. The SQL and the metadata are below.

Save us all a bit of time and provide details of the 'bug'. You have
not said whether it does not execute, or whether it is giving you an
error, or if it is returning the 'wrong' results. If it is giving you
an error, provide the exact error message you are receiving.

On a 10 second check of the query it seems to have acceptable syntax.

Adam