diff options
| author | drh <drh@noemail.net> | 2018-07-28 21:01:55 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2018-07-28 21:01:55 +0000 |
| commit | f559ed3400d826c494bb23bbf31d280e7fbee28f (patch) | |
| tree | 57e3508fc33c324c5fa978174a102a9241ca45fd /test/where.test | |
| parent | 07aded63f44d6879ead369a30b723ffed00fffc1 (diff) | |
| download | sqlite-f559ed3400d826c494bb23bbf31d280e7fbee28f.tar.gz sqlite-f559ed3400d826c494bb23bbf31d280e7fbee28f.zip | |
Add a small cost penalty to sorting to bias the query planner in favor of
plans that do not require a final sorting pass.
FossilOrigin-Name: 85b9beb4605eb0cfe2ed063c2a1925186c9e37031f78c875e60a347cce891638
Diffstat (limited to 'test/where.test')
| -rw-r--r-- | test/where.test | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/test/where.test b/test/where.test index 216325d03..db0bc47a7 100644 --- a/test/where.test +++ b/test/where.test @@ -582,7 +582,7 @@ do_test where-6.7.2 { cksort { SELECT * FROM t3 WHERE b>0 ORDER BY a LIMIT 1 } -} {1 100 4 sort} +} {1 100 4 nosort} ifcapable subquery { do_test where-6.8a { cksort { |