diff options
| author | unknown <kostja@oak.local> | 2003-09-15 22:21:39 +0400 |
|---|---|---|
| committer | unknown <kostja@oak.local> | 2003-09-15 22:21:39 +0400 |
| commit | db03c7e89f6ff78f04bbab2fdc3b136525fdb8e3 (patch) | |
| tree | e525d94eb1ae909e6f88230278d3c4814cbc939d /mysql-test/r/select_safe.result | |
| parent | cdbc2fe43a0d9d19bdaec304d841fe45e3e91551 (diff) | |
| download | mariadb-git-db03c7e89f6ff78f04bbab2fdc3b136525fdb8e3.tar.gz | |
Fixed bug in the optimiser for FULL TABLE SCAN case:
to estimate correctly cost of full table scan we should take into
account rows read and skipped on each iteration.
mysql-test/r/distinct.result:
Fixed test suite: now full scan is used
less often
mysql-test/r/join_outer.result:
Fixed test suite: now full scan is used
less often
mysql-test/r/select_safe.result:
Fixed test suite: now full scan is used
less often
Diffstat (limited to 'mysql-test/r/select_safe.result')
| -rw-r--r-- | mysql-test/r/select_safe.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/select_safe.result b/mysql-test/r/select_safe.result index c4e5984d360..1ee1368d029 100644 --- a/mysql-test/r/select_safe.result +++ b/mysql-test/r/select_safe.result @@ -70,7 +70,7 @@ insert into t1 values (null,"a"),(null,"a"),(null,"a"),(null,"a"),(null,"a"),(nu explain select STRAIGHT_JOIN * from t1,t1 as t2 where t1.b=t2.b; table type possible_keys key key_len ref rows Extra t1 ALL b NULL NULL NULL 21 -t2 ALL b NULL NULL NULL 16 Using where +t2 ref b b 21 t1.b 6 Using where set MAX_SEEKS_FOR_KEY=1; explain select STRAIGHT_JOIN * from t1,t1 as t2 where t1.b=t2.b; table type possible_keys key key_len ref rows Extra |