SQLite
Timeline
Not logged in

50 most recent timeline items

2016-12-09
00:15
[1f16c9a7] Leaf: 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:09 • Edit [3c58b173d90f2fbf|3c58b173]: Mark "Closed". (user: drh)
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
23:37 • Fixed ticket [2df0107b]: Incorrect result from LEFT JOIN with a subquery on the LHS plus 3 other changes (user: drh)
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)
19:34 • Ticket [2df0107b] Incorrect result from LEFT JOIN with a subquery on the LHS status still Open with 6 other changes (user: drh) ... 1 similar event omitted.
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)
2016-11-25
20:20
[a4205a83] Clarification of the behavior of sqlite3_stmt_readonly() on BEGIN IMMEDIATE statements. The is comment changes only - no changes to code. (user: drh, tags: trunk)
19:32
[6ac7b07a] Remove the OP_RowKey opcode. Use OP_RowData in its place. (user: drh, tags: trunk)
19:18
[49ebc219] Refactor the sqlite3BtreeKey() and sqlite3BtreeData() internal interfaces into sqlite3BtreePayload() and sqlite3BtreePayloadChecked(), respectively. This is a continuation of the optimization started by check-in [2d831074cf]. The result is a slightly smaller and faster binary. (user: drh, tags: trunk)
17:03
[a9498407] Small performance increase and size reduction in the OP_Column opcode. (user: drh, tags: trunk)
15:47
[c53dca7f] Performance enhancement to sqlite3_snprintf(). (user: drh, tags: trunk)