Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2026 07:05 AM
Thanks for replying. I got the process of how databricks processes the schema evolution command internally. It helps a lot.
As you mentioned there are 2 steps. First, is the explicit set statement which I wrote. This statement is processed case-insensitively, right? Because in SET clause i can write 'NEST_COL', 'NesT_Col' or any other casing and it would still point to the same column. I have some doubts then.
- Shouldn't the second step also follow case-insensitivity then? During second step when looking at source schema to determine if any source columns should be added to target, shouldn't the comparison be case-insensitive? The end user only writes the 'set' clause which is step 1 and is case-insensitive
- Also, considering the broader picture, since the query is supposed to be case-insensitive, shouldn't any sub-implementations take into consideration that the query is case-insensitive?