← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/subselect_sj.result

  • Committer: patrick crews
  • Date: 2010-09-29 15:15:19 UTC
  • mfrom: (1099.4.188 drizzle)
  • Revision ID: gleebix@gmail.com-20100929151519-6mrmzd1ciw2p9nws
Tags: 2010.09.1802
Update translations

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/subselect_sj.result
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