morrySnow opened a new pull request, #10519: URL: https://github.com/apache/doris/pull/10519
# Proposed changes This PR fix a bug in predicate inference. The original predicate inference compare two slot without SlotId. This will arise an error when a query has SetOperand and more than one SetOperand's child use same table alias. e.g. ``` select * from tb1 inner join tb2 on tb1.k1 = tb2.k1 union select * from tb1 inner join tb2 on tb1.k2 = tb2.k2 where tb1.k1 = 3; ``` in this case, we infer a predicate `tb2.k1 = 3` on table 'tbl2' of SetOperand's second child by mistake. ## Problem Summary: Issue Number: close #10489 ## Checklist(Required) 1. Does it affect the original behavior: Yes 2. Has unit tests been added: Yes 3. Has document been added or modified: No Need 4. Does it need to update dependencies: No 5. Are there any changes that cannot be rolled back: No -- 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]
