Subject Re: [firebird-support] limit to number of OR conditions in a where clause
Author Bart Smissaert
Ah, yes, didn't think of that.
Any idea roughly how many characters that will be?

RBS


On Mon, Jul 16, 2012 at 2:37 PM, Thomas Steinmaurer <ts@...>wrote:

> **
>
>
> > Firebird 1.5 classic on Windows.
> > Is there a limit to the number of OR conditions you can put in a where
> clause?
> > It looks there is as I get unexpected end of command when there are
> > some 2000 ors, but
> > maybe that is due limitations of the control holding the SQL. I found
> > some 150 ors is still fine.
>
> Perhaps you hit the limit of a single SQL statement text, which is ~64KB.
>
> --
> With regards,
> Thomas Steinmaurer
> http://www.upscene.com/
>
>
>


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