From bcb61e6860ae71cbc7e07cc5c956da1542bf5db8 Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 4 May 2006 19:31:10 +0300 Subject: Fix for Bug#11326. mysql-test/r/date_formats.result: Added test cases for Bug#11326 mysql-test/t/date_formats.test: Added test cases for Bug#11326 --- mysql-test/t/date_formats.test | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'mysql-test/t/date_formats.test') diff --git a/mysql-test/t/date_formats.test b/mysql-test/t/date_formats.test index 78b4482a94a..143cddbc4fe 100644 --- a/mysql-test/t/date_formats.test +++ b/mysql-test/t/date_formats.test @@ -276,3 +276,14 @@ select str_to_date( 1, NULL ); select str_to_date( NULL, 1 ); select str_to_date( 1, IF(1=1,NULL,NULL) ); # End of 4.1 tests + +# +# Bug#11326 +# + +SELECT TIME_FORMAT("24:00:00", '%r'); +SELECT TIME_FORMAT("00:00:00", '%r'); +SELECT TIME_FORMAT("12:00:00", '%r'); +SELECT TIME_FORMAT("15:00:00", '%r'); +SELECT TIME_FORMAT("01:00:00", '%r'); +SELECT TIME_FORMAT("25:00:00", '%r'); -- cgit v1.2.1 From 02dcc76e3754887cb838cdfd8e1b11e8bd21094d Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 4 May 2006 20:19:37 +0300 Subject: Fixed Bug#11324: TIME_FORMAT using "%l:%i" returns 36:00 with 24:00:00 in TIME column mysql-test/r/date_formats.result: Added test case for Bug#11324, "TIME_FORMAT using "%l:%i" returns 36:00 with 24:00:00 in TIME column" mysql-test/t/date_formats.test: Added test case for Bug#11324, "TIME_FORMAT using "%l:%i" returns 36:00 with 24:00:00 in TIME column" --- mysql-test/t/date_formats.test | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'mysql-test/t/date_formats.test') diff --git a/mysql-test/t/date_formats.test b/mysql-test/t/date_formats.test index 143cddbc4fe..f3d507e69e6 100644 --- a/mysql-test/t/date_formats.test +++ b/mysql-test/t/date_formats.test @@ -287,3 +287,14 @@ SELECT TIME_FORMAT("12:00:00", '%r'); SELECT TIME_FORMAT("15:00:00", '%r'); SELECT TIME_FORMAT("01:00:00", '%r'); SELECT TIME_FORMAT("25:00:00", '%r'); + +# +# Bug#11324 +# + +SELECT TIME_FORMAT("00:00:00", '%l %p'); +SELECT TIME_FORMAT("01:00:00", '%l %p'); +SELECT TIME_FORMAT("12:00:00", '%l %p'); +SELECT TIME_FORMAT("23:00:00", '%l %p'); +SELECT TIME_FORMAT("24:00:00", '%l %p'); +SELECT TIME_FORMAT("25:00:00", '%l %p'); -- cgit v1.2.1