summaryrefslogtreecommitdiff
path: root/mysql-test/t/bdb-alter-table-1.test
blob: 5861c2fe0bf4471eda4c2afe321d6e3863a11a47 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
#
# Test of problem when shutting down mysqld at once after ALTER TABLE
#
-- source include/have_bdb.inc
drop table if exists t1;
create table t1(objid BIGINT not null, tablename  varchar(64), oid BIGINT not null, test BIGINT,  PRIMARY KEY (objid), UNIQUE(tablename))  type=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