← Back to branch summary

~posulliv/drizzle/memcached_applier

« back to all changes in this revision

Viewing changes to tests/r/subselect2.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/subselect2.result
123
123
1       PRIMARY t2      ALL     DDOCTYPEID_IDX  NULL    NULL    NULL    9       Using where
124
124
1       PRIMARY t1      eq_ref  PRIMARY PRIMARY 130     test.t2.DOCID   1       
125
125
1       PRIMARY t4      eq_ref  PRIMARY PRIMARY 130     test.t2.DOCTYPEID       1       
126
 
2       DEPENDENT SUBQUERY      t3      eq_ref  PRIMARY,FFOLDERID_IDX,CMFLDRPARNT_IDX   PRIMARY 130     func    1       Using where
127
 
2       DEPENDENT SUBQUERY      t3      eq_ref  PRIMARY,FFOLDERID_IDX,CMFLDRPARNT_IDX   PRIMARY 130     test.t3.PARENTID        1       Using where
128
 
2       DEPENDENT SUBQUERY      t3      eq_ref  PRIMARY,FFOLDERID_IDX,CMFLDRPARNT_IDX   PRIMARY 130     test.t3.PARENTID        1       Using where
129
 
2       DEPENDENT SUBQUERY      t3      eq_ref  PRIMARY,FFOLDERID_IDX,CMFLDRPARNT_IDX   PRIMARY 130     test.t3.PARENTID        1       Using where
130
 
2       DEPENDENT SUBQUERY      t3      eq_ref  PRIMARY,FFOLDERID_IDX,CMFLDRPARNT_IDX   PRIMARY 130     test.t3.PARENTID        1       Using where
 
126
2       SUBQUERY        t3      ALL     NULL    NULL    NULL    NULL    21      Using where
 
127
3       SUBQUERY        t3      ALL     NULL    NULL    NULL    NULL    21      Using where
 
128
4       SUBQUERY        t3      ALL     NULL    NULL    NULL    NULL    21      Using where
 
129
5       SUBQUERY        t3      ALL     NULL    NULL    NULL    NULL    21      Using where
 
130
6       SUBQUERY        t3      ref     CMFLDRPARNT_IDX CMFLDRPARNT_IDX 131     const   6       Using where
131
131
drop table t1, t2, t3, t4;
132
132
CREATE TABLE t1 (a int, PRIMARY KEY (a)) Engine=InnoDB;
133
133
INSERT INTO t1 VALUES (1),(2);