SQLite

All files named ”test/fts3sort.test”
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/fts3sort.test

2013-06-10
23:30
[ed34c716a1] part of check-in [aa580e368e] Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. (check-in: [aa580e368e] user: drh branch: nextgen-query-plan-logcost, size: 5657)
2011-10-04
19:41
[95be0b19d7] part of check-in [0f439944ab] Improve test coverage of fts3.c. (check-in: [0f439944ab] user: dan branch: fts4-content, size: 5658)
2011-09-13
19:08
[9a5176c931] part of check-in [07788c0f7f] Allocate the correct size for the output buffer in fts3DoclistOrMerge(). Fix for [56be976859]. (check-in: [07788c0f7f] user: dan branch: trunk, size: 5449)
2011-06-06
06:55
[63d52c1812] part of check-in [0425138a23] Clean up the code for processing FTS4 options a bit. (check-in: [0425138a23] user: dan branch: fts3-prefix-search, size: 4815)
2011-06-04
20:04
[c599f19e94] part of check-in [f6a0193f5a] Allow the "order=DESC" and "order=ASC" parameters in FTS4 "CREATE VIRTUAL TABLE" statements. Tables created with "order=DESC" store all doclists in descending order, which allows optimizations normally applied to "ORDER BY docid ASC" queries to be used with "ORDER BY docid DESC" queries instead. (check-in: [f6a0193f5a] user: dan branch: fts3-prefix-search, size: 4757)
2011-05-04
15:41
[e6f24e9cff] part of check-in [95e09b20e9] Fix a performance problem in queries that use "ORDER BY rowid DESC" and one or more FTS auxiliary functions. (check-in: [95e09b20e9] user: dan branch: vtab-conflict, size: 3210)
12:52
Added: [b33d4650e8] part of check-in [13395121e3] Optimize "ORDER BY rowid/docid DESC/ASC" clauses on FTS tables. (check-in: [13395121e3] user: dan branch: vtab-conflict, size: 3133)