Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around d0719ad757bdf7cf.
|
2017-07-31
| ||
| 19:34 | Sync up the MSVC autoconf makefile. check-in: 44cebc6e user: drh tags: branch-3.20 | |
| 19:26 | Sync up the MSVC autoconf makefile. check-in: b3b89f4f user: mistachkin tags: trunk | |
| 17:51 | Fix a windows-compatibility issue in the recently added schema6.test script. check-in: 14e6c302 user: drh tags: trunk | |
| 17:40 | More consistent column names. Cherry-pick of [09834279] and [0c38dde45] as a fix for ticket [de3403bf5ae]. check-in: be0e24a0 user: drh tags: branch-3.20 | |
| 17:06 | Prevent OSSFuzz from using debugging pragmas that are disabled in default builds and which generate lots of excess output. check-in: cdc6494c user: drh tags: trunk | |
| 16:42 | Move the generation of output column names earlier, to right after name resolution and before query transformations such as flattening. This prevents the names from getting mangled by query transformations, and obviates hacks in the query flattener that attempt to work around the name mangling. The resulting code is smaller and faster and gives more consistent output. Fix to ticket [de3403bf5ae5f72ed]. check-in: ade7ddf1 user: drh tags: trunk | |
| 13:22 | Use batch atomic writes when running on a recent F2FS filesystem, if compiled with SQLITE_ENABLE_BATCH_ATOMIC_WRITE. check-in: 2dd0c77d user: drh tags: branch-3.19 | |
| 13:11 | Move the generation of output column names earlier, to right after name resolution and before query transformations such as flattening. This prevents the names from getting mangled by query transformations, and obviates hacks in the query flattener that attempt to work around the name mangling. The resulting code is smaller and faster and gives more consistent output. This is a fix for ticket [de3403bf5ae5f72ed] and a cherry-pick of check-in [09834279aeca3bda] check-in: 499942b3 user: drh tags: branch-3.19 | |
| 12:19 | Correctly handle an "INTEGER PRIMARY KEY UNIQUE" column in a WITHOUT ROWID table. This is a fix for ticket [bc115541132dad136], cherry-picked from check-in [5216bfb73f1a49bdd8] check-in: 322a2ede user: drh tags: branch-3.19 | |
| 12:07 | Increase the version number to 3.19.4 check-in: b77f297d user: drh tags: branch-3.19 | |
| 12:04 | Merge further enhancements to the batch-atomic-write subsystem. Leaf check-in: 4be4265d user: drh tags: batch-atomic-write-3.19 | |
|
2017-07-30
| ||
| 20:30 | Correctly handle an "INTEGER PRIMARY KEY UNIQUE" column in a WITHOUT ROWID table. This is a fix for ticket [bc115541132dad136] cherry-picked from [5216bfb73f1a49bdd]. check-in: 5c8cb1ff user: drh tags: branch-3.20 | |
| 19:50 | Add the schema6.test module for demonstrating schemas that generate identical and different content. check-in: ac1da06a user: drh tags: trunk | |
| 18:40 | Correctly handle an "INTEGER PRIMARY KEY UNIQUE" column in a WITHOUT ROWID table. This is a fix for ticket [bc115541132dad136], a problem discovered by OSSFuzz. check-in: 5216bfb7 user: drh tags: trunk | |
|
2017-07-29
| ||
| 17:10 | Merge latest trunk changes with this branch. check-in: b42c8779 user: dan tags: server-process-edition | |
| 17:02 | New test cases for column name generation interacting with the query flattener. Closed-Leaf check-in: 0c38dde4 user: drh tags: early-column-names | |
| 17:01 | Update test program "tserver" to use a native pthreads mutex/condition variable to efficiently manage wal file checkpoints without the wal file growing indefinitely. check-in: 8299bdb7 user: dan tags: server-process-edition | |
| 16:01 | Move the generation of output column names earlier, to right after name resolution and before query transformations such as flattening. This prevents the names from getting mangled by query transformations, and obviates hacks in the query flattener that attempt to work around the name mangling. The resulting code is smaller and faster and gives more consistent output. This is an alternative fix to ticket [de3403bf5ae5f72ed]. check-in: 09834279 user: drh tags: early-column-names | |
| 14:56 | Use the subquery column name, not the original SQL statement text, as the added AS clause in the query flattener. Closed-Leaf check-in: 5df7f0e6 user: drh tags: flattener-column-names | |
| 03:33 | In the query flattener, only add AS clauses to output columns of the outer query that are copied directly from the inner query. Formerly, all columns of the outer query received an AS clause if they did not have one already. This is a proposed fix for ticket [de3403bf5ae5f72]. check-in: 439cc5c5 user: drh tags: flattener-column-names | |
|
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 | |