← Back to branch summary

~vkolesnikov/pbxt/pbxt-preload-test-bug

« back to all changes in this revision

Viewing changes to pbxt/mysql-test-update/mysql-test/r/key_diff.result

  • Committer: paul-mccullagh
  • Date: 2008-03-10 11:36:34 UTC
  • Revision ID: paul-mccullagh-417ebf175a9c8ee6e5b3777d9e2398e1fb197391
Implemented full durability

Show diffs side-by-side

added added

removed removed

Lines of Context:
pbxt/mysql-test-update/mysql-test/r/key_diff.result
36
36
explain select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B;
37
37
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
38
38
1       SIMPLE  t1      ALL     a       NULL    NULL    NULL    5       
39
 
1       SIMPLE  t2      ALL     b       NULL    NULL    NULL    5       Using where
 
39
1       SIMPLE  t2      ALL     b       NULL    NULL    NULL    5       Using where; Using join buffer
40
40
select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B order by binary t1.a,t2.a;
41
41
a       b       a       b
42
42
A       B       a       a