SQLite
Timeline
Not logged in

50 most recent check-ins

2016-12-02
19:07
[6e144735] Leaf: 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)
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)
15:11
[b6acf5d4] Performance improvement in sqlite3StrAccumFinish() for the common case where no memory allocation is required. (user: drh, tags: trunk)
14:30
[6df7c574] Add a comment to help clarify the EP_FromJoin hack in exprCodeBetween(). (user: drh, tags: trunk)
2016-11-24
13:42
[e31d646a] Fix a test case in vacuum5.test so that it works with the in-memory journal permutation. Cherrypick of [81c86401]. (user: dan, tags: branch-3.15)
2016-11-23
23:18
[9a603a18] Fix the error message for invalid ".mode" arguments in the command-line shell, so that it mentions the new "quote" mode. (user: drh, tags: trunk)
21:33
[f693850a] Updates makefiles and build scripts on windows to used Tcl 8.6. (user: drh, tags: branch-3.15)
21:14
[86dc74cb] Update the version number to 3.15.2. (user: drh, tags: branch-3.15)
21:13
[4c6efe60] Code constant vector components outside of any loops in CASE and BETWEEN expressions. Fix for [1a684656]. (user: drh, tags: branch-3.15)
21:08
[661b4506] Prevent a possible use-after-free bug in the query optimizer. (user: drh, tags: branch-3.15)
21:01
[27438fb4] Disable the query flattener optimization for SELECT statements that are on the RHS of vector IN operators. This is a hack that fixes the bug described in ticket [da7841375186386c]. A better solution that does not disable the query flattener is needed, but this will server for the time being. (user: drh, tags: branch-3.15)
20:44
[0f956597] Fix a potential use-after-free error during parsing of malformed CREATE TABLE statement. (user: drh, tags: branch-3.15)
20:37
[4efd331e] Fix an fts5 problem causing a crash in phrase queries where the first token of the phrase matches one or more rows but some other token within the phrase matches zero. (user: drh, tags: branch-3.15)
20:31
[6492e57e] Fix OOM error reporting in the json1_group_object() SQL function. Remove an unreachable branch from the JSON1 logic. (user: drh, tags: branch-3.15)
20:24
[7c466283] Fix the JSON1 extension so that the JSON validator correctly rejects malformed backslash escapes within string literals. (user: drh, tags: branch-3.15)
20:19
[8a55b8e1] Avoid a crash that can occur after an obscure OOM in the built-in INSTR() function. (user: drh, tags: branch-3.15)
20:12
[8fd2fcce] Mark the ICU extension functions as deterministic. (user: drh, tags: branch-3.15)
19:43
[794763fd] Handle some obscure "row value misused" cases that could cause segfaults or assertion failures. (user: drh, tags: branch-3.15)
19:40
[f8cf7ff1] Take care not to try to generate code for the ATTACH and DETACH commands if there were syntax errors during parsing. Fix for ticket [2f1b168ab4d4844] (user: drh, tags: branch-3.15)
19:31
[c08aff13] Code constant vector components outside of any loops in CASE and BETWEEN expressions. Fix for [1a684656]. (user: dan, tags: trunk)
14:19
[161192f1] Correctly display the names of SQL functions in the VDBE_PROFILE output. (user: drh, tags: trunk)
2016-11-22
22:23
[e2c4bdf5] Closed-Leaf: Merge bug fixes and enhancements from trunk. (user: drh, tags: serializable-snapshot)
21:11
[e7be3183] Enclose the sqlite3WalSnapshotRecover() routine within (user: drh, tags: serializable-snapshot)
20:29
[bee2859b] Add a new requirement mark for CAST expressions. (user: drh, tags: trunk)