Aleksandar Tomic created SPARK-47286:
----------------------------------------
Summary: 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
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: [email protected]
For additional commands, e-mail: [email protected]
