diff options
| author | unknown <iggy@rolltop.ignatz42.dyndns.org> | 2006-08-16 19:31:33 -0400 |
|---|---|---|
| committer | unknown <iggy@rolltop.ignatz42.dyndns.org> | 2006-08-16 19:31:33 -0400 |
| commit | b2cfa703f4799e68bc41dd651e30d4057b5c7076 (patch) | |
| tree | 09113ee1ad0f3a06c7c13659f66d5e2d71dccbca /mysql-test/t/func_time.test | |
| parent | 90b069ed34c293f7eb55f7827dd9fd086ff78015 (diff) | |
| parent | 4934231545c994b90517b2c1b4c9b85b4fbe2018 (diff) | |
| download | mariadb-git-b2cfa703f4799e68bc41dd651e30d4057b5c7076.tar.gz | |
Merge rolltop.ignatz42.dyndns.org:/mnt/storeage/mysql-4.1-maint_20328
into rolltop.ignatz42.dyndns.org:/mnt/storeage/mysql-5.0-merge
sql/item_timefunc.cc:
Auto merged
sql/slave.cc:
Auto merged
mysql-test/r/func_time.result:
manual merge
mysql-test/r/mysql_client.result:
manual merge
mysql-test/t/func_time.test:
manual merge
mysql-test/t/mysql_client.test:
manual merge
sql/sql_acl.cc:
manual merge
Diffstat (limited to 'mysql-test/t/func_time.test')
| -rw-r--r-- | mysql-test/t/func_time.test | 20 |
1 files changed, 19 insertions, 1 deletions
diff --git a/mysql-test/t/func_time.test b/mysql-test/t/func_time.test index c95d3e3319a..0945c3ab33e 100644 --- a/mysql-test/t/func_time.test +++ b/mysql-test/t/func_time.test @@ -446,7 +446,25 @@ create table t1 select now() - now(), curtime() - curtime(), show create table t1; drop table t1; -# End of 4.1 tests +# +# Bug #19844 time_format in Union truncates values +# + +(select time_format(timediff(now(), DATE_SUB(now(),INTERVAL 5 DAY)),'%H') As H) +union +(select time_format(timediff(now(), DATE_SUB(now(),INTERVAL 5 DAY)),'%H') As H); +(select time_format(timediff(now(), DATE_SUB(now(),INTERVAL 5 DAY)),'%k') As H) +union +(select time_format(timediff(now(), DATE_SUB(now(),INTERVAL 5 DAY)),'%k') As H); +(select time_format(timediff(now(), DATE_SUB(now(),INTERVAL 5 HOUR)),'%H') As H) +union +(select time_format(timediff(now(), DATE_SUB(now(),INTERVAL 5 HOUR)),'%H') As H); + +(select time_format(timediff(now(), DATE_SUB(now(),INTERVAL 5 HOUR)),'%k') As H) +union +(select time_format(timediff(now(), DATE_SUB(now(),INTERVAL 5 HOUR)),'%k') As H); + +--echo End of 4.1 tests explain extended select timestampdiff(SQL_TSI_WEEK, '2001-02-01', '2001-05-01') as a1, timestampdiff(SQL_TSI_FRAC_SECOND, '2001-02-01 12:59:59.120000', '2001-05-01 12:58:58.119999') as a2; |