[
https://issues.apache.org/jira/browse/SPARK-43753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17732012#comment-17732012
]
Jia Fan commented on SPARK-43753:
---------------------------------
Seem already fixed on the master branch.
> 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: 2.4.8, 3.0.3, 3.1.3
> Reporter: Kernel Force
> Priority: Major
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
