diff options
| author | unknown <konstantin@mysql.com> | 2003-11-03 19:56:01 +0300 |
|---|---|---|
| committer | unknown <konstantin@mysql.com> | 2003-11-03 19:56:01 +0300 |
| commit | 22bc137c2ea9dbba8f2ce34f71a914534549ec8d (patch) | |
| tree | 30dc36a34ee5ba9b65edf101b7cbbfdb78ba0335 /mysql-test/r/select.result | |
| parent | 15cc0ad2ecfd9be44261f89cfe6d062f8a28e652 (diff) | |
| download | mariadb-git-22bc137c2ea9dbba8f2ce34f71a914534549ec8d.tar.gz | |
fix for bug #1724 'WHERE ... IN() optimizer behaviour
has changed since 4.0.14'
We need to calculate cost of RANGE
scan if it is present instead of cost of
FULL scan.
mysql-test/r/order_by.result:
more accurate row estimation
for RANGE scan
mysql-test/r/range.result:
added test case for bug #1724
'WHERE ... IN() optimizer behaviour has changed since 4.0.14'
mysql-test/r/select.result:
please ignore
mysql-test/t/range.test:
added test case for bug #1724
'WHERE ... IN() optimizer behaviour has changed since 4.0.14'
sql/sql_select.cc:
fix for bug #1724 'WHERE ... IN() optimizer behaviour
has changed since 4.0.14'
We need to calculate cost of RANGE
scan instead of cost of FULL scan
if RANGE is present
Few comments cleaned up.
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 09a4ffdb88b..9cc5ad76ff0 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -2136,10 +2136,10 @@ a a a select * from (t1 as t2 left join t1 as t3 using (a)) inner join t1 on t1.a>1; a a a 1 1 2 -2 2 2 -3 3 2 1 1 3 +2 2 2 2 2 3 +3 3 2 3 3 3 select * from t1 inner join (t1 as t2 left join t1 as t3 using (a)) on t1.a>1; a a a |