~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/subselect_sj.result

Merge Stewart's dead code removal

Show diffs side-by-side

added added

removed removed

Lines of Context:
70
70
0       0       0       0
71
71
1       1       1       1
72
72
2       2       2       2
73
 
insert into t1 select (A.a + 10 * B.a),1 from t0 A CROSS JOIN t0 B;
 
73
insert into t1 select (A.a + 10 * B.a),1 from t0 A, t0 B;
74
74
explain extended select * from t1 where a in (select pk from t10 where pk<3);
75
75
id      select_type     table   type    possible_keys   key     key_len ref     rows    filtered        Extra
76
76
1       PRIMARY t1      ALL     NULL    NULL    NULL    NULL    103     100.00  Using where