diff options
author | Sergei Golubchik <serg@mariadb.org> | 2022-04-16 11:40:15 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2022-04-19 17:10:05 +0200 |
commit | a59f483c06b12e606747da3f864ed94615f038c0 (patch) | |
tree | 919796c30989e9c1fc10d413fe96f3ef65a246ef | |
parent | 5aef0123a707415c56ffae48fc872e7d3ad292d2 (diff) | |
download | mariadb-git-a59f483c06b12e606747da3f864ed94615f038c0.tar.gz |
MDEV-28092 MariaDB SEGV issue
add test
-rw-r--r-- | mysql-test/suite/vcol/r/vcol_misc.result | 11 | ||||
-rw-r--r-- | mysql-test/suite/vcol/t/vcol_misc.test | 8 |
2 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/suite/vcol/r/vcol_misc.result b/mysql-test/suite/vcol/r/vcol_misc.result index 6c4975f2178..f13a20bf4c9 100644 --- a/mysql-test/suite/vcol/r/vcol_misc.result +++ b/mysql-test/suite/vcol/r/vcol_misc.result @@ -510,6 +510,17 @@ a b 13 14 DROP TABLE t1; SET sql_mode=DEFAULT; +create table t1 (b timestamp, a int as (1 in (dayofmonth (b between 'x' and current_user) = b))); +insert into t1(b) values ('2022-03-17 14:55:37'); +select 1 from t1 x natural join t1; +1 +1 +Warnings: +Warning 1292 Incorrect datetime value: 'x' +Warning 1292 Incorrect datetime value: 'root@localhost' +Warning 1292 Incorrect datetime value: 'x' +Warning 1292 Incorrect datetime value: 'root@localhost' +drop table t1; # # End of 10.2 tests # diff --git a/mysql-test/suite/vcol/t/vcol_misc.test b/mysql-test/suite/vcol/t/vcol_misc.test index 07f96f4e0b8..821dd418e64 100644 --- a/mysql-test/suite/vcol/t/vcol_misc.test +++ b/mysql-test/suite/vcol/t/vcol_misc.test @@ -488,6 +488,14 @@ SELECT * FROM t1; DROP TABLE t1; SET sql_mode=DEFAULT; +# +# MDEV-28092 MariaDB SEGV issue +# +create table t1 (b timestamp, a int as (1 in (dayofmonth (b between 'x' and current_user) = b))); +insert into t1(b) values ('2022-03-17 14:55:37'); +select 1 from t1 x natural join t1; +drop table t1; + --echo # --echo # End of 10.2 tests --echo # |