diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2019-07-26 22:42:35 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2019-07-26 22:42:35 +0200 |
| commit | d97342b6f2cfdd55eb0f82b390ebc89c5997c382 (patch) | |
| tree | 238dbb11c51a2352c99de198586b84f260b3aad9 /mysql-test/main/subselect_mat.result | |
| parent | 00a254cc069e77f2088f6fbf8c367f247cfdd0dc (diff) | |
| parent | 32c6f40a6319d493e5270c72ac5d27dc99d1b242 (diff) | |
| download | mariadb-git-d97342b6f2cfdd55eb0f82b390ebc89c5997c382.tar.gz | |
Merge branch '10.2' into 10.3
Diffstat (limited to 'mysql-test/main/subselect_mat.result')
| -rw-r--r-- | mysql-test/main/subselect_mat.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/subselect_mat.result b/mysql-test/main/subselect_mat.result index 358bec24e1d..45f6f135b48 100644 --- a/mysql-test/main/subselect_mat.result +++ b/mysql-test/main/subselect_mat.result @@ -2251,7 +2251,7 @@ id select_type table type possible_keys key key_len ref rows filtered Extra 3 MATERIALIZED t3 ALL NULL NULL NULL NULL 8 100.00 Warnings: Note 1276 Field or reference 'test.t1.f1' of SELECT #2 was resolved in SELECT #1 -Note 1003 /* select#1 */ select `test`.`t1`.`f1` AS `f1` from `test`.`t1` where <expr_cache><`test`.`t1`.`f1`>(exists(/* select#2 */ select 1 from `test`.`t2` semi join (`test`.`t3`) join `test`.`t3` where `test`.`t3`.`i3` = `test`.`t2`.`i2` and `test`.`t1`.`f1` = `test`.`t3`.`f3`)) +Note 1003 /* select#1 */ select `test`.`t1`.`f1` AS `f1` from `test`.`t1` where <expr_cache><`test`.`t1`.`f1`>(exists(/* select#2 */ select 1 from `test`.`t2` semi join (`test`.`t3`) join `test`.`t3` where `test`.`t3`.`i3` = `test`.`t2`.`i2` and `test`.`t1`.`f1` = `test`.`t3`.`f3` limit 1)) # this checks the result set above set optimizer_switch= 'materialization=off,semijoin=off'; SELECT * FROM t1 |