EmmyMiao87 opened a new pull request #1758: Bug-fix: error result of union stmt URL: https://github.com/apache/incubator-doris/pull/1758 ISSUES-1725: The result of union stmt whose child is outer join stmt is incorrect. Example: sql: (select k1 from empty) union all (select b.k1 k1 from left_table a left join empty b on a.k2 = b.k2); context: the empty table has no data. error result: 0 expect result: null Reason: The judgment (columns k1 who belongs to union tuple is nullable ) is incorrect. It could not be determined by slot attribute of children when the slot is produced by the outer join. The slot A is not nullable while the result of outer join is nullable which is same as slot A. So, the judgment needs to consider if the slot is come from the outer join.
---------------------------------------------------------------- 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: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
