diff options
| author | monty@mashka.mysql.fi <> | 2003-06-27 03:04:54 +0300 |
|---|---|---|
| committer | monty@mashka.mysql.fi <> | 2003-06-27 03:04:54 +0300 |
| commit | 34919a03c4d0d17e6bb5f11fab53366ee04ea7f9 (patch) | |
| tree | 6fef037dd6b940bf2ed11b3042a97c08dc6b364c /mysql-test/r/key_diff.result | |
| parent | 5f556f11e0e0ef0daefd41829cd400cc7addb583 (diff) | |
| download | mariadb-git-34919a03c4d0d17e6bb5f11fab53366ee04ea7f9.tar.gz | |
Added thread variable max_seeks_for_key
Change optimizer to prefer key lookups before table scan
Change table scans to be done after tables with constrains on scanned table
Diffstat (limited to 'mysql-test/r/key_diff.result')
| -rw-r--r-- | mysql-test/r/key_diff.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/key_diff.result b/mysql-test/r/key_diff.result index 4eaccc696f9..2d4bc19474f 100644 --- a/mysql-test/r/key_diff.result +++ b/mysql-test/r/key_diff.result @@ -36,7 +36,7 @@ a a a a explain select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B; table type possible_keys key key_len ref rows Extra t1 ALL a NULL NULL NULL 5 -t2 ALL b NULL NULL NULL 5 Using where +t2 ALL b NULL NULL NULL 4 Using where select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B order by binary t1.a,t2.a; a b a b A B a a |