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

2023-03-07 Thread Gengliang Wang (Jira)


 [ 
https://issues.apache.org/jira/browse/SPARK-42681?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Gengliang Wang reassigned SPARK-42681:
--

Assignee: Vitalii Li

> Relax ordering constraint for ALTER TABLE ADD|REPLACE column options
> 
>
> Key: SPARK-42681
> URL: https://issues.apache.org/jira/browse/SPARK-42681
> Project: Spark
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 3.5.0
>Reporter: Vitalii Li
>Assignee: Vitalii Li
>Priority: Major
> Fix For: 3.5.0
>
>
> 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.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org



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

2023-03-06 Thread Apache Spark (Jira)


 [ 
https://issues.apache.org/jira/browse/SPARK-42681?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Apache Spark reassigned SPARK-42681:


Assignee: Apache Spark

> Relax ordering constraint for ALTER TABLE ADD|REPLACE column options
> 
>
> Key: SPARK-42681
> URL: https://issues.apache.org/jira/browse/SPARK-42681
> Project: Spark
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 3.5.0
>Reporter: Vitalii Li
>Assignee: Apache Spark
>Priority: Major
> Fix For: 3.5.0
>
>
> 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.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org



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

2023-03-06 Thread Apache Spark (Jira)


 [ 
https://issues.apache.org/jira/browse/SPARK-42681?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Apache Spark reassigned SPARK-42681:


Assignee: (was: Apache Spark)

> Relax ordering constraint for ALTER TABLE ADD|REPLACE column options
> 
>
> Key: SPARK-42681
> URL: https://issues.apache.org/jira/browse/SPARK-42681
> Project: Spark
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 3.5.0
>Reporter: Vitalii Li
>Priority: Major
> Fix For: 3.5.0
>
>
> 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.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org