panyanye opened a new issue, #33895:
URL: https://github.com/apache/doris/issues/33895

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no 
similar issues.
   
   
   ### Version
   
   branch-2.0 (doris-2.0.7-dc065ead16)
   
   ### What's Wrong?
   
   SELECT SQL with round funcrion leads to BE crash, because of 
NullPointerException.
   
   The crash stack as follows:
   
![image](https://github.com/apache/doris/assets/57991859/ad8c9d5e-6208-478b-b437-859710e04440)
   
   It looks like in file typeid_cast.h the function " To typeid_cast(From* 
from) " return null point.
   
   ### What You Expected?
   
   be work normal not crash
   
   ### How to Reproduce?
   
   create table test(big_key bigint)
   DISTRIBUTED BY HASH(big_key) BUCKETS 1 PROPERTIES ("replication_num" = "1");
   
   select 1 from test e1
   having truncate(100,2)<-2308.57
   and cast(round(round(465.56,min(-5.987)),2) as DECIMAL) in (
   select cast(truncate(round(8990.65-4556.2354,2.4652),2)as DECIMAL)
   from test r2);
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to