diff options
| author | unknown <tomas@poseidon.ndb.mysql.com> | 2004-10-07 08:42:11 +0000 |
|---|---|---|
| committer | unknown <tomas@poseidon.ndb.mysql.com> | 2004-10-07 08:42:11 +0000 |
| commit | 1f43673426eedf15809dd47c27b46bf8f1955c3f (patch) | |
| tree | d98c614f86a1df7fb6bed57da0c3f2d645812bc9 /mysql-test/r/ndb_subquery.result | |
| parent | 10cd526ded91311fbb183510d54363c481cd997f (diff) | |
| download | mariadb-git-1f43673426eedf15809dd47c27b46bf8f1955c3f.tar.gz | |
adder order by
Diffstat (limited to 'mysql-test/r/ndb_subquery.result')
| -rw-r--r-- | mysql-test/r/ndb_subquery.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/ndb_subquery.result b/mysql-test/r/ndb_subquery.result index 8c89805a765..f65f09b71b3 100644 --- a/mysql-test/r/ndb_subquery.result +++ b/mysql-test/r/ndb_subquery.result @@ -10,7 +10,7 @@ explain select * from t2 where p NOT IN (select p from t1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t2 ALL NULL NULL NULL NULL 5 Using where 2 DEPENDENT SUBQUERY t1 unique_subquery PRIMARY PRIMARY 4 func 1 Using index -select * from t2 where p NOT IN (select p from t1); +select * from t2 where p NOT IN (select p from t1) order by p; p u o 4 4 4 5 5 5 @@ -18,7 +18,7 @@ explain select * from t2 where p NOT IN (select u from t1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t2 ALL NULL NULL NULL NULL 5 Using where 2 DEPENDENT SUBQUERY t1 unique_subquery u u 4 func 1 Using index -select * from t2 where p NOT IN (select u from t1); +select * from t2 where p NOT IN (select u from t1) order by p; p u o 4 4 4 5 5 5 @@ -26,7 +26,7 @@ explain select * from t2 where p NOT IN (select o from t1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t2 ALL NULL NULL NULL NULL 5 Using where 2 DEPENDENT SUBQUERY t1 index_subquery o o 4 func 1 Using index -select * from t2 where p NOT IN (select o from t1); +select * from t2 where p NOT IN (select o from t1) order by p; p u o 4 4 4 5 5 5 @@ -34,7 +34,7 @@ explain select * from t2 where p NOT IN (select p+0 from t1); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t2 ALL NULL NULL NULL NULL 5 Using where 2 DEPENDENT SUBQUERY t1 ALL NULL NULL NULL NULL 3 Using where -select * from t2 where p NOT IN (select p+0 from t1); +select * from t2 where p NOT IN (select p+0 from t1) order by p; p u o 4 4 4 5 5 5 |