diff options
| author | sergefp@mysql.com <> | 2006-07-28 21:27:01 +0400 |
|---|---|---|
| committer | sergefp@mysql.com <> | 2006-07-28 21:27:01 +0400 |
| commit | 699291a8e68b94cdfdc0cc2c9b865d736d808017 (patch) | |
| tree | 43dd1049a05d7e894a1de909d7f8cf4eff44540a /mysql-test/r/func_default.result | |
| parent | 1459784aba4bbf11fdc18d73ccc9f4cc735edbcd (diff) | |
| download | mariadb-git-699291a8e68b94cdfdc0cc2c9b865d736d808017.tar.gz | |
BUG#14940 "MySQL choose wrong index", v.2
- Make the range-et-al optimizer produce E(#table records after table
condition is applied),
- Make the join optimizer use this value,
- Add "filtered" column to EXPLAIN EXTENDED to show
fraction of records left after table condition is applied
- Adjust test results, add comments
Diffstat (limited to 'mysql-test/r/func_default.result')
| -rw-r--r-- | mysql-test/r/func_default.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/func_default.result b/mysql-test/r/func_default.result index 5742ddd102b..7f1e53b00e0 100644 --- a/mysql-test/r/func_default.result +++ b/mysql-test/r/func_default.result @@ -5,8 +5,8 @@ select default(str), default(strnull), default(intg), default(rel) from t1; default(str) default(strnull) default(intg) default(rel) def NULL 10 3.14 explain extended select default(str), default(strnull), default(intg), default(rel) from t1; -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 system NULL NULL NULL NULL 1 +id select_type table type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 system NULL NULL NULL NULL 1 100.00 Warnings: Note 1003 select default(`test`.`t1`.`str`) AS `default(str)`,default(`test`.`t1`.`strnull`) AS `default(strnull)`,default(`test`.`t1`.`intg`) AS `default(intg)`,default(`test`.`t1`.`rel`) AS `default(rel)` from `test`.`t1` select * from t1 where str <> default(str); |