diff options
| author | unknown <gkodinov@dl145s.mysql.com> | 2006-09-18 18:30:51 +0400 |
|---|---|---|
| committer | unknown <gkodinov@dl145s.mysql.com> | 2006-09-18 18:30:51 +0400 |
| commit | 379226c2fd02ce3eeec04b5ef3217719d8213ce9 (patch) | |
| tree | 5d9c18734ec29a0f0a7805e0e42719eaaf6c9ba6 /mysql-test/r/func_str.result | |
| parent | 5222b59093bfd3d6055ff4d375f450c4468a7366 (diff) | |
| download | mariadb-git-379226c2fd02ce3eeec04b5ef3217719d8213ce9.tar.gz | |
merge fixes
Diffstat (limited to 'mysql-test/r/func_str.result')
| -rw-r--r-- | mysql-test/r/func_str.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index f99847a679a..4d31b2ba496 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -1142,9 +1142,9 @@ A12 a12 EXPLAIN EXTENDED SELECT * FROM t1 INNER JOIN t2 ON code=id WHERE id='a12' AND (LENGTH(code)=5 OR code < 'a00'); -id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref code code 13 const 3 Using where; Using index -1 SIMPLE t2 ref PRIMARY PRIMARY 12 const 1 Using where; Using index +id select_type table type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 ref code code 13 const 3 100.00 Using where; Using index +1 SIMPLE t2 ref PRIMARY PRIMARY 12 const 1 100.00 Using where; Using index Warnings: Note 1003 select `test`.`t1`.`code` AS `code`,`test`.`t2`.`id` AS `id` from `test`.`t1` join `test`.`t2` where ((`test`.`t1`.`code` = _latin1'a12') and (`test`.`t2`.`id` = _latin1'a12') and (length(`test`.`t1`.`code`) = 5)) DROP TABLE t1,t2; |