Subject Re: [firebird-support] 'when' conditions limits in case expression
Author Thomas Steinmaurer
> Can someone tell me if there is a limit about the amount of 'when' conditions in a case expressions, like in the 'in' statement?

I haven't tried. ;-)

One limit you have for sure is ~64K for the CREATE DDL statement and
AFAIK ~48K for the compiled BLR.

Is your question theoretical for some kind of case study or DBMS
comparison thingy or did you hit a limit already? Just curious. ;-)

With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist