[jira] [Resolved] (SPARK-47210) Addition of implicit casting without indeterminate support

["Wenchen Fan (Jira)" <ji...@apache.org>]

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

Wenchen Fan resolved SPARK-47210.
---------------------------------
    Fix Version/s: 4.0.0
       Resolution: Fixed

Issue resolved by pull request 45383
[https://github.com/apache/spark/pull/45383]

> Addition of implicit casting without indeterminate support
> ----------------------------------------------------------
>
>                 Key: SPARK-47210
>                 URL: https://issues.apache.org/jira/browse/SPARK-47210
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 4.0.0
>            Reporter: Mihailo Milosevic
>            Assignee: Mihailo Milosevic
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 4.0.0
>
>
> *What changes were proposed in this pull request?*
> This PR adds automatic casting and collations resolution as per `PGSQL` behaviour:
> 1. Collations set on the metadata level are implicit
> 2. Collations set using the `COLLATE` expression are explicit
> 3. When there is a combination of expressions of multiple collations the output will be:
>  - if there are explicit collations and all of them are equal then that collation will be the output
>  - if there are multiple different explicit collations `COLLATION_MISMATCH.EXPLICIT` will be thrown
>  - if there are no explicit collations and only a single type of non default collation, that one will be used
>  - if there are no explicit collations and multiple non-default implicit ones `COLLATION_MISMATCH.IMPLICIT` will be thrown
> *Why are the changes needed?*
> We need to be able to compare columns and values with different collations and set a way of explicitly changing the collation we want to use.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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