summaryrefslogtreecommitdiff
path: root/mysql-test/t/bdb.test
diff options
context:
space:
mode:
authorserg@serg.mylan <>2004-06-24 19:46:50 +0200
committerserg@serg.mylan <>2004-06-24 19:46:50 +0200
commit1ff21a9e64da5ce5b6bc7462e807711859617088 (patch)
tree99d5fd1b33e2fdbeb208cef9dae2aa9acf28c5ce /mysql-test/t/bdb.test
parent334eb77356e6e189419517fa42f0a5567017e85f (diff)
downloadmariadb-git-1ff21a9e64da5ce5b6bc7462e807711859617088.tar.gz
bug#4089 - JOIN::join_free calling mysql_unlock w/o index_end() before
Diffstat (limited to 'mysql-test/t/bdb.test')
-rw-r--r--mysql-test/t/bdb.test17
1 files changed, 10 insertions, 7 deletions
diff --git a/mysql-test/t/bdb.test b/mysql-test/t/bdb.test
index acc70bf0fe7..42729034d41 100644
--- a/mysql-test/t/bdb.test
+++ b/mysql-test/t/bdb.test
@@ -840,10 +840,13 @@ set autocommit=1;
# Bug #4089: subselect and open cursor.
#
-#create table t1(a int primary key, b varchar(30)) engine=bdb;
-#insert into t1 values (1,'one'), (2,'two'), (3,'three'), (4,'four');
-#create table t2 like t1;
-#insert into t2 (a, b)
-# select a, b from t1 where (a, b) in (select a, b from t1);
-#select * from t2;
-#drop table t1, t2;
+create table t1(a int primary key, b varchar(30)) engine=bdb;
+insert into t1 values (1,'one'), (2,'two'), (3,'three'), (4,'four');
+create table t2 like t1;
+insert t2 select * from t1;
+select a from t1 where a in (select a from t2);
+delete from t2;
+insert into t2 (a, b)
+ select a, b from t1 where (a, b) in (select a, b from t1);
+select * from t2;
+drop table t1, t2;