diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2022-11-03 11:47:10 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2022-11-03 11:47:10 +0100 |
| commit | f8997c68fe645cc94f6730a135aca5e530dec449 (patch) | |
| tree | b3d607eb1a106a16b900d7da6af81a60332a7584 /mysql-test/main/range.result | |
| parent | 49a22c5897823c528d52886f6048d5b4c91e221f (diff) | |
| parent | acf8dc0a577f8fed2d059c033f4efbd07dd95ac0 (diff) | |
| download | mariadb-git-mariadb-10.10.2.tar.gz | |
Merge branch '10.9' into 10.10mariadb-10.10.2
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 9edf7c5a070..2fc6fbde38c 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|filter a,b a|b 5|5 NULL 2 (41%) Using index condition; Using where; Using rowid filter SELECT * FROM t1 WHERE a IN(1,2) AND b=5; a b DROP TABLE t1; |