create alias function fn_get_isdate2(varchar) with PARAMETER(pstr) As
if (DATE_FORMAT(SUBSTR(replace(replace(replace(pstr,'-',''),'/',''),'.',''),1,8),'yyyy-MM-dd')is not null,"true","false");
doris版本:2.0.5, 请问这个是一个bug还是不支持这种写法了
create alias function fn_get_isdate2(varchar) with PARAMETER(pstr) As
if (DATE_FORMAT(SUBSTR(replace(replace(replace(pstr,'-',''),'/',''),'.',''),1,8),'yyyy-MM-dd')is not null,"true","false");
doris版本:2.0.5, 请问这个是一个bug还是不支持这种写法了
我简单验证了下,别名函数目前不支持 if 这种条件判断语句,可以用ifnull 函数试试看是否满足场景
https://doris.apache.org/zh-CN/docs/dev/sql-manual/sql-functions/conditional-functions/ifnull?_highlight=if