[GitHub] [doris] yinzhijian opened a new issue, #10674: [Bug] join reorder may cause column non-existence problem

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

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: commits-unsubscribe@doris.apache.org.apache.org

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


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

[GitHub] [doris] morningman closed issue #10674: [Bug] join reorder may cause column non-existence problem

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

morningman closed issue #10674: [Bug] join reorder may cause column non-existence problem
URL: https://github.com/apache/doris/issues/10674


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

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


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