diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2016-09-24 15:27:56 +0300 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2016-09-24 15:27:56 +0300 |
| commit | a95e384d5470253cae46aa6fd6869e887de081ab (patch) | |
| tree | 39a070c9ce32201d98d84279c4c7582d4677467e /mysql-test/r/select.result | |
| parent | 457f3b99413e50c7cf393b06a86483e1854d86c8 (diff) | |
| download | mariadb-git-a95e384d5470253cae46aa6fd6869e887de081ab.tar.gz | |
MDEV-10174: Make the fix for MDEV-8989 enabled by default in 10.2
- Change the default @@optimizer_switch value
- Adjust the testcases
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 5a8b52521cb..f8ff343e8bb 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -606,7 +606,7 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t3 eq_ref PRIMARY PRIMARY 4 test.t2.fld1 1 Using where; Using index explain select * from t3 as t1,t3 where t1.period=t3.period order by t3.period; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL period NULL NULL NULL 41810 Using temporary; Using filesort +1 SIMPLE t1 ALL period NULL NULL NULL 41810 Using filesort 1 SIMPLE t3 ref period period 4 test.t1.period 4181 explain select * from t3 as t1,t3 where t1.period=t3.period order by t3.period limit 10; id select_type table type possible_keys key key_len ref rows Extra |