diff options
author | unknown <joreland@mysql.com> | 2004-09-03 14:46:39 +0200 |
---|---|---|
committer | unknown <joreland@mysql.com> | 2004-09-03 14:46:39 +0200 |
commit | 92f58a4b766109d02bfb85722c9bb35b7094f929 (patch) | |
tree | de2d0661d813531286345455daf8eaea6f5d7a33 /mysql-test | |
parent | f54c4a9460550d9b2afa00e3a4cf03e35de7665f (diff) | |
download | mariadb-git-92f58a4b766109d02bfb85722c9bb35b7094f929.tar.gz |
Remove usage of row count (as it trashes _all_ explain & table status)
Use order by
mysql-test/r/ndb_index_ordered.result:
Use order by
mysql-test/t/ndb_index_ordered.test:
Use order by
sql/ha_ndbcluster.cc:
Remove usage of row count (as it trashes _all_ explain & table status)
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/ndb_index_ordered.result | 4 | ||||
-rw-r--r-- | mysql-test/t/ndb_index_ordered.test | 2 |
2 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/ndb_index_ordered.result b/mysql-test/r/ndb_index_ordered.result index 2f1ad251e40..2a3050e5dea 100644 --- a/mysql-test/r/ndb_index_ordered.result +++ b/mysql-test/r/ndb_index_ordered.result @@ -219,10 +219,10 @@ c int unsigned, KEY bc(b,c) ) engine = ndb; insert into t1 values(1,1,1),(2,NULL,2),(3,NULL,NULL),(4,4,NULL); -select * from t1 use index (bc) where b IS NULL; +select * from t1 use index (bc) where b IS NULL order by a; a b c -3 NULL NULL 2 NULL 2 +3 NULL NULL select * from t1 use index (bc)order by a; a b c 1 1 1 diff --git a/mysql-test/t/ndb_index_ordered.test b/mysql-test/t/ndb_index_ordered.test index 00807bfcb98..2a94475df13 100644 --- a/mysql-test/t/ndb_index_ordered.test +++ b/mysql-test/t/ndb_index_ordered.test @@ -130,7 +130,7 @@ CREATE TABLE t1 ( ) engine = ndb; insert into t1 values(1,1,1),(2,NULL,2),(3,NULL,NULL),(4,4,NULL); -select * from t1 use index (bc) where b IS NULL; +select * from t1 use index (bc) where b IS NULL order by a; select * from t1 use index (bc)order by a; select * from t1 use index (bc) order by a; |