Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around e8540377ec66fa5f.
2018-12-10
| ||
15:51 | Add extra tests to shmlock.test (direct testing of xShmLock methods). (check-in: d2c785f9 user: dan tags: mutexfree-shmlock) | |
15:24 | Rework the SQLITE_MUTEXFREE_SHMLOCK code to reduce contention. (check-in: d9157dd1 user: dan tags: mutexfree-shmlock) | |
09:45 | Avoid a mutex in-and-out in unixShmBarrier() on this branch. Use __sync_synchronize() instead. (check-in: a8c5fd86 user: dan tags: mutexfree-shmlock) | |
09:36 | Avoid a mutex in-and-out in unixShmBarrier() on this branch. Use __sync_synchronize() instead. (check-in: 280d1a72 user: dan tags: begin-concurrent-pnu-mutexfree-shmlock) | |
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) | |
02:00 | Merge enhancements from trunk. (check-in: b1bbc718 user: drh tags: apple-osx) | |
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 | • Fixed ticket [1d958d90]: Incorrect result with NOT IN operator and partial index plus 5 other changes (artifact: 06dc40aa user: drh) | |
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) | |
13:06 | • New ticket [1d958d90] Incorrect result with NOT IN operator and partial index. (artifact: 17e6b575 user: drh) | |
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) | |
20:25 | Add multi-threaded performance test program "tserver" to this branch. Fix bugs in the begin-concurrent/wal2 integration revealed by the same. (check-in: 7bd3b356 user: dan tags: begin-concurrent-wal2) | |
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) | |
02:01 | 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: 65aafb55 user: drh tags: branch-3.26) | |
01:56 | • Fixed ticket [f09fcd17]: Assertion fault when window functions are used. plus 5 other changes (artifact: d07f783f user: drh) | |
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) | |
20:26 | Add the mutexfree-shmlock experiment to the begin-concurrent-pnu branch. (check-in: 3aead209 user: dan tags: begin-concurrent-pnu-mutexfree-shmlock) | |
20:18 | Experimental changes to (optionally) allow double-quoted strings to be checked against known identifiers. (Leaf check-in: 73a6b8c1 user: mistachkin tags: normalize_v4) | |
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) | |
18:58 | Experiment with using an atomic CPU primitive instead of a mutex for intra-process locking with the unix-excl VFS. (check-in: 8f4cb9dd user: dan tags: mutexfree-shmlock) | |
17:17 | • New ticket [f09fcd17] Assertion fault when window functions are used.. (artifact: f0910878 user: drh) | |
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) | |
14:24 | Bump the version number to 3.26.1. (check-in: e97e053b user: drh tags: branch-3.26) | |
14:11 | Fix a potential NULL pointer dereference that can occur in ALTER TABLE following an OOM. Test case in TH3. (check-in: 99a0951f user: drh tags: branch-3.26) | |
13:57 | Ensure that ALTER TABLE modifies table and column names embedded in WITH clauses that are part of views and triggers. (check-in: e066b4e1 user: drh tags: branch-3.26) | |
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) | |
03:13 | Merge fixes from trunk. (check-in: f2083ee4 user: drh tags: begin-concurrent-pnu) | |
02:08 | Merge bug fixes from trunk. (check-in: 1e13aaa2 user: drh tags: begin-concurrent) | |
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) | |
00:08 | Merge ALTER TABLE and sqlite3_normalized_sql() bug fixes from trunk. (check-in: 3793e5d5 user: drh tags: begin-concurrent-pnu) | |
00:05 | Merge ALTER TABLE and sqlite3_normalized_sql() fixes from trunk. (check-in: acf10b3f user: drh tags: begin-concurrent) | |
00:01 | • Edit [9b6e9a6e45f3da3a|9b6e9a6e]: Mark "Closed". (artifact: 731ac2ed user: drh) | |
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) | |
23:27 | • Edit [9b6e9a6e45f3da3a|9b6e9a6e]: Move to branch mistake. Edit check-in comment. (artifact: 837bc151 user: drh) | |
23:25 | Bungled checkin. Ignore. (Closed-Leaf check-in: 9b6e9a6e user: drh tags: mistake) | |
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) | |
18:28 | Merge enhancements and the ALTER TABLE bug fix from trunk. (check-in: edfc2acf user: drh tags: apple-osx) | |
18:25 | Add test cases to wal2concurrent.test. (check-in: ef9e7a87 user: dan tags: begin-concurrent-wal2) | |
17:48 | Simplifications to the sqlite3_normalized_sql() implementation. (check-in: 94ea6379 user: drh tags: trunk) | |
17:36 | Fix a test script problem on this branch. (check-in: 692ddc28 user: dan tags: begin-concurrent-wal2) | |
17:31 | Fix a test script problem on this branch. (check-in: 285d1c59 user: dan tags: wal2) | |
17:20 | Fix a problem causing "PRAGMA journal_mode" to report the wrong journal mode (wal instead of wal2) under some circumstances. (check-in: bf309107 user: dan tags: begin-concurrent-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:45 | 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: d8c2d55f user: dan tags: begin-concurrent-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 | Merge enhancements from trunk, especially the sqlite3_normalized_sql() enhancement. (check-in: 342c9538 user: drh tags: begin-concurrent-pnu) | |
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:44 | Merge enhancements from trunk, especially the enhanced sqlite3_normalized_sql() interface. (check-in: 47b73f6b user: drh tags: begin-concurrent) | |
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
| ||
21:16 | When compiled with SQLITE_ENABLE_NORMALIZE, always have sqlite3_exec() enable the SQLITE_PREPARE_NORMALIZE flag. (Leaf check-in: 28643d83 user: mistachkin tags: execWithNormalize) | |
19:41 | First attempt at making features work together. Only the most minimal testing so far. (check-in: fd707001 user: dan tags: begin-concurrent-wal2) | |
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 | Fix a problem with SQLITE_ENABLE_EXPENSIVE_ASSERT builds on this branch. (check-in: ddb4a6fb user: dan tags: begin-concurrent) | |
13:51 | Small performance increase in sqlite3_step() for the common case where it returns SQLITE_ROW. (check-in: 89344826 user: drh tags: trunk) | |
01:18 | Attempt to make the parser a little faster by storing the ON and USING clause in a single OnUsing object. (Leaf check-in: 6770ed08 user: drh tags: on-using-opt) | |
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) | |
20:49 | Merge the wal2 and begin-concurrent code. Both features work, but not at the same time. (check-in: b7281a1c user: dan tags: begin-concurrent-wal2) | |
20:38 | Minor change to wal.c on this branch to make it more similar to trunk. (check-in: 6a7af3ea user: dan tags: begin-concurrent) | |
19:29 | Cherrypick a couple of fixes from begin-concurrent-pnu into this branch. The differences between the two branches are now that this one does not have "PRAGMA noop_update" or the mutex-free PRNG. (check-in: a56506b9 user: dan tags: begin-concurrent) | |
18:24 | Merge in all changes for release 3.26.0. (check-in: 85fd92c7 user: drh tags: begin-concurrent-pnu) | |
18:15 | Bring up to date with version 3.26.0. (check-in: f0ddb358 user: drh tags: begin-concurrent) | |
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) | |
18:22 | Merge the pre-3.26.0 fixes from trunk. (check-in: 2c76ce4f user: drh tags: apple-osx) | |
16:26 | Merge the mutex-free PRNG change into this branch. (check-in: 81e626f4 user: dan tags: begin-concurrent-pnu) | |
2018-11-29
| ||
16:31 | • Edit [31b6aee755c81d69|31b6aee7]: Move to branch reuse-schema1. (artifact: b4a6b1a1 user: dan) | |
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:16 | • Edit [8eb62fd5fa9adb88|8eb62fd5]: Timestamp 2018-11-28 19:12:59. (artifact: 70add297 user: drh) | |
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) | |