SQLite
Timeline
Not logged in

50 most recent timeline items

2017-07-21
07:56
[8201f4e1] 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 a cherry-pick of [f0f49224] via [69906880cee] and is ultimately inspired by check-in [72de49f2]. (user: drh, tags: branch-3.18)
07:45
[69906880] 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 a cherry-pick of [f0f49224] with version-specific edits. That check-in was inspired by check-in [72de49f2]. (user: drh, tags: branch-3.9.2)
04:08
[5a3022e0] 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
[a66a5b39] 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
[f0f49224] 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
[5e944eea] Leaf: Add the documentation text for the new VFS interfaces used by batch-atomic writes. (user: drh, tags: batch-atomic-write)
21:01
[f2c6b584] Transform two #ifdef statements into #if statements. (user: drh, tags: batch-atomic-write)
21:00
[7eb9bf2c] 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|416973ed]: Move to branch batch-atomic-write. (user: drh)
20:49
[e4b1dd36] 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|929bc46b]: Mark "Closed". (user: drh)
19:49
[416973ed] Add support for F2FS atomic writes. Untested at this point. (user: dan, tags: batch-atomic-write)
19:28
[58553d61] Leaf: Minor fix to the concurrent.test module so that it works on windows. (user: drh, tags: begin-concurrent)
19:08
[44c760d1] Fix compiler warnings. (user: drh, tags: begin-concurrent)
18:56
[7355e742] Fix a faulty #ifdef on the previous check-in (user: drh, tags: begin-concurrent)
18:28
[a29401e9] Get the build working with SQLITE_OMIT_CONCURRENT. (user: drh, tags: begin-concurrent)
17:47
[213c61cb] Merge all the latest trunk enhancements. (user: drh, tags: begin-concurrent)
16:55
[10556ee4] 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|55791928]: Mark "Closed". (user: drh)
15:08
[a90c062d] 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
[b7f70c7f] 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
[22eda098] 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
[0a5e1c04] 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
[be0df0a6] Leaf: Merge latest trunk changes with this branch. (user: dan, tags: server-process-edition)
18:01
[d14fc621] Remove some 'breakpoint' commands in test files. (user: mistachkin, tags: trunk)
17:12
[55791928] 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
[c93284cd] Add further tests to unionvtab.test. (user: dan, tags: trunk)
11:20
[929bc46b] 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
[255d6b99] Fix a crash in unionvtab caused by a misconfiguration. Add other test cases for the same. (user: dan, tags: trunk)
21:00 • [714f6cbb] Support for Batch-Atomic Writes (user: drh, tags: batch-atomic-write)
20:59
[505fdc8f] Fix shell.c.in so that it aligns with shell.c. (user: drh, tags: trunk)
20:49
[deadaad2] Add test cases and fix minor error-handling issues in unionvtab.c. (user: dan, tags: trunk)
20:30
[47b80ecc] Fix duplicate test name. No changes to code. (user: mistachkin, tags: trunk)
20:28
[d49639c2] Fix another harmless compiler warning. Get the MSVC makefile working with unionvtab. (user: drh, tags: trunk)
20:22
[4d147a1e] Suppress harmless compiler warnings in union-vtab. (user: drh, tags: trunk)
20:17
[a447fdf1] Remove an unused variable from unionvtab.c. (user: dan, tags: trunk)
20:03
[5bcf0f86] Improve the readability of the unionvtab code. (user: dan, tags: trunk)
19:51
[4a6c416f] 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
[6c9128e1] Add test cases to unionvtab.test. (user: dan, tags: trunk)
18:19
[948f9504] Add the union-vtab extension - still experimental and under active development. (user: drh, tags: trunk)
17:34
[9dbae1df] 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
[d2f0b2e8] 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 [ce68383b] Incorrect LEFT JOIN result with IS operator in WHERE clause and auto-index. (user: drh)
14:41
[0b69aa7e] Change the default command-line shell history depth to 2000 lines. (user: drh, tags: trunk)
2017-07-17
21:03
[f2c4a584] Closed-Leaf: Add test cases to test/unionvtab.test. (user: dan, tags: union-vtab)
20:25
[9c3f1b9a] Enhance error detection and fix other issues in unionvtab code. (user: dan, tags: union-vtab)
20:21
[e181225d] Leaf: Merge all the latest fixes and enhancements from trunk. (user: drh, tags: apple-osx)
19:37
[cd6ac078] 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
[adc082c1] 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
[52674f94] 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)