/ Timeline
Login

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

29 check-ins using file src/where.c version d2f58a44

2013-10-01
20:02
Allow multi-token phrases to load doclists from the database incrementally. This allows queries that feature such phrases to benefit from the "docid<?" optimization. check-in: ea543f08 user: dan tags: fts4-docid-range-constraints
2013-09-30
19:05
Add some timing tests to the amatch test script. check-in: ad71c72b user: drh tags: trunk
18:16
Merge trunk changes with this branch. check-in: e294a9c7 user: dan tags: fts4-docid-range-constraints
18:14
Fix a performance problem in the FTS4 auxiliary functions triggered by an OR clause in the full-text query. check-in: fa0f2f0e user: dan tags: trunk
17:37
Fix memory leaks in the amatch extension. Add a few simple test cases. check-in: 60413473 user: drh tags: trunk
11:42
Have fts4 full-text queries consider "docid<?" and similar constraints. check-in: 6622424a user: dan tags: fts4-docid-range-constraints
11:01
Update and modernize an obsolete comment associated with VACUUM. No changes to code. check-in: 94c914e3 user: drh tags: trunk
2013-09-29
04:56
Fix typo in comment. No changes to code. check-in: 0b7bd468 user: mistachkin tags: trunk
2013-09-28
16:43
Add new test file fts3defer3.test. check-in: a6cd14ef user: dan tags: trunk
13:28
In the nextchar.c extension, allow the second argument to the next_char() function to be a subquery. check-in: 59b9fa22 user: drh tags: trunk
12:40
Updates to the sqlite3_analyzer utility: Change the names of some labels, especially change "Fragmentation" to "Non-sequential pages". Revise the computation of non-sequential pages so that it ignores itercalated non-leaf pages (overflow and index pages). check-in: 3e5c7771 user: drh tags: trunk
2013-09-26
15:21
Obtain the required shared-cache write-lock when executing "DELETE FROM tbl" statements. Fix for [1e1321ee98]. check-in: 1f8f4fdf user: dan tags: trunk
11:04
Fix a faulty assert() in sqlite3BtreeBeginTrans() that may fail in shared-cache mode. check-in: 1e1321ee user: dan tags: trunk
2013-09-24
19:07
Merge updates from trunk. check-in: 435ce3b3 user: mistachkin tags: toTypeFuncs
2013-09-18
11:16
Test that the unicode61 tokenchars= and separators= options work with the fts3tokenize virtual table. check-in: ed240514 user: dan tags: trunk
2013-09-17
23:36
Clear the current time value on prepared statements when the prepared statement is reset. check-in: cebd6fc5 user: drh tags: trunk
2013-09-16
20:46
Readability improvements to the Win32 RC file. check-in: e6459062 user: mistachkin tags: trunk
19:27
Minor consistency fixes to the Win32 RC file. check-in: 619c5211 user: mistachkin tags: trunk
12:57
The date and time functions use the exact same notion of "now" for every invocation within the same call to sqlite3_step(). check-in: daf6ba41 user: drh tags: trunk
2013-09-13
23:27
Fix Windows SDK compiler warning. check-in: d5fc3f1d user: mistachkin tags: trunk
23:26
Fix test issues for Windows portability. check-in: 650b3282 user: mistachkin tags: trunk
22:38
VSIX tooling changes to support Visual Studio 2013. check-in: d56fac40 user: mistachkin tags: trunk
21:03
Fix the "const" qualifiers on the pragma name table. check-in: b74e6be8 user: drh tags: trunk
21:01
Add the soft_heap_limit pragma. check-in: c326356f user: drh tags: trunk
19:00
Tweak the new PRAGMA name parser to achieve full branch test coverage. check-in: c82e05c4 user: drh tags: trunk
18:15
Remove one unreachable branch and add asserts() to dupedExprStructSize(). New asserts verify that removed branch is unused and that constants that are ORed together in the output do not overlap. check-in: 86ad358b user: drh tags: trunk
17:47
Adjust the query planner to take into account WHERE clause terms that do not drive indices. Add the unlikely() and likelihood() functions used to give hints to the query planner about the selectivity of WHERE clause terms. check-in: bc446449 user: drh tags: trunk
2013-09-12
23:42
Refactor the ExprSetIrreducible() macro into ExprSetVVAProperty(*,EP_NoReduce). This is a naming change only. The logic is the same. Closed-Leaf check-in: 695aee46 user: drh tags: unlikely-func
17:29
Merge in the Expr.flags expansion to 32-bits. Use an extra bit to help optimize the sqlite3ExprSkipCollate() routine. check-in: 4c84d1b4 user: drh tags: unlikely-func