diff options
| author | unknown <kaa@polly.local> | 2007-01-25 19:58:04 +0300 |
|---|---|---|
| committer | unknown <kaa@polly.local> | 2007-01-25 19:58:04 +0300 |
| commit | cccad802ef31bcf96badaa67f4224fbe3b8d5985 (patch) | |
| tree | 847a0df641a2bcc9d0b6ed2da63cda5b88e57a04 /mysql-test/t/func_time.test | |
| parent | 0c10457ec4a340337ae0a240b4821216dad76bbe (diff) | |
| download | mariadb-git-cccad802ef31bcf96badaa67f4224fbe3b8d5985.tar.gz | |
Added a test case for bug #20293 "group by cuts off value from time_format"
Diffstat (limited to 'mysql-test/t/func_time.test')
| -rw-r--r-- | mysql-test/t/func_time.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/func_time.test b/mysql-test/t/func_time.test index a69cbb67c5b..920c79c27c9 100644 --- a/mysql-test/t/func_time.test +++ b/mysql-test/t/func_time.test @@ -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; |