diff options
author | unknown <serg@serg.mylan> | 2004-06-24 19:46:50 +0200 |
---|---|---|
committer | unknown <serg@serg.mylan> | 2004-06-24 19:46:50 +0200 |
commit | ff736789672632d415d7d75d8b0a2e85b7b7eae4 (patch) | |
tree | 99d5fd1b33e2fdbeb208cef9dae2aa9acf28c5ce /mysql-test/r/bdb.result | |
parent | c6840712f55f9df9951474b0688e221f0f7c7403 (diff) | |
download | mariadb-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.result | 20 |
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; |