Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-08-2026 11:55 PM - edited 03-09-2026 12:05 AM
Hi @SteveOstrowski
Thanks for replying. I have few doubts. Could you help me clarify the same?
- You said, "..., the schema evolution logic detects that both NEST_COL and nest_col would resolve to the same column, which triggers the conflict error.".
- Could you explain why this results in an error? Because column names should be case insensitive and the names 'Nest_col', 'NEST_COL', 'NeSt_CoL', 'nest_col' should all point to the same column.
- You said, "... SET clause says NEST_COL = source.NEST_COL but the source view actually has nest_col (lowercase), the engine sees these as potentially two separate columns that would collide"
- Shouldn't the source treat them as same? Isn't that what case-insensitive should be about?
- Also, I may be misunderstanding. But your two statements seem to be conflicting with each other.