[SPARK-48294] Make nestedTypeMissingElementTypeError case insensitive

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.5.0, 4.0.0, 3.5.1, 3.5.2
• Fix Version/s: 3.5.2
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Michael Zhang
• Reporter: Michael Zhang
• Created: 15/May/24 19:44
• Updated: 17/May/24 22:17
• Resolved: 17/May/24 22:17

Description

When incorrectly declaring a complex data type using nested types (ARRAY, MAP and STRUCT), the query fails with a match error rather than `INCOMPLETE_TYPE_DEFINITION`. This is because the match is case sensitive,

Issue Links

• links to: GitHub Pull Request #46623
• links to: GitHub Pull Request #46643