summaryrefslogtreecommitdiff
path: root/mysql-test/r/bdb.result
diff options
context:
space:
mode:
authorunknown <serg@serg.mylan>2004-06-24 19:46:50 +0200
committerunknown <serg@serg.mylan>2004-06-24 19:46:50 +0200
commitff736789672632d415d7d75d8b0a2e85b7b7eae4 (patch)
tree99d5fd1b33e2fdbeb208cef9dae2aa9acf28c5ce /mysql-test/r/bdb.result
parentc6840712f55f9df9951474b0688e221f0f7c7403 (diff)
downloadmariadb-git-ff736789672632d415d7d75d8b0a2e85b7b7eae4.tar.gz
bug#4089 - JOIN::join_free calling mysql_unlock w/o index_end() before
sql/ha_myisam.h: cleanup mysql-test/r/bdb.result: bug#4089 mysql-test/t/bdb.test: bug#4089 sql/opt_range.cc: be sloppy sql/sql_select.cc: JOIN::join_free - pass it down the tree (of selects) call mysql_unlock_tables only in top-level select
Diffstat (limited to 'mysql-test/r/bdb.result')
-rw-r--r--mysql-test/r/bdb.result20
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/bdb.result b/mysql-test/r/bdb.result
index f15862be5db..cc6a974b192 100644
--- a/mysql-test/r/bdb.result
+++ b/mysql-test/r/bdb.result
@@ -1190,3 +1190,23 @@ exists (select 'two' from t1 where 'two' = outer_table.b);
b
drop table t1;
set autocommit=1;
+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);
+a
+1
+2
+3
+4
+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;
+a b
+1 one
+2 two
+3 three
+4 four
+drop table t1, t2;