summaryrefslogtreecommitdiff
path: root/mysql-test/t/date_formats.test
diff options
context:
space:
mode:
authorTatiana A. Nurnberg <azundris@mysql.com>2009-01-09 14:22:15 +0100
committerTatiana A. Nurnberg <azundris@mysql.com>2009-01-09 14:22:15 +0100
commitd3c4a5cb102f474ab86ddc412c724010d983927f (patch)
tree78041ec60acdde7dc5a0d3dbf75ec084a0569533 /mysql-test/t/date_formats.test
parent4bd55050adb67b35a4c15c327d06a52535811fe7 (diff)
parentc42892d61413adea81c174a90d458c07a8ddd52c (diff)
downloadmariadb-git-d3c4a5cb102f474ab86ddc412c724010d983927f.tar.gz
auto-merge
Diffstat (limited to 'mysql-test/t/date_formats.test')
-rw-r--r--mysql-test/t/date_formats.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/date_formats.test b/mysql-test/t/date_formats.test
index abf09942d1c..e474fac8a2a 100644
--- a/mysql-test/t/date_formats.test
+++ b/mysql-test/t/date_formats.test
@@ -340,3 +340,15 @@ select str_to_date('04/30 /2004', '%m /%d /%Y');
select str_to_date('04/30/2004 ', '%m/%d/%Y ');
--echo "End of 4.1 tests"
+
+#
+# Bug #41470: DATE_FORMAT() crashes the complete server with a valid date
+#
+
+# show that these two do not crash the server:
+SELECT DATE_FORMAT("0000-01-01",'%W %d %M %Y') as valid_date;
+SELECT DATE_FORMAT("0000-02-28",'%W %d %M %Y') as valid_date;
+# show that date within the Gregorian range render correct results: (THU)
+SELECT DATE_FORMAT("2009-01-01",'%W %d %M %Y') as valid_date;
+
+--echo "End of 5.0 tests"