~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/join_nested.result

  • Committer: Monty Taylor
  • Date: 2008-09-13 20:24:20 UTC
  • mfrom: (383.1.35 drizzle)
  • Revision ID: monty@inaugust.com-20080913202420-lkj76ewbabl8ljvp
MergedĀ fromĀ trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
1502
1502
ON t4.carrier = t1.carrier;
1503
1503
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
1504
1504
1       SIMPLE  t1      ALL     PRIMARY NULL    NULL    NULL    36      
1505
 
1       SIMPLE  t4      eq_ref  PRIMARY,id      PRIMARY 4       test.t1.carrier 1       
 
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
1507
1       SIMPLE  t2      ref     package_id      package_id      5       test.t1.id      1       Using index
1508
1508
1       SIMPLE  t3      ref     package_id      package_id      5       test.t1.id      1       Using index