summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authormonty@mashka.mysql.fi <>2002-08-31 14:41:56 +0300
committermonty@mashka.mysql.fi <>2002-08-31 14:41:56 +0300
commit184ef91d4c049752488ad08437b5a12ca1e3c2dc (patch)
tree8ebda9dd300ed81d064105ecbc642add1096ec5d /mysql-test
parentb8bf46ca9b7f42667b5701e025fd4c145c62bbd5 (diff)
parentb17eea55053c5891fcbf05c0dec70f7fcb99eb06 (diff)
downloadmariadb-git-184ef91d4c049752488ad08437b5a12ca1e3c2dc.tar.gz
Merge
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/bdb-alter-table-1.result4
-rw-r--r--mysql-test/r/bdb-alter-table-2.result4
-rw-r--r--mysql-test/t/bdb-alter-table-1.test12
-rw-r--r--mysql-test/t/bdb-alter-table-2.test3
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