SQLite
Timeline
Not logged in

30 ancestors of [1e1221fc48]


2014-11-22
21:37
[1e1221fc48] Leaf: Always reinitialized the Index.bUnordered and Index.noSkipscan flags before rereading the sqlite_stat1 table, even if SQLITE_ENABLE_STAT4 is defined. (user: drh, tags: trunk)

19:52
[9660ce5418] Fix an error in the comments from the previous check-in. (user: drh, tags: trunk)
18:50
[221659945c] Deploy heuristics (well-commented) to better estimate how much unindexed terms in the WHERE clause filter the number of output rows from a single table. (user: drh, tags: trunk)
12:22
[eea4793349] Remove a redundant test case (probably a copy/paste error). Add an assert() to where.c to ensure that automatic indexes do not have there output row counts adjusted downward by supplementary constraints. (user: drh, tags: trunk)
2014-11-20
23:21
[b1e6c02f8b] Fix a typo in a requirements mark on the abs() SQL function. (user: drh, tags: trunk)
23:11
[332cc9591d] Fix a benign test error on PRAGMA collation_list introduced by a recent checkin. (user: drh, tags: trunk)
23:03
[fcf8b7e4c6] Updates to requirements tags on the mutex documentation. (user: drh, tags: trunk)
19:22
[4b608b62ac] Add requirements marks on the built-in collating functions. (user: drh, tags: trunk)
15:30
[ef9fbc08b0] Ensure that when the number of cells on a page drops to zero that the freelist and fragment counter are both cleared. Also add evidence marks corresponding to file-format documentation. (user: drh, tags: trunk)
02:58
[2d7c8da5f1] Fix the encoding of some integers to use the minimum amount of space: -128, -32768, -8388608, -217483648, and -140737488355328. (user: drh, tags: trunk)
02:18
[9a9627e178] Add some requirements marks to the record formatting logic. Comment changes only - the code is unaltered. (user: drh, tags: trunk)
2014-11-19
16:36
[6d00bcca6e] Add new requirements marks associated with the file format documentation. No changes to code. (user: drh, tags: trunk)
14:31
[89b3c1c455] Completely remove an assert() that had previously been commented out. (user: drh, tags: trunk)
14:05
[9ed97a85fe] Add an ALWAYS on an always-true branch in wal.c. Fix the ANALYZE command so that it resets the "unordered" and "noskipscan" flags on indices when reloading the sqlite_stat1 table. (user: drh, tags: trunk)
2014-11-18
21:54
[4461bf045d] Adding the "noskipscan" token to an sqlite_stat1.stat field prevents an index for being used with the skip-scan algorithm. (user: drh, tags: trunk)
21:45
[c52f7971e9] Allow an automatic index to be used if the only uses of declared indexes for the same loop use the skip-scan algorithm. (user: drh, tags: trunk)
20:49
[296b0c7397] Merge in all the other ROLLBACK fixes from the branch-3.8.7 branch. I don't know why I was doing them one-by-one. (user: drh, tags: trunk)
20:22
[2896f2640a] Fix a bug in the sqlite3TripAllCursors() routine that prevents it from reporting errors. It is unknown at this time whether or not this omission can result in any incorrect result in an actual query. (user: drh, tags: trunk)
20:16
[abccda769a] Update a couple of test cases to account for the fact that ROLLBACK does not always abort all running SELECT statements. (user: drh, tags: trunk)
12:28
[945a9e687f] Increment the version number to 3.8.7.2 (user: drh, tags: branch-3.8.7)
02:44
[c5eae8a60d] Add an ALWAYS() to an always-true conditional in the WAL rollback logic. (user: drh, tags: branch-3.8.7)
2014-11-17
20:33
[57c4aa988c] Remove code from sqlite3BtreeKeySize() made unreachable by the previous check-in. (user: drh, tags: branch-3.8.7)
19:44
[2f2ecb9948] Avoid calling sqlite3BtreeKeysize() on a b-tree cursor in SKIPNEXT or SKIPPREV state. Cherrypick of 54e7d3fcb1. (user: dan, tags: branch-3.8.7)
19:42
[54e7d3fcb1] Avoid calling sqlite3BtreeKeysize() on a b-tree cursor in SKIPNEXT or SKIPPREV state. (user: dan, tags: trunk)
19:25
[e956e7db05] Improved comments on the BtCursor.skipNext field. No changes to code. (user: drh, tags: branch-3.8.7)
17:13
[34fc4a082c] When a SELECT statement is terminated by a ROLLBACK TO operation, make the error message be "abort due to ROLLBACK" rather than "callback requested query abort". (user: drh, tags: branch-3.8.7)
15:32
[42588207ff] Fix a bug in the sqlite3TripAllCursors() routine that prevents it from reporting errors. It is unknown at this time whether or not this omission can result in any incorrect result in an actual query. (user: drh, tags: branch-3.8.7)
15:22
[eba171e980] Update a couple of test cases to account for the fact that ROLLBACK does not always abort all running SELECT statements. (user: dan, tags: branch-3.8.7)
2014-11-15
19:08
[00fe095057] Closed-Leaf: Adding the "noskipscan" token to an sqlite_stat1.stat field prevents an index for being used with the skip-scan algorithm. (user: drh, tags: noskipscan-token)
2014-11-14
19:34
[93642a65ef] Closed-Leaf: Consider using an automatic-index for a scan even if there exists a possible skip-scan that uses one or more "=" operators. (user: dan, tags: experimental-autoindex-fix)
15:42
[98457a57d6] Do not automatically remove the DISTINCT keyword from "a IN (SELECT DISTINCT ...)" expressions. Fix for [db87229497]. (user: drh, tags: branch-3.8.7)