SQL query planner crash when subquery combined with limit and case when

[linehrr]

Affected Version

27.0.0

Description

we have a table like this:

then we issue this query against version 27.0.0 druid:

query failed due to

however the same query runs fine against druid version 0.22.1.

also if we remove the inner limit it also runs ok.
if we remove the case when it works.
if we remove the COALESCE it works.

more strangely, if we replace the actual table with dummy select, it also works !