[SPARK-42681] Relax ordering constraint for ALTER TABLE ADD|REPLACE column options

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.5.0
• Fix Version/s: 3.5.0
• Component/s: SQL
• Assignee: Vitalii Li
• Reporter: Vitalii Li
• Created: 06/Mar/23 08:36
• Updated: 08/Mar/23 04:04
• Resolved: 08/Mar/23 04:04

Description

Currently the grammar for ALTER TABLE ADD|REPLACE column is:

qualifiedColTypeWithPosition
: name=multipartIdentifier dataType (NOT NULL)? defaultExpression? commentSpec? colPosition?
;

This enforces a constraint on the order of: (NOT NULL, DEFAULT value, COMMENT value FIRST|AFTER value). We can update the grammar to allow these options in any order instead, to improve usability.

Issue Links

• links to: [Github] Pull Request #40295 (vitaliili-db)