diff options
| author | unknown <sergefp@mysql.com> | 2005-04-21 01:55:33 +0400 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2005-04-21 01:55:33 +0400 |
| commit | a52359e00ccff887f9607c37715f495296c033e5 (patch) | |
| tree | e171a6c5adc44eafc57d6943052326006901c0a1 /mysql-test/r/range.result | |
| parent | 241bedadeb19d6d08976a915c0c958eadd51c5c6 (diff) | |
| download | mariadb-git-a52359e00ccff887f9607c37715f495296c033e5.tar.gz | |
Fix for BUG#10037
* Add 0.01 to cost of 'range'+'using index' scan to avoid optimizer choice races with
'index' scan.
mysql-test/r/range.result:
Update the test result after the changed cost
sql/opt_range.cc:
Fix for BUG#10037
* Add 0.01 to cost of 'range'+'using index' scan to avoid optimizer choice races with
'index' scan.
* make QUICK_GROUP_MIN_MAX_SELECT handle the case where the source table is empty.
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, |