[GitHub] [pinot] 61yao opened a new issue, #9986: [multistage] [bug] Wrong result when both left join and inequi join exist and inequi condition filter out keys

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

61yao opened a new issue, #9986:
URL: https://github.com/apache/pinot/issues/9986

   Example:
   tbl1
   numCol, strCol
   1, "a"
   2, "b"
   
   tbl2
   numCol, strCol
   1, "a"
   2, "c"
   
   
   
   Select * from tbl1 left join tbl2 on tbl1.numCol = tbl2.numCol and tbl1.strCol  != tbl2.strCol 
   
   This should produce 
   1, a, null, null, 
   2, b, 2, c 
   
   However today we produce 
   2, b, 2, c
   
   


-- 
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@pinot.apache.org.apache.org

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


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

[GitHub] [pinot] 61yao closed issue #9986: [multistage] [bug] Wrong result when both left join and inequi join exist and inequi condition filter out keys

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

61yao closed issue #9986: [multistage] [bug] Wrong result when both left join and inequi join exist and inequi condition filter out keys 
URL: https://github.com/apache/pinot/issues/9986


-- 
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@pinot.apache.org

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


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