~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/subselect3.result

  • Committer: Lee Bieber
  • Date: 2010-12-23 23:11:00 UTC
  • mfrom: (2024.1.1 clean)
  • Revision ID: kalebral@gmail.com-20101223231100-0rqirgz7ugkl10yp
Merge Brian - session list cleanup

Show diffs side-by-side

added added

removed removed

Lines of Context:
247
247
NULL    1       100     0
248
248
NULL    2       100     NULL
249
249
create table t4 (x int);
250
 
insert into t4 select A.a + 10*B.a from t1 A CROSS JOIN t1 B;
 
250
insert into t4 select A.a + 10*B.a from t1 A, t1 B;
251
251
explain extended 
252
252
select a,b, oref, 
253
253
(a,b) in (select a,b from t1,t4 where c=t2.oref) Z