/ Timeline
Login

100 check-ins occurring around bbd85d235f.

2016-12-12
12:58
Merge recent enhancements from trunk. check-in: dc006e08 user: drh tags: est_count_pragma
11:05
Performance optimization in sqlite3PagerWrite(). check-in: d4dff10a user: drh tags: trunk
01:53
Updates to the tokenizer for EBCDIC. No changes for standard builds. check-in: 4fc6580f user: drh tags: trunk
01:30
Size and performance optimization in btreeInitPage() in the freeblock validation step. check-in: 57deb1b4 user: drh tags: trunk
00:58
Change the order of comparison for divider cell overflow in balance non-root to avoid a (harmless) reference to an uninitialized variable. check-in: f9f2e23b user: drh tags: trunk
2016-12-10
13:12
Avoid an unnecessary memset() in the sqlite3BtreeInsert() routine. check-in: 35ecd4eb user: drh tags: trunk
12:58
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. check-in: 8165f88b user: drh tags: trunk
04:06
Avoid signed integer overflow when dealing with a LIMIT and OFFSET whose sum exceeds the maximum integer value. check-in: c9bdf7ad user: drh tags: trunk
00:14
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. Closed-Leaf check-in: 478627c9 user: drh tags: failed-dropCell-opt
2016-12-09
19:42
When doing the sqlite3BtreeInsert() overwrite optimization, make sure the memcpy() does not extend off the end of the page. check-in: 684ef458 user: drh tags: trunk
18:09
Additional comments and an assert on the sqlite3BtreeInsert() overwrite optimization. check-in: c1f0ae9d user: drh tags: trunk
17:32
In sqlite3BtreeInsert() when replacing a re-existing row, try to overwrite the cell directly rather than deallocate and reallocate the cell. check-in: 0b86fbca user: drh tags: trunk
16:12
Fix an fts5 bug that could cause a crash following an OOM error or sqlite3_interrupt() interrupt. check-in: 0ea3ece9 user: dan tags: trunk
16:02
Avoid unnecessary zeroing of fields in the MemPage object that are going to be reinitialized before use anyhow. A smaller and faster binary results. check-in: 01ada3d1 user: drh tags: trunk
00:15
Fix an obscure problem in range estimation with STAT4. check-in: 1f16c9a7 user: drh tags: trunk
2016-12-08
23:52
Fix the showstat4 utility program so that is displays strings using standard SQL notation (single quotes) rather than C-style notation. check-in: 92998e4a user: drh tags: trunk
19:04
Fix a minor error in the cg_anno.tcl script causing the cycles-per-file counts to be miscomputed. check-in: b26df26e user: drh tags: trunk
18:36
Update the tool/cg_anno.tcl script to give a summary of cycle counts by canonical source file name. check-in: 254a83bf user: drh tags: trunk
01:38
More changes to take advantage of the sqlite3VdbeAppendP4() method. check-in: 83bc5e40 user: drh tags: trunk
2016-12-07
21:35
Add the sqlite3VdbeAppendP4() method for adding P4 content to the most recently coded instruction. check-in: 28883e8f user: drh tags: trunk
20:22
The use P4_DYNAMIC in place of the P4_MPRINTF operand type. check-in: 3954f837 user: drh tags: trunk
20:09
Performance optimization for sqlite3VdbeAddOp4(). check-in: 04716c90 user: drh tags: trunk
17:06
Put the SQLITE_UNTESTABLE compile-time option in the correct order for PRAGMA compile_options. check-in: 24574a15 user: drh tags: trunk
15:49
Rename the SQLITE_OMIT_BUILTIN_TEST compile-time option to SQLITE_UNTESTABLE. check-in: f3608187 user: drh tags: trunk
15:38
Prevent the flattening or where-term push-down optimizations from obscuring misuses of SQL row values that can lead to crashes or assert() failures. check-in: 433d16ff user: dan tags: trunk
13:49
Always honor the sqlite3.dbOptFlags bitmask, regardless of compile-time options. Continuing fix for ticket [da78413751863]. check-in: afab1663 user: drh tags: trunk
07:46
Merge latest trunk changes into this branch. Leaf check-in: 391344d8 user: dan tags: changebatch
2016-12-06
22:47
Performance improvement and size reduction in the Expr node allocator function sqlite3PExpr(). check-in: 2a81763e user: drh tags: trunk
19:33
Add missing nul-terminator to a Tcl_AppendResult() call in tclsqlite.c. check-in: 0820f8b3 user: dan tags: trunk
17:59
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. check-in: e8247065 user: drh tags: trunk
2016-12-05
20:16
Fix a harmless redundant local variable declaration in the date/time function logic. check-in: b4bc40d1 user: drh tags: trunk
20:06
Work around a bug in the definition of "ino_t" on some versions of Android. check-in: 8df492c1 user: drh tags: trunk
2016-12-02
19:07
Simplify the date/time function logic for improved rebustness and also to decrease the size of the binary. check-in: 6e144735 user: drh tags: trunk
17:08
Extend the valid range of 'unixepoch' dates from JulianDay 0 through 9999-12-31. check-in: 768c9859 user: drh tags: trunk
14:15
Fix a potential integer overflow during out-of-bound date computations. Closed-Leaf check-in: 3c58b173 user: drh tags: date-overflow-fix
02:19
Test cases for the improved LIKE/GLOB matcher. check-in: 0bdb7ae1 user: drh tags: trunk
2016-12-01
19:58
Avoid clearing the EP_FromJoin flag from terms in ON clauses when flattening sub-selects. Possible fix for [2df0107b]. check-in: a427c405 user: dan tags: trunk
19:38
Avoid clearing the EP_FromJoin flag from terms in ON clauses when flattening sub-selects. Possible fix for [2df0107b]. Closed-Leaf check-in: 8bed4cd5 user: dan tags: left-join-fix
18:57
Performance improvement for GLOB and LIKE matching for patterns with two or more multi-character wildcards ("*" or "%"). check-in: 2df0ebf9 user: drh tags: trunk
18:49
Faster version of patternCompare() that uses new return values rather than an extra parameter to communicate wildcard information back up to parent searches. Closed-Leaf check-in: a1e2b6ce user: drh tags: pattern-compare-optimization
17:34
Modify the patternCompare() function (used for GLOB, LIKE) to better handle patterns containing multiple wildcard characters ("*", "%"). check-in: c5e5614d user: dan tags: pattern-compare-optimization
2016-11-30
16:54
Add the remember(V,PTR) extension function which copies an SQL value into an application variable. check-in: d2d30914 user: drh tags: trunk
16:39
Merge all the latest changes from trunk. check-in: 7ca58a07 user: drh tags: est_count_pragma
14:47
Fix then handling of the (oversized) integer literal -0x8000000000000000. check-in: 3816bb41 user: drh tags: trunk
05:08
Change the OP_DecrJumpZero opcode back to its old behavior of always decrementing, except top the decrementing when it reaches the largest negative number. check-in: 9d0d8c2e user: drh tags: trunk
04:07
More improvements to boundary cases in the date/time functions, flowing out of branch coverage testing. check-in: 1218005a user: drh tags: trunk
01:05
Prevent a warning about integer overflow when using a very large negative LIMIT. check-in: 96106d56 user: drh tags: trunk
00:48
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. check-in: dc453b34 user: drh tags: trunk
2016-11-29
20:39
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. check-in: d410a839 user: drh tags: trunk
2016-11-28
21:22
Fix broken hyperlinks to the sqlite3_snapshot objection definition in the documentation. No changes to code. check-in: 9021f687 user: drh tags: trunk
19:13
Version 3.15.2 Leaf check-in: bbd85d23 user: drh tags: release, version-3.15.2, branch-3.15
14:52
Simplify some code in fts5_expr.c. Add some extra test cases for the same. check-in: 7cc2d60d user: dan tags: trunk
2016-11-26
20:44
Merge all recent trunk changes, and especially the new sqlite3_snapshot_recover() interface. check-in: 41a3af54 user: drh tags: apple-osx
20:12
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. check-in: d6a7bf80 user: drh tags: apple-osx
19:44
Add the sqlite3_snapshot_recover() interface and related functionality. check-in: b70c85ce user: drh tags: trunk
2016-11-25
20:20
Clarification of the behavior of sqlite3_stmt_readonly() on BEGIN IMMEDIATE statements. The is comment changes only - no changes to code. check-in: a4205a83 user: drh tags: trunk
19:32
Remove the OP_RowKey opcode. Use OP_RowData in its place. check-in: 6ac7b07a user: drh tags: trunk
19:18
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. check-in: 49ebc219 user: drh tags: trunk
17:03
Small performance increase and size reduction in the OP_Column opcode. check-in: a9498407 user: drh tags: trunk
15:47
Performance enhancement to sqlite3_snprintf(). check-in: c53dca7f user: drh tags: trunk
15:11
Performance improvement in sqlite3StrAccumFinish() for the common case where no memory allocation is required. check-in: b6acf5d4 user: drh tags: trunk
14:30
Add a comment to help clarify the EP_FromJoin hack in exprCodeBetween(). check-in: 6df7c574 user: drh tags: trunk
2016-11-24
13:42
Fix a test case in vacuum5.test so that it works with the in-memory journal permutation. Cherrypick of [81c86401]. check-in: e31d646a user: dan tags: branch-3.15
2016-11-23
23:18
Fix the error message for invalid ".mode" arguments in the command-line shell, so that it mentions the new "quote" mode. check-in: 9a603a18 user: drh tags: trunk
21:33
Updates makefiles and build scripts on windows to used Tcl 8.6. check-in: f693850a user: drh tags: branch-3.15
21:14
Update the version number to 3.15.2. check-in: 86dc74cb user: drh tags: branch-3.15
21:13
Code constant vector components outside of any loops in CASE and BETWEEN expressions. Fix for [1a684656]. check-in: 4c6efe60 user: drh tags: branch-3.15
21:08
Prevent a possible use-after-free bug in the query optimizer. check-in: 661b4506 user: drh tags: branch-3.15
21:01
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. check-in: 27438fb4 user: drh tags: branch-3.15
20:44
Fix a potential use-after-free error during parsing of malformed CREATE TABLE statement. check-in: 0f956597 user: drh tags: branch-3.15
20:37
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. check-in: 4efd331e user: drh tags: branch-3.15
20:31
Fix OOM error reporting in the json1_group_object() SQL function. Remove an unreachable branch from the JSON1 logic. check-in: 6492e57e user: drh tags: branch-3.15
20:24
Fix the JSON1 extension so that the JSON validator correctly rejects malformed backslash escapes within string literals. check-in: 7c466283 user: drh tags: branch-3.15
20:19
Avoid a crash that can occur after an obscure OOM in the built-in INSTR() function. check-in: 8a55b8e1 user: drh tags: branch-3.15
20:12
Mark the ICU extension functions as deterministic. check-in: 8fd2fcce user: drh tags: branch-3.15
19:43
Handle some obscure "row value misused" cases that could cause segfaults or assertion failures. check-in: 794763fd user: drh tags: branch-3.15
19:40
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] check-in: f8cf7ff1 user: drh tags: branch-3.15
19:31
Code constant vector components outside of any loops in CASE and BETWEEN expressions. Fix for [1a684656]. check-in: c08aff13 user: dan tags: trunk
14:19
Correctly display the names of SQL functions in the VDBE_PROFILE output. check-in: 161192f1 user: drh tags: trunk
2016-11-22
22:23
Merge bug fixes and enhancements from trunk. Closed-Leaf check-in: e2c4bdf5 user: drh tags: serializable-snapshot
21:11
Enclose the sqlite3WalSnapshotRecover() routine within check-in: e7be3183 user: drh tags: serializable-snapshot
20:29
Add a new requirement mark for CAST expressions. check-in: bee2859b user: drh tags: trunk
19:15
Update requirement marks to reflect changes in wording in the documentation. No changes to code. check-in: f5ac98ef user: drh tags: trunk
01:26
Remove unnecessary OP_Close opcodes for a size reduction and performance increase. check-in: 32be7aae user: drh tags: trunk
2016-11-21
21:33
Remove unnecessary OP_Close opcodes at the end of INSERT operations, resulting in smaller and faster code. check-in: abeddb6d user: drh tags: trunk
18:15
Enhance speedtest1.c so that is works on older versions of SQLite, before the introduction of the group_concat() aggregate function. check-in: 9979ba80 user: drh tags: trunk
2016-11-20
17:59
Fix harmless compiler warnings. check-in: b3b7b42d user: drh tags: trunk
12:00
Prevent a possible use-after-free bug in the query optimizer. check-in: 0a98c8d7 user: drh tags: trunk
2016-11-19
18:31
Remove the requirement to open the wal file before sqlite3_snapshot_recover() is called. Also add some comments to new functions. check-in: 28393c41 user: dan tags: serializable-snapshot
17:30
Test some extra error conditions in sqlite3_recover_snapshot(). check-in: db314213 user: dan tags: serializable-snapshot
17:20
Add another fault-injection test for sqlite3_snapshot_recover(). check-in: 7e040406 user: dan tags: serializable-snapshot
16:35
Fix a problem causing sqlite3_snapshot_recover() to return SQLITE_IOERR_SHORT_READ. check-in: 525f75fa user: dan tags: serializable-snapshot
14:53
Fix a bug in sqlite3_snapshot_recover() that could cause subsequent read transactions to use out-of-data cache entries. check-in: 9abeb798 user: dan tags: serializable-snapshot
2016-11-18
20:49
Add experimental sqlite3_snapshot_recover() API. check-in: 174a6076 user: dan tags: serializable-snapshot
18:43
Require that the database handle be in autocommit mode for sqlite3_snapshot_get() to succeed. This is because it may open a read transaction on the database file. check-in: 83b658da user: dan tags: serializable-snapshot
18:22
Add tests for snapshot interfaces. check-in: 1f7ee7af user: dan tags: serializable-snapshot
14:38
Enhance existing snapshot tests to serialize/deserialize snapshots. No new tests. check-in: 16b9bf92 user: dan tags: serializable-snapshot
2016-11-17
21:52
Experimental changes for faster in-memory DB operation for large databases. Closed-Leaf check-in: 4fe94b0f user: drh tags: memdb-opt
20:05
Fix a problem in rtreeD.test causing it to fail in OMIT_BUILTIN_TEST builds. check-in: d6b3779e user: dan tags: trunk
14:02
When opening the *-shm file for a readonly database, try to open it in read-write mode before falling back to readonly. This is in case some other read/write connection within the same process uses the same file descriptor. check-in: a07c581e user: dan tags: apple-osx