From 699291a8e68b94cdfdc0cc2c9b865d736d808017 Mon Sep 17 00:00:00 2001 From: "sergefp@mysql.com" <> Date: Fri, 28 Jul 2006 21:27:01 +0400 Subject: 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 --- mysql-test/r/func_crypt.result | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'mysql-test/r/func_crypt.result') diff --git a/mysql-test/r/func_crypt.result b/mysql-test/r/func_crypt.result index afdec0f4d06..32377c9ba63 100644 --- a/mysql-test/r/func_crypt.result +++ b/mysql-test/r/func_crypt.result @@ -88,8 +88,8 @@ select old_password(' i d k f a '); old_password(' i d k f a ') 5c078dc54ca0fcca explain extended select password('idkfa '), old_password('idkfa'); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL No tables used +id select_type table type possible_keys key key_len ref rows filtered Extra +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used Warnings: Note 1003 select password(_latin1'idkfa ') AS `password('idkfa ')`,old_password(_latin1'idkfa') AS `old_password('idkfa')` select encrypt('1234','_.'); -- cgit v1.2.1