diff options
Diffstat (limited to 'mysql-test/t/type_year.test')
-rw-r--r-- | mysql-test/t/type_year.test | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/mysql-test/t/type_year.test b/mysql-test/t/type_year.test index 70a3053f19b..e9e34dbc29f 100644 --- a/mysql-test/t/type_year.test +++ b/mysql-test/t/type_year.test @@ -1,10 +1,19 @@ # # Test year # - +drop table if exists t1; create table t1 (y year,y2 year(2)); insert into t1 values (0,0),(1999,1999),(2000,2000),(2001,2001),(70,70),(69,69); select * from t1; select * from t1 order by y; select * from t1 order by y2; drop table t1; + +# +# Bug 2335 +# + +create table t1 (y year); +insert into t1 values (now()); +select if(y = now(), 1, 0) from t1; +drop table t1; |