Nikola Mandic created SPARK-47874:
-------------------------------------
Summary: Multiple bugs with map operations in combination with
collations
Key: SPARK-47874
URL: https://issues.apache.org/jira/browse/SPARK-47874
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 4.0.0
Reporter: Nikola Mandic
Following two queries produce different results (first succeeds, second throws
an exceptions):
{code:java}
select map('a', 1, 'A' collate utf8_binary_lcase, 2); -- success
select map('a' collate utf8_binary_lcase, 1, 'A', 2); -- exception{code}
Following query results in 1:
{code:java}
select cast(map('a', 1, 'A', 2) as map<string collate utf8_binary_lcase,
string>)['A' collate utf8_binary_lcase]; -- 1{code}
--
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
