diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2019-03-22 13:20:44 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2019-03-22 13:20:44 +0200 |
| commit | ca80e14a882b1928350ef0522607cd1011048941 (patch) | |
| tree | 05d992be3d25cf47e38c7bc1ea2dacee485f33c5 /mysql-test/main/subselect_sj.test | |
| parent | c23d4700e6d9ea4f32eda6965ffc907fa83425e8 (diff) | |
| parent | 1c60f40868f6067be81a50198e1c72df08814adf (diff) | |
| download | mariadb-git-ca80e14a882b1928350ef0522607cd1011048941.tar.gz | |
Merge 10.3 into 10.4
Diffstat (limited to 'mysql-test/main/subselect_sj.test')
| -rw-r--r-- | mysql-test/main/subselect_sj.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/main/subselect_sj.test b/mysql-test/main/subselect_sj.test index 1df143738b5..22c9b2bf0cf 100644 --- a/mysql-test/main/subselect_sj.test +++ b/mysql-test/main/subselect_sj.test @@ -2876,6 +2876,16 @@ EXECUTE stmt; drop view v3; drop table t1,t2,t3; +--echo # +--echo # MDEV-18896: IN subquery in WHERE of a table-less query used for INSERT +--echo # + +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; + --echo # End of 5.5 test # The following command must be the last one the file |