/ Timeline
Login

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

100 check-ins occurring around f2c6b5845028ef25.

2017-07-28
22:22
Update Tcl version used by the TclKit batch tool for MSVC. check-in: bcec155e user: mistachkin tags: trunk
22:13
Fix harmless compiler warning. check-in: 3286e1a0 user: mistachkin tags: trunk
21:02
Reduce the number of mallocs required of writers in server mode. check-in: 60953997 user: dan tags: server-process-edition
20:49
Disable the writecrash.test module on Windows. Leaf check-in: 4c0520d4 user: drh tags: batch-atomic-write
18:16
More precise determination of when an in-memory journal needs to be spilled to disk. check-in: 6a505bdd user: drh tags: batch-atomic-write
13:18
Add new extended error codes for the atomic write file-controls. check-in: 94a20047 user: drh tags: batch-atomic-write
12:20
Fix a punctuation typo in the documentation for sqlite3_step(). No changes to code. check-in: c965b757 user: drh tags: branch-3.20
11:05
Add new test file test/atomic.test. check-in: f9213e48 user: dan tags: batch-atomic-write
02:02
Backport of all batch-atomic-write changes through check-in [67bad7fb9b] check-in: def55027 user: drh tags: batch-atomic-write-3.19
01:53
Add the SQLITE_ENABLE_BATCH_ATOMIC_WRITE macro to ctime.c check-in: 67bad7fb user: drh tags: batch-atomic-write
00:45
Release candidate 3 for 3.20.0 check-in: d891a2a0 user: drh tags: branch-3.20
2017-07-27
22:16
Enhance the like optimization so that it works with an ESCAPE clause. check-in: 2495acf7 user: drh tags: branch-3.8.9
20:24
Enhance the like optimization so that it works with an ESCAPE clause. check-in: f5d330f4 user: drh tags: trunk
19:59
Increase the version number to 3.21.0 in anticipation for changes to go into the next release. check-in: 0645f25c user: drh tags: trunk
18:49
Merge the pointer-passing interface changes from the 3.20 branch. check-in: c63903a4 user: drh tags: trunk
18:43
Simplified documentation for the pointer passing interface. check-in: 2dfcd9a8 user: drh tags: branch-3.20
18:34
Do not set device-capabilities flags SEQUENTIAL or SAFE_APPEND for f2fs file-systems. check-in: 4477e60c user: dan tags: batch-atomic-write
17:45
Add destructor functions for the pointer argument (NB: not the type string) to the sqlite3_bind_pointer() and sqlite3_result_pointer() interfaces. Use this new capability to resolve a pointer leak in the custom geometry function mechanism of the RTREE extension. check-in: 5a2340b8 user: drh tags: branch-3.20
16:42
In sqlite3_bind_pointer(), invoke the destructor if the bind index is out of range, like sqlite3_bind_blob() does. Closed-Leaf check-in: d6684d2a user: drh tags: pointer-with-destructor
15:53
Improved implementation of the destructor on pointer-passing interfaces. check-in: 601ad679 user: drh tags: pointer-with-destructor
14:04
A demonstration of how FTS3 cursor pointers can be passed from the MATCH operator to the snippet() function securely and opaquely without having to use the sqlite3_result_pointer() and sqlite3_value_pointer() interfaces. Closed-Leaf check-in: 49cf31da user: drh tags: pass-pointer-as-blob
03:48
Add a destructor argument to sqlite3_bind_pointer() and sqlite3_result_pointer(). check-in: 3d9e841f user: drh tags: pointer-with-destructor
00:27
Do now allow the geometry object in the right operand of a MATCH operator in the RTREE extension to be inpersonated by a BLOB literal. check-in: 24c9cd46 user: drh tags: branch-3.19
2017-07-26
19:59
Add the new sqlite3.mDbFlags field. Factor out bits of sqlite3.flags that do not interact with PRAGMA statements into sqlite3.mDbFlags. check-in: 3808a00f user: drh tags: trunk
18:26
Allow ATTACH and DETACH to occur inside of a transaction. Closed-Leaf check-in: ac1fd6be user: drh tags: attach-in-trans
10:04
Fix a comment on the UnpackedRecord.r1 and UnpackedRecord.r2 fields. No changes to code. check-in: 622b1089 user: drh tags: trunk
2017-07-25
15:12
Release candidate 2 for 3.20.0. check-in: f39cb76b user: drh tags: branch-3.20
01:34
Fix a bug in the deterministic date/time function logic that can only appear with STAT3 or STAT4. check-in: 1ca707a4 user: drh tags: trunk
2017-07-24
20:01
Do not attempt to run test file unionvtabfault.test with SQLITE_OMIT_VIRTUAL_TABLE builds. check-in: 1a632a9a user: dan tags: trunk
19:43
Update this branch with latest changes from trunk. check-in: d0719ad7 user: dan tags: server-process-edition
19:25
Do not attempt to run test file unionvtab.test with SQLITE_OMIT_VIRTUAL_TABLE builds. check-in: 9a5a3d60 user: dan tags: trunk
19:23
Only open a db in server-mode if there is a directory named "db-journal" in the file-system and the VFS is an exclusive locking VFS. check-in: e77d29f6 user: dan tags: server-process-edition
17:37
Handle a real OOM condition when incrblob2.test is run on a low-memory machine. check-in: f483d06a user: drh tags: trunk
15:29
Additional documentation on sqlite3_bind_pointer() and sqlite3_result_pointer(). No changes to code. check-in: b1572d4e user: drh tags: trunk
14:44
Compiler warning fix associated with date/time functions. check-in: a98f07d9 user: drh tags: trunk
2017-07-22
20:12
Add a test for the outcome of a process crash within an xWrite VFS method call. check-in: eb871800 user: dan tags: batch-atomic-write
16:58
Add the "atomic-batch-write" permutation to permutations.test. This permutation fails if not run on a file-system that supports atomic-batch-writes. check-in: 9f1b83fa user: dan tags: batch-atomic-write
16:32
Keep batch-atomic-writes turned on for journal_mode=MEMORY, but turn them off for synchronous=OFF. Refuse to compile with both SQLITE_MMAP_READWRITE and SQLITE_ENABLE_BATCH_ATOMIC_WRITE. Fix up some comments in the commit logic. check-in: 2e80e19e user: drh tags: batch-atomic-write
16:00
Omit unused batch-atomic-write code if SQLITE_ENABLE_BATCH_ATOMIC_WRITE is not defined. check-in: a89b62c4 user: drh tags: batch-atomic-write
2017-07-21
21:06
Use ioctl(F2FS_IOC_GET_FEATURES) to determine whether or not atomic batch writes are available. check-in: 532bbf1f user: dan tags: batch-atomic-write
20:31
Remove stray (and incomplete) comment from a test file. No changes to code. check-in: 8de20fc7 user: mistachkin tags: trunk
20:29
Fix typo in comment. No changes to code. check-in: 65ec077b user: mistachkin tags: batch-atomic-write
14:49
Additional documentation on the new VFS interface. No changes to code. check-in: 83077ec8 user: drh tags: batch-atomic-write
07:56
Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This changes is a cherry-pick of [f0f49224] via [69906880cee] and is ultimately inspired by check-in [72de49f2]. check-in: 8201f4e1 user: drh tags: branch-3.18
07:45
Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This changes is a cherry-pick of [f0f49224] with version-specific edits. That check-in was inspired by check-in [72de49f2]. check-in: 69906880 user: drh tags: branch-3.9.2
04:08
Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This is a cherry-pick of [f0f49224] which was in turn inspired by [72de49f2]. Leaf check-in: 5a3022e0 user: drh tags: branch-3.8.10
03:23
Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This is a cherry-pick of [f0f492245e95], which is in turn inspired by check-in [72de49f2]. Leaf check-in: a66a5b39 user: drh tags: branch-3.8.6
03:09
Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This changes is inspired by check-in [72de49f2] but is new implementation, not a cherry-pick. Leaf check-in: f0f49224 user: drh tags: branch-3.7.11
2017-07-20
21:18
Add the documentation text for the new VFS interfaces used by batch-atomic writes. check-in: 5e944eea user: drh tags: batch-atomic-write
21:01
Transform two #ifdef statements into #if statements. check-in: f2c6b584 user: drh tags: batch-atomic-write
21:00
Split SQLITE_ENABLE_ATOMIC_WRITE into two options - the original and SQLITE_ENABLE_BATCH_ATOMIC_WRITE. check-in: 7eb9bf2c user: dan tags: batch-atomic-write
20:49
Fix a harmless typo, but one that would show up in the documentation if not fixed. check-in: e4b1dd36 user: drh tags: trunk
19:49
Add support for F2FS atomic writes. Untested at this point. check-in: 416973ed user: dan tags: batch-atomic-write
19:28
Minor fix to the concurrent.test module so that it works on windows. check-in: 58553d61 user: drh tags: begin-concurrent
19:08
Fix compiler warnings. check-in: 44c760d1 user: drh tags: begin-concurrent
18:56
Fix a faulty #ifdef on the previous check-in check-in: 7355e742 user: drh tags: begin-concurrent
18:28
Get the build working with SQLITE_OMIT_CONCURRENT. check-in: a29401e9 user: drh tags: begin-concurrent
17:47
Merge all the latest trunk enhancements. check-in: 213c61cb user: drh tags: begin-concurrent
16:55
Experimental API sqlite3_stmt_refresh() to force a prepared statement to recompile if it needs to due to a schema change or other factor. Leaf check-in: 10556ee4 user: drh tags: sqlite3_stmt_refresh
15:08
Enhance the built-in date/time functions so that they can be used in CHECK constraints, in the WHERE clause or partial indexes, and index expressions, provided that none of the non-deterministic keywords ("now", "localtime", "utc") are used as arguments. check-in: a90c062d user: drh tags: trunk
14:36
New test cases for date/time functions in indexes on expressions, in the WHERE clause of partial indexes, and in CHECK constraints. Closed-Leaf check-in: b7f70c7f user: drh tags: index-on-date-func
13:17
Combine the Parse.ckBase and Parse.iSelfTab fields into just Parse.iSelfTab. This fixes a problem with date/time functions in check-constraints. Add some test cases for date/time functions in index expressions and check constraints. check-in: 22eda098 user: drh tags: index-on-date-func
2017-07-19
19:48
Allow indexes to be created on date/time functions as long as the 'now' date and the 'localtime' and 'utc' modifiers are not used. check-in: 0a5e1c04 user: drh tags: index-on-date-func
18:54
Merge latest trunk changes with this branch. check-in: be0df0a6 user: dan tags: server-process-edition
18:01
Remove some 'breakpoint' commands in test files. check-in: d14fc621 user: mistachkin tags: trunk
17:12
Create "pure" versions of the date/time functions that omit the 'now' feature and are therefore deterministic and usable in an index. Closed-Leaf check-in: 55791928 user: drh tags: pure-date-functions
11:52
Add further tests to unionvtab.test. check-in: c93284cd user: dan tags: trunk
11:20
Add VFS interfaces needed to make use of batch atomic write capabilities in the underlying filesystem. check-in: 929bc46b user: drh tags: batch-atomic-write
2017-07-18
21:19
Fix a crash in unionvtab caused by a misconfiguration. Add other test cases for the same. check-in: 255d6b99 user: dan tags: trunk
20:59
Fix shell.c.in so that it aligns with shell.c. check-in: 505fdc8f user: drh tags: trunk
20:49
Add test cases and fix minor error-handling issues in unionvtab.c. check-in: deadaad2 user: dan tags: trunk
20:30
Fix duplicate test name. No changes to code. check-in: 47b80ecc user: mistachkin tags: trunk
20:28
Fix another harmless compiler warning. Get the MSVC makefile working with unionvtab. check-in: d49639c2 user: drh tags: trunk
20:22
Suppress harmless compiler warnings in union-vtab. check-in: 4d147a1e user: drh tags: trunk
20:17
Remove an unused variable from unionvtab.c. check-in: a447fdf1 user: dan tags: trunk
20:03
Improve the readability of the unionvtab code. check-in: 5bcf0f86 user: dan tags: trunk
19:51
Have unionvtab support constraints on the column that corresponds to the INTEGER PRIMARY KEY field of the underlying source tables in the same way as rowid. check-in: 4a6c416f user: dan tags: trunk
18:50
Add test cases to unionvtab.test. check-in: 6c9128e1 user: dan tags: trunk
18:19
Add the union-vtab extension - still experimental and under active development. check-in: 948f9504 user: drh tags: trunk
17:34
Do not use the flattening optimization for a sub-query on the RHS of a LEFT JOIN if that subquery reads data from a virtual table. Because it prevents the planner from creating an automatic index on the results of the sub-query, the flattening optimization sometimes slows things down in this case. check-in: 9dbae1df user: dan tags: trunk
17:13
Avoid creating an automatic index on the RHS of a LEFT JOIN to optimize an IS term. Fix for [ce68383b]. check-in: d2f0b2e8 user: dan tags: trunk
14:41
Change the default command-line shell history depth to 2000 lines. check-in: 0b69aa7e user: drh tags: trunk
2017-07-17
21:03
Add test cases to test/unionvtab.test. Closed-Leaf check-in: f2c4a584 user: dan tags: union-vtab
20:25
Enhance error detection and fix other issues in unionvtab code. check-in: 9c3f1b9a user: dan tags: union-vtab
20:21
Merge all the latest fixes and enhancements from trunk. check-in: e181225d user: drh tags: apple-osx
19:37
Try to push relevant WHERE clause terms of the outer query down into the subquery in order to help the subquery run faster and/or use less memory. This is a cherry-pick of [6df18e949d36] with bug fixes. check-in: cd6ac078 user: drh tags: branch-3.8.9
19:25
When checking for the WHERE-clause push-down optimization, verify that all terms of the compound inner SELECT are non-aggregate, not just the last term. Fix for ticket [f7f8c97e97597]. Closed-Leaf check-in: adc082c1 user: drh tags: push-down-backport
19:14
Do not apply the WHERE-clause pushdown optimization to terms that originate in the ON or USING clause of a LEFT JOIN. Fix for ticket [c2a19d81652f40568c]. check-in: 52674f94 user: drh tags: push-down-backport
19:07
For FROM-clause subqueries that cannot be flattened, try to push relevant WHERE clause terms of the outer query down into the subquery in order to help the subquery run faster and/or use less memory. Cherry-pick from [6df18e949d36]. Still need to backport bug fixes associated with that check-in. check-in: 043d6ce8 user: drh tags: push-down-backport
18:45
Merge all changes from branch-3.20. Improvements to the fts5() extension interface. Work around a gcc/valgrind bug in the sqlite3_value_pointer() interface. check-in: e0aca7d2 user: drh tags: trunk
17:46
Interchange to branches within an "if" statement in sqlite3_value_pointer() in order to work around a bug in gcc. Closed-Leaf check-in: 8a606e4a user: drh tags: branch-3.20
15:38
Improved the interface to the fts5() extension mechanism for enhanced security. check-in: bc78235f user: drh tags: branch-3.20
13:37
Merge the pointer-type enhancement from the 3.20 branch. check-in: 9e8e1c4a user: drh tags: trunk
12:41
Comment changes clarifying details of the pointer-type parameter. No changes to code. check-in: e4579e50 user: drh tags: branch-3.20
12:27
Add the pointer-type parameter to sqlite3_bind_pointer(), sqlite3_result_pointer(), and sqlite3_value_pointer(). The pointer type is a static string that must match (according to strcmp()) or else the pointer is passed as a NULL. This is a security measure to prevent crossing pointers between different extensions. check-in: e1196567 user: drh tags: branch-3.20
11:39
Improve the sqlite3_result_pointer() interface so that it cannot be faked using sqlite3_result_null() and sqlite3_result_subtype(). Closed-Leaf check-in: c13264d5 user: drh tags: pointer-types
09:30
Use integer handles for fts3 cursors for a small performance improvement. Closed-Leaf check-in: f4f7196b user: dan tags: union-vtab, fts3-int-cursor
00:40
Add an experimental "pointer type" parameter to sqlite3_bind_pointer(), sqlite3_result_pointer(), and sqlite3_value_pointer(). The pointer type is a string that must compare equal using strcmp() or else the pointer comes through as a NULL. check-in: 211cce04 user: drh tags: pointer-types
2017-07-15
20:48
Add the "unionvtab" virtual table extension in ext/misc/unionvtab.c. check-in: 62a86aa6 user: dan tags: union-vtab
20:44
Merge the fix for ticket [a4e06e75a9ab61a12] from trunk. check-in: b64d64c8 user: drh tags: branch-3.20