Hi. Dmitry.

I'm sorry reply away late.

> i.e. 800 constants? And no other conditions in the WHERE clause?

Around 800 constants as you guess.
But the boundary value increases and decreases depends on the conditon.
The boundary value is not clear because it is differnt for each conditions.
The other filtering conditions is at most 10.

> What do you mean by available range? Documented 1500 items limit or
> something else?

I meant documented 1500 items limit.
I create the WHERE clause with less than 1000 constants.
But 1000 or less constants makes the query execution unsuccessful.
My script cannot handle the error.
The error in windows event log that I have meant before is recorded instead.

--- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@...> wrote:
>
> 06.02.2014 12:38, hosodaamiya wrote:
>
> > SQL query includes the condition like below ends with error.
> >
> > e.g. )
> > where ID in ('000001','000002,'...'000800')
>
> i.e. 800 constants? And no other conditions in the WHERE clause?
>
> > Boundary values seems to depend on other conditions, etc.
> > But it is obviously smaller than the range available.
>
> What do you mean by available range? Documented 1500 items limit or
> something else?
>
>
> Dmitry
>