[jira] [Created] (SPARK-32856) Prohibit binary comparisons chain

["Yuming Wang (Jira)" <ji...@apache.org>]

Yuming Wang created SPARK-32856:
-----------------------------------

             Summary: Prohibit binary comparisons chain
                 Key: SPARK-32856
                 URL: https://issues.apache.org/jira/browse/SPARK-32856
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 3.1.0
            Reporter: Yuming Wang


{code:scala}
spark.range(10).selectExpr("id as a", "id as b", "id as c").createTempView("t1")
spark.range(10).selectExpr("id as a", "id as b", "id as c").createTempView("t2")
spark.sql("select * from t1 join t2 on t1.a = t2.a = t1.b = t2.b").explain()
{code}

{noformat}
== Physical Plan ==
BroadcastNestedLoopJoin BuildRight, Inner, (cast((cast((a#2704L = a#2712L) as bigint) = b#2705L) as bigint) = b#2713L)
:- *(1) Project [id#2702L AS a#2704L, id#2702L AS b#2705L, id#2702L AS c#2706L]
:  +- *(1) Range (0, 10, step=1, splits=2)
+- BroadcastExchange IdentityBroadcastMode, [id=#207]
   +- *(2) Project [id#2710L AS a#2712L, id#2710L AS b#2713L, id#2710L AS c#2714L]
      +- *(2) Range (0, 10, step=1, splits=2)
{noformat}


{noformat}
postgres=# create table t1(a int, b int, c int);
CREATE TABLE
postgres=# select * from t1 where a = b =c;
ERROR:  syntax error at or near "="
LINE 1: select * from t1 where a = b =c;
                                     ^
{noformat}





--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org