diff options
author | Alexander Barkov <bar@mariadb.com> | 2019-03-29 12:26:42 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2019-03-29 12:26:42 +0400 |
commit | 780d77109be6431bc51a7935144dbf605f9cfc87 (patch) | |
tree | d64c9920833653ab2c223c3f1b0c867fbc25764f /mysql-test/main/type_temporal_innodb.result | |
parent | a5ac029f8a96aae19f09b99a821cae5ddf8c0751 (diff) | |
download | mariadb-git-780d77109be6431bc51a7935144dbf605f9cfc87.tar.gz |
MDEV-17969 Assertion `name' failed in THD::push_warning_truncated_value_for_field
Diffstat (limited to 'mysql-test/main/type_temporal_innodb.result')
-rw-r--r-- | mysql-test/main/type_temporal_innodb.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/main/type_temporal_innodb.result b/mysql-test/main/type_temporal_innodb.result index f8d8bc018bd..55b398b3b02 100644 --- a/mysql-test/main/type_temporal_innodb.result +++ b/mysql-test/main/type_temporal_innodb.result @@ -160,3 +160,15 @@ SELECT * FROM t1 WHERE LEAST( UTC_TIME(), d ); d 2012-12-21 DROP TABLE t1; +# +# MDEV-17969 Assertion `name' failed in THD::push_warning_truncated_value_for_field +# +CREATE TABLE t1 (c1 DATE , c2 TIMESTAMP) ENGINE=InnoDB; +INSERT INTO t1 VALUES ('2006-07-17','0000-00-00 00:00:00'); +CREATE TABLE t2 (pk INT, a1 TIME) Engine=InnoDB; +INSERT INTO t2 VALUES (6,'00:00:00'); +SET SESSION sql_mode= 'strict_all_tables,no_zero_date'; +CREATE TABLE tbl SELECT * FROM t1 WHERE t1.c1 = (SELECT c2 FROM t2 WHERE pk = 6); +ERROR 22007: Truncated incorrect datetime value: '0000-00-00 00:00:00' +DROP TABLE t1,t2; +SET sql_mode=DEFAULT; |