diff options
| author | Varun Gupta <varunraiko1803@gmail.com> | 2018-05-31 15:51:59 +0530 |
|---|---|---|
| committer | Varun Gupta <varunraiko1803@gmail.com> | 2018-11-07 13:17:05 +0530 |
| commit | 5915a7d6ad347b09783968ca7a7b62cb21d73871 (patch) | |
| tree | ed4a535916ad46269c67644bbc487f04e03ad529 /mysql-test/main/range.test | |
| parent | 41e68e8e5b3ce89c61f19bf072b59cf13a6fdc16 (diff) | |
| download | mariadb-git-10.4-selectivty4.tar.gz | |
MDEV-15253: Default optimizer setting changes for MariaDB 10.410.4-selectivty4
Diffstat (limited to 'mysql-test/main/range.test')
| -rw-r--r-- | mysql-test/main/range.test | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/mysql-test/main/range.test b/mysql-test/main/range.test index bd2299bac5f..df5b17b47de 100644 --- a/mysql-test/main/range.test +++ b/mysql-test/main/range.test @@ -1892,9 +1892,7 @@ insert into t2 values (6,5,'f'), (6,3,'g'), (6,7,'h'), (3,3,'i'), (6,2,'j'), (9,5,'aa'), (9,8,'ba'), (9,3,'ca'), (2,2,'da'), (9,1,'ea'), (6,5,'fa'), (6,3,'ga'), (6,7,'ha'), (9,3,'ia'), (6,2,'ja'); - ---echo # join order: (t2,t1) with ref access of t1 ---echo # range access to t1 by keys for index idx1 + let $q4= select * from t1,t2 where a = d and (a,e) in ((3,3),(7,7),(2,2)); |