diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2019-03-19 16:04:59 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2019-03-19 16:04:59 +0200 |
| commit | 117291db8b35ddb4cd8c89ee4d8de888160b7163 (patch) | |
| tree | 05041fcbc5a4c5c14531d148505216cb88add73c /mysql-test/main/update.test | |
| parent | 26e5bff00318272c717561e7b980036df3332d7b (diff) | |
| parent | a77e2668667e46d96c445a4a9a8325b7fe9461b3 (diff) | |
| download | mariadb-git-117291db8b35ddb4cd8c89ee4d8de888160b7163.tar.gz | |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/update.test')
| -rw-r--r-- | mysql-test/main/update.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/main/update.test b/mysql-test/main/update.test index e5ef0b11127..84709102f96 100644 --- a/mysql-test/main/update.test +++ b/mysql-test/main/update.test @@ -654,3 +654,22 @@ show status like 'Handler_read%'; drop table t1, t2; --echo # End of MariaDB 10.0 tests + +--echo # +--echo # MDEV-18945: multi-table update with constant table and +--echo # comparison of date field with integer field +--echo # + +CREATE TABLE t1 (i1 int, d1 date , i2 int , d2 date) engine=myisam; +INSERT INTO t1 VALUES (19,'0000-00-00',73,'2008-05-21'); + +CREATE TABLE t2 (d1 date , i1 int, i2 int , d2 date) engine=myisam; +INSERT INTO t2 VALUES + ('2006-01-12',-102,45,'2023-11-25'),('2034-12-19',-102,45,'2001-11-20'); + +--error ER_TRUNCATED_WRONG_VALUE +UPDATE t1,t2 SET t1.i1 = -39 WHERE t2.d1 <> t1.i1 AND t2.d1 = t1.d2; + +DROP TABLE t1,t2; + +--echo # End of MariaDB 10.2 tests |