[SPARK-29103] CheckAnalysis for data source V2 ALTER TABLE ignores case sensitivity

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Duplicate
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Jose Torres
• Created: 16/Sep/19 22:47
• Updated: 12/Dec/22 18:10
• Resolved: 19/Feb/20 07:57

Description

For each column referenced, we run

```val field = table.schema.findNestedField(fieldName, includeCollections = true)```

and fail analysis if the field isn't there. This check is always case-sensitive on column names, even if the underlying catalog is case insensitive, so it will sometimes throw on ALTER operations which the catalog supports.

Issue Links

• duplicates: SPARK-30615 normalize the column name in AlterTable