|Subject||Re: [firebird-support] 'when' conditions limits in case expression|
> 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. ;-)
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist