odbc.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
- # Initialise
- --disable_warnings
- drop table if exists t1;
- --enable_warnings
- #
- # 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;
- # End of 4.1 tests