Index: third_party/sqlite/src/test/where.test |
diff --git a/third_party/sqlite/src/test/where.test b/third_party/sqlite/src/test/where.test |
index 0b5bb934d06b9c5c39c5ab453677d314ab3dae17..d4f04e806374b589df333034ea771728dd3546fb 100644 |
--- a/third_party/sqlite/src/test/where.test |
+++ b/third_party/sqlite/src/test/where.test |
@@ -573,11 +573,16 @@ do_test where-6.6 { |
SELECT * FROM t3 WHERE a>0 ORDER BY a LIMIT 3 |
} |
} {1 100 4 2 99 9 3 98 16 nosort} |
-do_test where-6.7 { |
+do_test where-6.7.1 { |
cksort { |
- SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 3 |
+ SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 10 |
} |
-} {1 100 4 2 99 9 3 98 16 nosort} |
+} {/1 100 4 2 99 9 3 98 16 .* nosort/} |
+do_test where-6.7.2 { |
+ cksort { |
+ SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 1 |
+ } |
+} {1 100 4 sort} |
ifcapable subquery { |
do_test where-6.8a { |
cksort { |