diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2018-03-12 20:35:38 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2018-03-14 12:45:41 +0100 |
| commit | 42529c4341ab8d4d5b2b7982baa9431ccdce6860 (patch) | |
| tree | b40ca5c6a80d2a1ef53f435beb584ad33787ad60 /mysql-test/t/check_constraint.test | |
| parent | d390e501eb812138db8963098a66d888f8adf490 (diff) | |
| download | mariadb-git-42529c4341ab8d4d5b2b7982baa9431ccdce6860.tar.gz | |
MDEV-15141 Check constraint validation on a datetime field crashes the process
add the test case (the bug was fixed in d390e501eb8)
Diffstat (limited to 'mysql-test/t/check_constraint.test')
| -rw-r--r-- | mysql-test/t/check_constraint.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/check_constraint.test b/mysql-test/t/check_constraint.test index f72ce38087e..9a77736acd7 100644 --- a/mysql-test/t/check_constraint.test +++ b/mysql-test/t/check_constraint.test @@ -103,3 +103,11 @@ insert t1 values (2); insert t1 values (NULL); select * from t1; drop table t1; + +# +# MDEV-15141 Check constraint validation on a datetime field crashes the process +# +create table t1 (id int auto_increment primary key, datecol datetime, check (datecol>'0001-01-01 00:00:00')); +insert into t1 (datecol) values (now()); +insert into t1 (datecol) values (now()); +drop table t1; |