bdb-alter-table-1.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
源码类别:
MySQL数据库
开发平台:
Visual C++
- #
- # Test of problem when shutting down mysqld at once after ALTER TABLE
- #
- -- source include/have_bdb.inc
- --disable_warnings
- drop table if exists t1;
- --enable_warnings
- create table t1(objid BIGINT not null, tablename varchar(64), oid BIGINT not null, test BIGINT, PRIMARY KEY (objid), UNIQUE(tablename)) engine=BDB;
- insert into t1 values(1, 't1',4,9);
- insert into t1 values(2, 'metatable',1,9);
- insert into t1 values(3, 'metaindex',1,9 );
- select * from t1;
- alter table t1 drop column test;
- # Now we do a reboot and continue with the next test
- # End of 4.1 tests