[MDEV-14700] ALTER TABLE fails with bogus "BLOB/TEXT column '(null)' can't have a default value" - Jira

Support for default values for blobs was added in scope of ~~MDEV-10134~~. So now this works:

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (i INT);

ALTER TABLE t1 ADD COLUMN b1 BLOB NULL;

ALTER TABLE t1 ALTER COLUMN b1 SET DEFAULT NULL;

MariaDB [test]> ALTER TABLE t1 ALTER COLUMN b1 SET DEFAULT NULL;

Query OK, 0 rows affected (0.00 sec)

Records: 0  Duplicates: 0  Warnings: 0

But this does not work:

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (i INT);

ALTER TABLE t1 ADD COLUMN b2 BLOB NULL, ALTER COLUMN b2 SET DEFAULT NULL;

MariaDB [test]> ALTER TABLE t1 ADD COLUMN b2 BLOB NULL, ALTER COLUMN b2 SET DEFAULT NULL;

ERROR 1101 (42000): BLOB/TEXT column '(null)' can't have a default value

relates to

MDEV-10134 Add full support for DEFAULT

Elena Stepanova created issue - 2017-12-18 13:03

Elena Stepanova made changes - 2017-12-18 13:03

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-10134~~ [ ~~MDEV-10134~~ ]

Elena Stepanova made changes - 2021-03-04 14:45

Assignee	Michael Widenius [ monty ]	Elena Stepanova [ elenst ]
Labels		need_bisect

Sergei Golubchik made changes - 2021-12-06 21:33

Workflow

MariaDB v3 [ 84493 ]

MariaDB v4 [ 140562 ]

Elena Stepanova made changes - 2022-01-06 14:12

Elena Stepanova made changes - 2022-01-06 14:12

Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server