[ https://issues.apache.org/jira/browse/SPARK-47286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aleksandar Tomic resolved SPARK-47286. -------------------------------------- Fix Version/s: 4.0.0 Target Version/s: 4.0.0 Resolution: Fixed > IN operator support > ------------------- > > Key: SPARK-47286 > URL: https://issues.apache.org/jira/browse/SPARK-47286 > Project: Spark > Issue Type: Bug > Components: Spark Core > Affects Versions: 4.0.0 > Reporter: Aleksandar Tomic > Priority: Major > Fix For: 4.0.0 > > > At this point following query works fine: > ``` > sql("select * from t1 where ucs_basic_lcase in ('aaa' collate > 'ucs_basic_lcase', 'bbb' collate 'ucs_basic_lcase')").show() > ``` > But if we were to miss explicit collate or even mix collations: > ``` > sql("select * from t1 where ucs_basic_lcase in ('aaa' collate > 'ucs_basic_lcase', 'bbb'").show() > ``` > Query would still run and return invalid results. -- 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