SQLite
Timeline
Not logged in

200 most recent check-ins using file tool/speed-check.sh version 9eccb9ad

2017-10-12
10:28
[5d0ceb8d] Make sure the tableColumnList() routine of the command-line shell does not cause a null-pointer dereference in an error condition. (user: drh, tags: branch-3.21)
01:19
[f0a2724f] Fix a typo in a numeric constant in an assert() - a bug that has been present in the code since check-in [79e22b95038] on 2010-03-30. (user: drh, tags: branch-3.21)
2017-10-11
17:50
[31eee0e4] Make JSON1 defines consistent in the makefiles for MSVC. (user: mistachkin, tags: branch-3.21)
17:25
[79c96121] Enable JSON by default in the Windows command-line shell sqlite3.exe. (user: drh, tags: branch-3.21)
11:12
[0f160a8a] Create a branch for the 3.21.0 release. Development continues on trunk. (user: drh, tags: branch-3.21)
2017-10-10
20:11
[63955442] Leaf: Add new extension "bgckpt" in ext/misc/bgckpt.c. For experimenting with running wal2 mode checkpoints in a background thread. (user: dan, tags: wal2)
13:37
[b8c1b5a5] DROP TABLE now works for WITHOUT ROWID tables and the SQLITE_OMIT_AUTOVACUUM compile-time option. Fix for ticket [e651b1341861d6] (user: drh, tags: trunk)
2017-10-09
19:50
[d218d815] Merge latest trunk changes with this branch. (user: dan, tags: wal2)
19:49
[9c80cd20] Add a header comment to wal.c describing the differences between wal and wal2 mode. (user: dan, tags: wal2)
2017-10-08
02:22
[5594a121] Fix harmless compiler warnings in FTS5 seen with MSVC. (user: mistachkin, tags: trunk)
2017-10-07
23:58
[39d920d1] Fix harmless compiler warning seen with MSVC. (user: mistachkin, tags: trunk)
23:35
[63d1b425] Revise variable declaration moved in the previous check-in so sqlite3VdbeReset() is consistent with sqlite3VdbeRewind(). (user: mistachkin, tags: trunk)
23:31
[14b181e8] Fix C99-style variable declaration issue seen with older versions of MSVC. (user: mistachkin, tags: trunk)
19:55
[f7360fad] Ignore the *-wal2 file if the *-wal file is zero bytes in size. (user: dan, tags: wal2)
13:37
[8932b2f1] Check in test file wal2simple.test. (user: dan, tags: wal2)
2017-10-06
18:00
[702b137a] Add tests for the example fts3 "rank" function that appears in the documentation. (user: dan, tags: trunk)
14:25
[7e435178] Merge latest trunk changes into this branch. (user: dan, tags: wal2)
14:08
[9e1502e1] Fix a bug in recovering wal2 mode databases introduced by the previous commit. (user: dan, tags: wal2)
13:43
[a4b02bc9] Fix frame overwriting in wal2 mode. (user: dan, tags: wal2)
2017-10-05
20:57
[8ca0fa8d] Fix compiler warnings that come up with SQLITE_OMIT_WAL. (user: drh, tags: trunk)
20:02
[373b0ace] Fix a problem building with SQLITE_OMIT_WAL defined. (user: dan, tags: trunk)
19:12
[4258fb57] Fix the command-line shell so that the ".schema --indent" command does a better job of dealing with \r\n in the middle of a CREATE statement in the schema. (user: drh, tags: trunk)
18:14
[16decc13] Fix test case failures on this branch. (user: dan, tags: wal2)
11:29
[d22c99b6] Disable the delta checksum verification in RBU by default. Reenable it using -DRBU_ENABLE_DELTA_CKSUM, if desired. (user: drh, tags: trunk)
2017-10-04
20:57
[e2fc5c81] Add experimental mode that uses two wal files. Activated using "PRAGMA journal_mode = wal2". (user: dan, tags: wal2)
18:26
[40964a4e] Updates to requirements marks. (user: drh, tags: trunk)
17:05
[7c69f8f1] Update the speedtest1 program so that it prints the output of "PRAGMA compile_options" if the -stats option is specified. (user: dan, tags: trunk)
16:35
[182ec9d6] Fix typos in session extension header comments. No changes to code. (user: mistachkin, tags: trunk)
14:13
[ef94ea06] New test cases for ticket [b899b6042f97f5] derived from a bug report on the mailing list from Wout Mertens. (user: drh, tags: trunk)
12:08
[9ff49441] Amend recent changes to busy.test to avoid failing with SQLITE_ENABLE_STAT4 builds. (user: dan, tags: trunk)
12:06
[4464f40c] Turn restriction 20 on the query flattener into an assert since the situation restricted can no longer occur because of the more aggressive use of co-routines. (user: drh, tags: trunk)
10:39
[fb83c3d8] Add tests to verify that the busy-handler is invoked correctly when processing "PRAGMA optimize" and ANALYZE commands. (user: dan, tags: trunk)
05:59
[66629b2a] Remove a redundant restriction from the query flattener. (user: drh, tags: trunk)
02:30
[d050dc60] Fix a minor typo in the query flattener header comment. No code changes. (user: drh, tags: trunk)
2017-10-03
19:53
[772b0db1] Simplify the computation of types on columns of a view. (user: drh, tags: trunk)
18:35
[f5c39583] Do not enable SELECT tracing with -DSQLITE_DEBUG. Require the -DSQLITE_ENABLE_SELECTTRACE compile-time option to enable SELECT tracing. (user: drh, tags: trunk)
17:29
[1dd82808] Add some OK_IF_ALWAYS_TRUE() marks on optimization branches in select.c. (user: drh, tags: trunk)
17:17
[7be760e9] Remove an unused variable from sqlite3Insert() and fix harmless compiler warnings associated with -DSQLITE_MUTATION_TEST. (user: drh, tags: trunk)
16:57
[966438bd] Fix the sqlite3_column_decltype() interface to return the correct datatype when the value comes through a CTE. (user: drh, tags: trunk)
14:24
[c5ad5e16] The simplification to sqlite3SelectExpand() in last night's [3a4ffb21] check-in was not completely correct. This adjustment is needed for correct OOM handling in some configurations. (user: drh, tags: trunk)
03:24
[f10ece96] Closed-Leaf: Simplification to the logic that computes column type names. Update: Does not work in all configurations. (user: drh, tags: does-not-work)
03:01
[e4342fd4] Do not compute column and row size estimates for the transient Table objects associated with the result set of a SELECT statement, since those estimates are never used for anything constructive. (user: drh, tags: trunk)
2017-10-02
23:50
[3a4ffb21] Mark a single branch within sqlite3SelectExpand() as an optimization. (user: drh, tags: trunk)
23:30
[5bf2ccb9] Simplification to sqlite3SelectPrep() for improved testability. (user: drh, tags: trunk)
21:29
[6035c9b2] Add the OK_IF_ALWAYS_TRUE() and OK_IF_ALWAYS_FALSE() macros for marking conditionals that improve performance but do not change the outcome. (user: drh, tags: trunk)
13:20
[d815f255] Avoid using lookaside memory for persistent virtual table structures. (user: drh, tags: trunk)
02:52
[c9104b59] The query planner now always prefers to implement a FROM-clause subquery using a co-routine rather than flattening the subquery into the outer query. (user: drh, tags: trunk)
02:32
[8000d230] Improvements to a comment in lempar.c. No code changes. (user: drh, tags: trunk)
2017-09-30
11:47
[92848623] Closed-Leaf: More details in the header comment of pushDownWhereTerms(). No changes to code. (user: drh, tags: prefer-coroutine-sort-subquery)
10:50
[6aed4ea3] Make sure the SQLITE_Stat34 optimization switch is always 0x800, a value which is hard-coded in the TH3 test suite. (user: drh, tags: prefer-coroutine-sort-subquery)
01:25
[71f0adf7] Fix unreachable conditionals and revise a testcase that was made obsolete by the changes on this branch. (user: drh, tags: prefer-coroutine-sort-subquery)
2017-09-29
22:13
[6b1651d7] Always render a subquery that is not part of a join as a co-routine. (user: drh, tags: prefer-coroutine-sort-subquery)
16:08
[f62cd4d9] Merge the query flattener comment improvements from trunk. (user: drh, tags: prefer-coroutine-sort-subquery)
16:07
[0840f9f8] Clean up the comments on the query flattener to more clearly and accurately express the conditions under which the flattener is able to run. (user: drh, tags: trunk)
14:31
[06f432fb] Merge changes from trunk. (user: drh, tags: prefer-coroutine-sort-subquery)
12:44
[2a45bbc9] Make sure the 6th parameter to the authorizer callback for view subqueries has the correct view name. (user: drh, tags: trunk)
12:12
[04ef40a8] Better names for subqueries in EXPLAIN comments. (user: drh, tags: trunk)
2017-09-28
20:06
[042d655d] Do not flatten subqueries that contain an ORDER BY or GROUP BY clause and can be implemented using a co-routine. (user: drh, tags: prefer-coroutine-sort-subquery)
17:29
[ff2f5a31] Remove the (undocumented) query-planner control that prevents a "SELECT ALL" subquery in FROM clause from being implemented as a co-routine. This control was added by [a29e117d7ec], where it was called a "stop-gap". (user: drh, tags: trunk)
16:56
[fd3267ef] Fix over-length source code lines in select.c. No logic changes. (user: drh, tags: trunk)
13:47
[5b9ae693] Fix an issue introduced by check-in [4cd2a9672c59] (2017-03-03) that could allow a negative value in the 3rd parameter to memmove() when defragmentPage() is called on a btree page with a corrupted freeblock list. The corruption is now detected early and results in an SQLITE_CORRUPT return before the memmove() is reached. (user: drh, tags: trunk)
01:58
[490e488e] Add new routines to simplify dealing with collating sequences in expressions: sqlite3ExprNNCollSeq() and sqlite3ExprCollSeqMatch(). (user: drh, tags: trunk)
01:09
[04130018] Indexes on expressions with a COLLATE clause are able to satisfy an ORDER BY with the same COLLATE clause. (user: drh, tags: trunk)
00:01
[80277d2f] In two places, change the magic number -1 to its proper symbol XN_ROWID. (user: drh, tags: trunk)
2017-09-27
16:51
[f5ef2e1b] Disable tests for the LIKE optimization when ICU is enabled, since the LIKE optimization only works for the built-in LIKE operator and ICU overrides the built-in. (user: drh, tags: trunk)
2017-09-25
09:37
[24a95e14] Add an extra snapshot related test case. (user: dan, tags: trunk)
2017-09-23
07:46
[d71eeaab] Leaf: Experimental change so that snapshot transactions always lock the wal file - preventing writers or truncate-checkpointers from wrapping it. (user: dan, tags: snapshots-lock-wal)
2017-09-22
20:18
[8d2a1cca] Leaf: Merge in all the trunk enhancements of the previous 7 months. The LIKE optimization has stopped working when there is an ESCAPE - that problem will be addressed in a subsequent check-in. (user: drh, tags: est_count_pragma)
16:23
[2c03d8b8] Use the updated Win32 VFS semantics for winOpen from check-in [5d03c738e9] for WinRT, et al, as well. (user: mistachkin, tags: trunk)
12:52
[403b88a8] Partial backout of check-in [e0af9a904076]. It turns out we do need some extra space at the end of the record blob as an overrun area to use when decoding a maliciously malformed record. (user: drh, tags: trunk)
11:09
[c7a5880d] Leaf: Cherrypick [ec37ad6d08] into this branch. With this patch, if SQLITE_SHARED_MAPPING is defined at build-time SQLite will use a single memory mapping for multiple connections to the same database file within a single process. (user: dan, tags: begin-concurrent)
10:49
[307b802e] Merge latest trunk changes into this branch. (user: dan, tags: begin-concurrent)
00:24
[0a12915b] Update the configure script so that it looks for tclsh8.7 ahead of tclsh8.6. (user: drh, tags: trunk)
2017-09-21
20:43
[5d03c738] In the Windows VFS, when trying to open a database file read/write, if it fails check to see if the file exists and is read-only and immediately fall back to a read-only open attempt, rather than running the AV retry loop. (user: drh, tags: trunk)
20:03
[fa3f5bcc] In the Windows VFS, do not emit an SQLITE_CANTOPEN error log message when falling back from SQLITE_OPEN_READWRITE to SQLITE_OPEN_READONLY. Wait until the open fails completely. (user: drh, tags: trunk)
19:08
[68e9a840] Fix harmless UB in the ICU extension. (user: drh, tags: trunk)
14:03
[3fbfa9a8] Leaf: The sqlite3_snapshot_describe() interface useful for debugging snapshot logic. (user: drh, tags: sqlite3_snapshot_describe)
13:11
[fd4ec0cd] Fix a potential use of an uninitialized pointer in RTree following an OOM error. (user: drh, tags: trunk)
10:24
[65765222] Fix a bug in tool/mksourceid.c: The mksourceid.c program was incorrectly including the "# Remove this line" line of the Fossil-generated "manifest" file in the SHA3 hash. That means that all SQLITE_SOURCE_IDs for trunk versions going back to check-in [30966d56] (2017-08-22) are incorrect. (user: drh, tags: trunk)
01:04
[f8b1c64d] Revert one performance improvement changes from check-in [3b3e32d4cd07] as it was causing a reference to an uninitialized value. (user: drh, tags: trunk)
00:49
[adc12c83] Fix the rendering of the P4_INTARRAY argument to the OP_IntegrityCk opcode in the output of EXPLAIN. (user: drh, tags: trunk)
2017-09-20
18:47
[4b3f7eac] Size and performance optimization on sqlite3VdbeMemGrow(). (user: drh, tags: trunk)
18:07
[e0af9a90] The BLOB returned by sqlite3VdbeMemFromBtree() does not need to be zero-terminated. (user: drh, tags: trunk)
17:49
[3b3e32d4] Small size and performance optimization in the bytecode engine. (user: drh, tags: trunk)
10:47
[7f2bd4ff] Improved resolution of large integer values in "CAST(x AS NUMERIC)". (user: drh, tags: trunk)
09:09
[5b2002f3] Updates to the "lemon.html" document received from Andy Goth. (user: drh, tags: trunk)
2017-09-18
18:17
[1b2de414] Add the sqlite3_mmap_warm() function as an extension in the ext/misc/mmapwarm.c source file. (user: drh, tags: trunk)
18:08
[3235835b] Closed-Leaf: Fix a typo in the MSVC makefile. (user: drh, tags: mmap-warm)
16:28
[d4a30b91] Add extension "mmapwarm.c". Provides function sqlite3_mmap_warm(), used to "warm up" the memory mapping used by SQLite in mmap mode to access db file content. (user: dan, tags: mmap-warm)
13:16
[a9447193] Minor simplification of error message generation during compound query code generation. (user: drh, tags: trunk)
09:40
[74f399d8] The out-of-bounds read on recovery fix of check-in [378afa16381a222a] caused problems for some corner-case error conditions. This alternative fix appears to work better. (user: drh, tags: trunk)
08:51
[2e573350] Leaf: Merge latest trunk changes with this branch. (user: dan, tags: shared-mapping-hack)
00:18
[42f07775] Fix the CSV virtual table extension so that it works when the default character is unsigned. (user: drh, tags: trunk)
2017-09-17
19:45
[29227d00] Do not make the assumption (as check-in [4da49a95c0f07] incorrectly did) that the ExprList returned by sqlite3ExprListDup() would never be passed into sqlite3ExprListAppend(). Include a new test case that shows this sometimes does happen. (user: drh, tags: trunk)
2017-09-16
20:58
[5dbb255a] Simplify the sqlite3VdbeGet() routine. Smaller, faster, and easier to maintain. (user: drh, tags: trunk)
2017-09-15
17:40
[dd95887f] Remove an unnecessary parameter from selectInnerLoop(). (user: drh, tags: trunk)
15:38
[5dc3ecb5] Improved the header-comment documentation on sqlite3ExprCodeExprList(). No changes to code. (user: drh, tags: trunk)
15:17
[4da49a95] Optimization to the ExprList object to make it slightly smaller and faster. (user: drh, tags: trunk)
14:36
[f7f0bf1d] Fix a harmless comment typo. No changes to code. (user: drh, tags: trunk)
2017-09-14
21:12
[1a7e0b61] Add another test case for the problem fixed by the previous commit. (user: dan, tags: trunk)
20:41
[cf5bf42c] Avoid an out-of-bounds read that can be caused by a specially constructed journal file. (user: dan, tags: trunk)
02:36
[378afa16] Avoid an out-of-bounds read on a recovery attempt using a carefully crafted database and rollback journal with mismatched page sizes. The test case for this is in TH3. (user: drh, tags: trunk)
2017-09-13
20:20
[43c6023b] Test case update due to PRAGMA integrity_check enhancements in [8525c30c]. No changes to code. (user: drh, tags: trunk)
18:38
[ebada072] Leaf: Experimental sqlite3_stmt_retryable() interface. (user: drh, tags: sqlite3_stmt_retryable)
12:55
[87ccdf9c] Disable FTS3 matchinfo() tests that assume a littleEndian platform when running on bigEndian. (user: drh, tags: trunk)
00:33
[8525c30c] Improvements to PRAGMA integrity_check for better detection of malformed records. Integrity_check now avoids returning SQLITE_CORRUPT on a corrupt record. Also includes microoptimizations that I stumbled over while working on integrity_check. (user: drh, tags: trunk)
00:13
[81f62e99] Closed-Leaf: PRAGMA integrity_check returns SQLITE_OK even if it encounters corruption while scanning indexes. (user: drh, tags: improved-integrity-check)
00:01
[a5a19492] Fix test script comment. No changes to code. (user: mistachkin, tags: trunk)
2017-09-12
23:58
[3a2793aa] Remove use of the rand_s() function (added by [139081bef9f63c3e]) as it appears to cause issues with some third-party DLLs. (user: mistachkin, tags: trunk)
18:49
[de2e3717] Leaf: Add the highly-experimental "PRAGMA noop_update=TRUE" command. (user: drh, tags: pragma-noop-update)
18:11
[8b1fc4b9] Merge the mutex-free PRNG change into this branch. (user: dan, tags: shared-mapping-hack)
18:03
[ec37ad6d] Hack to have multiple connections to a single file share a single memory mapping of the databse file. (user: dan, tags: shared-mapping-hack)
15:05
[9780b23c] Fix an error in [b22cdd67] that can cause a negative infinity to be (rarely) reported as a positive infinity. (user: drh, tags: trunk)
13:27
[b22cdd67] Changes to (hopefully) get the build working with recent Intel compilers. (user: drh, tags: trunk)
00:24
[d7b7f038] Make sure all connections are closed in the pragma.test script. Test change only - no changes to code. (user: drh, tags: trunk)
2017-09-11
23:46
[9d91ee5e] New test case for ticket [b899b6042f97f52d]. (user: drh, tags: trunk)
20:54
[3b7dbe9d] Add support for new operators in virtual tables: !=, IS, IS NOT, IS NULL, and NOTNULL. (user: drh, tags: trunk)
19:47
[0fb992af] Closed-Leaf: Refactor names of constants and functions associated with the auxiliary operators for xBestIndex. (user: drh, tags: vtab-extra-ops)
18:37
[d3153abd] Minor adjustments to indentation and spacing for clarity. No changes to code. (user: drh, tags: vtab-extra-ops)
08:53
[8d24e080] Add tests to check that affinities work with != operators on virtual table column values. No changes to code. (user: dan, tags: vtab-extra-ops)
2017-09-10
01:06
[99b9140c] Simplifications to the PRAGMA integrity_check code generator. (user: drh, tags: improved-integrity-check)
2017-09-09
22:46
[b6425d01] Simplification and performance improvement to sqlite3_reset(). (user: drh, tags: improved-integrity-check)
20:38
[8fa923ca] Improved detection of malformed records by PRAGMA integrity_check. (user: drh, tags: improved-integrity-check)
19:41
[34c8e952] Enhance the vtab interface to handle IS, !=, IS NOT, IS NULL and IS NOT NULL constraints. (user: dan, tags: vtab-extra-ops)
08:03
[e63d1a7c] Leaf: Use a mutex-free PRNG for the random() and randomblob() SQL functions and for the randomness used during checkpoint operations. (user: drh, tags: mutex-free-randomness)
06:10
[6a0b9d9d] Leaf: Merge trunk enhancements (user: drh, tags: apple-osx)
00:51
[faa22e29] Fix harmless compiler warnings seen with MSVC. (user: mistachkin, tags: trunk)
2017-09-08
17:48
[e1e3ca7e] Have the header comment for sqlite3Checkpoint() mention TRUNCATE along with the other three checkpoint types. No changes to code. (user: dan, tags: trunk)
2017-09-07
09:56
[02828d71] Prevent a possible crash when trying to recover using a carefully corrupted \ and truncated rollback journal. (Test case in TH3) (user: drh, tags: trunk)
2017-09-05
20:16
[9e393a0e] Update "PRAGMA integrity_check" to detect inconsistencies between a single record's header and body. (user: dan, tags: trunk)
17:23
[868cd196] Fix a comment describing the xRowid method of the "series" virtual table. No code changes. (user: dan, tags: trunk)
16:24
[7fdd6298] Add experimental API sqlite3rbu_temp_size_limit(). For limiting the amount of temporary disk space RBU uses. (user: dan, tags: trunk)
2017-09-04
19:31
[72d22c22] Use the SQLITE_CORRUPT_BKPT return code in a couple more places. (user: mistachkin, tags: trunk)
18:44
[77854694] Add the 'mksourceid' executable to the clean target for MSVC. (user: mistachkin, tags: trunk)
00:33
[c7f9f47b] Proposed fix for ticket [b899b6042f97f5] (user: drh, tags: trunk)
00:19
[03f3cc03] Fix recent test cases in test/indexepxr2.test so that they work even without SQLITE_ENABLE_STAT4 and SQLITE_ENABLE_JSON1. (user: drh, tags: trunk)
2017-09-01
14:50
[b2e2100c] Add the new sqlite3PagerUnrefPageOne() pager method to deal with the special case of unreferencing page1. (user: drh, tags: trunk)
12:57
[c4e7e175] Remove an obsolete optimization in pcache that due to more recent changes was recently making the code a little slower. (user: drh, tags: trunk)
12:18
[919863b1] Small size and performance improvement in pcacheManageDirtyList() by not zeroing the PgHdr.pDirtyNext and PgHdr.pDirtyPrev pointers for PgHdr objects that are not on the dirty list. (user: drh, tags: trunk)
2017-08-31
21:11
[4094a341] Clarify the documentation about "protected" versus "unprotected" sqlite3_value objects. No changes to code. (user: drh, tags: trunk)
2017-08-30
13:21
[bcc20be5] Remove unnecessary "__declspec(dllexport)" qualifiers from generated file shell.c. (user: dan, tags: trunk)
04:44
[ffd437da] Small performance optimization in pcache1. (user: drh, tags: trunk)
2017-08-29
20:21
[a06263f1] Faster memory allocation from lookaside by not trying to keep track of the number of outstanding allocations, and rather computing that value only when requested. (user: drh, tags: trunk)
17:52
[1b3df8ff] Leaf: Add a Tcl script to run the performance tests described in README-server-edition.html. (user: dan, tags: server-process-edition)
2017-08-28
17:19
[d53108e7] Merge recent enhancements from trunk. (user: drh, tags: begin-concurrent)
17:00
[64a8ae68] Add the --enable-update-limit option to the ./configure script. (user: drh, tags: trunk)
16:11
[1ba051e3] Avoid unnecessary mutexes in the pcache1 implementation in the common case where no auxiliary page cache memory is configured. (user: drh, tags: trunk)
15:51
[54b00024] Remove the rarely-used scratch memory allocator. This makes the code smaller, faster, and easier to maintain. In place of the scratch allocator, add the SQLITE_CONFIG_SMALL_MALLOC configuration option that provides a hint to SQLite that large memory allocations should be avoided. (user: drh, tags: trunk)
14:33
[2348045f] Backport changes to shell.c into shell.c.in. (user: drh, tags: trunk)
11:12
[cf0d3715] Fix the ".dump", ".schema", and ".fullschema" commands of the command-line shell so that they work even if PRAGMA empty_result_callbacks is enabled. Fix for ticket [02f0f4c54f281]. (user: drh, tags: trunk)
2017-08-27
10:55
[c93298d5] Leaf: Instrumentation and changes in an effort to reduce thread contention. (user: drh, tags: reduced-thread-contention)
2017-08-25
19:51
[1783c54c] Fix a few over-length source code lines. No functional changes. (user: drh, tags: trunk)
15:43
[776d9128] Size and performance optimization for sqlite3Init(). (user: drh, tags: trunk)
13:34
[39f708d1] Small performance optimization in sqlite3WhereBegin(). (user: drh, tags: trunk)
13:02
[2738b8db] Convert a branch made unreachable by [59560d07] into an assert(). (user: drh, tags: trunk)
11:44
[e8d23afe] Improve the internal mechanism used to keep track of what kind of syncing to do for WAL transaction commits and checkpoint operations. Use the checkpoint-style of syncing to sync the header of a new or restarted WAL file. (user: drh, tags: trunk)
09:17
[b79cc8dc] Avoid returning duplicate rows in experimental pragmas "pragma_list", "module_list" and "function_list". (user: dan, tags: trunk)
01:14
[bf65dae8] Closed-Leaf: Update the mechanism used to keep track of what kind of syncing to do for WAL transaction commits and checkpoint operations. Use the checkpoint-style of syncing to sync the header of a new or restarted WAL file. (user: drh, tags: wal-sync-refactor)
2017-08-24
20:54
[25292b9a] Fix an incorrect hyperlink in a comment. (user: drh, tags: trunk)
15:43
[7ec72314] Fixes to documentation about SQLITE_OPEN_URI. (user: drh, tags: trunk)
13:55
[d2f9230c] Make sure the sqlite3_result_pointer() interface does not leave a VM register in an inconsistent state. Fix for ticket [7486aa54b968e9b5]. Test cases are in TH3. (user: drh, tags: trunk)
2017-08-23
23:09
[59560d07] Performance optimization to pageFindSlot() in the b-tree layer. (user: drh, tags: trunk)
20:36
[bc1ec123] Size and performance optimization to dropCell() and freeSpace(). (user: drh, tags: trunk)
14:45
[77074990] Smaller and faster implementation of the fillInCell() routine. (user: drh, tags: trunk)
2017-08-22
21:23
[e69c0c87] Update documentation to make it clear that SQLITE_SOURCE_ID and sqlite3_sourceid() might changes if the source code is edited. (user: drh, tags: trunk)
21:07
[564c7340] Less dramatic changes to the source-id following an edit. Modify the way that the amalgamation is constructed to give it the opportunity to detect changes and modify the source-id. (user: drh, tags: trunk)
19:54
[515d6a83] Modify the SQLITE_SOURCE_ID if the source code has changed in any way since the previous check-in. (user: drh, tags: trunk)
19:49
[a1b3337e] Closed-Leaf: Trying again to get out-of-tree builds to work correctly. (user: drh, tags: mksourceid)
19:44
[ca5dcb4a] Leaf: mksourceid still does not work right. (user: drh, tags: mistake)
19:43
[5a037ac2] Attempting to fix the source-id generator so that it works for out-of-tree builds. (user: drh, tags: mksourceid)
19:19
[d4c05e04] Add the "mksourceid" program to the build process. That program changes the SQLITE_SOURCE_ID if the source tree has been modified in any way. (user: drh, tags: mksourceid)
15:21
[885c2b44] Fix error tests in seldom-used compile-time branches of the unix backend. (user: drh, tags: trunk)
2017-08-21
02:20
[56d19f9f] Remove an unnecessary conditional. (user: drh, tags: trunk)
02:05
[6538ef7b] Minor optimization to sqlite3VdbeMemSetStr(). (user: drh, tags: trunk)
2017-08-19
20:38
[d01d2cff] Space and size optimization to the printf implementation. (user: drh, tags: trunk)
15:50
[2dd36ade] Ensure that write-locks on pages are dropped at the end of each write transaction, even if there is still a read transaction open. (user: dan, tags: server-process-edition)
2017-08-18
22:30
[745bc8de] Another size and performance optimization to readDbPage(). This time we eliminate some unnecessary local variables. (user: drh, tags: trunk)
21:14
[ca9e1875] Size and performance optimization the readDbPage() routine in the pager. (user: drh, tags: trunk)
18:55
[abb6e076] Add tests to this branch. (user: dan, tags: server-process-edition)
16:09
[3075cfa0] For the unix VFS, avoid an unnecessary stat() system call prior to opening any file in the common case where there are no unused file descriptors. (user: drh, tags: trunk)
16:04
[66fb9e1c] Do not search for locks to clear when connecting to a db in multi-process mode unless it looks like the previous user of the client-id crashed. (user: dan, tags: server-process-edition)
14:34
[eb1202b5] Combine the OP_CreateTable and OP_CreateIndex opcodes of the bytecode engine into a single OP_CreateBtree opcode. This simplifies the implementation and makes the bytecode programs clearer. (user: drh, tags: trunk)
08:29
[37e19008] Only use indexes on expressions to optimize ORDER BY and GROUP BY if the collation sequence matches. Possible fix for [e20dd54a]. (user: dan, tags: trunk)
2017-08-17
20:53
[a42a438c] Use the __builtin_clzll() function of gcc to improve the performance and reduce the size of the sqlite3LogEst() routine. (user: drh, tags: trunk)
19:32
[a8115f95] Add support for crash recovery in multi-process mode. And add test cases for the same. (user: dan, tags: server-process-edition)
19:23
[264a5e1b] Small optimization in the Expr tree walker. (user: drh, tags: trunk)
18:54
[0367a4d5] Size optimization in the authorizer error message generation logic. (user: drh, tags: trunk)
18:23
[f13682ea] In sqlite3ViewGetColumnNames(), return the number of errors, not an error code. (user: drh, tags: trunk)
18:17
[0712f057] The RTREE extension should return SQLITE_CORRUPT_VTAB, not just SQLITE_CORRUPT when it encounters incorrectly formatted shadow tables. (user: drh, tags: trunk)
14:47
[fb6ca99b] Remove an unnecessary branch from the [be436a7f4587ce517ddc] fix. (user: drh, tags: trunk)
14:12
[2101b420] Add test cases for ticket [be436a7f4587ce517] using virtual table modules fts5 and rtree. (user: dan, tags: trunk)
02:26
[a7bc7752] Defer schema resets when the query planner is running. Proposed fix for ticket [be436a7f4587ce517]. (user: drh, tags: trunk)
2017-08-16
19:20
[f078deb2] Avoid a test for CURTYPE_BTREE in sqlite3VdbeCursorMoveto() in order to reduce the size and improve the performance of OP_Column. (user: drh, tags: trunk)
17:06
[380a7b7a] Update this branch with the latest changes from trunk. (user: dan, tags: server-process-edition)
16:52
[04e0cb57] Enhance this branch to support page-level-locking (without MVCC) for multi-process deployments. (user: dan, tags: server-process-edition)
14:16
[39543903] Remove an unnecessary local variable from OP_Column, for a small size reduction and performance increase. (user: drh, tags: trunk)
11:04
[dc98a92f] Performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
2017-08-15
14:14
[2cf3f3de] Small size and performance improvement in the OP_Column opcode. (user: drh, tags: trunk)
03:46
[373b71d1] Btree optimization: New field BtCursor.pPage that points to the current page, saving a single pointer dereference on each access. (user: drh, tags: trunk)
2017-08-14
23:53
[16969338] Minor size and performance optimization to sqlite3BtreeCloseCursor(). (user: drh, tags: trunk)