innodb-replace.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
源码类别:
MySQL数据库
开发平台:
Visual C++
- -- source include/have_innodb.inc
- # embedded server ignores 'delayed', so skip this
- -- source include/not_embedded.inc
- --disable_warnings
- drop table if exists t1;
- --enable_warnings
- #
- # Bug #1078
- #
- create table t1 (c1 char(5) unique not null, c2 int, stamp timestamp) engine=innodb;
- select * from t1;
- --error 1031
- replace delayed into t1 (c1, c2) values ( "text1","11"),( "text2","12");
- select * from t1;
- --error 1031
- replace delayed into t1 (c1, c2) values ( "text1","12"),( "text2","13"),( "text3","14", "a" ),( "text4","15", "b" );
- select * from t1;
- drop table t1;
- # End of 4.1 tests