diff options
author | Sergei Petrunia <sergey@mariadb.com> | 2023-02-02 17:12:39 +0200 |
---|---|---|
committer | Sergei Petrunia <sergey@mariadb.com> | 2023-02-02 17:35:34 +0200 |
commit | 8f08993816978cf9225040c12964bd6c24a4f754 (patch) | |
tree | 71b386a63f5e677e4cf12376639a9879cab23214 /mysql-test/main/range.result | |
parent | 3137f694ce2dffd1d6319ef75bb4aae200e18360 (diff) | |
download | mariadb-git-8f08993816978cf9225040c12964bd6c24a4f754.tar.gz |
MDEV-30218: Incorrect optimization for rowid_filtering, correctionbb-10.4-release-mdev30218
Final corrections:
- Remove incorrect tracing, "rowid_filter_skipped"
- Put the worst_seeks sanity check back
Diffstat (limited to 'mysql-test/main/range.result')
-rw-r--r-- | mysql-test/main/range.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/range.result b/mysql-test/main/range.result index 0e728d76a3e..a3ce10fe38a 100644 --- a/mysql-test/main/range.result +++ b/mysql-test/main/range.result @@ -281,7 +281,7 @@ INSERT INTO t1 VALUES (33,5),(33,5),(33,5),(33,5),(34,5),(35,5); EXPLAIN SELECT * FROM t1 WHERE a IN(1,2) AND b=5; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref|filter a,b b|a 5|5 const 15 (5%) Using where; Using rowid filter +1 SIMPLE t1 range a,b a 5 NULL 2 Using index condition; Using where SELECT * FROM t1 WHERE a IN(1,2) AND b=5; a b DROP TABLE t1; |