diff options
| author | Lena Startseva <lena.startseva@mariadb.com> | 2022-09-23 19:47:13 +0700 |
|---|---|---|
| committer | Lena Startseva <lena.startseva@mariadb.com> | 2022-09-23 19:47:13 +0700 |
| commit | 78dcf71e88c86772f89f4ae788079c3619a4d38c (patch) | |
| tree | 8557a5777219e4e06c15a53ab5633f7ca52b3123 /mysql-test/main/selectivity.test | |
| parent | 0c0a56902898038726342ae11decf4bf5421d339 (diff) | |
| parent | 72ba96a48eb3e99a967e0489cc79f378e865e3fd (diff) | |
| download | mariadb-git-78dcf71e88c86772f89f4ae788079c3619a4d38c.tar.gz | |
Merge branch 'bb-10.3-all-builders' into bb-10.4-all-builders
Diffstat (limited to 'mysql-test/main/selectivity.test')
| -rw-r--r-- | mysql-test/main/selectivity.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/selectivity.test b/mysql-test/main/selectivity.test index 1d96dc0bf80..97e2ae4f2bd 100644 --- a/mysql-test/main/selectivity.test +++ b/mysql-test/main/selectivity.test @@ -848,7 +848,7 @@ create table t2 (c int, d int, key(c), key(d)) engine=myisam; insert t2 select floor(rand()*1e5/2)*2, floor(rand()*1e5/3)*3 from t1; analyze table t1,t2; - +--disable_view_protocol set optimizer_use_condition_selectivity=1; explain extended select * from t1, t2, t1 as t3 @@ -864,7 +864,7 @@ select * from t1, t2, t1 as t3 --sorted_result select * from t1, t2, t1 as t3 where t1.b=t2.c and t2.d=t3.a and t3.b<5 and t1.a < 2000; - +--enable_view_protocol set optimizer_use_condition_selectivity=@save_optimizer_use_condition_selectivity; drop table t1,t2; |