dolt icon indicating copy to clipboard operation
dolt copied to clipboard

Add support for altering table comments

Open angelamayxie opened this issue 7 months ago • 2 comments

Dolt currently does not support altering table comments. Altering table comments is supported in MySQL (docs).

tmp/main*> create table t1 (i int);
tmp/main*> alter table t1 comment = "new comment";
tmp/main*> show create table t1;
+-------+------------------------------------------------------------------+
| Table | Create Table                                                     |
+-------+------------------------------------------------------------------+
| t1    | CREATE TABLE `t1` (                                              |
|       |   `i` int                                                        |
|       | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin |
+-------+------------------------------------------------------------------+
1 row in set (0.00 sec) 

angelamayxie avatar May 29 '25 23:05 angelamayxie

I would like to try it

aaryansinhaa avatar May 31 '25 20:05 aaryansinhaa

The changes will likely be made in dolthub/go-mysql-server

angelamayxie avatar May 31 '25 22:05 angelamayxie

Looks like none of the table options are currently supported. We will need to make changes to vitess too

angelamayxie avatar Jul 30 '25 16:07 angelamayxie