[GitHub] [doris] Gabriel39 opened a new issue, #11314: [Bug] Wrong types for outer join

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

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

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   master
   
   ### What's Wrong?
   
   For outer join, output block will be produced according to intermediate tuple so we must keep types in intermediate tuple are consistent to build/probe side output tuples. But in some cases it's not consistent so could cause a potential core dump.
   
   Specifically, for a right outer join with right key is datetime and left key is string. The expression tree for right key is
   `Cast(type = datetime, child = TupleIsNull(type=BigInt, children = [NullLiteral, Cast(type = BigInt, child = SlotRef(type = datetime))]))`.
   
   But now when we try to compute intermediate tuple, this expression is substituted in a wrong way and get a final expression is `TupleIsNull(type=BigInt, children = [NullLiteral, Cast(type = BigInt, child = SlotRef(type = datetime))])`. So we got a wrong type `BigInt` in this case.
   
   ### What You Expected?
   
   fix
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] 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: commits-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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

[GitHub] [doris] yiguolei closed issue #11314: [Bug] Wrong types in outer join

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

yiguolei closed issue #11314: [Bug] Wrong types in outer join
URL: https://github.com/apache/doris/issues/11314


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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