/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

45 descendants and 100 ancestors of [d8dd98a3]

2019-05-14
22:07
Merge the latest trunk and wal2 enhancements. Leaf check-in: 3deaa6e2 user: drh tags: begin-concurrent-pnu-wal2
22:02
Merge the latest trunk enhancements into the wal2 branch. Leaf check-in: 23ec34e4 user: drh tags: wal2
2019-04-15
15:28
Merge all recent enhancements. check-in: 1cd536ec user: drh tags: begin-concurrent-pnu-wal2
15:17
Merge the latest trunk enhancements. check-in: 8950f119 user: drh tags: wal2
2019-03-26
12:29
Bring this branch up to date with all the latest enhancements. check-in: 2e964aaf user: drh tags: begin-concurrent-pnu-wal2
12:22
Merge enhancements from trunk. check-in: a0e2e902 user: drh tags: wal2
2019-03-08
16:06
Merge the latest enhancements and fixes from trunk. check-in: 543ecb30 user: drh tags: begin-concurrent-pnu-wal2
15:57
Merge the latest enhancements and fixes from trunk. check-in: bf20d4ff user: drh tags: wal2
15:39
Add the bgckpt.c extension to Makefile.in and Makefile.msc. check-in: 3712d625 user: drh tags: wal2
2019-01-11
15:26
Merge documentation changes from branch begin-concurrent-wal2 into this branch. check-in: cf8a0c71 user: dan tags: begin-concurrent-pnu-wal2
15:22
Merge documentation changes from branch "begin-concurrent" into this branch. Leaf check-in: 41e742bd user: dan tags: begin-concurrent-wal2
15:00
Merge latest begin-concurrent-wal2 changes (documentation only). check-in: d0ab56a3 user: dan tags: begin-concurrent-pnu-wal2
14:59
Merge latest wal2 changes (documentation only) into this branch. check-in: 820ba1cc user: dan tags: begin-concurrent-wal2
14:58
Add new file doc/wal2.md to this branch. check-in: b495dce1 user: dan tags: wal2
2019-01-04
19:39
Fix the experimental sqlite3_wal_info() API so that it works with wal2 mode. check-in: 079daedb user: dan tags: begin-concurrent-pnu-wal2
19:25
Add the "-external" option to the tserver_test.tcl program.. check-in: ae7c5ed1 user: dan tags: begin-concurrent-pnu-wal2
17:12
Update the "tserver" program to report the amount of time spent in COMMIT commands. check-in: cf494b41 user: dan tags: begin-concurrent-pnu-wal2
2019-01-02
19:46
Merge changes from begin-concurrent-wal2. Also modify the unix-excl shm-locks on this branch so that it is not an error to attempt to release an EXCLUSIVE lock that is not held. check-in: 86685679 user: dan tags: begin-concurrent-pnu-wal2
17:08
Reinstate assert() statements in os_unix.c that were removed to allow wal-mode SHARED locks to be taken over more than one locking slot (this branch no longer does that, so the assert() statements can go back in). check-in: fcb7348b user: dan tags: begin-concurrent-wal2
17:00
Reinstate assert() statements in os_unix.c that were removed to allow wal-mode SHARED locks to be taken over more than one locking slot (this branch no longer does that, so the assert() statements can go back in). check-in: 8445fb6d user: dan tags: wal2
16:30
Merge latest wal2 changes into this branch. check-in: c31eeb3c user: dan tags: begin-concurrent-wal2
16:15
Merge latest trunk changes into this branch. check-in: 87ef68f9 user: dan tags: wal2
2018-12-29
20:47
Merge latest begin-concurrent changes with this branch. check-in: 1625887c user: dan tags: begin-concurrent-wal2
16:34
Increase coverage provided by permutation "coverage-wal" on this branch. check-in: f664f940 user: dan tags: begin-concurrent-wal2
2018-12-28
16:20
Add new test file wal2rollback.test to this branch. check-in: 85a376fc user: dan tags: wal2
2018-12-27
17:11
Merge latest wal2 changes with this branch. check-in: ea96001e user: dan tags: begin-concurrent-wal2
16:49
Increase test coverage of wal.c provided by permutation "coverage-wal" on this branch. check-in: 2f7f893a user: dan tags: wal2
2018-12-26
20:42
Improve testing of the wal.c changes on this branch. check-in: 63483e22 user: dan tags: wal2
19:10
Merge latest trunk changes with this branch. check-in: 404f9d99 user: dan tags: wal2
2018-12-22
15:50
Enhance the wal2 header comment in wal.c to explain how the wal-hook is invoked in wal2 mode. check-in: 118aa7e3 user: dan tags: wal2
2018-12-18
19:46
Add the "mutexfree-shmlock" patch to this branch. check-in: c3191fc8 user: dan tags: begin-concurrent-pnu-wal2
18:16
Fix a test script problem in wal2savepoint.test. check-in: e388d029 user: dan tags: begin-concurrent-pnu-wal2
18:01
Merge the wal2 feature into this branch. check-in: a2c618c0 user: dan tags: begin-concurrent-pnu-wal2
17:32
Merge latest trunk changes into this branch. check-in: b3a163b4 user: dan tags: begin-concurrent-wal2
16:24
Add the ".integrity_check" command to tserver. check-in: fa46fa3b user: dan tags: begin-concurrent-wal2
2018-12-17
18:26
Add wal2 related tests to this branch. check-in: 56458220 user: dan tags: begin-concurrent-wal2
15:22
Merge changes from wal2 branch. check-in: 85f49f0d user: dan tags: begin-concurrent-wal2
15:22
Add extra test case to wal2recover.test. check-in: 1a5aa734 user: dan tags: wal2
2018-12-15
20:59
Merge latest wal2 changes into this branch. check-in: 06bb80ee user: dan tags: begin-concurrent-wal2
20:20
Further test cases for wal2 mode. check-in: 9cb5f8da user: dan tags: wal2
2018-12-14
19:53
Add further tests for wal2 mode. check-in: 54e628f9 user: dan tags: wal2
2018-12-13
16:26
Add tests cases for recovery in wal2 mode. check-in: 34f56f8a user: dan tags: wal2
2018-12-12
20:39
Add new test file wal2big.test. check-in: e3e50bcd user: dan tags: wal2
19:04
Add tests to ensure that each of the 4 wal read-locks does what it is supposed to. check-in: 4d5779f3 user: dan tags: wal2
2018-12-11
17:56
Change the way wal2 locks work to ensure a reader only ever has to lock a single slot. check-in: 18b2c23a user: dan tags: wal2
13:44
Merge latest trunk changes into this branch. check-in: d8dd98a3 user: dan tags: wal2
12:51
Small performance improvement in sqlite3_step(). check-in: d1db8d58 user: drh tags: trunk
12:20
Small performance improvement in the sqlite3_bind() family of interfaces. check-in: 1dc0c3df user: drh tags: trunk
2018-12-10
20:01
Further refinements to the sqlite3_normalized_sql() interface. TH3 now gives 100% MC/DC on that interface. check-in: c96bf6cc user: drh tags: trunk
18:15
Refactor the sqlite3_normalized_sql() implementation. check-in: 06e955e5 user: drh tags: trunk
16:49
Fix issues with the new normalizer. Leaf check-in: 057d7d40 user: drh tags: normalize-refactor
16:00
Refactor the sqlite3_normalized_sql() implementation. This is a work-in-progress. There are still issues. check-in: a4c890b0 user: drh tags: normalize-refactor
08:41
Fix a problem with using "<db>-vacuum" (the default) as the state database when resuming an RBU vacuum. check-in: c878d741 user: dan tags: trunk
01:48
Add support for the VACUUM INTO command. check-in: 77f150b8 user: drh tags: trunk
00:41
Fix the shell1.test test for the new format of the .backup command. Closed-Leaf check-in: 9748d799 user: drh tags: vacuum-into
00:40
Merge fixes from trunk. check-in: ab1e58fa user: drh tags: vacuum-into
2018-12-09
18:55
New test case for ticket [1d958d90596593a77420e59]. check-in: b7bf3c98 user: drh tags: trunk
2018-12-08
20:30
Do not use a partial index as a table scan in an IN operator. Fix for ticket [1d958d90596593a77420e59]. check-in: 15bc915d user: drh tags: trunk
01:09
Add the --async option to the ".backup" command in the CLI. check-in: 7b6a605b user: drh tags: vacuum-into
00:43
Allow the INTO clause of VACUUM to be a text-valued expression. check-in: af172b53 user: drh tags: vacuum-into
2018-12-07
23:48
Do not allow VACUUM INTO into a file that already exists. check-in: 92f70e0f user: drh tags: vacuum-into
20:40
Merge the VACUUM simplification from trunk. check-in: 93d92a0a user: drh tags: vacuum-into
20:26
Remove a line of code from VACUUM that is no longer needed, due to the change that allows ATTACH to run within a transaction. check-in: a92c398f user: drh tags: trunk
17:28
Prototype implementation for the VACUUM INTO command. check-in: 036e3320 user: drh tags: vacuum-into
16:32
Fix the sqlite3_normalized_sql() interface so that it renders double-quoted string literals as "?". check-in: 0d8e1504 user: drh tags: trunk
03:01
Fix dbfuzz2.c so that it works with -DSQLITE_OMIT_INIT check-in: 9ad796a8 user: drh tags: trunk
01:56
Fix the sqlite3ExprDup() function so that it correctly duplicates the Window object list on a Select that contains window functions. Fix for ticket [f09fcd17810f65f717]. check-in: db5ed226 user: drh tags: trunk
2018-12-06
22:12
Performance improvement: Avoid using sqlite3WalkerSelectExpr() and sqlite3WalkerSelectFrom() twice, so that the compiler will in-line their implementation. Closed-Leaf check-in: 2b9258b8 user: drh tags: ticket-f09fcd17810f
22:04
Fix the sqlite3ExprDup() routine so that it makes complete duplications of subqueries containing window functions. check-in: 94017454 user: drh tags: ticket-f09fcd17810f
19:56
New test case that still hits an assertion fault, just to prove that the previous checkin merely made the problem more obscure and did not completely fix it. check-in: a9a3b532 user: drh tags: ticket-f09fcd17810f
19:15
Simplify the query flattener so that it does not duplicate the WHERE clause of subquery that is being incorporated into the outer query - copies it directly. This is more efficient. And it also fixes the specific test case show for ticket [f09fcd17810f65f71789525] but it does not resolve the more general problem that sqlite3ExprDup() does not correctly duplicate expressions that contain subqueries with window functions. check-in: f1b18d44 user: drh tags: ticket-f09fcd17810f
17:06
When masking bits off of sqlite3.flags, make sure the mask is 64 bits in size so as not to accidentally mask of high-order bits. check-in: 53d3b169 user: drh tags: trunk
16:54
Add test file wal2snapshot.test that should have been added as part of an earlier commit. check-in: f6baa7e1 user: dan tags: wal2
16:50
When saving off the value of sqlite3.flags, take care to preserve all 64 bits. check-in: 9c6dbcfa user: drh tags: trunk
16:11
Issue a warning whenever a double-quoted string literal is used. check-in: ac9ad504 user: drh tags: trunk
03:59
Invoking the sqlite3_trace() or sqlite3_trace_v2() interfaces cancels any sqlite3_profile() that is running. check-in: ec63d350 user: drh tags: trunk
02:01
Remove the unused pColHash field from the Table object. check-in: 3a2c0479 user: drh tags: trunk
01:53
Fix a potential NULL pointer dereference that can occur in ALTER TABLE following an OOM. Test case in TH3. check-in: ea50815b user: drh tags: trunk
01:08
Fix a missing mutex in the sqlite3_normalized_sql() interface when it is called on a prepared statement that did not previously have a computed normalization of the input SQL. check-in: 1a1a59c6 user: drh tags: trunk
2018-12-05
23:56
Get rid of the hash table used to track IN operators in the sqlite3_normalized_sql() implementation. Use simple integer variables instead. check-in: 272dc74f user: drh tags: trunk
23:45
The sqlite3_normalized_sql() interface should not be transforming quoted identifier names into wildcards. Fix this, and at the same time simplify the code substantially. check-in: e8540377 user: drh tags: trunk
21:55
Fix an imbalanced lock problem in sqlite3Normalize() introduced by the simplification in [94ea6379178e3ff6a]. check-in: f6962437 user: drh tags: trunk
19:42
Increase the version number to 3.27.0 for the next development cycle. check-in: 8f8d6828 user: drh tags: trunk
17:48
Simplifications to the sqlite3_normalized_sql() implementation. check-in: 94ea6379 user: drh tags: trunk
17:31
Fix a test script problem on this branch. check-in: 285d1c59 user: dan tags: wal2
17:14
Fix a problem causing "PRAGMA journal_mode" to report the wrong journal mode (wal instead of wal2) under some circumstances. check-in: 1d8d4f68 user: dan tags: wal2
16:31
Fixes for snapshots API on this branch. Also ensure that the snapshots API cannot be used with wal2 mode databases (for now anyhow). check-in: 19c61ab7 user: dan tags: wal2
13:49
Ensure that ALTER TABLE modifies table and column names embedded in WITH clauses that are part of views and triggers. check-in: f44bc7a8 user: dan tags: trunk
13:39
Enhance the sqlite3_normalize_sql() interface so that it works even if the prepared statement was not initially compiled using SQLITE_PREPARE_NORMALIZED. Enhance the ".trace" command in the CLI so that it is able to access the full scope of functionality provided by sqlite3_trace_v2() and in particular so that it is able to show normalized SQL output using the newly enhanced sqlite3_normalize_sql() interface. check-in: 7da617e9 user: drh tags: trunk
2018-12-04
16:51
Add the "index_usage" utility program. check-in: df954552 user: drh tags: trunk
14:33
Performance improvement in sqlite3_step() by creating a new mTrace flag for the legacy xProfile pointer that is set by sqlite3_profile(). check-in: e28584e8 user: drh tags: trunk
13:51
Small performance increase in sqlite3_step() for the common case where it returns SQLITE_ROW. check-in: 89344826 user: drh tags: trunk
2018-12-03
23:57
Reduce the size of the parser tables generated by Lemon by splitting the yyRuleInfo structure into separate yyRuleInfoLhs and yyRuleInfoNRhs arrays. check-in: 70fe8ec2 user: drh tags: trunk
18:13
Increase a timeout in test file walprotocol2.test. To account for unix builds without HAVE_USLEEP. check-in: 480be916 user: dan tags: wal2
17:40
Remove the unused sqlite3Fts5UnicodeNCat() function. check-in: 7149dacf user: drh tags: trunk
16:14
Add the "remove_diacritics=2" option to the unicode61 tokenizer in both FTS5 and FTS3/4. check-in: 06177f3f user: dan tags: trunk
14:58
Update the autoconf makefile for MSVC. check-in: 675aba1f user: mistachkin tags: trunk
01:58
Remove two lines of unnecessary code, for a very small performance increase and size decrease. check-in: 15824ccd user: drh tags: trunk
01:47
Fix a parser bug in the use of parentheses around table-valued functions. check-in: 58a51123 user: drh tags: trunk
2018-12-02
01:15
Omit a line of code that has no affect on the outcome. check-in: 5d933aa6 user: drh tags: trunk
2018-12-01
21:13
Very slightly smaller and faster. check-in: 27798f17 user: drh tags: trunk
20:14
Sync this branch with the latest trunk. check-in: 7a44fa5a user: dan tags: wal2
12:34
Version 3.26.0 check-in: bf8c1b2b user: drh tags: trunk, release, version-3.26.0
2018-11-30
20:59
Fix a typo in a comment. No changes to code. check-in: 23684cb8 user: drh tags: trunk
2018-11-29
12:00
Fix the name of the trig function approximation in geopoly. No functional changes to the code. check-in: 33576b12 user: drh tags: trunk
2018-11-28
19:23
Fix a typo in a comment used to generate documentation. No changes to code. check-in: 62360cea user: drh tags: trunk
19:12
Update incrvacuum.test so that it works with builds that do not support mmap(). check-in: 8eb62fd5 user: dan tags: trunk
11:49
Update some test cases to account for SQLITE_OMIT_VIRTUAL_TABLE builds. check-in: b53a9a3d user: dan tags: trunk
11:09
Follow-up to [0bf0fd242b93c3bd30]: only reset the pager when adding a new codec, not when overwriting an existing codec. Also, improve a comment in the pcache1 subsystem. check-in: 5c040fdb user: drh tags: trunk
08:24
Changes to Makefile.in to allow testfixture to be built with SQLITE_USER_AUTHENTICATION. check-in: 7b510f59 user: dan tags: trunk
08:09
Remove -DSQLITE_USER_AUTHENTICATION from the "Unlock-Notify" configuration. Create a dedicated "User-Auth" configuration for testing this feature. check-in: 8c41024f user: dan tags: trunk
08:02
Fixes for SQLITE_OMIT_VIRTUAL_TABLE builds. check-in: 9bcdec85 user: dan tags: trunk
01:45
Always enable SQLITE_ENABLE_DESERIALIZE for the MSVC makefile as this is necessary to get releasetest.tcl to work. check-in: d362dedb user: drh tags: trunk
2018-11-27
19:47
Fix a failing assert() in sqlite3ResetAllSchemasOfConnection(). check-in: 0ea049f3 user: dan tags: trunk
17:02
Improvements to two cases in pragma4.test. check-in: 3c893d9b user: drh tags: trunk
14:41
Remove the sqlite3PagerUseWal() routine which was made obsolete by the [81629ba91475938b6ad] change. check-in: 4331b499 user: drh tags: trunk
14:34
Add a simple test case for Lemon. Always include assert.h in the Lemon-generated parser. check-in: 9c9c46dc user: drh tags: trunk
14:03
Fix to the error handling logic in the Lemon parser template. This does not affect SQLite since SQLite does not use that part of the Lemon parser template. check-in: c6dfc59e user: drh tags: trunk
09:57
Add an "#ifndef SQLITE_DISABLE_FTS4_DEFERRED" block around function fts3EvalDeferredPhrase() in fts3 in order to silence a compiler warning. check-in: 6f4b0d04 user: dan tags: trunk
2018-11-26
18:09
Do not allow direct access to internal-use SQL functions such as sqlite_rename_column() and sqlite3_rename_table() except when the new SQLITE_TESTCTRL_INTERNAL_FUNCTIONS flag is set. check-in: 6e133054 user: drh tags: trunk
15:00
Minor comment enhancement in alter.c. No changes to code. check-in: 12920bcb user: drh tags: trunk
2018-11-24
20:44
Fix a bug in the geopoly_ccw() function. Test cases in TH3. check-in: 773c5c1d user: drh tags: trunk
17:46
Make the winTruncate() method of the windows VFS be a no-op if there are outstanding references to the memory-mapped pages. Otherwise, memory might be deleted out from under those references when the file is remapped during the truncate operation. check-in: ffce4aac user: drh tags: trunk
16:07
Remove the unused mmapSizeActual field from the Windows sqlite3_file implementation. check-in: 0e7aa622 user: drh tags: trunk
2018-11-22
19:10
Fix a problem reading from temp databases in SQLITE_DIRECT_OVERFLOW_READ builds. check-in: 81629ba9 user: dan tags: trunk
2018-11-21
14:27
Improvements to the ossfuzz.c fuzz-testing module so that it works with -DSQLITE_OMIT_PROGRESS_CALLBACK and with -DSQLITE_OMIT_INIT. check-in: d343f7d6 user: drh tags: trunk
2018-11-20
18:09
Fix problems in pragma.c causing some PRAGMA statements to test the wrong schema-cookie before proceeding, or to try to open cursors on the wrong database ("PRAGMA foreign_key_check" only). check-in: 6982f52f user: dan tags: trunk
2018-11-17
14:59
Fix the regexp used to recognize libdl errors on OS-X. check-in: 17400253 user: drh tags: trunk
14:26
Fix harmless compiler warnings that appear with SQLITE_OMIT_EXPLAIN. check-in: 5fff00b0 user: drh tags: trunk
14:19
Remove a C++-style comment. check-in: 645232f2 user: drh tags: trunk
13:08
Fix a problem in test script e_fkey.test. check-in: acfd0a05 user: dan tags: trunk
2018-11-16
20:50
Fix a test case so that it works on windows. check-in: 2d92d25f user: drh tags: trunk
20:18
Add SQLITE_CONSTRAINT support to the xBestIndex methods on dbstat, sqlite_dbpage, and zipfile. check-in: 5cd24e55 user: drh tags: trunk
19:19
Update the explain virtual table to make use of SQLITE_CONSTRAINT. check-in: b2d41ff7 user: drh tags: trunk
16:04
Fix the JSON table-valued functions to make use of SQLITE_CONSTRAINT. check-in: 3f34f4f5 user: drh tags: trunk
15:41
Add an assert() to the generate_series virtual table to verify assumptions about the design. check-in: cd13b499 user: drh tags: trunk
15:08
Update the generate_series() table-valued function to make use of the new SQLITE_CONSTRAINT return from xBestIndex. check-in: 4372ad64 user: drh tags: trunk
14:36
In order to avoid exporting a symbol, use a macro instead of a function to replace sqlite3_complete() in the shell code when SQLITE_OMIT_COMPLETE is defined. check-in: d584a0cb user: dan tags: trunk
13:56
Enhance the xBestIndex interface of virtual table so that if the xBestIndex method returns SQLITE_CONSTRAINT then that particular combination of constraints is considered unusable and does not participate further in query planning. check-in: 684013ce user: drh tags: trunk
13:06
Fix comments and make magic numbers into #defines in the fsdir implementation. check-in: c537c9c3 user: drh tags: trunk
08:36
Fix a problem with virtual table "fsdir" and some join queries. check-in: 7fffcee0 user: dan tags: trunk
01:42
Improvements to the CSV virtual table. check-in: 0406ecbb user: drh tags: trunk
2018-11-15
19:12
Fix typos in the previous check-in. check-in: 9b37bbf5 user: mistachkin tags: trunk
16:56
Include geopoly in the compiler-warning script. check-in: 3d947e1e user: drh tags: trunk
13:51
New fuzztest cases. check-in: e8316ba4 user: drh tags: trunk
2018-11-13
20:21
Fix a potential buffer overread in the dbstat virtual table when processing a corrupt database file. check-in: a62e6b59 user: drh tags: trunk