Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Open leaves:
|
2024-04-26
| ||
| 19:10 | Fix issues in LIMIT/OFFSET support for virtual tables. The first problem was reported by forum post c243b8f856. That report prompted an enhancement to the generate_series() (also included in this merge) which in turn identified other similar issues. (Leaf check-in: 5f6c079d user: drh tags: trunk) | |
|
2024-04-17
| ||
| 19:48 | Prevent tokenize-blobs from being used with non-contentless tables. Fix some other issues with the new code on this branch. (Leaf check-in: 6a640ea4 user: dan tags: fts5-tokenize-blob) | |
|
2024-04-15
| ||
| 14:59 | Merge version 3.45.3 patches into the reuse-schema-3.45 sub-branch. (Leaf check-in: a1ff4153 user: drh tags: reuse-schema-3.45) | |
| 14:45 | Merge all of the latest trunk enhancements into the bedrock branch. (Leaf check-in: 16dac180 user: drh tags: bedrock) | |
| 14:39 | Merge the latest trunk enhancements into the wal2 branch. (Leaf check-in: 4a72acbc user: drh tags: wal2) | |
| 14:36 | Merge the latest trunk enhancements into the begin-concurrent branch. (Leaf check-in: eedf6bed user: drh tags: begin-concurrent) | |
| 14:21 | Merge all 3.45.3 changes into the wal2-3.45 branch. (Leaf check-in: 2ccc0185 user: drh tags: wal2-3.45) | |
| 14:18 | Merge all 3.45.3 changes into the begin-concurrent-3.45 subbranch. (Leaf check-in: 3dda82e0 user: drh tags: begin-concurrent-3.45) | |
| 13:34 | Version 3.45.3 (Leaf check-in: 8653b758 user: drh tags: release, branch-3.45, version-3.45.3) | |
|
2024-04-12
| ||
| 15:15 | Mark the BTree cell overflow cache as invalid whenever the rowid goes invalid. (Leaf check-in: 0ec6669c user: drh tags: branch-3.44) | |
|
2024-04-06
| ||
| 23:09 | Add comments to note the name abiguity between the MySQL push-down optimization and the WHERE-clause push-down optimization. (Leaf check-in: 681dfe2d user: drh tags: wrong-branch) | |
|
2024-04-05
| ||
| 15:04 | Merge all recent trunk enhancements into the reuse-schema branch. (Leaf check-in: e556f3d3 user: drh tags: reuse-schema) | |
|
2024-04-02
| ||
| 18:48 | Fix typos in comments. Provided ".wheretrace" debugging output for the interstage heuristic module. Do omit automatic index loops in the interstage heuristic. (Leaf check-in: 357d9513 user: drh tags: branch-3.28) | |
|
2024-03-15
| ||
| 12:59 | Attempt to use the Dekker high-precision floating point algorithm in the ext/misc/totype.c extension. This check-in should have been derived from trunk, not the exp-values-clause2 branch. But that's ok, because both trunk and the branch are the same in all aspects that relate to this check-in and this check-in is just parking the proposed enhancement for future consideration - it is not a serious proposal at this point. (Leaf check-in: dd41db3b user: drh tags: totype-dekker) | |
|
2024-03-12
| ||
| 12:00 | Merge all 3.45.2 pages into the bedrock-3.45 subbranch. (Leaf check-in: 33b9cf7c user: drh tags: bedrock-3.45) | |
|
2024-03-07
| ||
| 18:47 | Improved error handling. (Leaf check-in: cf2d1ad0 user: drh tags: exp-values-clause) | |
|
2024-03-06
| ||
| 08:45 | Wasm build tweaks to attempt to get the node.js-for-node.js build to use Emscripten's nodefs filesystem driver for persistent storage. This is completely untested - validating it requires a nodeist. (Leaf check-in: 0bcbde7c user: stephan tags: wasm-nodefs) | |
|
2024-03-04
| ||
| 18:02 | The ability to DROP multiple tables (or views or indexes or triggers) at once, as implemented by this branch, appears to work. However, this branch adds over 1000 bytes to the code footprint. And the changes is significant, adding risk. The benefit of being able to drop multiple tables in a single statement is not seen to be enough to overcome those downsides, and so there are no immediate plans to merge this branch. (Leaf check-in: 1a49788a user: drh tags: multi-drop) | |
|
2024-01-12
| ||
| 16:33 | Fix a usan complaint about signed integer overflow. (Leaf check-in: 16aa7297 user: drh tags: branch-3.43) | |
|
2023-12-03
| ||
| 19:32 | Partial hand-merge of shell.c.in (not buildable) (Leaf check-in: 62e90c9b user: larrybr tags: cli_extension_wip) | |
|
2023-11-27
| ||
| 15:08 | Pickup stray oput?() calls that should have gone to stdout. Simplify console line reading, sacrificing speed (which does not matter then) for code size. (Leaf check-in: 8e20645c user: larrybr tags: console-io-lib) | |
|
2023-11-24
| ||
| 12:48 | Merge 3.44.2 changes into the reuse-schema-3.44 sub-branch. (Leaf check-in: 2b9d5ff7 user: drh tags: reuse-schema-3.44) | |
| 12:42 | Merge 3.44.2 changes into the bedrock-3.44 sub-branch. (Leaf check-in: 1d9dfad0 user: drh tags: bedrock-3.44) | |
| 12:38 | Merge 3.44.2 changes into the wal2-3.44 sub-branch. (Leaf check-in: 0118e8c9 user: drh tags: wal2-3.44) | |
| 12:33 | Merge 3.44.2 changes into the begin-concurrent-3.44 sub-branch. (Leaf check-in: 6d97426f user: drh tags: begin-concurrent-3.44) | |
|
2023-11-16
| ||
| 20:50 | Cherrypick changes to simplify and make more rational how console I/O package features are selected. (Leaf check-in: b20c9f17 user: larrybr tags: consio-3.44) | |
|
2023-11-13
| ||
| 17:26 | Mistaken creation by a Fossil expert-to-be-maybe. (Leaf check-in: 2e3e98a4 user: larrybr tags: mistake) | |
|
2023-11-10
| ||
| 13:13 | Fix a potential UAF caused by JSON parser cache spill. (Leaf check-in: ce3fc4fc user: drh tags: bedrock-3.43) | |
|
2023-11-07
| ||
| 19:02 | Do not allow aggregate or window functions in UPDATE statements. (Leaf check-in: fce776cc user: dan tags: no-aggregates-in-update) | |
|
2023-10-30
| ||
| 23:04 | Remedy CLI non-UTF8 handling detection flaw noted in a forum post. (Leaf check-in: 2666b80d user: larrybr tags: win-utf8-io-split) | |
|
2023-10-26
| ||
| 18:24 | Handle utf8 mode restore better for redirected input or output. Move utf8 mode setup to before any invocation command processing. Sync w/trunk. (Leaf check-in: 59452e7c user: larrybr tags: win-utf8-io-split) | |
|
2023-10-21
| ||
| 11:00 | Fix a test case broken by the previous check-in. (Leaf check-in: 1e61864c user: drh tags: string_agg) | |
|
2023-10-20
| ||
| 11:44 | Merge trunk into the wasm-xGetLastError branch. (Leaf check-in: 48a9bd64 user: stephan tags: wasm-xGetLastError) | |
|
2023-10-14
| ||
| 17:34 | Merge the version-3.43.2 changes into the begin-concurrent-3.43 branch. (Leaf check-in: f3fb30af user: drh tags: begin-concurrent-3.43) | |
|
2023-10-12
| ||
| 20:03 | Fix a problem with an fts5 secure-delete on a rowid/term pair that follows a legacy delete of the same pair. (Leaf check-in: f5913e76 user: dan tags: branch-3.42) | |
|
2023-10-10
| ||
| 13:55 | Merge the 3.43.2 release changed into the reuse-schema-3.43 branch. (Leaf check-in: 5fefa147 user: drh tags: reuse-schema-3.43) | |
|
2023-09-30
| ||
| 10:31 | Make all native JNI sqlite3_...() bindings package-private as a foot-shooting protective measure (higher-level pre-native-call argument validation is largely pending). Move SQLTester.java and TesterFts5.java into the org.sqlite.jni package so that they can access the being-tested methods. (Leaf check-in: ec82f725 user: stephan tags: jni-ptr-passing) | |
|
2023-09-09
| ||
| 15:22 | Merge post-3.43.0 wal2 fixes into the wal2-3.43 sub-branch. (Leaf check-in: f82b1a0b user: drh tags: wal2-3.43) | |
|
2023-09-05
| ||
| 15:43 | Add debugging routines to check each page for corruption after it it is manipulated by the fts5 secure-delete code, and to log said page via sqlite3_log() if it is found to be corrupt. (Leaf check-in: da4b7385 user: dan tags: fts5-secure-delete-debug) | |
|
2023-09-02
| ||
| 22:07 | Eliminate a redundant NK_DbAboutToClose notification. (Leaf check-in: eccffaa7 user: larrybr tags: cli_extension) | |
|
2023-08-10
| ||
| 21:20 | Add tests for structured-exception-handling and wal2. Fix a problem with the same. (Leaf check-in: 87242777 user: dan tags: wal2-shm-exceptions) | |
| 17:07 | Merge latest trunk changes into this branch. (Leaf check-in: 3ed89c34 user: dan tags: wal-shm-exceptions) | |
|
2023-08-04
| ||
| 08:39 | More work towards fts5 customzation in JS. (Leaf check-in: ce2a65d8 user: stephan tags: wasm-fts5) | |
|
2023-08-02
| ||
| 18:20 | If a query has an ORDER BY clause that only refers to result columns of the left-most table and the left most table is a MATERIALIZED common table expresion, then attempt to push the ORDER BY clause down into the subquery. (Leaf check-in: 8e7a70b2 user: drh tags: order-by-push-down) | |
|
2023-07-25
| ||
| 00:13 | First attempt to cache modified JSON parses. Does not work. This is an incremental check-in. (Leaf check-in: 075eb09a user: drh tags: json-opt-wcache1) | |
|
2023-07-21
| ||
| 22:22 | Mark an unreachable branch as NEVER(). (Leaf check-in: 414a4d66 user: drh tags: big-function-text) | |
|
2023-07-07
| ||
| 16:58 | Proof of concept for a new sqlite3_function_needed() interface. (Leaf check-in: cd67edc0 user: drh tags: need-function) | |
|
2023-07-03
| ||
| 00:51 | The fptest(X) routine used for exploring another idea for improving fp-to-decimal conversion without the use of long double. (Leaf check-in: d9a883d7 user: drh tags: fp-to-decimal-branch2) | |
|
2023-04-27
| ||
| 19:27 | Dynamically resize the node hash table used by the rtree module. (Leaf check-in: f94f3da5 user: dan tags: rtree-batch-insert) | |
|
2023-04-25
| ||
| 15:12 | If an ON clause to the left of a RIGHT JOIN is false, that does not imply that the query returns no rows. (Leaf check-in: 4011b9d3 user: drh tags: branch-3.41) | |
|
2023-04-18
| ||
| 22:53 | Add comment on CLI ^C fix (because it is a bit subtle.) (Leaf check-in: 19c062f1 user: larrybr tags: cli-no-dump) | |
| 20:02 | Make use of F_BARRIERFSYNC as an alternative to F_FULLFSYNC when it is available. (Leaf check-in: 3c517ba5 user: drh tags: barrier-fsync) | |
|
2023-04-17
| ||
| 22:28 | Minor coding style changes. (Leaf check-in: 481aa3cc user: mistachkin tags: cli-utf8) | |
|
2023-03-31
| ||
| 16:27 | Merge recent trunk fixes into the nan-inf branch. (Leaf check-in: a51fb9d7 user: drh tags: nan-inf) | |
|
2023-03-22
| ||
| 13:47 | Merge the 3.41.2 patch into the reuse-schema-3.41 subbranch of reuse-schema (Leaf check-in: 995fa4d0 user: drh tags: reuse-schema-3.41) | |
| 13:35 | Merge the 3.41.2 patches into the bedrock-3.41 subbranch of bedrock. (Leaf check-in: b7a144c4 user: drh tags: bedrock-3.41) | |
| 13:25 | Merge the 3.41.2 patch into the wal2-3.41 subbranch of wal2. (Leaf check-in: db44f17a user: drh tags: wal2-3.41) | |
|
2023-02-27
| ||
| 21:53 | Make the "unref" operation on database pages a method which is part of the PgHdr object. This is a potential performance optimization. (Leaf check-in: 37c5c8aa user: drh tags: unref-opt) | |
|
2023-02-26
| ||
| 19:36 | Correct substantive error (DML and DQL versus DML) of last check-in. (Leaf check-in: 703fa854 user: larrybr tags: db_config_ops_rewrite) | |
|
2023-02-02
| ||
| 14:27 | Merge latest enhancments into this branch from branch wal2. (Leaf check-in: 5a22010c user: dan tags: begin-concurrent-pnu-wal2) | |
|
2023-01-25
| ||
| 17:24 | Change the instrumentation messages on this branch so that they contain "v=7" instead of "v=6". (Leaf check-in: acea12d9 user: dan tags: schema-version-instr) | |
|
2023-01-14
| ||
| 19:36 | Add OOM check, per tip at forum post 933479b2d5 (Leaf check-in: c66c7734 user: drh tags: branch-3.40) | |
|
2023-01-13
| ||
| 19:00 | Fix an error in debugging output discovered while working on the problem with RETURNING reported by forum post d010a26798. (Leaf check-in: 3ae9127f user: drh tags: returning-is-null-fix) | |
|
2022-12-28
| ||
| 14:55 | Merge the 3.40.1 changes into the reuse-schema branch. (Leaf check-in: 126c68bd user: drh tags: reuse-schema-3.40) | |
|
2022-12-21
| ||
| 20:17 | Merge the latest trunk enhancements into the begin-concurrent-report branch. (Leaf check-in: 397fb07b user: drh tags: begin-concurrent-report) | |
| 18:28 | Sync w/trunk prior to branch-purpose changes. (Leaf check-in: ae8f623f user: larrybr tags: extension_opts) | |
|
2022-12-06
| ||
| 05:09 | Add optional feature: A CLI continuation prompt which reflects open lexemes and parens, similarly to PG shell. (Leaf check-in: dac2ddc2 user: larrybr tags: dynamic_prompt) | |
|
2022-11-28
| ||
| 18:17 | Test cases added derived from the enhancment ticket. (Leaf check-in: c022c015 user: drh tags: covering-indexed-expr) | |
|
2022-11-18
| ||
| 17:50 | Add the SQLITE_DBCONFIG_LENIENT_JSON configuration option. Modify the built-in JSON routines such that when this setting is active, arguments that that ought to be JSON but still give a reasonable result (ex: NULL) rather than raising an error. (Leaf check-in: 186db57d user: drh tags: lenient-json) | |
|
2022-11-03
| ||
| 21:08 | Experimental changes that try to identify indexes as covering when they contain expressions which do cover all data uses. This check-in does not work, because the AggInfo object might still refer to individual columns. The purpose of this check-in is to preserve the idea. I might come back to it later. (Leaf check-in: 018914a5 user: drh tags: indexed-expr-exp) | |
|
2022-10-31
| ||
| 18:11 | Make the UPDATE method of the sqlite_dbpage virtual table rebust against OOM errors. Forum post bbcf0dd6ca. Test case in TH3. (Leaf check-in: 852f2c95 user: drh tags: branch-3.39) | |
|
2022-10-26
| ||
| 18:29 | Remove an undefined left-shift operation from the recover extension. (Leaf check-in: a6708235 user: dan tags: recover-extension) | |
|
2022-10-09
| ||
| 13:33 | Cherrypick [ea370b9b05f7ed7eaa] and part of [92b500da] into kv-vfs branch. (Leaf check-in: 81263803 user: stephan tags: kv-vfs) | |
|
2022-10-01
| ||
| 13:28 | Merge the Parse.prepFlags change from trunk. (Leaf check-in: c8d77f39 user: drh tags: stmt-cache) | |
|
2022-09-30
| ||
| 12:27 | Merge version 3.39.4 changes into the reuse-schema-3.39 branch. (Leaf check-in: 81025928 user: drh tags: reuse-schema-3.39) | |
|
2022-09-28
| ||
| 17:10 | Prototype implementation of "PRAGMA reset_database". This pragma differs from SQLITE_DBCONFIG_RESET_DATABASE in that the pragma only works if the database is reasonably well-formed, whereas the dbconfig works regardless. (Leaf check-in: cf0999d4 user: drh tags: reset-database) | |
|
2022-09-27
| ||
| 17:00 | Fix a potential division by zero error in this version of RBU that might occur if an external client checkpoints a wal file created by a suspended RBU process. (Leaf check-in: 73edd93a user: dan tags: branch-3.14) | |
|
2022-09-20
| ||
| 14:36 | When compiled with SQLITE_OS_KV_OPTIONAL, the magic names ":localStorage:" and ":sessionStorage:" are recognized and converted to use the kv-vfs. (Leaf check-in: c5db9262 user: drh tags: kv-vfs-magic-names) | |
|
2022-09-05
| ||
| 12:39 | Version 3.39.3 patches applied to the begin-concurrent branch. (Leaf check-in: 31304de8 user: drh tags: begin-concurrent-3.39) | |
|
2022-09-02
| ||
| 15:53 | When an OOM occurs and sets the Parse.nErr value, also set the Parse.nErr value for all outer Parse objects. dbsqlfuzz d33f60aaa67733aa700cd69dacf8e0e23a327a29 (Leaf check-in: b17a2503 user: drh tags: branch-3.39-pcache) | |
|
2022-07-22
| ||
| 20:48 | Updates to the 'vtshim' extension. (Leaf check-in: 163c6cdf user: mistachkin tags: xShadowName2) | |
|
2022-06-28
| ||
| 21:52 | Merge latest fixes from begin-concurrent-pnu-wal2 branch. (Leaf check-in: 77fe7376 user: dan tags: begin-concurrent-report-wal2) | |
|
2022-06-21
| ||
| 12:54 |
| |
|
2022-06-08
| ||
| 15:30 | Add restriction (29) to the query flattener - do not allow flattening that would leave both EP_InnerON and EP_OuterON constraints on the same join term. (Leaf check-in: c585d6a4 user: drh tags: right-join-query-flattener) | |
|
2022-05-20
| ||
| 13:27 | Add a terminal-style view to the fiddle app, based on jquery.terminal. (Leaf check-in: 82b57f2e user: stephan tags: fiddle-terminal-view) | |
|
2022-05-18
| ||
| 20:44 | Experimental code to provide a SIZE_HINT when writing the -wal file. (Leaf check-in: 3b29080d user: drh tags: wal-size-hint) | |
|
2022-05-06
| ||
| 17:06 | Merge the 3.38.5 fix into the 3.38 subbranch of reuse-schema. (Leaf check-in: bfccca2b user: drh tags: reuse-schema-3.38) | |
| 16:52 | Merge the 3.38.5 fix into the begin-concurrent-wal2 subbranch for 3.38. (Leaf check-in: 0586b3e9 user: drh tags: begin-concurrent-wal2-3.38) | |
| 15:25 | Version 3.38.5 (Leaf check-in: 78d9c993 user: drh tags: release, version-3.38.5, branch-3.38) | |
|
2022-04-27
| ||
| 21:10 | The -DSQLITE_MXFILENAMESZ=N option for some non-negative integer value N prevents SQLite from ever creating a hole larger than N bytes in a named file for which a size hint has been issued. The exception code never runs, except for cases when the application deliberately corrupts the size hint. (Leaf check-in: 0c2da4ff user: drh tags: mkfileholesz) | |
|
2022-04-08
| ||
| 12:50 | Grammar rules for a hypothetical FOR EACH ROW statement. No new keywords required. However, the sqlite3_complete() machine had to be reworked because of the fact that FOR EACH ROW can contain internal semicolon tokens. (Leaf check-in: 32ae9ee7 user: drh tags: foreachrow-statement) | |
| 10:35 | Tokenizer and grammar rules sufficient for the MERGE command. (Leaf check-in: 2deee326 user: drh tags: merge-statement) | |
|
2022-03-12
| ||
| 14:54 | Merge trunk enhancements, including 3.38.1 patches, into the begin-concurrent-report branch. (Leaf check-in: c4a61135 user: drh tags: begin-concurrent-report-3.28) | |
|
2022-03-10
| ||
| 11:10 | Improve formatting of changes doc for this branch (Leaf check-in: 2129cfb8 user: larrybr tags: shell-tweaks) | |
|
2022-02-14
| ||
| 01:12 | CLI's .import column rename made more minimal, and reports renames. (Leaf check-in: c626cff7 user: larrybr tags: auto-column) | |
|
2022-02-09
| ||
| 16:18 | Prototype implementation of IF EXISTS and IF NOT EXISTS clauses on the various forms of ALTER TALE. (Leaf check-in: 460abf93 user: drh tags: alter-table-if-exists) | |
|
2022-01-21
| ||
| 16:47 | When computing a vector to be used as a key for an index lookup, do not check for NULL values and abort until after all key values have been computed, in case one of the later key values involves some initialization that is needed by a LEFT JOIN. Fix for the problem identified by Forum post ab95010d410a0a55. (Leaf check-in: 3bc8d162 user: drh tags: branch-3.37) | |
|
2022-01-09
| ||
| 21:16 | Update the json-enhancements.md document to match the version in the json-in-core branch, as outside readers have linked to this branch. (Leaf check-in: 2027b3be user: drh tags: json-enhancements) | |
|
2022-01-07
| ||
| 14:09 | Merge 3.37.2 changes into the begin-concurrent-pnu branch. (Leaf check-in: e525892d user: drh tags: begin-concurrent-3.37) | |
|
2022-01-06
| ||
| 14:16 | Merge the 3.37.2 patches into the reuse-schema branch. (Leaf check-in: d7ec5a2b user: drh tags: reuse-schema-3.37) | |
|
2021-12-24
| ||
| 20:51 | Create new branch named "instr-bidir-more" (Leaf check-in: 4ca96d2d user: larrybr tags: instr-bidir-more) | |
|
2021-12-06
| ||
| 17:23 | Create new branch named "ppvar_manage" (Leaf check-in: 74ee8d2b user: larrybr tags: ppvar_manage) | |
|
2021-11-06
| ||
| 11:58 | Add the rbu_exclusive_checkpoint query parameter to RBU. (Leaf check-in: c15806a4 user: drh tags: reuse-schema-3.36) | |
|
2021-10-26
| ||
| 10:02 | Fix an RBU problem with restarting an update after the *-oal file is already larger than 4GiB. (Leaf check-in: e4662603 user: drh tags: branch-3.36) | |
|
2021-09-19
| ||
| 18:31 | Adjust shell tests for *Nix and Windows test platform anomaly (Leaf check-in: 577544c5 user: larrybr tags: speedy_cli) | |
|
2021-08-11
| ||
| 18:56 | Fix an RBU problem with restarting an update after the *-oal file is already larger than 4GiB. (Leaf check-in: 56869f54 user: dan tags: rbu-replace-hack) | |
|
2021-07-29
| ||
| 14:27 | Merge the latest enhancements from trunk. (Leaf check-in: 8498d772 user: drh tags: win-blocking-locks) | |
|
2021-07-22
| ||
| 10:44 | Fix a problem in the new os_unix.c code. Refine the threadtest3 test case some. (Leaf check-in: 2039d447 user: dan tags: unix-timed-wait-exp) | |
|
2021-07-13
| ||
| 11:55 | Merge from trunk, rename tool option for its effect (Leaf check-in: 9327f73c user: larrybr tags: line_tags) | |
|
2021-07-12
| ||
| 15:00 | Fix a defect in the query-flattener optimization identified by ticket [8f157e8010b22af0]. This fix is associated with CVE-2020-15358. (Leaf check-in: bcd014c4 user: dan tags: branch-3.32a) | |
|
2021-07-09
| ||
| 16:00 | Remove disused linkage macros. (Leaf check-in: f14d3571 user: drh tags: disused-link-macros) | |
|
2021-05-28
| ||
| 14:28 | If a subquery is used to drive an index, this change avoids making an extra copy of the result of that subquery. But, such situations are probably sufficiently unusual that the added complexity of this enhancement is not worth the performance gain. So I'm going to park this check-in on a branch. If we later find a use case to justify it, we can merge it to trunk then. This is the "further change" that was promised by the prior check-in comment. (Leaf check-in: 4488cb88 user: drh tags: copy-optimization) | |
|
2021-05-21
| ||
| 13:32 | Add a new sqlite3_config() option for setting the maximum precision of a printf() substitition. The default value is 100,000. It was formerly more than 2 billion. The default can be changed using the SQLITE_PRINTF_PRECISION_LIMIT compile-time option. (Leaf check-in: fd8b68a4 user: drh tags: compile-time-precision-limit) | |
|
2021-05-19
| ||
| 23:29 | final merge from trunk (Leaf check-in: 06629569 user: larrybr tags: compile_options) | |
|
2021-05-11
| ||
| 11:33 | Merge changes from branch-3.35. Specifically, fixes for a running RBU with a cksumvfs VFS. (Leaf check-in: ca62c36b user: dan tags: reuse-schema-3.35) | |
| 11:25 | Fixes for cksmvfs and rbu so that they work together. (Leaf check-in: ce8b589e user: dan tags: branch-3.35) | |
|
2021-05-10
| ||
| 13:28 | Add new output columns to the "PRAGMA database_list" statement. (Leaf check-in: 905085a7 user: drh tags: database-list-enhancement) | |
|
2021-04-27
| ||
| 17:36 | Create new branch named "testing_help" (Leaf check-in: a97a5022 user: larrybr tags: testing_help) | |
|
2021-04-18
| ||
| 15:45 | Create new branch named "auth-vac" (Leaf check-in: 5a7410ac user: larrybr tags: auth-vac) | |
|
2021-03-27
| ||
| 20:45 | Performance improvement in the comparison opcodes by rewriting an array lookup using pointer arithmetic. This makes gcc 5.4.0 builds with -Os both faster and smaller. Though I suspect that in newer compilers with better optimizers in will probably make no difference at all in the generated machine code. Later: Even though the new code is perfectly valid, and generates correct machine code that is both smaller and faster, UBSAN complains about it in OSSFuzz. So we will take it out. So here was have an example of OSSFuzz coercing a widely used application to become bigger and slower. (Leaf check-in: 4a8805d9 user: drh tags: gcc-opt) | |
|
2021-03-24
| ||
| 19:57 | Add a comment to snapshotrevert.c warning of the undefined effects reverting to an old snapshot may have on newer readers. (Leaf check-in: 00af3bd2 user: dan tags: snapshot-revert) | |
|
2021-03-12
| ||
| 21:59 | Add test for autoconf/Makefile.msc current with respect to its generator input. (Leaf check-in: 4dfd8716 user: larrybr tags: derived_tests) | |
|
2021-03-08
| ||
| 13:45 | Require that the appendvfs suffix mark indicate that the appended database begins at an offset that is a muliple of 512 and that the appended database contains at least 512 bytes. (Leaf check-in: aeb87cc7 user: drh tags: appendvfs_tighten) | |
|
2021-02-12
| ||
| 21:07 | Parsing of DML statements in a WITH clause. But at this point, it just generates an error about "not yet supported". (Leaf check-in: 964ff68d user: drh tags: dml-in-cte) | |
|
2021-02-11
| ||
| 16:19 | In RBU, avoid passing VFS xShmLock calls through to the underlying VFS in cases where xShmMap calls may not be. This fixes a bad interaction with ZipVFS. (Leaf check-in: 0c3838d9 user: dan tags: reuse-schema-3.31) | |
|
2021-02-04
| ||
| 21:19 | Initial commit (Leaf check-in: e73dbce8 user: shearer tags: selective-debug) | |
|
2021-01-20
| ||
| 15:10 | Incorporate the 3.34.1 patches into the reuse-schema branch. (Leaf check-in: cc0e5828 user: drh tags: reuse-schema-3.34) | |
| 14:10 | Version 3.34.1 (Leaf check-in: 10e20c0b user: drh tags: release, patch, version-3.34.1, branch-3.34) | |
|
2020-10-19
| ||
| 01:44 | New test cases for recursive CTEs with multiple recursive terms. (Leaf check-in: cd5182bd user: drh tags: cte-enhancement) | |
|
2020-09-16
| ||
| 16:55 | Merge bugfixes made since version 3.33.0 into this branch. (Leaf check-in: 2e269dcd user: dan tags: reuse-schema-3.33) | |
| 16:49 | Fix a buffer overread found by OSSFuzz that could occur if a WITHOUT ROWID table with many columns was NATURAL JOINed against itself. (Leaf check-in: 807643c5 user: dan tags: branch-3.33) | |
|
2020-09-02
| ||
| 16:14 | Add tests for virtual table shmlock. (Leaf check-in: 1c6a8442 user: dan tags: shmlock-vtab) | |
|
2020-08-31
| ||
| 20:37 | Update this branch with the "PRAGMA noop_update" fix from begin-concurrent-report. (Leaf check-in: 1d984722 user: dan tags: begin-concurrent-unixshmlock-opt) | |
|
2020-07-29
| ||
| 16:18 | Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (Leaf check-in: a80ae2c9 user: drh tags: typos) | |
|
2020-06-18
| ||
| 14:30 | Merge the 3.32.3 release into the reuse-schema branch. (Leaf check-in: c2d36763 user: drh tags: reuse-schema-3.32) | |
| 14:00 | Version 3.32.3 (Leaf check-in: 7ebdfa80 user: drh tags: release, branch-3.32, version-3.32.3) | |
|
2020-06-09
| ||
| 14:56 | Crazy experimental change to refcount the AggInfo objects. (Leaf check-in: 9a4cc1db user: drh tags: refcount-agginfo) | |
| 13:17 | Persist AggInfo expressions before deleting them when omitting the LIMIT clause in a subquery. One possible fix for ticket [7c6d876f84e6e7e2]. (Leaf check-in: 04867cba user: drh tags: tkt-7c6d876f84e6e7e2) | |
|
2020-06-07
| ||
| 14:42 | New debugging output. (Leaf check-in: c0d9dfe5 user: drh tags: early-winfunc-rewrite-dev) | |
| 00:51 | Extra steps to ensure that queries that involve both window functions and aggregate functions are processed correctly by sqlite3WindowRewrite(). Fix for ticket [e5504e987e419fb0]. (Leaf check-in: 765bbcce user: drh tags: branch-3.32-early-winfunc-rewrite) | |
|
2020-04-14
| ||
| 15:35 | Change the name from NATSORT to UINT. Provide an OMIT compile-time option. (Leaf check-in: cc56cbdb user: drh tags: natsort) | |
|
2020-04-09
| ||
| 18:51 | Merge recent trunk changes into the apple-osx branch. (Leaf check-in: d6fda470 user: drh tags: apple-osx) | |
|
2020-04-04
| ||
| 00:29 | In the push-down optimization, do not substitute columns that have previously been identified as being constant by the propagate-constants optimization. Fix for ticket [51166be0159fd2ce]. Also, avoid factoring out constant expressions on the LHS of an IN(...) operator, as the IN(...) operation may affect the affinity of these values. Fix for [fd1bda016d1]. (Leaf check-in: 43612157 user: drh tags: branch-3.31) | |
|
2020-04-01
| ||
| 17:10 | Add support for the "ANALYZE WITH LIMIT=N" syntax. (Leaf check-in: 7e666b60 user: drh tags: analyze-with-limit) | |
|
2020-03-21
| ||
| 14:05 | Merge updates from trunk. (Leaf check-in: 2383aa2c user: drh tags: explain-improvements) | |
|
2020-03-20
| ||
| 20:00 | Add the EXPLAIN TABLES syntax that uses SQLITE_STMTMODE_TABLELIST. Seems to work, but not well-tested. (Leaf check-in: e7343ce7 user: drh tags: sqlite3_stmt_mode) | |
|
2020-01-17
| ||
| 14:18 | Import all FTS3/4 enhancements and fixes that exist on the latest trunk (3.31.0-beta) that do not require extensive change to the SQLite core into the 3.22 branch. Basically, the 3.31.0 FTS3 sources are copied into 3.22.0, with minor changes to work around core enhancements that are not available in 3.22.0. (Leaf check-in: cbcbb1e5 user: drh tags: branch-3.22) | |
|
2020-01-16
| ||
| 13:02 | Very small performance improvement by ensuring that the argument to sqlite3VdbeFreeCursor() is non-NULL. Hold for the next sprint. (Leaf check-in: f8801ffd user: drh tags: close-cursor-faster) | |
|
2020-01-10
| ||
| 00:20 | Begin making changes to turn off trusted schema in command-line tools that open SQLite databases. There are a lot of these, and a lot of places to change, which makes me wonder if trusted schema should be off by default. (Leaf check-in: 3d23a275 user: drh tags: default-untrusted-schema) | |
|
2020-01-07
| ||
| 14:51 | Provide the ability to tag an application-defined function as "testonly". (Leaf check-in: e6f5c0e0 user: drh tags: testonly-functions) | |
|
2019-12-19
| ||
| 03:14 | More restrictions on changes to shadow tables when in defensive mode. (Leaf check-in: 4146c629 user: drh tags: branch-3.30) | |
| 00:59 | Minor enhancement to Win32 locking semantics. (Leaf check-in: ed66ffce user: mistachkin tags: win32LockFlags) | |
|
2019-12-13
| ||
| 22:59 | Initial exploration of blocky APIs, starting with a variant of sqlite3_exec. (Leaf check-in: fd849d5b user: numist tags: blocky-exec) | |
| 00:49 | Tie up the loose ends in the ExprList size reduction. (Leaf check-in: 59d0f3af user: drh tags: two-size-lookaside, exprlist-size-reduction) | |
|
2019-11-27
| ||
| 12:03 | Fix obsolete comment. No changes to code. (Leaf check-in: 0ff59edb user: drh tags: reuse-shm) | |
|
2019-11-07
| ||
| 19:59 | Experimental branch to provide SQLITE_LIMIT_HEAP_K to limit the amount of allocated memory used by each database connection, individually. (Leaf check-in: 4ab9dbb9 user: drh tags: limit_heap_k) | |
|
2019-10-23
| ||
| 18:14 | Add uuid_string and uuid_blob functions (Leaf check-in: 97ba442b user: numist tags: uuid-funcs) | |
|
2019-10-18
| ||
| 22:54 | Use an allocation count and freelist instead of a membership bitfield in the mini lookaside allocator (Leaf check-in: 9496b4d3 user: numist tags: 2-size-lookaside) | |
|
2019-10-11
| ||
| 11:21 | Merge the 3.30.1 changes into reuse-schema. (Leaf check-in: eff7cd7f user: drh tags: reuse-schema-3.30) | |
|
2019-10-08
| ||
| 19:45 | Store 64-bit offset values in osinst log files. (Leaf check-in: 74d975c6 user: dan tags: osinst) | |
|
2019-09-03
| ||
| 19:40 | Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. (Leaf check-in: b54aa18b user: dan tags: branch-3.18) | |
| 19:29 | Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. (Leaf check-in: b584fd36 user: dan tags: branch-3.9) | |
| 18:43 | Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. (Leaf check-in: 0770363b user: drh tags: branch-3.19) | |
|
2019-08-12
| ||
| 15:37 | Fix the build for compilation using separate files rather than the amalgamation. (Leaf check-in: 1e0f4869 user: drh tags: sha3) | |
|
2019-07-22
| ||
| 23:30 | Do not use the insert-overwrite optimization if the cell might overwrite the page header. (Leaf check-in: 9991626b user: drh tags: branch-3.29) | |
|
2019-07-13
| ||
| 16:22 | Rework the FILTER clause implementation to share more code with window functions. (Leaf check-in: 5dac8c38 user: dan tags: filter-clause) | |
|
2019-07-08
| ||
| 12:44 | Comment improvements. No changes to code. (Leaf check-in: b0629132 user: drh tags: tkt9b78184b-alt) | |
|
2019-06-12
| ||
| 20:11 | Enhancements to the printf() logic in order to render a negative zero with a minus sign. (Leaf check-in: 6ba4be66 user: drh tags: negative-zero) | |
|
2019-05-07
| ||
| 02:57 | Add the exprNodeCopy() routine that will safely memcpy() an Expr node that might be a size-reduced node. (Leaf check-in: ab2ba8e7 user: drh tags: expr-node-copy-patch) | |
|
2019-04-27
| ||
| 20:39 | Add the shardvtab virtual table that uses the new cost estimation functions. (Leaf check-in: 9404300a user: drh tags: cost-est) | |
|
2019-04-18
| ||
| 17:37 | Undo change to 'analyze9.test' because the extra output can be useful for debugging. (Leaf check-in: f3081e59 user: mistachkin tags: msvc) | |
|
2019-04-12
| ||
| 20:33 | Add the socketvfs test extension. (Leaf check-in: f5b3ce94 user: dan tags: socketvfs) | |
|
2019-04-04
| ||
| 22:05 | Add the vtab enable/disable options to the sqlite3_db_config TCL command in the testfixture. (Leaf check-in: c7052428 user: drh tags: disable-vtab) | |
|
2019-04-03
| ||
| 17:54 | Add a defense-in-depth NEVER() test to the WAL cleanup code. (Leaf check-in: 1109942a user: drh tags: branch-3.27) | |
|
2019-03-20
| ||
| 20:27 | Experimental change to apply affinity before running CHECK constraints on an INSERT. Note that in the CHECK constraints, REAL affinity really is REAL affinity, and not numeric affinity. This causes failures in some tests that are assuming affinity is applied after CHECK constraints. (Leaf check-in: 9ef69d18 user: drh tags: apply-affinity-first) | |
|
2019-02-21
| ||
| 18:11 | Fix OOM handling in sqlite3NestedParse(). (Leaf check-in: e6e9dd5c user: dan tags: nested-parse-oom) | |
|
2019-02-08
| ||
| 20:55 | Use a fast compiler-provided memory barrier exclusively, if such a memory barrier is available. (Leaf check-in: df66fec9 user: drh tags: faster-memory-barrier) | |
|
2019-01-24
| ||
| 16:51 | While PRAGMA full_column_names is off (the default) do not make changes to the short_column_names pragma when computing the column names for subqueries. (Leaf check-in: 718ead55 user: drh tags: literal-column-names) | |
|
2019-01-06
| ||
| 01:46 | Give symbolic names to the special prepared statements used to implement incremental blob I/O. (Leaf check-in: 2a1cc632 user: drh tags: named-blob-I/O) | |
|
2018-12-28
| ||
| 21:40 | Merge performance enhancements and other patches. (Leaf check-in: 44e1b55a user: drh tags: factor-out-scalar-subselect) | |
|
2018-12-24
| ||
| 15:15 | Merge latest trunk with this branch. (Leaf check-in: 606b1ead user: dan tags: mutexfree-shmlock) | |
|
2018-12-14
| ||
| 21:58 | Experimental support for new sqlite3_bind_blob() and sqlite3_bind_text() interfaces that take an extra void* argument that is passed into the destructor in front of the object that is to be destroyed. (Leaf check-in: 33a1924e user: drh tags: custom-destructors) | |
| 20:28 | Add a missing OP_ColumnsUsed opcode to code for expressions like "? IN (SELECT ...)" in cases where expression can use an index that may contain NULL values. (Backported fix from version 3.14.0). (Leaf check-in: 11368e67 user: drh tags: branch-3.8.9) | |
|
2018-12-10
| ||
| 16:53 | Merge latest mutexfree-shmlock changes into this branch. (Leaf check-in: 186b376e user: dan tags: begin-concurrent-pnu-mutexfree-shmlock) | |
| 16:49 | Fix issues with the new normalizer. (Leaf check-in: 057d7d40 user: drh tags: normalize-refactor) | |
|
2018-12-06
| ||
| 20:18 | Experimental changes to (optionally) allow double-quoted strings to be checked against known identifiers. (Leaf check-in: 73a6b8c1 user: mistachkin tags: normalize_v4) | |
|
2018-12-04
| ||
| 21:16 | When compiled with SQLITE_ENABLE_NORMALIZE, always have sqlite3_exec() enable the SQLITE_PREPARE_NORMALIZE flag. (Leaf check-in: 28643d83 user: mistachkin tags: execWithNormalize) | |
| 01:18 | Attempt to make the parser a little faster by storing the ON and USING clause in a single OnUsing object. (Leaf check-in: 6770ed08 user: drh tags: on-using-opt) | |
|
2018-11-23
| ||
| 13:21 | Make the winTruncate() method of the windows VFS be a no-op if there are outstanding references to the memory-mapped pages. Otherwise, memory might be deleted out from under those references when the file is remapped during the truncate operation. (Leaf check-in: 8576ccb4 user: drh tags: branch-3.25) | |
|
2018-11-20
| ||
| 16:02 | Consolidate the two sqlite3SchemaToIndex() routines. (Leaf check-in: dfab7170 user: dan tags: reuse-schema1) | |
|
2018-10-06
| ||
| 14:33 | Ensure each ALTER TABLE statement makes just a single SQLITE_ALTER_TABLE call to the authorizer function. (Leaf check-in: dac28547 user: dan tags: alter-auth-callbacks) | |
|
2018-10-05
| ||
| 20:09 | When the left-hand side of a WHERE clause contraint is a UNIQUE column, and that term of the WHERE clause is not used for indexing, assume that the term reduces the number of output rows by half. This is one proposed fix for ticket [e8b674241947eb3ba4] (Leaf check-in: 5c243eec user: drh tags: unique-constraint-weights) | |
|
2018-10-04
| ||
| 18:17 | The 0x8000 optimization flag associated with SQLITE_TESTCTRL_OPTIMIZATIONS causes a large penalty (200) to be added to all sorting costs, which encourages the query planner avoid using the sorter. This flag can be used in experiments to help come up with a more accurate estimate of the true cost of sorting. (Leaf check-in: 857a1b01 user: drh tags: query-planner-debug) | |
|
2018-09-27
| ||
| 14:24 | Minor enhancement to the pager so that it remembers if the underlying database files is immutable. (Leaf check-in: 64db614e user: drh tags: immutable-pager) | |
|
2018-09-19
| ||
| 20:14 | Reduce the size of Expr to 64-bytes. This works somewhat, but there are test failures. More importantly, the size reduction from 80- to 64-bytes has not lowered the schema memory usage, but it has made the code a little bigger and a little slower. So the initial evidence is that this Expr refactoring experiment is not working... (Leaf check-in: 24b0f66a user: drh tags: expr-simplify) | |
| 18:17 | A minor code simplification, saved in a branch for future reference. (Leaf check-in: 5e458f4a user: drh tags: minor-altertab-simplification) | |
|
2018-07-20
| ||
| 18:01 | Experimental change to ANALYZE so that when computing values for sqlite_stat1, it uses the maximum number for the number of rows having equivalent values, rather than the average. (Leaf check-in: 085f17e1 user: drh tags: stat1-max) | |
|
2018-07-10
| ||
| 15:55 | Experimental planner change to avoid a skip-scan if a regular index scan on the same index columns can be done instead. (Leaf check-in: 350f29ea user: dan tags: exp-begin-concurrent-pnu) | |
|
2018-07-04
| ||
| 14:28 | Experimental planner change to avoid a skip-scan if a regular index scan on the same index columns can be done instead. (Leaf check-in: 32924446 user: dan tags: exp-avoid-expensive-skipscan) | |
|
2018-06-30
| ||
| 18:54 | Have the tokenizer handle fallback for tokens "OVER" and "FILTER" in the same way as it does for "WINDOW". (Leaf check-in: 12d819e1 user: dan tags: weak-fallback) | |
|
2018-06-21
| ||
| 23:43 | Improved context for error_log message coming from sqlite3_prepare(). (Leaf check-in: 64df1189 user: drh tags: ieee754) | |
|
2018-06-19
| ||
| 19:16 | The file_control_ofd_locks TCL command in testfixture distinguishes between OFD locks unavailable on the platform and OFD locks not used. (Leaf check-in: 87a9e9d7 user: drh tags: ofd-locks) | |
|
2018-05-26
| ||
| 18:03 | Experimental change that allows overloaded functions to be analyzed by the xBestIndex method and used by the xFilter method of a virtual table. (Leaf check-in: a353b1d7 user: drh tags: vtab-func-constraint) | |
|
2018-05-25
| ||
| 14:39 | This is an untested proof-of-concept for enhancements to RTree that attempt to use sqlite3_value_nochange() to reduce the amount of work associated with UPDATE operations in cases where either the coordinates or the auxiliary data is unchanged. (Leaf check-in: 6f7cfeff user: drh tags: rtree-update-optimization) | |
| 03:46 | Add SQLITE_LOCKED_VTAB and SQLITE_CORRUPT_SEQUENCE to sqlite3ErrName(). Also, use SQLITE_CORRUPT_BKPT in one more place. (Leaf check-in: eac8888d user: mistachkin tags: errCodes) | |
|
2018-05-09
| ||
| 02:23 | Version 3.23.2 (Leaf check-in: f139f6f0 user: drh tags: release, branch-3.23, version-3.23.2) | |
|
2018-05-01
| ||
| 01:18 | The ".selecttrace 0x4000" command causes the AST to be output to stdout as a table with four columns. (Leaf check-in: 2a75e631 user: drh tags: ast-trace-demo) | |
|
2018-04-28
| ||
| 12:43 | Add the SQLITE_DBCONFIG_RESET_DATABASE control as a replacement for the reset_database pragma. Resetting the database should be hard enough to do that it cannot be done by accident. (Leaf check-in: ff836cb8 user: drh tags: reset-database) | |
|
2018-04-27
| ||
| 20:49 | Better comments on the bindvtab.c implementation. All the two-argument version of the .set command. All bindings from .set and -D are still string. (Leaf check-in: 7b2a65a6 user: drh tags: shell-bindings) | |
|
2018-04-19
| ||
| 20:18 | Avoid unnecessary OP_Goto instructions on an upsert of a table that only has a single secondary index. (Leaf check-in: 97dd21ab user: drh tags: upsert-opt) | |
|
2018-03-31
| ||
| 18:43 | Fix an error in README-server-edition.html. (Leaf check-in: 754ad35c user: dan tags: server-process-edition) | |
|
2018-03-19
| ||
| 16:59 | Show symbolic SELECT names in EXPLAIN QUERY PLAN output when compiling with SQLITE_ENABLE_SELECTTRACE. (Leaf check-in: 16c22ff8 user: drh tags: EQP-improvements) | |
|
2018-02-27
| ||
| 20:09 | Update zonefile README.md file to mention the frame cache. (Leaf check-in: 84e9351b user: dan tags: zonefile) | |
|
2018-02-15
| ||
| 20:00 | On unix, the "PRAGMA fsync_interval=N" command causes an extra fdatasync() after writing N bytes of content, to force a write-queue flush in the underlying OS. This is an experimental hack that is not expected to land on trunk. (Leaf check-in: b18cc5fe user: drh tags: write-queue-flush-hack) | |
|
2018-02-02
| ||
| 16:46 | Enable the ".wheretrace" and ".selecttrace" options in the shell when configure is run using --enable-debug. This mirrors a similar change that has already occurred on trunk. (Leaf check-in: c4f798b2 user: drh tags: branch-3.9.2) | |
|
2018-01-23
| ||
| 01:56 | Enhance the PRAGMA noop_update statement so that the behavior persists across reprepare operations. (Leaf check-in: c25da6de user: drh tags: noop-update-reprepare) | |
|
2018-01-12
| ||
| 00:30 | Enable the one-pass optimization for DELETE and UPDATE on RTree. This is parked in a branch because is seems to make no measureable performance difference. (Leaf check-in: 8b8314cb user: drh tags: rtree-one-pass) | |
|
2018-01-01
| ||
| 16:59 | Experiments with the regexp.c extension, trying to get it to report the exact substring that matches the RE. (Leaf check-in: 3d6fba62 user: drh tags: regexp-span) | |
|
2017-11-28
| ||
| 02:47 | Add the "PRAGMA table_ipk(TABLE)" command for evaluation purposes. (Leaf check-in: 2494132a user: drh tags: pragma-table-ipk) | |
|
2017-11-21
| ||
| 23:47 | An experimental optimization to DISTINCT that causes an immediate exit of the inner loop of a join following each output row if the inner loop does not contribute any columns to the result set. (Leaf check-in: a33f88ac user: drh tags: distinct-early-out) | |
|
2017-10-24
| ||
| 18:55 | Version 3.21.0 (Leaf check-in: 1a584e49 user: drh tags: release, branch-3.21, version-3.21.0) | |
|
2017-09-22
| ||
| 20:18 | Merge in all the trunk enhancements of the previous 7 months. The LIKE optimization has stopped working when there is an ESCAPE - that problem will be addressed in a subsequent check-in. (Leaf check-in: 8d2a1cca user: drh tags: est_count_pragma) | |
|
2017-09-21
| ||
| 14:03 | The sqlite3_snapshot_describe() interface useful for debugging snapshot logic. (Leaf check-in: 3fbfa9a8 user: drh tags: sqlite3_snapshot_describe) | |
|
2017-09-18
| ||
| 08:51 | Merge latest trunk changes with this branch. (Leaf check-in: 2e573350 user: dan tags: shared-mapping-hack) | |
|
2017-09-13
| ||
| 18:38 | Experimental sqlite3_stmt_retryable() interface. (Leaf check-in: ebada072 user: drh tags: sqlite3_stmt_retryable) | |
|
2017-09-12
| ||
| 18:49 | Add the highly-experimental "PRAGMA noop_update=TRUE" command. (Leaf check-in: de2e3717 user: drh tags: pragma-noop-update) | |
|
2017-09-09
| ||
| 08:03 | Use a mutex-free PRNG for the random() and randomblob() SQL functions and for the randomness used during checkpoint operations. (Leaf check-in: e63d1a7c user: drh tags: mutex-free-randomness) | |
|
2017-08-28
| ||
| 17:32 | Add the --enable-update-limit option to the ./configure script. (Leaf check-in: f545db6c user: drh tags: begin-concurrent-branch-3.19) | |
|
2017-08-27
| ||
| 10:55 | Instrumentation and changes in an effort to reduce thread contention. (Leaf check-in: c93298d5 user: drh tags: reduced-thread-contention) | |
|
2017-08-24
| ||
| 16:21 | Version 3.20.1 (Leaf check-in: 8d3a7ea6 user: drh tags: release, branch-3.20, version-3.20.1) | |
|
2017-08-22
| ||
| 19:44 | mksourceid still does not work right. (Leaf check-in: ca5dcb4a user: drh tags: mistake) | |
|
2017-08-07
| ||
| 19:06 | On Windows, avoid casting a value larger than 2^31 to a (SIZE_T) on systems where it is a 32-bit type. (Leaf check-in: f08d63b4 user: mistachkin tags: mmap-size-limit) | |
|
2017-07-31
| ||
| 12:04 | Merge further enhancements to the batch-atomic-write subsystem. (Leaf check-in: 4be4265d user: drh tags: batch-atomic-write-3.19) | |
|
2017-07-28
| ||
| 20:49 | Disable the writecrash.test module on Windows. (Leaf check-in: 4c0520d4 user: drh tags: batch-atomic-write) | |
|
2017-07-21
| ||
| 04:08 | Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This is a cherry-pick of [f0f49224] which was in turn inspired by [72de49f2]. (Leaf check-in: 5a3022e0 user: drh tags: branch-3.8.10) | |
| 03:23 | Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This is a cherry-pick of [f0f492245e95], which is in turn inspired by check-in [72de49f2]. (Leaf check-in: a66a5b39 user: drh tags: branch-3.8.6) | |
| 03:09 | Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This changes is inspired by check-in [72de49f2] but is new implementation, not a cherry-pick. (Leaf check-in: f0f49224 user: drh tags: branch-3.7.11) | |
|
2017-07-20
| ||
| 16:55 | Experimental API sqlite3_stmt_refresh() to force a prepared statement to recompile if it needs to due to a schema change or other factor. (Leaf check-in: 10556ee4 user: drh tags: sqlite3_stmt_refresh) | |
|
2017-07-15
| ||
| 10:44 | Add new interfaces sqlite3_bind_pointer(), sqlite3_result_pointer(), and sqlite3_value_pointer() used to safely move pointer values through SQL without exposing underlying memory address information. (Leaf check-in: d6a44b35 user: drh tags: branch-3.17) | |
|
2017-07-08
| ||
| 18:27 | Disable compiler intrinsics when using the Intel C Compiler. (Leaf check-in: dbb59f61 user: drh tags: icc-fix) | |
|
2017-06-28
| ||
| 20:12 | Fix bugs in test program tserver.c. (Leaf check-in: 093b9108 user: dan tags: server-edition) | |
|
2017-06-17
| ||
| 19:06 | Avoid adding an artifical "LIMIT 1" on scalar subqueries that do not need it. This seems like a pointless optimization as it makes minimal run-time difference but does increase code complexity. Parked on a branch for historical reference. (Leaf check-in: c21628e9 user: drh tags: subquery-limit-opt) | |
|
2017-06-16
| ||
| 10:15 | Failed version 3.18.1. Somehow I managed to omit the bug fix which was the entire purpose of 3.18.1 in the first place! (Leaf check-in: e3038fbf user: drh tags: mistake) | |
|
2017-06-07
| ||
| 10:55 | Cause the ANALYZE command to build sqlite_stat1 table entries for empty tables with the assumption that such tables really contain 10 elements. This gives better query plans for tables that are truely empty, but is likely to cause problems in legacy systems, so the change is kept off trunk. Some TCL tests fail on this check-in due to the new stat1 entries. (Leaf check-in: c81f260c user: drh tags: analyze-empty-tables) | |
|
2017-05-27
| ||
| 18:05 | Add debugging functions btreePageOriginFile() and btreePageOriginOffset(). (Leaf check-in: 214d238a user: dan tags: btree-debug) | |
|
2017-03-08
| ||
| 23:29 | Refactor the output logic in the CLI. Not sure we want to go this way. Just saving the work for historical reference, or in case I decide to come back to it. (Leaf check-in: aacac906 user: drh tags: shell-print-refactor) | |
|
2017-03-07
| ||
| 14:47 | Before beginning an incremental checkpoint in RBU, sync the directory containing the target database file. This ensures that the new directory entry created by renaming the *-oal file to *-wal is synced to disk. Cherrypick of [915a9a28]. (Leaf check-in: 694fe0b2 user: dan tags: version-3.17.0-rbu-fixes) | |
|
2017-02-21
| ||
| 14:04 | The VDBE cycle counts for the sqlite3_progress_handler() callback are now cumulative. Leftovers from the previous statement are applied to the next statement. (Leaf check-in: 7a62fc6a user: drh tags: cumulative-progress-count) | |
| 13:29 | Proof of concept for a "PRAGMA vdbe_cycle_limit=N" command. When N>0, invoke sqlite3_interrupt() whenever any byte code program uses more than N virtual machine cycles. (Leaf check-in: 9626b41e user: drh tags: vdbe_cycle_limit) | |
|
2017-02-18
| ||
| 20:05 | Add an optimization to OP_Column to speed up sequential OP_Column instructions that read earlier fields from the same cursor. Attempt to reorder OP_Column opcodes so as to take advantage of this. (Leaf check-in: c1adf959 user: dan tags: sort-column-opcodes) | |
|
2017-02-17
| ||
| 21:23 | Increase the estimated cost of sorting when sorting wide results sets, to account for the extra storage space and I/O required for the external sort. (Leaf check-in: 38298ef9 user: drh tags: apple-increased-sorting-cost) | |
| 02:07 | Merge fixes from trunk. (Leaf check-in: 662e8ccf user: drh tags: increased-sorting-cost) | |
|
2017-02-15
| ||
| 17:47 | simple test cases for carray_asc. (Leaf check-in: 1d4759c1 user: drh tags: carray_asc) | |
| 01:02 | Make SQLITE_GET_MUTEX_TIME a proper noop on non-Win32/non-POSIX. (Leaf check-in: 4ca2b2f8 user: mistachkin tags: mutexDbg2) | |
|
2017-02-08
| ||
| 19:10 | Avoid preparing a SELECT statement each time an UPDATE or DELETE by docid is executed against an fts3 table. (Leaf check-in: 9962c10a user: dan tags: fts3-seekstmt-cache) | |
|
2017-02-04
| ||
| 14:30 | Merge the latest trunk changes, especially the RTREE enhancement to use sqlite3_blob objects. (Leaf check-in: 61bd2a88 user: drh tags: sqlite3_blob_reset) | |
|
2017-01-23
| ||
| 21:12 | Experimental changes to permit a VFS to directly override the initial page size. (Leaf check-in: 64131724 user: mistachkin tags: pagePerSector) | |
|
2017-01-21
| ||
| 16:21 | Fix problems in the previous commit. (Leaf check-in: 74ad80eb user: dan tags: trigger-trace) | |
| 15:30 | A proof-of-concept for running sqlite3_blob_open() without using OP_Column when operating on a pure key/value table. This demo does not include any corrupt database checking. Uses about 3% fewer CPU cycles on a key/value performance test. (Leaf check-in: 4cda3b30 user: drh tags: kv-access-opt-demo) | |
|
2017-01-19
| ||
| 12:07 | Add a prototype of the sqlite3_kv_reset() interface. (Leaf check-in: 088c5903 user: drh tags: sqlite3_kv) | |
| 11:52 | Add test cases for the instrumentation on this branch. Fix some OOM handling issues in the same. (Leaf check-in: 50ca94b9 user: dan tags: transaction-pages) | |
|
2017-01-18
| ||
| 23:12 | For Windows 8.x and higher, require the SQLITE_WIN32_WIN8_SECTOR_SIZE compile-time option in order to enable sector size determination. (Leaf check-in: 47beb55c user: mistachkin tags: winSectorSize) | |
|
2017-01-16
| ||
| 11:54 | An example showing how to improve performance of sqlite3VdbeSerialPut() using the GCC intrinsic function __builtin_bswap64(). (Leaf check-in: e42ed9b4 user: drh tags: builtin-bswap64) | |
|
2017-01-12
| ||
| 15:19 | Test case macros to show that the previous check-in is well tested. (Leaf check-in: bd8b977a user: drh tags: extra-testcase-macros) | |
|
2017-01-09
| ||
| 20:57 | Merge latest changes from trunk, and also move the perf-counter into the inner loop of sqlite3BtreeMovetoUnpacked(). (Leaf check-in: ff9eab95 user: drh tags: vdbe-aux-perf) | |
|
2017-01-06
| ||
| 16:32 | Version 3.16.2 (Leaf check-in: a65a6289 user: drh tags: release, branch-3.16, version-3.16.2) | |
|
2016-12-07
| ||
| 07:46 | Merge latest trunk changes into this branch. (Leaf check-in: 391344d8 user: dan tags: changebatch) | |
|
2016-11-28
| ||
| 19:13 | Version 3.15.2 (Leaf check-in: bbd85d23 user: drh tags: release, version-3.15.2, branch-3.15) | |
|
2016-11-10
| ||
| 21:19 | Break up the sqlite3BtreeMovetoUnpacked() routine into an eponymous routine and sqlite3BtreeMovetoIntkey(). Each routine specializes in a single kind of btree. (Leaf check-in: 9a64a4f2 user: drh tags: split-moveto) | |
|
2016-10-25
| ||
| 15:39 | Enhance the "PRAGMA index_info" and "PRAGMA index_xinfo" statements so that they work on WITHOUT ROWID tables and provide information about the underlying index btree that implements the WITHOUT ROWID table. (Leaf check-in: fe49fb03 user: drh tags: index-info-on-table) | |
|
2016-10-20
| ||
| 18:20 | Add the ability for the PRAGMA statement to accept multiple arguments. Currently all arguments other than the first are ignored. (Leaf check-in: fd81d8a4 user: drh tags: multi-arg-pragma) | |
|
2016-10-17
| ||
| 23:44 | Fix SQLITE_DBCONFIG_REQUIRE_TXN so that it allows BEGIN IMMEDAITE and BEGIN EXCLUSIVE to run outside of a transaction. (Leaf check-in: 29997f79 user: drh tags: require-write-txn) | |
| 19:00 | Escape non-ASCII character from an ICU extension comment. Cherrypick of [5ec02ecf3d20ce7e]. (Leaf check-in: a3a96c4d user: mistachkin tags: mutexDbg) | |
|
2016-08-13
| ||
| 14:30 | Questionable changes to support interruptible checkpoint in ZipVFS. (Leaf check-in: c7a9f26d user: dan tags: interruptible-checkpoint) | |
|
2016-08-10
| ||
| 03:35 | Try to make pcache1TruncateUnsafe() run faster for the case where iLimit is very close to iMaxKey. (Leaf check-in: 9ab53605 user: drh tags: debug) | |
|
2016-07-14
| ||
| 20:19 | Experimental patch restore the slight bias in btree-balancing immediately after the change to reduces the amount of memcpy() work done by balancing. (Leaf check-in: 46bd9533 user: drh tags: btree-balance-bias) | |
|
2016-06-24
| ||
| 02:21 | Provide for a separate default page size for TEMP and transient database files and initialize that separate default page size to 1024 instead of 4096. (Leaf check-in: a2778ae4 user: drh tags: temp-page-size) | |
|
2016-05-03
| ||
| 19:36 | Add the experimental SQLITE_FCNTL_WIN32_GET_HANDLE file control. (Leaf check-in: b6ddabe1 user: mistachkin tags: win32GetHandle) | |
|
2016-04-18
| ||
| 17:30 | Version 3.12.2 (Leaf check-in: 92dc59fd user: drh tags: release, branch-3.12.0, version-3.12.2) | |
|
2016-04-14
| ||
| 19:29 | Work toward improving analysis and code generation for DISTINCT and aggregate queries. (Leaf check-in: 129083bd user: drh tags: better-distinct-agg) | |
|
2016-04-08
| ||
| 21:35 | Attempt to treat the arguments to a table-valued function as if they occur in the ON clause of a LEFT JOIN rather than in the WHERE clause. But this causes undesirable behavior with generate_series, as demonstrated by test cases. This is an incremental check-in pending further work. (Leaf check-in: 00ac73a0 user: drh tags: tabfunc-in-left-join) | |
|
2016-04-05
| ||
| 00:44 | Avoid unnecessary memset() operations in sqlite3PagerGet(). (Leaf check-in: 0c97b802 user: drh tags: pager-get-noinit) | |
|
2016-03-29
| ||
| 21:19 | Fix some code and test coverage issues in fts5_index.c. (Leaf check-in: 7635c680 user: dan tags: fts5) | |
|
2016-03-04
| ||
| 19:55 | Simplify the computation of Index.aAvgEq. (Leaf check-in: c4488730 user: drh tags: analyze-worst-case) | |
|
2016-03-03
| ||
| 16:17 | Version 3.11.1 (Leaf check-in: f047920c user: drh tags: release, branch-3.11, version-3.11.1) | |
|
2016-02-27
| ||
| 19:03 | More compact implementation of PRAGMA onconflict, and some test cases. (Leaf check-in: 3e5d38f5 user: drh tags: pragma-onconflict) | |
|
2016-02-04
| ||
| 02:34 | Add and use the sqlite3VdbeZeroRegister() interface for coding the common operation of writing zero into a register. (Leaf check-in: 1c8d3001 user: drh tags: zero-register) | |
|
2016-02-02
| ||
| 00:59 | Add the SQLITE_DBCONFIG_REQUIRE_WRITE_TXN connection setting, which if enabled requires all write operations to be enclosed within BEGIN ... COMMIT. (Leaf check-in: 7453790c user: drh tags: require-write-txn) | |
|
2016-01-26
| ||
| 20:08 | Further minor performance improvements and code-size reductions related to fts5 column filters on detail=col tables. (Leaf check-in: b4ac61ae user: dan tags: fts5-perf) | |
| 15:23 | Change the automatic index mechanism so that it avoids creating transient indexes on columns that are known to have low cardinality. (Leaf check-in: 12ef3a8f user: drh tags: autoindex-planning) | |
|
2016-01-20
| ||
| 15:27 | Version 3.10.2 (Leaf check-in: 17efb420 user: drh tags: release, version-3.10.2, branch-3.10) | |
|
2015-12-30
| ||
| 20:50 | Use the OvflOffset() macro to try to remove some magic numbers from btree.c. (Leaf check-in: 1541607d user: drh tags: ovfloffset-macro) | |
|
2015-12-17
| ||
| 19:17 | Make the VdbeCursor object even smaller. But the resulting library is bigger and slower than trunk. This branch is a failed experiment. (Leaf check-in: 896a06cc user: drh tags: optimize-vdbecursor) | |
|
2015-12-12
| ||
| 19:23 | Update some stale comments in delete.c. No changes to code. (Leaf check-in: f59a3326 user: dan tags: onepass-delete-or) | |
|
2015-11-21
| ||
| 17:53 | Add a new OP_BColumn opcode where the cursor is guaranteed to be of type CURTYPE_BTREE and is thus able to skip some checks and run slightly faster. (Leaf check-in: 093e0d10 user: drh tags: btree-column-opcode) | |
|
2015-10-17
| ||
| 01:00 | Change the code generator for UPDATE to generate code in an order that might run more efficiently in many cases. (Leaf check-in: c6239bf9 user: drh tags: improved-update) | |
|
2015-10-16
| ||
| 03:34 | Whenever two or more OP_Column opcodes on the same cursor occur in succession, try to reordering them so that the one that extracts the right-most column is first, so that it will warm up the row cache for all those that follow. This gives a small performance boost. (Leaf check-in: 08e8f04d user: drh tags: reorder-column-opcodes) | |
|
2015-10-15
| ||
| 21:13 | Merge updates from trunk. (Leaf check-in: 40493680 user: mistachkin tags: mutexInitIsInitReCheck) | |
| 21:12 | Merge updates from trunk. (Leaf check-in: a447cf90 user: mistachkin tags: mutexInitSimpleCmpSwap) | |
| 20:17 | Experiments with an OP_Unpack opcode that extracts multiple columns from a record without caching. (Leaf check-in: 39ae92f5 user: drh tags: unpack-opcode) | |
|
2015-09-28
| ||
| 23:45 | Avoid unnecessary cursors and seeking when running a DELETE against a WITHOUT ROWID table. (Leaf check-in: 70ec88b2 user: drh tags: delete-without-rowid-opt) | |
|
2015-09-25
| ||
| 20:18 | Fix a faulty assert() on the benign-malloc controller callback in test_malloc.c. (Leaf check-in: 64f2cb8d user: drh tags: malloc-testing) | |
|
2015-08-13
| ||
| 21:43 | Convert the hint expression of the CursorHint opcode into a string for display by EXPLAIN. (Leaf check-in: 12640cb2 user: drh tags: cursor-hints-displayP4) | |
|
2015-08-11
| ||
| 13:41 | Add some extra timestamps to the experimental log output. (Leaf check-in: b09e3ea7 user: dan tags: experimentalIoLog) | |
|
2015-08-07
| ||
| 09:42 | Within a write-transaction on a wal database in mmap mode, check the page-cache for an entry before the wal file. This can be faster if the wal file is very large. (Leaf check-in: 3a82c8e6 user: dan tags: mmap-wal-bigtrans) | |
|
2015-06-20
| ||
| 18:13 | Split out all four cases of cellSizePtr() into different methods, each optimized for the specific page type. This gives a 0.36% performance increase at a cost of about 300 bytes of code. (Leaf check-in: 522502ec user: drh tags: btree-opt) | |
|
2015-06-13
| ||
| 19:05 | Added test cases based on Bruce Momjian's talk on SQL NULLs. (Leaf check-in: 68c168b5 user: drh tags: is-distinct-from) | |
|
2015-06-11
| ||
| 17:58 | Merge trunk fixes. (Leaf check-in: 1df8cbbe user: drh tags: view-optimization) | |
|
2015-06-02
| ||
| 16:09 | Add the built-in affinity() SQL function. This turns out to be not as useful as originally envisioned, so abandon it on a branch. (Leaf check-in: 80889306 user: drh tags: affinity-func) | |
|
2015-05-13
| ||
| 04:52 | Merge updates from trunk. (Leaf check-in: 10ee36d0 user: mistachkin tags: get-trace) | |
|
2015-05-02
| ||
| 18:25 | Add the SQLITE_LIMIT_PRINTF_WIDTH setting for sqlite3_limit() and associated logic for preventing DOS attacks using printf() with oversized widths or precisions. (Leaf check-in: f8b15979 user: drh tags: limit-printf-width) | |
|
2015-04-22
| ||
| 14:41 | Prototype for an sqlite3_db_log() interface. (Leaf check-in: 658e20f5 user: drh tags: sqlite3_db_log) | |
|
2015-04-15
| ||
| 19:13 | Add the BtCursor.pPage field which is the current page to which the cursor points, for a very small performance gain. (Leaf check-in: a200e1ea user: drh tags: btree-current-page-cache) | |
|
2015-04-10
| ||
| 08:28 | Update this branch with the latest changes from sorter-opt. (Leaf check-in: 08c0b19b user: dan tags: insert-select-opt) | |
|
2015-04-06
| ||
| 22:05 | Detect and suppress an endless loops in clearDatabasePage() that might result from a corrupt database file. This is an edited cherry-pick from [30011ad2f55c] and [395bb3e677a]. (Leaf check-in: e5f5ef00 user: drh tags: apple-osx-385) | |
|
2015-03-30
| ||
| 19:56 | Optimize CREATE INDEX, REINDEX and VACUUM statements by taking better advantage of the fact that index keys are being inserted into b-trees in sorted order. (Leaf check-in: 763d2bc7 user: dan tags: mistake) | |
|
2015-03-25
| ||
| 00:09 | Backport the 'stdcall' related enhancements from trunk. (Leaf check-in: cbb93d1a user: mistachkin tags: stdcall-3.8.8) | |
|
2015-02-26
| ||
| 14:27 | In the command-line shell, change the units on the ".width" directive from bytes to characters. (Leaf check-in: b1a9e291 user: drh tags: cli-char-width) | |
|
2015-02-25
| ||
| 13:29 | Version 3.8.8.3 (Leaf check-in: 9d6c1880 user: drh tags: release, version-3.8.8.3, branch-3.8.8) | |
|
2015-02-02
| ||
| 22:19 | Add an experimental pragma "PRAGMA preload;" that preloads the pcache with the entire database file. (Leaf check-in: 6dca23e6 user: drh tags: preload-pragma) | |
|
2014-12-09
| ||
| 01:34 | Version 3.8.7.4 (Leaf check-in: f66f7a17 user: drh tags: release, version-3.8.7.4, branch-3.8.7) | |
|
2014-10-23
| ||
| 17:26 | Add debugging code to count the number of iterations of each loop made as part of statement execution. (Leaf check-in: c6a5b67a user: dan tags: debug-loopcounters) | |
|
2014-10-02
| ||
| 09:27 | Fix a segfault that could occur if an 'optimize' command was issued on an FTS table that contained at least one row but zero terms. (Leaf check-in: b21746ac user: dan tags: branch-3.7.14) | |
|
2014-09-29
| ||
| 18:47 | Add the OPFLAG_MULTICOLUMN flag to the OP_Column opcode. Rearrange OP_Column instructions to take advantage of the new flag for a small performance increase (Leaf check-in: 5e5d6e86 user: drh tags: faster-OP_Column) | |
|
2014-08-12
| ||
| 13:32 | Remove support for Win9x. (Leaf check-in: 169fc47e user: drh tags: drop-win9x-support) | |
|
2014-07-31
| ||
| 17:47 | Try to reuse sorter statements in fts5. Does not work due to circular references on VTable object. (Leaf check-in: bc14e64b user: dan tags: save_sorter_stmt) | |
|
2014-06-17
| ||
| 15:13 | Small tweaks to the query planner to get it to try harder to use an index for sorting and to avoid using automatic indexes on constant terms. (Leaf check-in: 2d9de154 user: drh tags: branch-3.8.3) | |
|
2014-06-10
| ||
| 20:18 | Proposed change to the fix for ticket [1c69be2dafc28b] such that legacy applications that were exploiting the older buggy behavior in SQLite continue to work. (Leaf check-in: 401a0ca3 user: drh tags: group-by-name-resolution) | |
|
2014-05-28
| ||
| 09:56 | Moved to "mistake" because this commit contains a typo causing a test to fail. Was: Add an extra test to further verify that the FTS notindexed option is working properly. (Leaf check-in: 7d445e59 user: dan tags: mistake) | |
|
2014-05-19
| ||
| 19:26 | Fix harmless compiler warnings in MSVC. (Leaf check-in: aa7e2041 user: drh tags: safer-malloc) | |
|
2014-05-09
| ||
| 17:17 | Merge recent trunk changes into the orderby-planning branch. (Leaf check-in: 8d8609d6 user: drh tags: orderby-planning) | |
|
2014-05-06
| ||
| 15:28 | Experimental changes that reduce the size of Expr objects from 72 to 64 bytes each on x64 and from 48 to 44 bytes each on x32. (Leaf check-in: 8ad0a123 user: drh tags: smaller-expr) | |
|
2014-05-05
| ||
| 22:49 | Add the "omit_check_constraints" pragma that causes the check constraint expressions to be omitted from the parse tree. (Leaf check-in: f1a4bf01 user: drh tags: reduce-schema-size) | |
|
2014-04-03
| ||
| 16:53 | Version 3.8.4.3 (Leaf check-in: a611fa96 user: drh tags: release, version-3.8.4.3, branch-3.8.4) | |
|
2014-02-26
| ||
| 19:05 | Only run the OP_OpenRead opcodes for a correlated subquery once, on the initial iteration. Keep the cursor open for subsequent runs. This was suppose to be a performance enhancement, but it is difficult to come up with a query where is makes a significant difference. Hence, the change is getting parked in a branch. (Leaf check-in: 3ad687b7 user: drh tags: open-only-once) | |
|
2014-02-12
| ||
| 15:05 | Various fixes and test case updates so that veryquick.test passes again. (Leaf check-in: f352ef57 user: dan tags: deferred-open) | |
|
2014-02-06
| ||
| 14:59 | Change more OP_OpenEphemeral operations to OP_OpenHash. (Leaf check-in: 881164cf user: drh tags: subquery-codegen-refactor) | |
|
2014-01-28
| ||
| 00:49 | Provide hints to the btree layer Next and Previous primitives to let them know if they can be no-ops if the underlying index is unique. (Leaf check-in: a2c347fa user: drh tags: branch-3.8.2) | |
|
2013-11-14
| ||
| 15:35 | An experimental virtual tables for showing the content of internal schema objects. (Leaf check-in: d1fbc6ca user: drh tags: schema2-vtab) | |
|
2013-10-30
| ||
| 12:30 | Have the shell ".timer on" command cause the shell to report wall-clock time for each query (as well as user and system CPU time). (Leaf check-in: 5530cdc4 user: dan tags: shell-wall-clock) | |
|
2013-10-07
| ||
| 16:53 | Try to remember statistics from ANALYZE using LogEst instead of u64. (Leaf check-in: 8e78557a user: drh tags: log-stats) | |
|
2013-09-13
| ||
| 19:08 | VSIX tooling changes to support Visual Studio 2013. (Leaf check-in: e8ac4a12 user: mistachkin tags: branch-3.8.0) | |
|
2013-09-02
| ||
| 23:40 | Add the experimental SQLITE_DEFAULT_INDEX_SHAPE=1 compile-time option that makes a much more pessimistic guess at the effectiveness of unanalyzed indices. (Leaf check-in: d8daaba7 user: drh tags: index-shape-1) | |
|
2013-04-12
| ||
| 11:52 | Version 3.7.16.2 (Leaf check-in: cbea02d9 user: drh tags: release, version-3.7.16.2, branch-3.7.16) | |
|
2013-04-10
| ||
| 03:22 | Backport the multi-process tester to the last released version. (Leaf check-in: bf6ca21b user: mistachkin tags: branch-3.7.16) | |
|
2013-04-01
| ||
| 14:20 | Minor changes to unixMapfile() function. (Leaf check-in: 80c63443 user: dan tags: two-mappings) | |
|
2013-01-26
| ||
| 19:26 | Add a single test case to fts4unicode.test to verify that title-case maps to lower case. (Leaf check-in: 46f7c930 user: drh tags: branch-3.7.15) | |
|
2012-12-06
| ||
| 20:27 | Cherrypick [79ef8e3c77] (Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements). (Leaf check-in: 34aafb74 user: dan tags: branch-3.7.9) | |
|
2012-10-25
| ||
| 23:47 | Further work on getting ssdsim to run. This is an incremental checkin to save my place while jumping off to work on other things. (Leaf check-in: ae2f1627 user: drh tags: ssdsim) | |
|
2012-10-16
| ||
| 21:08 | An optimization that converts "a IN (b)" into "a==b". Seems to work, but needs additional test cases. (Leaf check-in: 8b4c3c5e user: drh tags: degenerate_IN) | |
|
2012-10-04
| ||
| 22:45 | Merge the 3.7.14.1 release including the fix for the LEFT JOIN problem into the sessions branch. (Leaf check-in: 17644c0e user: drh tags: sessions-3.7.14) | |
|
2012-08-25
| ||
| 00:49 | Backport check-in [62678be3df35cd]: When the same index is used for all OR-terms in a WHERE clause, then try to use that index as a covering index. (Leaf check-in: 865dfcba user: drh tags: branch-3.7.2) | |
|
2012-08-22
| ||
| 15:16 | Do not let the multi-core sorter use lookaside memory, which is not thread-safe. (Leaf check-in: acdc7d12 user: drh tags: threads-sort-ex1) | |
|
2012-08-15
| ||
| 15:57 | Experimental change to speed up ORDER BY clauses that sort based on a single expression. (Leaf check-in: 2bb8c492 user: dan tags: sorter-exp) | |
|
2012-08-07
| ||
| 01:37 | Parser bug fix: Make sure the table constraints allowed by prior releases can still be parsed, even if they are technically not allowed by the syntax diagram. This is a cherry-pick of [a1c014d8a87c8940b3], [38bf90af1ede6ee64e], and [e536ac041815b118c4]. (Leaf check-in: 28aed847 user: drh tags: apple-osx-ml) | |
|
2012-05-04
| ||
| 13:22 | Minor tweaks to the hebrew transliteration tables. (Leaf check-in: 7b6de5c3 user: drh tags: translit-tokenizer) | |
|
2012-04-04
| ||
| 13:51 | Fix the multiplexor logging so that it works with SQLITE_ENABLE_8_3_NAMES. (Leaf check-in: 627eff32 user: drh tags: nx-devkit) | |
|
2011-12-23
| ||
| 11:07 | Fix a problem with [f9c4a7c8f4] as applied to this branch. (Leaf check-in: e6a04bf9 user: dan tags: branch-3.7.6) | |
|
2011-10-11
| ||
| 00:09 | Patches to the apple-osx-377 branch so that it will compile and run on non-Mac unix platforms. (Leaf check-in: b431a634 user: drh tags: apple-osx-377) | |
|
2011-06-28
| ||
| 17:39 | Version 3.7.7.1. (Leaf check-in: af0d91ad user: dan tags: release, version-3.7.7.1, branch-3.7.7) | |
|
2011-06-21
| ||
| 15:34 | Backport the localtime() failure patch from trunk. Ticket [bd484a090c8077]. (Leaf check-in: 2f5b3712 user: drh tags: branch-3.6.1) | |
|
2011-06-01
| ||
| 11:26 | Toward version 3.7.5.1. This check-in updates the version number and also patches the pager so that it never spills cache while in WAL mode. The latter patch fixes ticket [2d1a5c67dfc23] and also prevents excessive WAL file sizes if the pager cache starts thrashing. A few test cases fail. (Leaf check-in: 2e5a912a user: drh tags: branch-3.7.5) | |
|
2011-05-19
| ||
| 02:34 | Bring the apple-wal-readonly branch up to date with the latest changes in apple-osx, and especially the fix for disappearing WAL transactions. (Leaf check-in: 57912327 user: drh tags: apple-wal-readonly) | |
|
2011-02-23
| ||
| 14:33 | Automatically retry system calls that fail with EINTR. This is a backport of the changes from [b9d29ea385bafc] and [af9ba2a6d2c379]. (Leaf check-in: 8609a15d user: drh tags: branch-3.7.4) | |
|
2011-02-19
| ||
| 14:19 | Changes which attempt to address an obscure SQLITE_PROTOCOL error. (Leaf check-in: 1725aa75 user: drh tags: wal-trace-375) | |
|
2011-01-05
| ||
| 13:07 | Cherrypick the WAL error logging from the pre-3.7.5 line into a branch for version 3.7.2. Include the sqlite3_vsnprintf() interface. This checkin is intended for debugging and not for release. (Leaf check-in: 6549e767 user: drh tags: wal-trace-372) | |
|
2010-10-02
| ||
| 01:01 | Backport the very lastest R-Tree in order to take advantage of its enhanced robustness to corrupt databases. (Leaf check-in: 29a681dd user: drh tags: apple-osx-3623) | |
| 01:00 | Fix the amalgamation builder so that it works with the rtree updates of the prior check-in. (Leaf check-in: 265b0b29 user: drh tags: branch-3.6.23) | |
|
2010-08-04
| ||
| 12:31 | Version 3.7.0.1 (Leaf check-in: 042a1abb user: drh tags: release, branch-3.7.0) | |
|
2010-03-22
| ||
| 23:55 | Sync the database file after a rollback. This is a cherrypick merge of check-in [b21b911f23]. (Leaf check-in: 82dd61fc user: drh tags: branch-3.6.22) | |
|
2010-01-30
| ||
| 23:08 | The iInUseDB and iInUseMM variables do not need to be volatile. (Leaf check-in: bb18f578 user: drh tags: branch-3.5.9) | |
|
2009-12-16
| ||
| 23:28 | Fix for the "(x AND y) OR z" bug backported to version 3.6.21. (Leaf check-in: 86734732 user: drh tags: branch-3.6.21) | |
|
2009-10-30
| ||
| 13:26 | Version 3.6.16.1 (Leaf check-in: 2a832b19 user: drh tags: release, branch_3_6_16) | |
|
2009-09-03
| ||
| 19:43 | Fix a VDBE stack overflow issue with the UPDATE statement. (Leaf check-in: 715cecb8 user: drh tags: branch-3.3.6) | |
|
2009-05-25
| ||
| 15:00 | Version 3.6.14.2 (CVS 6680) (Leaf check-in: ab76d1a2 user: drh tags: branch_3_6_14, release) | |
|
2008-11-26
| ||
| 18:01 | Version 3.6.6.2 (CVS 5960) (Leaf check-in: 30a20807 user: drh tags: branch_3_6_6) | |
|
2007-08-14
| ||
| 13:20 | Back-port critical soft heap limit fixes to version 3.3.17. The following check-ins were back-ported: (4031), (4037), (4097), (4202), (4203), (4207), (4208), (4214). (CVS 4222) (Leaf check-in: f0029da3 user: drh tags: branch_3_3_17) | |
|
2007-05-10
| ||
| 21:31 | Backport the stack-size reduction patch in (3673) to version 3.3.13. (CVS 3979) (Leaf check-in: e91012b6 user: drh tags: branch_3_3_13) | |
|
2007-01-08
| ||
| 16:20 | Fix a date round-off problem in strftime(). Ticket #2153. (CVS 3575) (Leaf check-in: 47fee16b user: drh tags: version_2) | |
|
2005-12-19
| ||
| 17:27 | Version 3.2.8 (CVS 2835) (Leaf check-in: e61382ae user: drh tags: branch_3_2) | |