Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent timeline items
|
2017-07-21
| ||
| 04:08 | [5a3022e081] Leaf: 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]. (user: drh, tags: branch-3.8.10) | |
| 03:23 | [a66a5b397b] Leaf: 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]. (user: drh, tags: branch-3.8.6) | |
| 03:09 | [f0f492245e] Leaf: 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. (user: drh, tags: branch-3.7.11) | |
|
2017-07-20
| ||
| 21:18 | [5e944eea5a] Leaf: Add the documentation text for the new VFS interfaces used by batch-atomic writes. (user: drh, tags: batch-atomic-write) | |
| 21:01 | [f2c6b58450] Transform two #ifdef statements into #if statements. (user: drh, tags: batch-atomic-write) | |
| 21:00 | [7eb9bf2c5b] Split SQLITE_ENABLE_ATOMIC_WRITE into two options - the original and SQLITE_ENABLE_BATCH_ATOMIC_WRITE. (user: dan, tags: batch-atomic-write) | |
| 20:51 | • Edit [416973ede3bde856|416973ede3]: Move to branch batch-atomic-write. (user: drh) | |
| 20:49 | [e4b1dd3683] Leaf: Fix a harmless typo, but one that would show up in the documentation if not fixed. (user: drh, tags: trunk) | |
| 19:54 | • Edit [929bc46b8be0111a|929bc46b8b]: Mark "Closed". (user: drh) | |
| 19:49 | [416973ede3] Add support for F2FS atomic writes. Untested at this point. (user: dan, tags: batch-atomic-write) | |
| 19:28 | [58553d61d1] Leaf: Minor fix to the concurrent.test module so that it works on windows. (user: drh, tags: begin-concurrent) | |
| 19:08 | [44c760d150] Fix compiler warnings. (user: drh, tags: begin-concurrent) | |
| 18:56 | [7355e74239] Fix a faulty #ifdef on the previous check-in (user: drh, tags: begin-concurrent) | |
| 18:28 | [a29401e924] Get the build working with SQLITE_OMIT_CONCURRENT. (user: drh, tags: begin-concurrent) | |
| 17:47 | [213c61cb82] Merge all the latest trunk enhancements. (user: drh, tags: begin-concurrent) | |
| 16:55 | [10556ee454] Leaf: Experimental API sqlite3_stmt_refresh() to force a prepared statement to recompile if it needs to due to a schema change or other factor. (user: drh, tags: sqlite3_stmt_refresh) | |
| 15:09 | • Edit [55791928f317a306|55791928f3]: Mark "Closed". (user: drh) | |
| 15:08 | [a90c062d46] 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. (user: drh, tags: trunk) | |
| 14:36 | [b7f70c7fca] Closed-Leaf: New test cases for date/time functions in indexes on expressions, in the WHERE clause of partial indexes, and in CHECK constraints. (user: drh, tags: index-on-date-func) | |
| 13:17 | [22eda0985e] 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. (user: drh, tags: index-on-date-func) | |
|
2017-07-19
| ||
| 19:48 | [0a5e1c04d9] Allow indexes to be created on date/time functions as long as the 'now' date and the 'localtime' and 'utc' modifiers are not used. (user: drh, tags: index-on-date-func) | |
| 18:54 | [be0df0a65f] Leaf: Merge latest trunk changes with this branch. (user: dan, tags: server-process-edition) | |
| 18:01 | [d14fc621e9] Remove some 'breakpoint' commands in test files. (user: mistachkin, tags: trunk) | |
| 17:12 | [55791928f3] Closed-Leaf: Create "pure" versions of the date/time functions that omit the 'now' feature and are therefore deterministic and usable in an index. (user: drh, tags: pure-date-functions) | |
| 11:52 | [c93284cd65] Add further tests to unionvtab.test. (user: dan, tags: trunk) | |
| 11:20 | [929bc46b8b] Add VFS interfaces needed to make use of batch atomic write capabilities in the underlying filesystem. (user: drh, tags: batch-atomic-write) | |
|
2017-07-18
| ||
| 21:19 | [255d6b99de] Fix a crash in unionvtab caused by a misconfiguration. Add other test cases for the same. (user: dan, tags: trunk) | |
| 21:00 | • [714f6cbbf7] Support for Batch-Atomic Writes (user: drh, tags: batch-atomic-write) | |
| 20:59 | [505fdc8ff5] Fix shell.c.in so that it aligns with shell.c. (user: drh, tags: trunk) | |
| 20:49 | [deadaad2a0] Add test cases and fix minor error-handling issues in unionvtab.c. (user: dan, tags: trunk) | |
| 20:30 | [47b80ecc67] Fix duplicate test name. No changes to code. (user: mistachkin, tags: trunk) | |
| 20:28 | [d49639c208] Fix another harmless compiler warning. Get the MSVC makefile working with unionvtab. (user: drh, tags: trunk) | |
| 20:22 | [4d147a1e28] Suppress harmless compiler warnings in union-vtab. (user: drh, tags: trunk) | |
| 20:17 | [a447fdf182] Remove an unused variable from unionvtab.c. (user: dan, tags: trunk) | |
| 20:03 | [5bcf0f86ea] Improve the readability of the unionvtab code. (user: dan, tags: trunk) | |
| 19:51 | [4a6c416fa0] 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. (user: dan, tags: trunk) | |
| 18:50 | [6c9128e1a5] Add test cases to unionvtab.test. (user: dan, tags: trunk) | |
| 18:19 | [948f95046b] Add the union-vtab extension - still experimental and under active development. (user: drh, tags: trunk) | |
| 17:34 | [9dbae1df75] 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. (user: dan, tags: trunk) | |
| 17:13 | [d2f0b2e859] Avoid creating an automatic index on the RHS of a LEFT JOIN to optimize an IS term. Fix for [ce68383b]. (user: dan, tags: trunk) | |
| 16:57 | • New ticket [ce68383bf6] Incorrect LEFT JOIN result with IS operator in WHERE clause and auto-index. (user: drh) | |
| 14:41 | [0b69aa7e37] Change the default command-line shell history depth to 2000 lines. (user: drh, tags: trunk) | |
|
2017-07-17
| ||
| 21:03 | [f2c4a584e8] Closed-Leaf: Add test cases to test/unionvtab.test. (user: dan, tags: union-vtab) | |
| 20:25 | [9c3f1b9a82] Enhance error detection and fix other issues in unionvtab code. (user: dan, tags: union-vtab) | |
| 20:21 | [e181225dc7] Leaf: Merge all the latest fixes and enhancements from trunk. (user: drh, tags: apple-osx) | |
| 19:37 | [cd6ac07848] Leaf: 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. (user: drh, tags: branch-3.8.9) | |
| 19:25 | [adc082c146] Closed-Leaf: 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]. (user: drh, tags: push-down-backport) | |
| 19:14 | [52674f948c] 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]. (user: drh, tags: push-down-backport) | |
| 19:07 | [043d6ce8ad] 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. (user: drh, tags: push-down-backport) | |
| 18:45 | [e0aca7d2c6] 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. (user: drh, tags: trunk) | |