diff options
| author | Lena Startseva <lena.startseva@mariadb.com> | 2022-09-28 09:40:17 +0700 |
|---|---|---|
| committer | Lena Startseva <lena.startseva@mariadb.com> | 2022-09-28 09:40:17 +0700 |
| commit | f9bf41632e8ae9506a64d179e65a491317326eff (patch) | |
| tree | 812fdf4c22f41e83ac0810227b6e476b31ac8620 /mysql-test/main/join_nested.test | |
| parent | 5e996fbad9e2326a197731c594c11ade8a3c2492 (diff) | |
| parent | 8bc9ee9571e19286f6706c38fb2afac13f9ea8a4 (diff) | |
| download | mariadb-git-f9bf41632e8ae9506a64d179e65a491317326eff.tar.gz | |
Merge branch 'bb-10.9-all-builders' into bb-10.10-all-builders
Diffstat (limited to 'mysql-test/main/join_nested.test')
| -rw-r--r-- | mysql-test/main/join_nested.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/main/join_nested.test b/mysql-test/main/join_nested.test index f0c6a9b65e0..bc87dab0054 100644 --- a/mysql-test/main/join_nested.test +++ b/mysql-test/main/join_nested.test @@ -1315,6 +1315,9 @@ DROP TABLE t1,t2,t3,t4,t5; --echo # MDEV-7992: Nested left joins + 'not exists' optimization --echo # +#view protocol gives different query plan (it doesnt' contain database name) +--disable_view_protocol + CREATE TABLE t1( K1 INT PRIMARY KEY, Name VARCHAR(15) @@ -1380,6 +1383,8 @@ eval EXPLAIN EXTENDED $q2; DROP VIEW v1; DROP TABLE t1,t2; +--enable_view_protocol + set optimizer_search_depth= @tmp_mdev621; --echo # |