diff options
author | unknown <monty@donna.mysql.com> | 2001-01-02 00:27:08 +0200 |
---|---|---|
committer | unknown <monty@donna.mysql.com> | 2001-01-02 00:27:08 +0200 |
commit | 170736f88607d53e818bf73d6d40309f7d96b1b6 (patch) | |
tree | ad69c7c5b1ebe3a109f863f979e2c6b9ceb041c7 /mysql-test/t/bdb.test | |
parent | 189509c623d09692e7bda2e998f5fbd9215f9ab3 (diff) | |
download | mariadb-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.test | 8 |
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; |