yinzhijian opened a new issue, #10674: URL: https://github.com/apache/doris/issues/10674
### 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? summary: Join reorder will make the dependencies out of order, resulting in non-existent columns in reanalyzing. for example： ```SQL select * from t1 inner join t2 on t1.a = t2.b inner join t3 on t3.c = t2.b; ``` The table size relationship is t3>t2>t1, and the problem that t2.b does not exist will occur in reanalyzing. The reason is that the dependency check in ReorderTable only needs to satisfy one of the predicates involved regardless of its order, for example, when checking t2, which involves t3.c = t2.b and t1.a = t2.b, the order of [t3,t2] can satisfy t3.c = t2.b, so that the order of [t3,t2,t1] can be checked through ### What You Expected? fix this ### How to Reproduce? see https://github.com/apache/doris/pull/10670 testDefaultJoinReorderWithView ### 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: [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]
