diff options
author | unknown <bell@sanja.is.com.ua> | 2003-09-14 09:40:57 +0300 |
---|---|---|
committer | unknown <bell@sanja.is.com.ua> | 2003-09-14 09:40:57 +0300 |
commit | 0f019a581de3c832e576931f29d36334fb94a2b8 (patch) | |
tree | 4e8998f81b215aeef78c383cccc792965ff6b411 /mysql-test/r/subselect2.result | |
parent | 1179d87a38d5f96b9dec23e7944c341cdd1cbf51 (diff) | |
download | mariadb-git-0f019a581de3c832e576931f29d36334fb94a2b8.tar.gz |
renamed join_types (as was suggested by Peter Gulutzan)
Diffstat (limited to 'mysql-test/r/subselect2.result')
-rw-r--r-- | mysql-test/r/subselect2.result | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/r/subselect2.result b/mysql-test/r/subselect2.result index c387d8b2d76..98df44553d2 100644 --- a/mysql-test/r/subselect2.result +++ b/mysql-test/r/subselect2.result @@ -123,9 +123,9 @@ id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 system PRIMARY NULL NULL NULL 0 const row not found 1 PRIMARY t2 ALL DDOCTYPEID_IDX NULL NULL NULL 9 Using where 1 PRIMARY t4 eq_ref PRIMARY PRIMARY 32 test.t2.DOCTYPEID 1 -2 DEPENDENT SUBQUERY t3 simple_in PRIMARY,FFOLDERID_IDX PRIMARY 32 func 1 Using index; Using where -3 DEPENDENT SUBQUERY t3 simple_in PRIMARY,FFOLDERID_IDX PRIMARY 32 func 1 Using index; Using where -4 DEPENDENT SUBQUERY t3 simple_in PRIMARY,FFOLDERID_IDX PRIMARY 32 func 1 Using index; Using where -5 DEPENDENT SUBQUERY t3 simple_in PRIMARY,FFOLDERID_IDX PRIMARY 32 func 1 Using index; Using where -6 DEPENDENT SUBQUERY t3 simple_in PRIMARY,FFOLDERID_IDX,CMFLDRPARNT_IDX PRIMARY 32 func 1 Using index; Using where +2 DEPENDENT SUBQUERY t3 unique_subquery PRIMARY,FFOLDERID_IDX PRIMARY 32 func 1 Using index; Using where +3 DEPENDENT SUBQUERY t3 unique_subquery PRIMARY,FFOLDERID_IDX PRIMARY 32 func 1 Using index; Using where +4 DEPENDENT SUBQUERY t3 unique_subquery PRIMARY,FFOLDERID_IDX PRIMARY 32 func 1 Using index; Using where +5 DEPENDENT SUBQUERY t3 unique_subquery PRIMARY,FFOLDERID_IDX PRIMARY 32 func 1 Using index; Using where +6 DEPENDENT SUBQUERY t3 unique_subquery PRIMARY,FFOLDERID_IDX,CMFLDRPARNT_IDX PRIMARY 32 func 1 Using index; Using where drop table t1, t2, t3, t4; |