~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/subselect3.result

  • Committer: Monty Taylor
  • Date: 2010-12-02 22:51:54 UTC
  • mto: (1975.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 1976.
  • Revision ID: mordred@inaugust.com-20101202225154-h54ifmga9x6cckgs
Refactored syslog module and changed it to use sys_var directly.

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