diff options
author | Alexander Barkov <bar@mariadb.com> | 2018-09-26 20:14:47 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2018-09-26 20:14:47 +0400 |
commit | 786940d7e03630d28d82bca4388c937c0d48594a (patch) | |
tree | 987ffe4cc2db3e2c7272f12fb32379f98b189793 /mysql-test/main/type_time.result | |
parent | 25ad38abe5b3fb6bb2aafff315de256b8f1e7839 (diff) | |
download | mariadb-git-786940d7e03630d28d82bca4388c937c0d48594a.tar.gz |
MDEV-17219 Assertion `!t->fraction_remainder(decimals())' failed in Field_time::store_TIME_with_warning
Diffstat (limited to 'mysql-test/main/type_time.result')
-rw-r--r-- | mysql-test/main/type_time.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/main/type_time.result b/mysql-test/main/type_time.result index 6d26ee1fdaa..f16c958d9c1 100644 --- a/mysql-test/main/type_time.result +++ b/mysql-test/main/type_time.result @@ -2076,5 +2076,17 @@ d1 t1 d1 UPDATE (t1 JOIN t2 ON (t2.d1 = t1.t1)) SET t1.d1 = '2018-07-07' WHERE (t1.d1 > 70 ); DROP TABLE t1,t2; # +# MDEV-17219 Assertion `!t->fraction_remainder(decimals())' failed in Field_time::store_TIME_with_warning +# +SET optimizer_use_condition_selectivity=3; +CREATE TABLE t1 (it TIME NOT NULL); +INSERT INTO t1 VALUES ('07:25:13'),('05:15:55'),('09:58:01'),('04:23:57'),('19:37:28'),('01:38:05'),('20:50:52'); +SELECT 1 FROM t1 WHERE it < -7487797330456870912; +1 +Warnings: +Warning 1292 Truncated incorrect time value: '-7487797330456870912' +DROP TABLE t1; +SET optimizer_use_condition_selectivity=DEFAULT; +# # End of 10.4 tests # |