← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/join_nested.result

Merged build changes from Antony.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/join_nested.result
1470
1470
(231063394),(231063424),(231063454),(231063514),(231063574),(231063664);
1471
1471
CREATE TABLE t4 (
1472
1472
carrier char(2) NOT NULL default '' PRIMARY KEY,
1473
 
id int(11) default NULL,
 
1473
id int default NULL,
1474
1474
INDEX id(id)
1475
1475
);
1476
1476
INSERT INTO t4 VALUES
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 2       test.t1.carrier 1       
 
1505
1       SIMPLE  t4      eq_ref  PRIMARY,id      PRIMARY 4       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