← Back to branch summary

~posulliv/drizzle/memcached_applier

« back to all changes in this revision

Viewing changes to tests/r/subselect3.result

  • Committer: Jay Pipes
  • Date: 2009-08-03 14:23:22 UTC
  • mfrom: (1039.2.68 staging)
  • mto: This revision was merged to the branch mainline in revision 1078.
  • Revision ID: jpipes@serialcoder-20090803142322-1g67h7su9mocg9ig
Merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/subselect3.result
99
99
1       1
100
100
show status like '%Handler_read_rnd_next';
101
101
Variable_name   Value
102
 
Handler_read_rnd_next   11
 
102
Handler_read_rnd_next   5
103
103
delete from t2;
104
104
insert into t2 values (NULL, 0),(NULL, 0), (NULL, 0), (NULL, 0);
105
105
flush status;
515
515
dd      1       NULL    0
516
516
select oref, a, b from t2 where (a,b) in (select ie1,ie2 from t1 where oref=t2.oref);
517
517
oref    a       b
 
518
ff      2       2
518
519
aa      1       1
519
 
ff      2       2
520
520
select oref, a, b from t2 where (a,b) not in (select ie1,ie2 from t1 where oref=t2.oref);
521
521
oref    a       b
522
522
bb      2       1
560
560
dd      1       NULL    0
561
561
select oref, a, b from t2 where (a,b) in (select ie1,ie2 from t1 where oref=t2.oref);
562
562
oref    a       b
 
563
ff      2       2
563
564
aa      1       1
564
 
ff      2       2
565
565
select oref, a, b from t2 where (a,b) not in (select ie1,ie2 from t1 where oref=t2.oref);
566
566
oref    a       b
567
567
bb      2       1