From ffdf98f2b8b51d033b379ee2b32eea624bc93a18 Mon Sep 17 00:00:00 2001 From: Sergei Golubchik Date: Fri, 18 Mar 2011 13:50:39 +0100 Subject: number to time comparison --- mysql-test/t/func_time.test | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'mysql-test/t/func_time.test') 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; -- cgit v1.2.1