A Long case statement with 1740 cases that used to work on SQL2005 and SQL2008, now fails with :
Msg 8631, Level 17, State 1, Line 7
Internal error: Server stack limit has been reached. Please look for potentially deep nesting in your query, and try to simplify it.
The case has the form:
declare @EnumString varchar(200) = 'string1'
when 'string1' then 1000000
when 'string2' then 1000001
when 'string3' then 1000002
when 'string4' then 1000003
Is there any chance that this will be fixed before RTM or is this a new limitation to case statements or the number of literals?