Query Error When Use Like in Where Clause

[汪胜]

Hello，
I execute a sql below:


select PRODUCT_LOOKUP.PRODUCT_NAME,SUM(SALES_FACT.STORE_SALES) from SALES_FACT 
inner join PRODUCT_LOOKUP on PRODUCT_LOOKUP.PRODUCT_ID=SALES_FACT.PRODUCT_ID 
where PRODUCT_LOOKUP.PRODUCT_NAME like '%' || 'Label' || '%'
group by PRODUCT_LOOKUP.PRODUCT_NAME


And this is result:


Error while executing SQL "select 
PRODUCT_LOOKUP.PRODUCT_NAME,SUM(SALES_FACT.STORE_SALES) from SALES_FACT inner 
join PRODUCT_LOOKUP on PRODUCT_LOOKUP.PRODUCT_ID=SALES_FACT.PRODUCT_ID where 
PRODUCT_LOOKUP.PRODUCT_NAME like '%' || 'Label' || '%' group by 
PRODUCT_LOOKUP.PRODUCT_NAME LIMIT 50000": null


I found there is a bug when I used "like '%' || 'Label' || '%'" in sql 
sentence. But when I changed filter into "like '%Label%'", the result is 
correct. 
Kylin generated "BuildInFunctionTupleFilter" for  " like '%' || 'Label' || '%' 
", and thus got a null column, and finally errored when used this null column 
to get dict.