diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2021-04-21 07:58:42 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2021-04-21 07:58:42 +0300 |
| commit | a0588d54a20488b17a178244989e1abc5151a88a (patch) | |
| tree | 7de7ef6bd7153479ee397006dd71eab7599b43f8 /mysql-test/main/alter_table.test | |
| parent | 031f11717d9f351dfb12cd27c225c533e289261a (diff) | |
| parent | 75c01f39b1b4a6d27d36d075f8baab9bdda7cc7e (diff) | |
| download | mariadb-git-a0588d54a20488b17a178244989e1abc5151a88a.tar.gz | |
Merge 10.3 into 10.4
Diffstat (limited to 'mysql-test/main/alter_table.test')
| -rw-r--r-- | mysql-test/main/alter_table.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/main/alter_table.test b/mysql-test/main/alter_table.test index ce461b2fe46..fa931fcadbf 100644 --- a/mysql-test/main/alter_table.test +++ b/mysql-test/main/alter_table.test @@ -2051,6 +2051,18 @@ ALTER TABLE t1 ALTER COLUMN k1 SET DEFAULT (SELECT 1 FROM t2 limit 1); DROP TABLE t1,t2; --echo # +--echo # MDEV-25403 ALTER TABLE wrongly checks for field's default value if AFTER is used +--echo # +create table t1(t int, d date not null); +insert into t1 values (1,'2001-1-1'); +set sql_mode = "no_zero_date"; +alter table t1 change d d date not null after t, add i int; +show create table t1; +--error ER_TRUNCATED_WRONG_VALUE +alter table t1 add x date not null; +drop table t1; + +--echo # --echo # End of 10.2 tests --echo # |