diff options
| author | sergefp@mysql.com <> | 2005-04-21 01:55:33 +0400 |
|---|---|---|
| committer | sergefp@mysql.com <> | 2005-04-21 01:55:33 +0400 |
| commit | c2959178ca9c3eacbd59d854899ecdcdb7ff72de (patch) | |
| tree | e171a6c5adc44eafc57d6943052326006901c0a1 /mysql-test/r/range.result | |
| parent | ab0ff5349d72481c87646efbddfac98a714e3f67 (diff) | |
| download | mariadb-git-c2959178ca9c3eacbd59d854899ecdcdb7ff72de.tar.gz | |
Fix for BUG#10037
* Add 0.01 to cost of 'range'+'using index' scan to avoid optimizer choice races with
'index' scan.
Diffstat (limited to 'mysql-test/r/range.result')
| -rw-r--r-- | mysql-test/r/range.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/range.result b/mysql-test/r/range.result index 256c4ee6431..fea5754d704 100644 --- a/mysql-test/r/range.result +++ b/mysql-test/r/range.result @@ -256,12 +256,12 @@ INSERT INTO t2 VALUES (0),(0),(1),(1),(2),(2); explain select * from t1, t2 where (t1.key1 <t2.keya + 1) and t2.keya=3; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 ref j1 j1 4 const 1 Using index -1 SIMPLE t1 range i1 i1 4 NULL 7 Using where; Using index +1 SIMPLE t1 index i1 i1 4 NULL 7 Using where; Using index explain select * from t1 force index(i1), t2 force index(j1) where (t1.key1 <t2.keya + 1) and t2.keya=3; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 ref j1 j1 4 const 1 Using index -1 SIMPLE t1 range i1 i1 4 NULL 7 Using where; Using index +1 SIMPLE t1 index i1 i1 4 NULL 7 Using where; Using index DROP TABLE t1,t2; CREATE TABLE t1 ( a int(11) default NULL, |