~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/subselect_sj.result

  • Committer: Stewart Smith
  • Date: 2009-10-08 05:39:17 UTC
  • mto: This revision was merged to the branch mainline in revision 1179.
  • Revision ID: stewart@flamingspork.com-20091008053917-b7u3opyo8997438r
remove unused find_string_in_array

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