diff options
| author | unknown <kaa@polly.local> | 2007-03-06 20:50:49 +0300 |
|---|---|---|
| committer | unknown <kaa@polly.local> | 2007-03-06 20:50:49 +0300 |
| commit | 3e42dddaa558e1b84065a1a63b04d3feafeb3e50 (patch) | |
| tree | 150f16037c331f40d9177214c0e2e4459bc19ca6 /mysql-test/t/func_time.test | |
| parent | 4660b8f094940dba93fdfc2743c1fb1138de565e (diff) | |
| parent | cccad802ef31bcf96badaa67f4224fbe3b8d5985 (diff) | |
| download | mariadb-git-3e42dddaa558e1b84065a1a63b04d3feafeb3e50.tar.gz | |
Merge polly.local:/tmp/maint/bug20293/my50-bug20293
into polly.local:/home/kaa/src/maint/mysql-5.0-maint
mysql-test/r/func_time.result:
Manual merge.
mysql-test/t/func_time.test:
Manual merge.
Diffstat (limited to 'mysql-test/t/func_time.test')
| -rw-r--r-- | mysql-test/t/func_time.test | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/t/func_time.test b/mysql-test/t/func_time.test index e08a7edb2bf..da909dc578f 100644 --- a/mysql-test/t/func_time.test +++ b/mysql-test/t/func_time.test @@ -745,3 +745,10 @@ SELECT t1, t2, SEC_TO_TIME( TIME_TO_SEC( t2 ) - TIME_TO_SEC( t1 ) ), QUARTER(d) SELECT t1, t2, SEC_TO_TIME( TIME_TO_SEC( t2 ) - TIME_TO_SEC( t1 ) ), QUARTER(d) FROM t1 ORDER BY a DESC; DROP TABLE t1; + +# +# 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; |