[SPARK-40944] Relax ordering constraint for CREATE TABLE column options

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: SQL
• Assignee: Daniel
• Reporter: Daniel
• Created: 27/Oct/22 22:32
• Updated: 31/Oct/22 23:57
• Resolved: 31/Oct/22 23:57

Description

Currently the grammar for each CREATE TABLE column is:

createOrReplaceTableColType
: colName=errorCapturingIdentifier dataType (NOT NULL)? defaultExpression? commentSpec?
;

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

Issue Links

• links to: [Github] Pull Request #38418 (dtenedor)