[#MDEV-9878] Awkward syntax for altering the column comments

[MDEV-9878] Awkward syntax for altering the column comments Created: 2016-04-06 Updated: 2016-04-07
Status:	Open
Project:	MariaDB Server
Component/s:	Data Definition - Alter Table
Fix Version/s:	None

Type:

Task

Priority:

Major

Reporter:

Bala

Assignee:

Unassigned

Resolution:

Unresolved

Votes:

Labels:

None

Issue Links:

Relates
relates to	~~MDEV-9168~~	altering a column comment does a full...	Closed

Description

Current syntax for altering the column comment is highly error prone, since you need to re-declare the data type.

It would be nice to have below:

ALTER TABLE 'myTable' ALTER COLUMN `myField` ADD COMMENT 'a comment'

Instead of:

ALTER TABLE `myTable` CHANGE `myField` `myField` varchar(20) NOT NULL COMMENT 'my comment'

Generated at Thu Feb 08 07:38:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.