diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2011-03-18 13:50:39 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2011-03-18 13:50:39 +0100 |
| commit | ffdf98f2b8b51d033b379ee2b32eea624bc93a18 (patch) | |
| tree | de1b339ceb6d22c80270dab3f3b2f25d266e811c /mysql-test/t/func_time.test | |
| parent | eea264b283fd0f2383e93d463ba88ca325261b21 (diff) | |
| download | mariadb-git-ffdf98f2b8b51d033b379ee2b32eea624bc93a18.tar.gz | |
number to time comparison
Diffstat (limited to 'mysql-test/t/func_time.test')
| -rw-r--r-- | mysql-test/t/func_time.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/func_time.test b/mysql-test/t/func_time.test index 65d347c05da..078f910a704 100644 --- a/mysql-test/t/func_time.test +++ b/mysql-test/t/func_time.test @@ -861,6 +861,12 @@ DROP TABLE t1; --echo End of 5.1 tests +select time('10:10:10') > 10; +select time('10:10:10') > 1010; +select time('10:10:09') > 101010; +select time('10:10:10') > 101010; +select time('10:10:11') > 101010; + select time(' 1 02:03:04') + interval 9 microsecond; select time(' 1 02:03:04') - interval 9 microsecond; select time('-1 02:03:04') + interval 9 microsecond; |