[jira] [Updated] (SPARK-25056) Unify the InConversion and BinaryComparison behaviour when InConversion's list only contains one datatype

["Dongjoon Hyun (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SPARK-25056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dongjoon Hyun updated SPARK-25056:
----------------------------------
    Affects Version/s:     (was: 3.0.0)
                       3.1.0

> Unify the InConversion and BinaryComparison behaviour when InConversion's list only contains one datatype
> ---------------------------------------------------------------------------------------------------------
>
>                 Key: SPARK-25056
>                 URL: https://issues.apache.org/jira/browse/SPARK-25056
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 3.1.0
>            Reporter: Yuming Wang
>            Priority: Major
>
> {code:java}
> scala> val df = spark.range(4).toDF().selectExpr("cast(id as decimal(9, 2)) as id")
> df: org.apache.spark.sql.DataFrame = [id: decimal(9,2)]
> scala> df.filter("id in('1', '3')").show
> +---+
> | id|
> +---+
> +---+
> scala> df.filter("id = '1' or id ='3'").show
> +----+
> |  id|
> +----+
> |1.00|
> |3.00|
> +----+
> {code}



--
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