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/t | |
| parent | e9c494c8438c7fcfe8edd197c9a6919be4a02ab0 (diff) | |
| parent | 925b5030583e3622705621b4a0e56d6ccc3c5fcc (diff) | |
| download | mariadb-git-8c493a910fd224235b3eddb4bacac0592146cac6.tar.gz | |
Merge 10.0 into 10.1
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/subselect_sj.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_sj.test b/mysql-test/t/subselect_sj.test index 623e414310a..1a1b8757864 100644 --- a/mysql-test/t/subselect_sj.test +++ b/mysql-test/t/subselect_sj.test @@ -2873,6 +2873,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 |