From: Date: January 25 2007 5:58pm
Subject: bk commit into 5.0 tree (kaa:1.2380) BUG#20293
List-Archive: http://lists.mysql.com/commits/18788
X-Bug: 20293
Message-Id: <20070125165811.9C8B113DF8D@polly.local>

Below is the list of changes that have just been committed into a local
5.0 repository of kaa. When kaa does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2007-01-25 19:58:04+03:00, kaa@stripped +2 -0
  Added a test case for bug #20293 "group by cuts off value from time_format"

  mysql-test/r/func_time.result@stripped, 2007-01-25 19:57:29+03:00, kaa@stripped +4 -0
    Added a test case for bug #20293 "group by cuts off value from time_format"

  mysql-test/t/func_time.test@stripped, 2007-01-25 19:58:02+03:00, kaa@stripped +8 -0
    Added a test case for bug #20293 "group by cuts off value from time_format"

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	kaa
# Host:	polly.local
# Root:	/tmp/maint/bug20293/my50-bug20293

--- 1.79/mysql-test/r/func_time.result	2007-01-25 19:58:11 +03:00
+++ 1.80/mysql-test/r/func_time.result	2007-01-25 19:58:11 +03:00
@@ -1207,3 +1207,7 @@ SET NAMES DEFAULT;
 select str_to_date('10:00 PM', '%h:%i %p') + INTERVAL 10 MINUTE;
 str_to_date('10:00 PM', '%h:%i %p') + INTERVAL 10 MINUTE
 NULL
+SELECT TIME_FORMAT(SEC_TO_TIME(a),"%H:%i:%s") FROM (SELECT 3020399 AS a UNION SELECT 3020398 ) x GROUP BY 1;
+TIME_FORMAT(SEC_TO_TIME(a),"%H:%i:%s")
+838:59:58
+838:59:59

--- 1.66/mysql-test/t/func_time.test	2007-01-25 19:58:11 +03:00
+++ 1.67/mysql-test/t/func_time.test	2007-01-25 19:58:11 +03:00
@@ -713,3 +713,11 @@ SET NAMES DEFAULT;
 #
 
 select str_to_date('10:00 PM', '%h:%i %p') + INTERVAL 10 MINUTE;
+
+
+#
+# Bug #20293: group by cuts off value from time_format
+#
+# Check if using GROUP BY with TIME_FORMAT() produces correct results
+
+SELECT TIME_FORMAT(SEC_TO_TIME(a),"%H:%i:%s") FROM (SELECT 3020399 AS a UNION SELECT 3020398 ) x GROUP BY 1;