Adding upstream version 1:10.5.12.upstream/1%10.5.12upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 9 insertions, 0 deletions

diff --git a/mysql-test/main/adddate_454.test b/mysql-test/main/adddate_454.test
new file mode 100644
index 00000000..bbdd89b5
--- /dev/null
+++ b/mysql-test/main/adddate_454.test
@@ -0,0 +1,9 @@
+#
+# MDEV-454 Addition of a time interval reduces the resulting value
+#
+create table t1 (d date);
+insert into t1 values ('2012-00-00');
+select * from t1;
+update ignore t1 set d = adddate(d, interval 1 day);
+select * from t1;
+drop table t1;