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/t/ndb_subquery.test | |
| parent | 10cd526ded91311fbb183510d54363c481cd997f (diff) | |
| download | mariadb-git-1f43673426eedf15809dd47c27b46bf8f1955c3f.tar.gz | |
adder order by
Diffstat (limited to 'mysql-test/t/ndb_subquery.test')
| -rw-r--r-- | mysql-test/t/ndb_subquery.test | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/t/ndb_subquery.test b/mysql-test/t/ndb_subquery.test index e80d9b16b46..cebc1920eaa 100644 --- a/mysql-test/t/ndb_subquery.test +++ b/mysql-test/t/ndb_subquery.test @@ -18,19 +18,19 @@ insert into t2 values (1,1,1),(2,2,2),(3,3,3), (4,4,4), (5,5,5); # Use pk explain select * from t2 where p NOT IN (select p from t1); -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; # Use unique index explain select * from t2 where p NOT IN (select u from t1); -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; # Use ordered index explain select * from t2 where p NOT IN (select o from t1); -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; # Use scan explain select * from t2 where p NOT IN (select p+0 from t1); -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; drop table t1; drop table t2; |