diff options
| author | Igor Babaev <igor@askmonty.org> | 2013-01-23 15:18:05 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2013-01-23 15:18:05 -0800 |
| commit | 32151409c13ddc09ebda7cd02fdfe40db290503e (patch) | |
| tree | 86997a41bbc6c4379209af0cccdb4ae612c8d4f4 /mysql-test/t/subselect_innodb.test | |
| parent | f1e758dc6f4183a8e3856d21c95f7e4973c585c1 (diff) | |
| parent | 746152959a8787f3c7cf6b1c710fc1ee6c54419f (diff) | |
| download | mariadb-git-32151409c13ddc09ebda7cd02fdfe40db290503e.tar.gz | |
Merge 5.3->5.5
Diffstat (limited to 'mysql-test/t/subselect_innodb.test')
| -rw-r--r-- | mysql-test/t/subselect_innodb.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_innodb.test b/mysql-test/t/subselect_innodb.test index 3af8f31062c..83c36b16163 100644 --- a/mysql-test/t/subselect_innodb.test +++ b/mysql-test/t/subselect_innodb.test @@ -377,4 +377,18 @@ select 1 from t1 where 1 like (select 1 from t1 where 1 <=> (select 1 from t1 gr drop table t1; +--echo # +--echo # MDEV-3988 crash in create_tmp_table +--echo # + +drop table if exists `t1`,`t2`; +create table `t1`(`a` char(1) character set utf8)engine=innodb; +create table `t2`(`b` char(1) character set utf8)engine=memory; +select distinct (select 1 from `t2` where `a`) `d2` from `t1`; +select distinct (select 1 from `t2` where `a`) `d2`, a from `t1`; +select distinct a, (select 1 from `t2` where `a`) `d2` from `t1`; +select distinct (1 + (select 1 from `t2` where `a`)) `d2` from `t1`; + +drop table t1,t2; + set optimizer_switch=@subselect_innodb_tmp; |