diff options
author | Alexander Barkov <bar@mariadb.com> | 2018-12-02 18:59:04 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2018-12-02 18:59:04 +0400 |
commit | f89a27b4e5d360315a090f816649edf14eae25a7 (patch) | |
tree | 5b137afb5ba45dd37bc9cda6788cc95cd849c443 /mysql-test/main/type_time.result | |
parent | 17e371fffe3d0a25936e64f8b2f87b9f5d73c0a3 (diff) | |
download | mariadb-git-f89a27b4e5d360315a090f816649edf14eae25a7.tar.gz |
MDEV-17319 Assertion `ts_type != MYSQL_TIMESTAMP_TIME' failed upon inserting into TIME field
Diffstat (limited to 'mysql-test/main/type_time.result')
-rw-r--r-- | mysql-test/main/type_time.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/main/type_time.result b/mysql-test/main/type_time.result index 0a66a94db69..00b7386a64e 100644 --- a/mysql-test/main/type_time.result +++ b/mysql-test/main/type_time.result @@ -2168,5 +2168,14 @@ Warning 1292 Truncated incorrect datetime value: 'z' Warning 1292 Truncated incorrect datetime value: 'z' Warning 1292 Truncated incorrect time value: 'z' # +# MDEV-17319 Assertion `ts_type != MYSQL_TIMESTAMP_TIME' failed upon inserting into TIME field +# +CREATE TABLE t1 (t TIME); +SET SESSION SQL_MODE='TRADITIONAL'; +INSERT INTO t1 VALUES ('0000-00-00 00:00:00'),('0000-00-00 00:00:00'); +ERROR 22007: Incorrect time value: '0000-00-00 00:00:00' for column 't' at row 1 +SET sql_mode=DEFAULT; +DROP TABLE t1; +# # End of 10.4 tests # |