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/heap.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/heap.result')
| -rw-r--r-- | mysql-test/r/heap.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/heap.result b/mysql-test/r/heap.result index d8905085e34..a04ddf3f302 100644 --- a/mysql-test/r/heap.result +++ b/mysql-test/r/heap.result @@ -166,7 +166,7 @@ alter table t1 add column new_col char(1) not null, add key (btn,new_col), drop update t1 set new_col=btn; explain select * from t1 where btn="a"; table type possible_keys key key_len ref rows Extra -t1 ALL btn NULL NULL NULL 14 Using where +t1 ALL btn NULL NULL NULL 11 Using where explain select * from t1 where btn="a" and new_col="a"; table type possible_keys key key_len ref rows Extra t1 ref btn btn 11 const,const 10 Using where |