wangyum commented on issue #27874: [WIP][SPARK-31114][SQL] Constraints inferred from equality constraints with cast URL: https://github.com/apache/spark/pull/27874#issuecomment-599045928 I closed it because this change cannot handle this case: ```scala spark.sql("create table T1(a string)") spark.sql("create table T2(b string)") spark.sql("create table T3(c bigint)") spark.sql("create table T4(d bigint)") spark.sql( """ |SELECT t1.a, t2.b, t4.d |FROM T1 t1 JOIN T2 t2 | ON (t1.a = t2.b) | JOIN T3 t3 | ON (t1.a = t3.c) | JOIN T4 t4 | ON (t3.c = t4.d) |""".stripMargin).explain() ```
---------------------------------------------------------------- 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]
