diff options
| author | Varun Gupta <varun.gupta@mariadb.com> | 2021-02-07 19:30:30 +0530 |
|---|---|---|
| committer | Varun Gupta <varun.gupta@mariadb.com> | 2021-02-09 03:31:02 +0530 |
| commit | 85ad3af57698f5c7f2f7759192fd3316767b0b95 (patch) | |
| tree | ab196bc3bd1842a557d80c37f2a59e06c3812620 /mysql-test/main/range.test | |
| parent | a5090ded52236bf372a6af7ff3ebaa4f78c2a544 (diff) | |
| download | mariadb-git-bb-10.6-varun.tar.gz | |
Enabling order by limit optimization by defaultbb-10.6-varun
Diffstat (limited to 'mysql-test/main/range.test')
| -rw-r--r-- | mysql-test/main/range.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/range.test b/mysql-test/main/range.test index 4f228e5dce3..677e1cefbdd 100644 --- a/mysql-test/main/range.test +++ b/mysql-test/main/range.test @@ -2247,7 +2247,7 @@ drop table t1,ten,t2; --echo # MDEV-15777: Use inferred IS NOT NULL predicates in the range optimizer --echo # -set @@optimizer_switch='not_null_range_scan=on'; +set @@optimizer_switch='not_null_range_scan=on,cost_based_order_by_limit=off'; create table ten(a int); insert into ten values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); |