morrySnow opened a new pull request, #69106: URL: https://github.com/apache/doris/pull/69106
### What problem does this PR solve? Issue Number: N/A Related PR: https://github.com/apache/doris/pull/67886 Problem Summary: UNION ALL could infer false output equalities from reordered child columns or contradictory constant rows, allowing downstream rewrites to discard required ordering keys. Share logical and physical union derivation, use explicit output mappings, and require every constant row to preserve the equality. ### Release note Fix incorrect UNION ALL equality inference and dependent query results. ### Backport validation - Test: Unit Test: EqualSetTest, EliminateOrderByKeyTest, PushProjectThroughUnionTest; FE Checkstyle (0 violations). - Combined eight-backport validation: 283 tests across 13 classes, 0 failures/errors after correcting identity-cast assertions. This standalone backport has not had a separate unit-test run. - Regression tests were not run: no isolated branch-4.2 cluster was deployed. - Full build.sh --fe packaging was blocked by incomplete native third-party dependencies; the prescribed FE unit-test entry point compiled FE sources. - Behavior changed: Yes (only equalities valid for every union row are propagated) - Does this need documentation: No (cherry picked from commit 1271f00190d8ab7881adde1fdc78519fc5cb9ff3) ### Scope This is an independent backport of #67886 onto branch-4.2. The branch contains one commit and does not include the other seven picks. The 283-test result above was obtained from the combined backport tree; this standalone branch has not had a separate unit-test run. ### Check List (For Author) - Test: - [x] Unit Test: 283 targeted tests passed on the combined backport tree. - [x] Manual test: standalone patch matches the validated pick; FE Checkstyle passed on the combined tree. - [ ] Regression test: no isolated branch-4.2 cluster was deployed. - Behavior changed: see the backport validation details above. - Does this need documentation: 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]
