diff options
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; |