SQLite
Timeline
Not logged in

50 most recent check-ins

2016-12-10
13:12
[35ecd4eb] Leaf: Avoid an unnecessary memset() in the sqlite3BtreeInsert() routine. (user: drh, tags: trunk)
12:58
[8165f88b] Reorder the fields in the VdbeCursor object so that those that need to be bulk zeroed on allocation are grouped at the beginning, and the memset() only runs over those fields that really need it. (user: drh, tags: trunk)
04:06
[c9bdf7ad] Avoid signed integer overflow when dealing with a LIMIT and OFFSET whose sum exceeds the maximum integer value. (user: drh, tags: trunk)
00:14
[478627c9] Closed-Leaf: In balance_nonroot, try to combine dropCell/insertCell combinations for the dividers into a cell overwrites. This results in a very small (0.05%) performance gain which is probably not worth the added complexity. (user: drh, tags: failed-dropCell-opt)
2016-12-09
19:42
[684ef458] When doing the sqlite3BtreeInsert() overwrite optimization, make sure the memcpy() does not extend off the end of the page. (user: drh, tags: trunk)
18:09
[c1f0ae9d] Additional comments and an assert on the sqlite3BtreeInsert() overwrite optimization. (user: drh, tags: trunk)
17:32
[0b86fbca] In sqlite3BtreeInsert() when replacing a re-existing row, try to overwrite the cell directly rather than deallocate and reallocate the cell. (user: drh, tags: trunk)
16:12
[0ea3ece9] Fix an fts5 bug that could cause a crash following an OOM error or sqlite3_interrupt() interrupt. (user: dan, tags: trunk)
16:02
[01ada3d1] Avoid unnecessary zeroing of fields in the MemPage object that are going to be reinitialized before use anyhow. A smaller and faster binary results. (user: drh, tags: trunk)
00:15
[1f16c9a7] Fix an obscure problem in range estimation with STAT4. (user: drh, tags: trunk)
2016-12-08
23:52
[92998e4a] Fix the showstat4 utility program so that is displays strings using standard SQL notation (single quotes) rather than C-style notation. (user: drh, tags: trunk)
19:04
[b26df26e] Fix a minor error in the cg_anno.tcl script causing the cycles-per-file counts to be miscomputed. (user: drh, tags: trunk)
18:36
[254a83bf] Update the tool/cg_anno.tcl script to give a summary of cycle counts by canonical source file name. (user: drh, tags: trunk)
01:38
[83bc5e40] More changes to take advantage of the sqlite3VdbeAppendP4() method. (user: drh, tags: trunk)
2016-12-07
21:35
[28883e8f] Add the sqlite3VdbeAppendP4() method for adding P4 content to the most recently coded instruction. (user: drh, tags: trunk)
20:22
[3954f837] The use P4_DYNAMIC in place of the P4_MPRINTF operand type. (user: drh, tags: trunk)
20:09
[04716c90] Performance optimization for sqlite3VdbeAddOp4(). (user: drh, tags: trunk)
17:06
[24574a15] Put the SQLITE_UNTESTABLE compile-time option in the correct order for PRAGMA compile_options. (user: drh, tags: trunk)
15:49
[f3608187] Rename the SQLITE_OMIT_BUILTIN_TEST compile-time option to SQLITE_UNTESTABLE. (user: drh, tags: trunk)
15:38
[433d16ff] Prevent the flattening or where-term push-down optimizations from obscuring misuses of SQL row values that can lead to crashes or assert() failures. (user: dan, tags: trunk)
13:49
[afab1663] Always honor the sqlite3.dbOptFlags bitmask, regardless of compile-time options. Continuing fix for ticket [da78413751863]. (user: drh, tags: trunk)
07:46
[391344d8] Leaf: Merge latest trunk changes into this branch. (user: dan, tags: changebatch)
2016-12-06
22:47
[2a81763e] Performance improvement and size reduction in the Expr node allocator function sqlite3PExpr(). (user: drh, tags: trunk)
19:33
[0820f8b3] Add missing nul-terminator to a Tcl_AppendResult() call in tclsqlite.c. (user: dan, tags: trunk)
17:59
[e8247065] In the LEMON parser-generator, fix the stack overflow processing so that it correct invokes the destructor on the top-level of the parse stack. (user: drh, tags: trunk)
2016-12-05
20:16
[b4bc40d1] Fix a harmless redundant local variable declaration in the date/time function logic. (user: drh, tags: trunk)
20:06
[8df492c1] Work around a bug in the definition of "ino_t" on some versions of Android. (user: drh, tags: trunk)
2016-12-02
19:07
[6e144735] Simplify the date/time function logic for improved rebustness and also to decrease the size of the binary. (user: drh, tags: trunk)
17:08
[768c9859] Extend the valid range of 'unixepoch' dates from JulianDay 0 through 9999-12-31. (user: drh, tags: trunk)
14:15
[3c58b173] Closed-Leaf: Fix a potential integer overflow during out-of-bound date computations. (user: drh, tags: date-overflow-fix)
02:19
[0bdb7ae1] Test cases for the improved LIKE/GLOB matcher. (user: drh, tags: trunk)
2016-12-01
19:58
[a427c405] Avoid clearing the EP_FromJoin flag from terms in ON clauses when flattening sub-selects. Possible fix for [2df0107b]. (user: dan, tags: trunk)
19:38
[8bed4cd5] Closed-Leaf: Avoid clearing the EP_FromJoin flag from terms in ON clauses when flattening sub-selects. Possible fix for [2df0107b]. (user: dan, tags: left-join-fix)
18:57
[2df0ebf9] Performance improvement for GLOB and LIKE matching for patterns with two or more multi-character wildcards ("*" or "%"). (user: drh, tags: trunk)
18:49
[a1e2b6ce] Closed-Leaf: Faster version of patternCompare() that uses new return values rather than an extra parameter to communicate wildcard information back up to parent searches. (user: drh, tags: pattern-compare-optimization)
17:34
[c5e5614d] Modify the patternCompare() function (used for GLOB, LIKE) to better handle patterns containing multiple wildcard characters ("*", "%"). (user: dan, tags: pattern-compare-optimization)
2016-11-30
16:54
[d2d30914] Add the remember(V,PTR) extension function which copies an SQL value into an application variable. (user: drh, tags: trunk)
16:39
[7ca58a07] Leaf: Merge all the latest changes from trunk. (user: drh, tags: est_count_pragma)
14:47
[3816bb41] Fix then handling of the (oversized) integer literal -0x8000000000000000. (user: drh, tags: trunk)
05:08
[9d0d8c2e] Change the OP_DecrJumpZero opcode back to its old behavior of always decrementing, except top the decrementing when it reaches the largest negative number. (user: drh, tags: trunk)
04:07
[1218005a] More improvements to boundary cases in the date/time functions, flowing out of branch coverage testing. (user: drh, tags: trunk)
01:05
[96106d56] Prevent a warning about integer overflow when using a very large negative LIMIT. (user: drh, tags: trunk)
00:48
[dc453b34] Further changes to the date/time functions to suppress harmless signed integer overflow warnings that could have occurred when doing out-of-range date calculations which, according to the docs, give undefined results. (user: drh, tags: trunk)
2016-11-29
20:39
[d410a839] The documentation says that the built-in date-time functions give undefined results for dates before 0000-01-01 and after 9999-12-31. Change the actually implementation so that the answer given is really NULL. This also avoids unnecessary hand-wringing over an signed integer overflow that might otherwise occur when processing out-of-bound dates. (user: drh, tags: trunk)
2016-11-28
21:22
[9021f687] Fix broken hyperlinks to the sqlite3_snapshot objection definition in the documentation. No changes to code. (user: drh, tags: trunk)
19:13
[bbd85d23] Leaf: Version 3.15.2 (user: drh, tags: release, branch-3.15, version-3.15.2)
14:52
[7cc2d60d] Simplify some code in fts5_expr.c. Add some extra test cases for the same. (user: dan, tags: trunk)
2016-11-26
20:44
[41a3af54] Leaf: Merge all recent trunk changes, and especially the new sqlite3_snapshot_recover() interface. (user: drh, tags: apple-osx)
20:12
[d6a7bf80] Update test case for opening SHM files read/write on a read-only connection so that they are only attempted on Darwin with SQLITE_ENABLE_PRESIST_WAL. (user: drh, tags: apple-osx)
19:44
[b70c85ce] Add the sqlite3_snapshot_recover() interface and related functionality. (user: drh, tags: trunk)