English
- #
- # Test year
- #
- --disable_warnings
- drop table if exists t1;
- --enable_warnings
- 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;
- # End of 4.1 tests
