[#MDEV-14039] CREATE TABLE does not validate DEFAULT for BLOB/TEXT

[MDEV-14039] CREATE TABLE does not validate DEFAULT for BLOB/TEXT Created: 2017-10-10 Updated: 2022-08-04
Status:	Open
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	10.2, 10.3
Fix Version/s:	10.3

Type:

Bug

Priority:

Major

Reporter:

Alexander Barkov

Assignee:

Alexey Botchkov

Resolution:

Unresolved

Votes:

Labels:

None

Sprint:

10.2.14

Description

This query returns the "Invalid default" error as expected:

CREATE OR REPLACE TABLE t1 (a VARCHAR(255) DEFAULT REPEAT('a',500));

ERROR 1067 (42000): Invalid default value for 'a'

This query does not:

CREATE OR REPLACE TABLE t1 (a TINYTEXT DEFAULT REPEAT('a',500));

Perhaps it should.

Generated at Thu Feb 08 08:10:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.