← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/subselect3.result

  • Committer: Lee Bieber
  • Date: 2010-11-07 19:34:48 UTC
  • mfrom: (1910.1.2 build)
  • Revision ID: kalebral@gmail.com-20101107193448-64kdu912qej354sh
Merge Stewart - including adapting and expanding the "differences from mysql" page from the wiki.
Merge Stewart - fix bug 668143: drizzleslap with --commit runs second iteration data load in a transaction

Show diffs side-by-side

added added

removed removed

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