diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2011-09-01 14:23:03 +0400 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2011-09-01 14:23:03 +0400 |
| commit | 11ebbabb087a7bd6c315e6412d8e8ee677c6217b (patch) | |
| tree | e4c07766727c38df867edd12430ce55185596ff6 /mysql-test/t/func_time.test | |
| parent | 26bd06feef0d3f2e6f0a20457db1f8397117d2d5 (diff) | |
| download | mariadb-git-11ebbabb087a7bd6c315e6412d8e8ee677c6217b.tar.gz | |
sec_to_time() in the integer context was losing the sign of the result
Diffstat (limited to 'mysql-test/t/func_time.test')
| -rw-r--r-- | mysql-test/t/func_time.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/func_time.test b/mysql-test/t/func_time.test index 2d84202c6aa..dafc9e0e0f0 100644 --- a/mysql-test/t/func_time.test +++ b/mysql-test/t/func_time.test @@ -18,6 +18,8 @@ select sec_to_time(9001),sec_to_time(9001)+0,time_to_sec("15:12:22"), select sec_to_time(9001.1), time_to_sec('15:12:22.123456'), time_to_sec(15.5566778899); select sec_to_time(time_to_sec('-838:59:59')); select sec_to_time('9001.1'), sec_to_time('1234567890123.123'); +select sec_to_time(-9001.1), sec_to_time(-9001.1) / 1, + sec_to_time(-9001.1) / 1e0, sec_to_time(-9001) div 1; --replace_result e+042 e+42 select sec_to_time(90011e-1), sec_to_time(1234567890123e30); select sec_to_time(1234567890123), sec_to_time('99999999999999999999999999999'); |