summaryrefslogtreecommitdiff
path: root/mysql-test/suite/vcol/r/vcol_misc.result
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2022-04-16 11:40:15 +0200
committerSergei Golubchik <serg@mariadb.org>2022-04-19 17:10:05 +0200
commita59f483c06b12e606747da3f864ed94615f038c0 (patch)
tree919796c30989e9c1fc10d413fe96f3ef65a246ef /mysql-test/suite/vcol/r/vcol_misc.result
parent5aef0123a707415c56ffae48fc872e7d3ad292d2 (diff)
downloadmariadb-git-a59f483c06b12e606747da3f864ed94615f038c0.tar.gz
MDEV-28092 MariaDB SEGV issue
add test
Diffstat (limited to 'mysql-test/suite/vcol/r/vcol_misc.result')
-rw-r--r--mysql-test/suite/vcol/r/vcol_misc.result11
1 files changed, 11 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
#