← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_str.result

  • Committer: Stewart Smith
  • Date: 2010-12-02 04:36:22 UTC
  • mto: (2021.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 1971.
  • Revision ID: stewart@flamingspork.com-20101202043622-vxiij48ug09z7h1u
EXPLAIN in test result changes due to modified InnoDB stats

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/func_str.result
833
833
WHERE id='a12' AND (LENGTH(code)=5 OR code < 'a00');
834
834
id      select_type     table   type    possible_keys   key     key_len ref     rows    filtered        Extra
835
835
1       SIMPLE  t2      const   PRIMARY PRIMARY 42      const   1       100.00  Using index
836
 
1       SIMPLE  t1      ref     code    code    43      const   2       100.00  Using where; Using index
 
836
1       SIMPLE  t1      ref     code    code    43      const   4       100.00  Using where; Using index
837
837
Warnings:
838
838
Note    1003    select `test`.`t1`.`code` AS `code`,'a12' AS `id` from `test`.`t1` join `test`.`t2` where ((`test`.`t1`.`code` = 'a12') and <cache>(('a12' = 'a12')) and ((length(`test`.`t1`.`code`) = 5) or <cache>(('a12' < 'a00'))))
839
839
DROP TABLE t1,t2;