Kernel Force created SPARK-43753: ------------------------------------ Summary: Incorrect result of MINUS in spark sql. Key: SPARK-43753 URL: https://issues.apache.org/jira/browse/SPARK-43753 Project: Spark Issue Type: Bug Components: SQL Affects Versions: 3.1.3, 3.0.3, 2.4.8 Reporter: Kernel Force
sql(""" with va as ( select '123' id, 'a' name union all select '123' id, 'b' name ) select '123' id, 'a' name from va t where t.name = 'a' minus select '123' id, 'a' name from va s where s.name = 'b' """).show +---+----+ | id|name| +---+----+ |123| a| +---+----+ which is expected to be empty result set. -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org