~drizzle-trunk/drizzle/development

Removal of SJ

added added

removed removed

123

1 PRIMARY t2 ALL DDOCTYPEID_IDX NULL NULL NULL 9 Using where

124

1 PRIMARY t1 eq_ref PRIMARY PRIMARY 130 test.t2.DOCID 1

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

drop table t1, t2, t3, t4;

132

CREATE TABLE t1 (a int, PRIMARY KEY (a)) Engine=InnoDB;

133

INSERT INTO t1 VALUES (1),(2);