Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around 44b21e35c92137cc.
2017-05-31
| ||
17:30 | Add the SQLITE_STMTSTATUS_MEMUSED opcode to sqlite3_stmt_status() for finding the heap memory usage by a single prepared statement. (check-in: c26cf978 user: drh tags: trunk) | |
17:06 | Generate extra log messages in response to irregularites in the pointer-map used by "BEGIN CONCURRENT" transactions. (check-in: f7e3e2bc user: dan tags: begin-concurrent) | |
16:21 | Add the SQLITE_STMTSTATUS_MEMUSED option for sqlite3_stmt_status() that reports the amount of heap memory used for a single prepared statement. (Closed-Leaf check-in: b57d5104 user: drh tags: stmtstatus-memused) | |
16:09 | Add the experimental "stmts" virtual table for introspection of prepared statements. (check-in: cb4c5c66 user: drh tags: trunk) | |
13:45 | Avoid allocating excess memory to the KeyInfo objects. (check-in: df785943 user: drh tags: trunk) | |
13:27 | Remove a completely unnecessary memset() from the INSERT code generator. (check-in: 7d58836b user: drh tags: trunk) | |
11:24 | Very small performance increase in sqlite3VdbeSetNumCols(). (check-in: 8885b446 user: drh tags: trunk) | |
03:20 | Reorder fields in the PgHdr object for a performance increase. (check-in: 326e63d7 user: drh tags: trunk) | |
02:58 | Avoid unnecessary memory zeroing during expression list allocation. (check-in: de28e651 user: drh tags: trunk) | |
00:49 | Size and performance optimizations to sqlite3ResolveExprNames(). (check-in: af8c0fed user: drh tags: trunk) | |
2017-05-30
| ||
18:34 | Change sqlite3BtreeNext() and sqlite3BtreePrevious() so that they return SQLITE_DONE if they have already reached the end (or beginning) of the table. This gives a performance increase and size reduction. (check-in: e972a386 user: drh tags: trunk) | |
18:14 | Omit a test of codepoint 0x202F (non-break narrow space) from the fts3 ICU tests. Different versions of ICU apparently handle this obscure codepoint slightly differently. (check-in: 69ae6889 user: dan tags: trunk) | |
2017-05-29
| ||
22:44 | More efficient error handling and reset in the binding mechanism. (check-in: 9a3e3b34 user: drh tags: trunk) | |
19:23 | Instead of a root page number, log the object (table or index) name if a page level locking conflict is detected. (check-in: 9ad846e5 user: dan tags: begin-concurrent) | |
17:59 | Omit unnecessary fstat() calls for determining the database file size, resulting in smaller and faster code. (check-in: dd61c736 user: drh tags: trunk) | |
17:43 | Fix an issue with OPT_FEATURE_FLAGS in configure.ac. (check-in: 43ce3bd3 user: drh tags: trunk) | |
16:45 | Avoid unnecessary fstat() calls to determine the database size when transitioning into a read transaction on a rollback-mode database. (Closed-Leaf check-in: 6c3476b5 user: drh tags: io-opt) | |
14:57 | Avoid unnecessary calls to fstat() to determine the database file size. (check-in: c733a1de user: drh tags: io-opt) | |
14:30 | Fix a typo in a comment. No code changes. (check-in: cb29b838 user: drh tags: trunk) | |
14:27 | Enhance the log messages emitted when a page conflict is detected. (check-in: 92618492 user: dan tags: begin-concurrent) | |
14:26 | Optimizations to the Walker object and its methods to make the code a little smaller and to help it run a little faster. (check-in: 6854a34e user: drh tags: trunk) | |
13:09 | Correctly initialize the iSelectId of FROM clause terms that are a self join of a reused materialized subquery. Without this, the EXPLAIN QUERY PLAN output for the query will identify the subquery using the uninitialized (and arbitrary) iSelectId. (check-in: 43c9ae37 user: drh tags: trunk) | |
03:48 | Improve shell help text for the '.open' command. (check-in: 7cc940a9 user: mistachkin tags: trunk) | |
2017-05-27
| ||
22:42 | Smaller and faster vdbeSorterCompareText(). (check-in: 542dc4c5 user: drh tags: trunk) | |
18:05 | • Edit [214d238a4763adff|214d238a]: Move to branch btree-debug. (artifact: c2e57e9d user: dan) | |
18:05 | Add debugging functions btreePageOriginFile() and btreePageOriginOffset(). (Leaf check-in: 214d238a user: dan tags: btree-debug) | |
2017-05-26
| ||
18:18 | Adjust the bitvec related sqlite3_log messages added by [9527089b]. (check-in: a7e0e7a4 user: dan tags: begin-concurrent) | |
16:51 | Add extra test cases for deferred page allocation. (check-in: 9df01957 user: dan tags: begin-concurrent) | |
16:15 | Fix a problem with deferred page allocation in transactions that revert page allocations by savepoint rollbacks. (check-in: a4a3bbe6 user: dan tags: begin-concurrent) | |
2017-05-25
| ||
21:35 | Small performance increase and size decrease in the btreeInitPage() routine. (check-in: 6f415833 user: drh tags: trunk) | |
21:02 | Fix a problem with the deferred page allocation on this branch that could occur when the database file is just slightly smaller than the PENDING_BYTE page offset. (check-in: 47a7dd92 user: dan tags: begin-concurrent) | |
17:36 | Merge all fixes from the 3.19.2 release. (check-in: 12964240 user: drh tags: apple-osx) | |
17:27 | Merge the LEFT JOIN query flattener fixes from 3.19.2. (check-in: 6513e4a1 user: drh tags: trunk) | |
16:50 | Version 3.19.2 (check-in: edb4e819 user: drh tags: release, branch-3.19, version-3.19.2) | |
16:28 | • Fixed ticket [7fde638e]: Assertion fault on a LEFT JOIN plus 5 other changes (artifact: f6f681e5 user: drh) | |
11:39 | The SQLITE_EXTRA_IFNULLROW compile-time option causes OP_IfNullRow opcodes to be issued for references to the right-hand side table of *any* flattened join, not just LEFT JOINs. This puts extra stress on the OP_IfNUllRow opcodes for testing purposes. (check-in: 1a074c8a user: drh tags: branch-3.19) | |
00:28 | The TK_IF_NULL_ROW expression node must be treated as a variable that references the table Expr.iTable. Proposed fix for ticket [7fde638e94287d2c]. (check-in: b30a364a user: drh tags: branch-3.19) | |
00:12 | Increase the version number to 3.19.2 since ticket [7fde638e94287d2] is going to necessitate another patch release. (check-in: c315727a user: drh tags: branch-3.19) | |
00:08 | The TK_IF_NULL_ROW expression node must be treated as a variable that references the table Expr.iTable. Proposed fix for ticket [7fde638e94287d2c]. (check-in: 77fc2301 user: drh tags: trunk) | |
2017-05-24
| ||
22:39 | • New ticket [7fde638e] Assertion fault on a LEFT JOIN. (artifact: dcc0914b user: drh) | |
15:32 | Fix harmless compiler warnings in FTS5. (check-in: 57a60e95 user: mistachkin tags: trunk) | |
13:08 | Version 3.19.1 (check-in: f6d7b988 user: drh tags: release, branch-3.19, version-3.19.1) | |
04:32 | Fix a problem in STAT4 equality estimation for multi-column indexes introduced by check-in [3e0590dee0e68cc1599]. (check-in: 19dad0a7 user: drh tags: branch-3.8.9) | |
04:18 | Fix a problem in STAT4 equality estimation for multi-column indexes introduced by check-in [3e0590dee0e68cc1599]. (check-in: cfb0d9e0 user: drh tags: trunk) | |
2017-05-23
| ||
20:00 | Remove the msvc.h header file from the autoconf tarball. (check-in: 84996aef user: drh tags: trunk) | |
19:35 | Do not use strcpy() in the (obsolete) amatch extension. In releasetest.tcl, run Apple tests using -Os instead of -O1 (check-in: 4440e420 user: drh tags: trunk) | |
19:23 | Add experimental new API sqlite3_wal_info(). (check-in: 5b9d498f user: dan tags: begin-concurrent) | |
19:16 | • Fixed ticket [cad1ab4c]: Segfault due to LEFT JOIN flattening optimization plus 3 other changes (artifact: 83102567 user: drh) | |
15:33 | Disable the LEFT JOIN flattening optimization for aggregate queries, as it does not currently work. Further fix for ticket [cad1ab4cb7b0fc344]. (check-in: 05ada741 user: drh tags: branch-3.19) | |
15:21 | Disable the LEFT JOIN flattening optimization for aggregate queries, as it does not currently work. Further fix for ticket [cad1ab4cb7b0fc344]. (check-in: 44b21e35 user: drh tags: trunk) | |
15:18 | • Open ticket [cad1ab4c]: Segfault due to LEFT JOIN flattening optimization plus 3 other changes (artifact: f952f397 user: drh) ... 1 similar event omitted. | |
12:44 | Ensure that the expression rewriter inside the query flattener decends into the substructure of the TK_IF_NULL_ROW operator. This is a continuation of the fix for ticket [cad1ab4cb7b0fc344]. (check-in: 28d2902d user: drh tags: branch-3.19) | |
12:36 | Ensure that the expression rewriter inside the query flattener decends into the substructure of the TK_IF_NULL_ROW operator. This is a continuation of the fix for ticket [cad1ab4cb7b0fc344]. (check-in: 941d8142 user: drh tags: trunk) | |
12:35 | • Ticket [cad1ab4c] Segfault due to LEFT JOIN flattening optimization status still Fixed with 3 other changes (artifact: 88096b0c user: drh) | |
01:35 | Change the version number to 3.19.1. (check-in: 16656b8f user: drh tags: branch-3.19) | |
01:30 | Remove a surplus semicolon, which was harmless on gcc and clang but caused compile-time errors on msvc. This only comes up using the encryption extension. (check-in: 4510d55d user: drh tags: branch-3.19) | |
01:29 | • Fixed ticket [cad1ab4c]: Segfault due to LEFT JOIN flattening optimization plus 5 other changes (artifact: b4ade83b user: drh) | |
01:29 | When flattening a query, make sure iTable attribute of TK_IF_NULL_ROW operators (that result from a prior flattening of a LEFT JOIN) are updated correctly. Fix for ticket [cad1ab4cb7b0fc344]. (check-in: 919d36e6 user: drh tags: branch-3.19) | |
01:21 | When flattening a query, make sure iTable attribute of TK_IF_NULL_ROW operators (that result from a prior flattening of a LEFT JOIN) are updated correctly. Fix for ticket [cad1ab4cb7b0fc344]. (check-in: 92c17850 user: drh tags: trunk) | |
01:17 | • New ticket [cad1ab4c] Segfault due to LEFT JOIN flattening optimization. (artifact: 6e17327e user: drh) | |
00:32 | Remove a surplus semicolon, which was harmless on gcc and clang but caused compile-time errors on msvc. This only comes up using the encryption extension. (check-in: 987a2b55 user: drh tags: trunk) | |
2017-05-22
| ||
19:24 | Pull in all changes from the 3.19.0 release. (check-in: bbd2d0e1 user: drh tags: apple-osx) | |
18:09 | Fix incompatibilities between the "sqldiff --changeset" command and the sessions module. Specifically, allow sessions to process changesets containing tables with zero operations on them and have sqldiff output the expected output for tables with multi-column primary keys. (check-in: 0bb23c48 user: dan tags: trunk) | |
18:00 | Add the ".cd" command to the command-line shell. (check-in: 5fe28e15 user: drh tags: trunk) | |
17:39 | Increase the version number to 3.20 for the next release cycle. (check-in: ab471f61 user: drh tags: trunk) | |
14:04 | Merge the last-minute 3.19.0 changes into trunk. (check-in: e6ba2a93 user: drh tags: trunk) | |
13:58 | Version 3.19.0 (check-in: 28a94eb2 user: drh tags: release, branch-3.19, version-3.19.0) | |
13:06 | Include the "msvc.h" header file in the amalgamation tarball. (check-in: 3dd6fe53 user: drh tags: branch-3.19) | |
08:04 | Fix a case where NULL was being passed to memcmp() following an OOM. This is probably not a real problem, as the number-of-bytes parameter was passed 0 in this case, but it was causing a santizer complaint. (check-in: 3ea2bad2 user: dan tags: trunk) | |
08:01 | Add code to this branch to emit a log message after each cumulative second that the WRITER lock has been held. (check-in: a726d981 user: dan tags: server-edition) | |
00:45 | When planning a query using sorting, resolve ties in the solver by selecting loop plans with the smaller unsorted cost. (check-in: f261678c user: drh tags: trunk) | |
00:27 | When planning a query using sorting, resolve ties in the solver by selecting loop plans with the smaller unsorted cost. (check-in: 962531e7 user: drh tags: branch-3.8.9) | |
2017-05-19
| ||
23:04 | Prevent a possible NULL pointer dereference in the OP_Found opcode that can follow an OOM error. Problem found by OSS-Fuzz. (check-in: 50ad60de user: drh tags: branch-3.19) | |
22:51 | Prevent a possible NULL pointer dereference in the OP_Found opcode that can follow an OOM error. Problem found by OSS-Fuzz. (check-in: c2de178f user: drh tags: trunk) | |
20:55 | Improved comments on one routine in the query planner. Improved diagnostic output for ".wheretrace". No production code changes. (check-in: 946b87a5 user: drh tags: trunk) | |
20:47 | Fix a documentation typo. No changes to code. (check-in: 68942a4f user: drh tags: trunk) | |
20:46 | Branch for the 3.19 release. (check-in: f2b829ec user: drh tags: branch-3.19) | |
19:57 | Invoke sqlite3_log() in response to irregularities surrounding the Pager.pAllRead bit-vector. (check-in: 9527089b user: dan tags: begin-concurrent) | |
12:32 | Fix some problems in fts5 code detected by -fsanitize=undefined. (check-in: 35f72104 user: dan tags: trunk) | |
2017-05-18
| ||
20:47 | Fix a problem on this branch causing some page-level read-locks to be omitted. (check-in: 0eed1521 user: dan tags: begin-concurrent) | |
18:17 | Fix a documentation typo. No changes to code. (Closed-Leaf check-in: cfa4aa20 user: drh tags: doc-type) | |
2017-05-16
| ||
09:50 | • Edit [7940bff32aa6ea86|7940bff3]: Edit check-in comment. (artifact: bf833132 user: dan) | |
09:49 | Update the tool/warnings.sh script to automatically use the right options on OpenBSD. (check-in: 7940bff3 user: dan tags: trunk) | |
2017-05-15
| ||
19:32 | Avoid writer starvation by adding a RESERVED state to page locks. (check-in: 9b7f8024 user: dan tags: server-edition) | |
17:56 | Merge changes from trunk. (check-in: 6e0f64ab user: drh tags: schemalint) | |
17:34 | Merge the latest changes from trunk. (check-in: 14ea8400 user: drh tags: begin-concurrent) | |
15:12 | Fix the build so that it works again with SQLITE_OMIT_SUBQUERY. (check-in: bb0d9281 user: drh tags: trunk) | |
15:05 | Improvements to the omittest.tcl script. (check-in: 0f05d7e9 user: drh tags: trunk) | |
2017-05-13
| ||
19:07 | Avoid running recovery while there is another read/write client. (check-in: a38858a2 user: dan tags: server-edition) | |
2017-05-12
| ||
18:52 | Require exclusive access to the db to wrap the wal file. Have "PRAGMA wal_checkpoint = restart" block for this. (check-in: cbf44ed9 user: dan tags: server-edition) | |
14:05 | Make sure the 'sqlite3changegroup_*' functions are included in the SQLITE_APICALL handling. (check-in: a123cb93 user: mistachkin tags: trunk) | |
2017-05-11
| ||
19:09 | Add another test case for the new authorizer functionality. (check-in: 339df63f user: dan tags: trunk) | |
18:49 | Merge recent enhancements from trunk. (check-in: b55c0f14 user: drh tags: apple-osx) | |
18:42 | Enhance the json_extract() function to reuse parses of the same JSON when the function appears multiple times in the same query. (check-in: 3ba9e7ab user: drh tags: trunk) | |
18:14 | Do not save the state of an fts5 merge operation mid-way through an input term, even if no previous entry for that term has caused any output. Doing so may corrupt the FTS index. (check-in: 9a2de4f0 user: dan tags: trunk) | |
16:49 | Cache the JSON parse used by json_extract(). (Closed-Leaf check-in: 44ca6c2c user: drh tags: auxdata-cache) | |
15:20 | Negative N values in sqlite3_get_auxdata() and sqlite3_set_auxdata() can be used to access an auxiliary data cache over all functions in a single prepared statement. (check-in: ff530675 user: drh tags: auxdata-cache) | |
13:43 | New requirements marks and documentation for the authorizer. (check-in: 3980ea09 user: drh tags: trunk) | |
12:27 | Improvements to the sqlite3_set_authorizer() documentation. (check-in: 47629b19 user: drh tags: trunk) | |