Index: third_party/sqlite/src/test/whereA.test |
diff --git a/third_party/sqlite/src/test/whereA.test b/third_party/sqlite/src/test/whereA.test |
index 64253adcd32f57def44748c3af963a30cd4f243d..5d0aca591ca2790ced5ec27d801d4224df27026a 100644 |
--- a/third_party/sqlite/src/test/whereA.test |
+++ b/third_party/sqlite/src/test/whereA.test |
@@ -33,11 +33,41 @@ do_test whereA-1.2 { |
} {3 4.53 {} 2 hello world 1 2 3} |
do_test whereA-1.3 { |
+ db close |
+ sqlite3 db test.db |
db eval { |
PRAGMA reverse_unordered_selects=1; |
+ SELECT * FROM t1; |
+ } |
+} {3 4.53 {} 2 hello world 1 2 3} |
+do_test whereA-1.4 { |
+ db close |
+ sqlite3 db test.db |
+ db eval { |
+ PRAGMA reverse_unordered_selects=1; |
+ SELECT * FROM t1 ORDER BY rowid; |
+ } |
+} {1 2 3 2 hello world 3 4.53 {}} |
+do_test whereA-1.5 { |
+ db eval { |
+ VACUUM; |
SELECT * FROM t1 ORDER BY rowid; |
} |
} {1 2 3 2 hello world 3 4.53 {}} |
+do_test whereA-1.6 { |
+ db eval { |
+ PRAGMA reverse_unordered_selects; |
+ } |
+} {1} |
+do_test whereA-1.7 { |
+ db close |
+ sqlite3 db test.db |
+ db eval { |
+ PRAGMA reverse_unordered_selects=1; |
+ VACUUM; |
+ SELECT * FROM t1; |
+ } |
+} {3 4.53 {} 2 hello world 1 2 3} |
do_test whereA-2.1 { |
db eval { |