[GitHub] [incubator-doris] yuanlihan commented on issue #2175: BE frequently crashing

[GitBox <gi...@apache.org>]

yuanlihan commented on issue #2175: BE frequently crashing
URL: https://github.com/apache/incubator-doris/issues/2175#issuecomment-552405233
 
 
   Found that BE crash by 'invalid' _**case when**_ clause (user write this clause with unexpected quote)
   `case when date(from_unixtime(SUBSTRING(CAST(f.dc_receive_time AS VARCHAR(50)), 11, 999))<>'1970-01-01')`
   while the following clause can be successfully processed by Doris:
   `case when date(from_unixtime(SUBSTRING(CAST(f.dc_receive_time AS VARCHAR(50)), 11, 999)))<>'1970-01-01'`
   
   As known that the _**case when**_ clause follow with _search_condition_:
   ```
   CASE
       WHEN search_condition THEN statement_list
       [WHEN search_condition THEN statement_list] ...
       [ELSE statement_list]
   END CASE
   ```
   Can we check whether the _search_condition_ is applicable at frontend?
   
   Or can BE evaluate with null value(or interrupt processing gracefully) when function of Doris applied with incompatible parameters?
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org