SQL query includes the condition like below ends with error.

e.g. )
where ID in ('000001','000002,'...'000800')

Boundary values seems to depend on other conditions, etc.
But it is obviously smaller than the range available.

--- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@...> wrote:
>
> 06.02.2014 10:08, hosodaamiya wrote:
> >
> > SQL query aborts when SQL statement is too long or complex.
> > Firebird seems to fail to handle the error of complecated SQL statement
> > when an error occurs at fbembedde.dll.
> > SQL query that includes IN operator with multiple columns and
> > OR conditons have been aborted in our development environment.
>
> How many conditions are combined by OR/IN?
>
> > What is the cause of forced termination?
>
> I bet the reason is not enough stack space configured for your application.
>
>
> Dmitry
>