Subject Re: [firebird-support] limit to number of OR conditions in a where clause
Author Thomas Steinmaurer
> 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