doris2.0.4版本,使用case...when语句时,语句中的column=''语法报错执行sql异常errCode = 2, detailMessage = Unexpected exception: null

Viewed 26

sql语句:select sum(case when (ID is null or ID = '') then 1 else 0 end) as num from (select * from TABLE_AAA) tt

报错:sql异常errCode = 2, detailMessage = Unexpected exception: null

使用explain也报错!
企业微信截图_17301057369310.png

2 Answers

show variables like "%ner%"; 看下:
experimental_enable_nereids_planner是true还是false。

打开关闭分别测试下的

2.0的哪个版本呢,走的什么优化器,explain $SQL 看下的