← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/join_nested.result

  • Committer: Joseph Daly
  • Date: 2010-08-19 01:17:00 UTC
  • mfrom: (1718 drizzle)
  • mto: (1725.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 1726.
  • Revision ID: jdaly@rx7-20100819011700-zmv90s31dfjex4vu
merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/join_nested.result
1054
1054
(t8.b=t9.b OR t8.c IS NULL) AND
1055
1055
(t9.a=1);
1056
1056
id      select_type     table   type    possible_keys   key     key_len ref     rows    filtered        Extra
1057
 
1       SIMPLE  t0      ref     idx_a   idx_a   5       const   1       100.00  
1058
 
1       SIMPLE  t1      ref     idx_b   idx_b   5       test.t0.b       1       100.00  
 
1057
1       SIMPLE  t0      ref     idx_a   idx_a   5       const   1       100.00  Using where
 
1058
1       SIMPLE  t1      ref     idx_b   idx_b   5       test.t0.b       1       100.00  Using where
1059
1059
1       SIMPLE  t2      ALL     NULL    NULL    NULL    NULL    3       100.00  Using where
1060
1060
1       SIMPLE  t4      ref     idx_b   idx_b   5       test.t2.b       1       100.00  
1061
1061
1       SIMPLE  t3      ALL     NULL    NULL    NULL    NULL    2       100.00  Using where
1504
1504
1       SIMPLE  t1      ALL     PRIMARY NULL    NULL    NULL    36      
1505
1505
1       SIMPLE  t4      eq_ref  PRIMARY,id      PRIMARY 10      test.t1.carrier 1       
1506
1506
1       SIMPLE  t5      ref     carrier_id      carrier_id      5       test.t4.id      1       Using index
1507
 
1       SIMPLE  t2      ref     package_id      package_id      5       test.t1.id      1       Using index
1508
 
1       SIMPLE  t3      ref     package_id      package_id      5       test.t1.id      1       Using index
 
1507
1       SIMPLE  t2      ref     package_id      package_id      5       test.t1.id      1       Using where; Using index
 
1508
1       SIMPLE  t3      ref     package_id      package_id      5       test.t1.id      1       Using where; Using index
1509
1509
SELECT COUNT(*) 
1510
1510
FROM ((t2 JOIN t1 ON t2.package_id = t1.id) 
1511
1511
JOIN t3 ON t3.package_id = t1.id)