← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/subselect3.result

  • Committer: Brian Aker
  • Date: 2009-07-29 07:29:19 UTC
  • mfrom: (1103.1.4 merge)
  • Revision ID: brian@gaz-20090729072919-1pv9yqddtpoljgia
Merge of SJ code.

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