English
- #
- # Test some ODBC compatibility
- #
- select {fn length("hello")}, { date "1997-10-20" };
- #
- # Test retreiving row with last insert_id value.
- #
- create table t1 (a int not null auto_increment,b int not null,primary key (a,b));
- insert into t1 SET A=NULL,B=1;
- insert into t1 SET a=null,b=2;
- select * from t1 where a is null and b=2;
- select * from t1 where a is null;
- explain select * from t1 where b is null;
- drop table t1;
