summaryrefslogtreecommitdiff
path: root/mysql-test/t/date_formats.test
diff options
context:
space:
mode:
authorunknown <jani@ua141d10.elisa.omakaista.fi>2006-05-05 00:27:12 +0300
committerunknown <jani@ua141d10.elisa.omakaista.fi>2006-05-05 00:27:12 +0300
commit16022e635c2ce712f8003ca7ee109bd3c4539d7f (patch)
tree526d37314974b49697c844e3b2e43da0e6b15522 /mysql-test/t/date_formats.test
parent5f173c302e3c2758277337dd2bbf3b6a46536e0d (diff)
downloadmariadb-git-16022e635c2ce712f8003ca7ee109bd3c4539d7f.tar.gz
Added more comments to the test cases.
Diffstat (limited to 'mysql-test/t/date_formats.test')
-rw-r--r--mysql-test/t/date_formats.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/date_formats.test b/mysql-test/t/date_formats.test
index 94a192e12f2..c3dd68abb86 100644
--- a/mysql-test/t/date_formats.test
+++ b/mysql-test/t/date_formats.test
@@ -280,6 +280,10 @@ select str_to_date( 1, IF(1=1,NULL,NULL) );
#
# Bug#11326
+# TIME_FORMAT using "%r" returns wrong hour using 24:00:00 in TIME column
+#
+# This tests that 24:00:00 does not return PM, when it should be AM.
+# Some other values are being tested same time.
#
SELECT TIME_FORMAT("24:00:00", '%r');
@@ -291,6 +295,10 @@ SELECT TIME_FORMAT("25:00:00", '%r');
#
# Bug#11324
+# TIME_FORMAT using "%l:%i" returns 36:00 with 24:00:00 in TIME column
+#
+# This tests that 24:00:00 does not change to "36:00 AM". Testing
+# some other values same time.
#
SELECT TIME_FORMAT("00:00:00", '%l %p');