diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-08-28 16:41:23 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-08-28 16:41:23 +0300 |
| commit | 9210160c5560c61044dd1529c9fa4de46e126a77 (patch) | |
| tree | 69f65dccef0752eb3d30c80ef25a24beec3d36cf /mysql-test | |
| parent | 63cdfc4b436baec414f587535fbdca0119765615 (diff) | |
| download | mariadb-git-9210160c5560c61044dd1529c9fa4de46e126a77.tar.gz | |
Little but nasty bug with BDB and alter table
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/bdb-alter-table-1.result | 4 | ||||
| -rw-r--r-- | mysql-test/r/bdb-alter-table-2.result | 4 | ||||
| -rw-r--r-- | mysql-test/t/bdb-alter-table-1.test | 12 | ||||
| -rw-r--r-- | mysql-test/t/bdb-alter-table-2.test | 3 |
4 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/r/bdb-alter-table-1.result b/mysql-test/r/bdb-alter-table-1.result new file mode 100644 index 00000000000..3742f45eb7a --- /dev/null +++ b/mysql-test/r/bdb-alter-table-1.result @@ -0,0 +1,4 @@ +objid tablename oid test +1 t1 4 9 +2 metatable 1 9 +3 metaindex 1 9 diff --git a/mysql-test/r/bdb-alter-table-2.result b/mysql-test/r/bdb-alter-table-2.result new file mode 100644 index 00000000000..19c6d5e1ff9 --- /dev/null +++ b/mysql-test/r/bdb-alter-table-2.result @@ -0,0 +1,4 @@ +objid tablename oid +1 t1 4 +2 metatable 1 +3 metaindex 1 diff --git a/mysql-test/t/bdb-alter-table-1.test b/mysql-test/t/bdb-alter-table-1.test new file mode 100644 index 00000000000..25a86cd92f6 --- /dev/null +++ b/mysql-test/t/bdb-alter-table-1.test @@ -0,0 +1,12 @@ +-- source include/have_bdb.inc + +# +# Small basic test for ALTER TABLE bug .. +# +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; diff --git a/mysql-test/t/bdb-alter-table-2.test b/mysql-test/t/bdb-alter-table-2.test new file mode 100644 index 00000000000..69ff04ee24a --- /dev/null +++ b/mysql-test/t/bdb-alter-table-2.test @@ -0,0 +1,3 @@ +-- source include/have_bdb.inc +select * from t1; +drop table t1;
\ No newline at end of file |