Add initial infrastructure for cursors. In where.c, optimize out clauses

of the form "ORDER BY rowid" if a table scan is being performed.  Do a
reverse table scan if "ORDER BY rowid DESC" is present. (CVS 2141)

FossilOrigin-Name: fc8c1393c86017a816beb52725b68af3b973f979

1 files changed, 4 insertions, 3 deletions

diff --git a/test/collate4.test b/test/collate4.test
index e7111c807..24b926792 100644
--- a/test/collate4.test
+++ b/test/collate4.test
@@ -12,7 +12,7 @@
 # This file implements regression tests for SQLite library.  The
 # focus of this script is page cache subsystem.
 #
-# $Id: collate4.test,v 1.4 2004/11/03 16:27:02 drh Exp $
+# $Id: collate4.test,v 1.5 2004/11/22 19:12:21 drh Exp $
 
 set testdir [file dirname $argv0]
 source $testdir/tester.tcl
@@ -669,6 +669,7 @@ do_test collate4-4.15 {
 # These indices are never used for sorting in SQLite. And you can't
 # create another index on an INTEGER PRIMARY KEY column, so we don't have 
 # to test that.
+# (Revised 2004-Nov-22):  The ROWID can be used for sorting now.
 #
 do_test collate4-6.0 {
   execsql {
@@ -682,12 +683,12 @@ do_test collate4-6.1 {
   cksort {
     SELECT * FROM collate4t1 ORDER BY 1;
   }
-} {10 15 101 sort}
+} {10 15 101 nosort}
 do_test collate4-6.2 {
   cksort {
     SELECT * FROM collate4t1 ORDER BY oid;
   }
-} {10 15 101 sort}
+} {10 15 101 nosort}
 do_test collate4-6.3 {
   cksort {
     SELECT * FROM collate4t1 ORDER BY oid||'' COLLATE TEXT;