diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2019-03-21 21:06:01 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2019-03-21 21:06:01 +0200 |
| commit | 8c493a910fd224235b3eddb4bacac0592146cac6 (patch) | |
| tree | 1ba77b09ad11054ae1f6767abc2441fcea54da07 /mysql-test/r | |
| parent | e9c494c8438c7fcfe8edd197c9a6919be4a02ab0 (diff) | |
| parent | 925b5030583e3622705621b4a0e56d6ccc3c5fcc (diff) | |
| download | mariadb-git-8c493a910fd224235b3eddb4bacac0592146cac6.tar.gz | |
Merge 10.0 into 10.1
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/subselect_sj.result | 7 | ||||
| -rw-r--r-- | mysql-test/r/subselect_sj_jcl6.result | 7 |
2 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_sj.result b/mysql-test/r/subselect_sj.result index 77dea34e2ab..6d36950eaa8 100644 --- a/mysql-test/r/subselect_sj.result +++ b/mysql-test/r/subselect_sj.result @@ -3186,5 +3186,12 @@ EXECUTE stmt; a drop view v3; drop table t1,t2,t3; +# +# MDEV-18896: IN subquery in WHERE of a table-less query used for INSERT +# +create table t1 (a1 varchar(25)); +create table t2 (a2 varchar(25)) ; +insert into t1 select 'xxx' from dual where 'xxx' in (select a2 from t2); +drop table t1,t2; # End of 5.5 test set optimizer_switch=@subselect_sj_tmp; diff --git a/mysql-test/r/subselect_sj_jcl6.result b/mysql-test/r/subselect_sj_jcl6.result index 0741eb236ea..a9c849370ed 100644 --- a/mysql-test/r/subselect_sj_jcl6.result +++ b/mysql-test/r/subselect_sj_jcl6.result @@ -3200,6 +3200,13 @@ EXECUTE stmt; a drop view v3; drop table t1,t2,t3; +# +# MDEV-18896: IN subquery in WHERE of a table-less query used for INSERT +# +create table t1 (a1 varchar(25)); +create table t2 (a2 varchar(25)) ; +insert into t1 select 'xxx' from dual where 'xxx' in (select a2 from t2); +drop table t1,t2; # End of 5.5 test set optimizer_switch=@subselect_sj_tmp; # |