summaryrefslogtreecommitdiff
path: root/mysql-test/t/bdb.test
diff options
context:
space:
mode:
authorunknown <monty@donna.mysql.com>2001-01-02 00:27:08 +0200
committerunknown <monty@donna.mysql.com>2001-01-02 00:27:08 +0200
commit170736f88607d53e818bf73d6d40309f7d96b1b6 (patch)
treead69c7c5b1ebe3a109f863f979e2c6b9ceb041c7 /mysql-test/t/bdb.test
parent189509c623d09692e7bda2e998f5fbd9215f9ab3 (diff)
downloadmariadb-git-170736f88607d53e818bf73d6d40309f7d96b1b6.tar.gz
Fixed bug when opening BDB tables twice
Build-tools/Do-all-build-steps: Create the result directory Docs/manual.texi: More explanation about mysql_install_db mysql-test/mysql-test-run.sh: Add --core option mysql-test/r/bdb.result: Test of opening tables twice mysql-test/t/bdb.test: Test of opening tables twice sql/ha_berkeley.cc: Fixed bug when table is in use sql/ha_berkeley.h: Fixed bug when table is in use
Diffstat (limited to 'mysql-test/t/bdb.test')
-rw-r--r--mysql-test/t/bdb.test8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/bdb.test b/mysql-test/t/bdb.test
index c03dd16dce5..370e10e7afa 100644
--- a/mysql-test/t/bdb.test
+++ b/mysql-test/t/bdb.test
@@ -326,3 +326,11 @@ CREATE TABLE t1 (
INSERT INTO t1 ( sca_code, cat_code, sca_desc, lan_code, sca_pic, sca_sdesc, sca_sch_desc) VALUES ( 'PD', 'J', 'PENDANT', 'EN', NULL, NULL, 'PENDANT'),( 'RI', 'J', 'RING', 'EN', NULL, NULL, 'RING');
select count(*) from t1 where sca_code = 'PD';
drop table t1;
+
+#
+# Test of opening table twice
+#
+CREATE TABLE t1 (a int not null, primary key (a)) type=bdb;
+insert into t1 values(1),(2),(3);
+select t1.a from t1 natural join t1 as t2 order by t1.a;
+drop table t1;