SQLite
Timeline
Not logged in

50 most recent check-ins

2018-12-09
18:55
New test case for ticket [1d958d90596593a77420e59]. Leaf check-in: b7bf3c9832 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: 15bc915dd7 user: drh tags: trunk
01:09
Add the --async option to the ".backup" command in the CLI. Leaf check-in: 7b6a605b18 user: drh tags: vacuum-into
00:43
Allow the INTO clause of VACUUM to be a text-valued expression. check-in: af172b53b4 user: drh tags: vacuum-into
2018-12-07
23:48
Do not allow VACUUM INTO into a file that already exists. check-in: 92f70e0fa3 user: drh tags: vacuum-into
20:40
Merge the VACUUM simplification from trunk. check-in: 93d92a0a5d 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: a92c398fc5 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. Leaf check-in: 7bd3b35661 user: dan tags: begin-concurrent-wal2
17:28
Prototype implementation for the VACUUM INTO command. check-in: 036e3320a4 user: drh tags: vacuum-into
16:32
Fix the sqlite3_normalized_sql() interface so that it renders double-quoted string literals as "?". check-in: 0d8e150434 user: drh tags: trunk
03:01
Fix dbfuzz2.c so that it works with -DSQLITE_OMIT_INIT check-in: 9ad796a882 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]. Leaf check-in: 65aafb5531 user: drh tags: branch-3.26
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: db5ed2268e 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: 2b9258b8b0 user: drh tags: ticket-f09fcd17810f
22:04
Fix the sqlite3ExprDup() routine so that it makes complete duplications of subqueries containing window functions. check-in: 940174543e user: drh tags: ticket-f09fcd17810f
20:26
Add the mutexfree-shmlock experiment to the begin-concurrent-pnu branch. Leaf check-in: 3aead209b4 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: 73a6b8c1b9 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: a9a3b53264 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: f1b18d44ff 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. Leaf check-in: 8f4cb9dd33 user: dan tags: mutexfree-shmlock
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: 53d3b169d8 user: drh tags: trunk
16:54
Add test file wal2snapshot.test that should have been added as part of an earlier commit. Leaf check-in: f6baa7e116 user: dan tags: wal2
16:50
When saving off the value of sqlite3.flags, take care to preserve all 64 bits. check-in: 9c6dbcfab5 user: drh tags: trunk
16:11
Issue a warning whenever a double-quoted string literal is used. check-in: ac9ad50430 user: drh tags: trunk
14:24
Bump the version number to 3.26.1. check-in: e97e053b78 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: 99a0951fdc 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: e066b4e171 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: ec63d3506b user: drh tags: trunk
03:13
Merge fixes from trunk. Leaf check-in: f2083ee410 user: drh tags: begin-concurrent-pnu
02:08
Merge bug fixes from trunk. Leaf check-in: 1e13aaa29f user: drh tags: begin-concurrent
02:01
Remove the unused pColHash field from the Table object. check-in: 3a2c047989 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: ea50815bf8 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: 1a1a59c6c5 user: drh tags: trunk
00:08
Merge ALTER TABLE and sqlite3_normalized_sql() bug fixes from trunk. check-in: 3793e5d5d6 user: drh tags: begin-concurrent-pnu
00:05
Merge ALTER TABLE and sqlite3_normalized_sql() fixes from trunk. check-in: acf10b3f8d user: drh tags: begin-concurrent
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: 272dc74fd0 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: e8540377ec user: drh tags: trunk
23:25
Bungled checkin. Ignore. Closed-Leaf check-in: 9b6e9a6e45 user: drh tags: mistake
21:55
Fix an imbalanced lock problem in sqlite3Normalize() introduced by the simplification in [94ea6379178e3ff6a]. check-in: f69624373e user: drh tags: trunk
19:42
Increase the version number to 3.27.0 for the next development cycle. check-in: 8f8d682825 user: drh tags: trunk
18:28
Merge enhancements and the ALTER TABLE bug fix from trunk. Leaf check-in: edfc2acfcd user: drh tags: apple-osx
18:25
Add test cases to wal2concurrent.test. check-in: ef9e7a87a4 user: dan tags: begin-concurrent-wal2
17:48
Simplifications to the sqlite3_normalized_sql() implementation. check-in: 94ea637917 user: drh tags: trunk
17:36
Fix a test script problem on this branch. check-in: 692ddc2808 user: dan tags: begin-concurrent-wal2
17:31
Fix a test script problem on this branch. check-in: 285d1c5904 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: bf309107df 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: 1d8d4f6896 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: d8c2d55fa4 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: 19c61ab794 user: dan tags: wal2
13:49
Merge enhancements from trunk, especially the sqlite3_normalized_sql() enhancement. check-in: 342c9538d9 user: drh tags: begin-concurrent-pnu