diff options
Diffstat (limited to 'mysql-test/r/bdb-alter-table-1.result')
| -rw-r--r-- | mysql-test/r/bdb-alter-table-1.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/bdb-alter-table-1.result b/mysql-test/r/bdb-alter-table-1.result index 3742f45eb7a..095d89355ad 100644 --- a/mysql-test/r/bdb-alter-table-1.result +++ b/mysql-test/r/bdb-alter-table-1.result @@ -1,4 +1,11 @@ +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; objid tablename oid test 1 t1 4 9 2 metatable 1 9 3 metaindex 1 9 +alter table t1 drop column test; |