Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-47874

Multiple bugs with map operations in combination with collations

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 4.0.0
    • None
    • SQL
    • None

    Description

      Following two queries produce different results (first succeeds, second throws an exceptions):

      select map('a', 1, 'A' collate utf8_binary_lcase, 2); -- success
select map('a' collate utf8_binary_lcase, 1, 'A', 2); -- exception

      Following query results in 1:

      select cast(map('a', 1, 'A', 2) as map<string collate utf8_binary_lcase, string>)['A' collate utf8_binary_lcase]; -- 1

      Attachments

        Activity

          People

            Unassigned Unassigned
            nikolamand-db Nikola Mandic
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: