diff options
author | serg@serg.mylan <> | 2004-06-24 19:46:50 +0200 |
---|---|---|
committer | serg@serg.mylan <> | 2004-06-24 19:46:50 +0200 |
commit | 1ff21a9e64da5ce5b6bc7462e807711859617088 (patch) | |
tree | 99d5fd1b33e2fdbeb208cef9dae2aa9acf28c5ce /mysql-test/t/bdb.test | |
parent | 334eb77356e6e189419517fa42f0a5567017e85f (diff) | |
download | mariadb-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.test | 17 |
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; |