| 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 {
|
|
|