/ Timeline
Login

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

50 check-ins occurring around 61fdfc57b9539cb6.

2019-03-05
14:47
New dbfuzz2 test cases added to test/fuzzdata7.db check-in: 25975e1fb2 user: drh tags: trunk
14:39
If the initial byte of a record is a large value, then always used the generalized record comparison routine sqlite3VdbeRecordCompare() rather than one of the specialized versions that are optimized for shorter records. check-in: c1ac00706b user: drh tags: trunk
2019-03-04
21:08
Merge trunk changes into this branch. check-in: 9b4d561f68 user: dan tags: window-functions
21:07
Support some "ROWS BETWEEN N PRECEDING AND M FOLLOWING" window functions without caching entire partitions. check-in: e7a91f1228 user: dan tags: window-functions
07:25
Merge latest trunk changes into this branch. check-in: 97a9604d85 user: dan tags: reuse-schema
07:15
Fix a problem preventing compilation with SQLITE_OMIT_UTF16. check-in: 906d1fd865 user: dan tags: trunk
2019-03-02
20:09
Improved comments on the fossildelta.c extension. check-in: d7d23f0450 user: drh tags: trunk
15:25
Fix the SQLITE_DIRECT_OVERFLOW_READ compile-time option so that it works with SQLITE_HAS_CODEC. check-in: fd085e9260 user: drh tags: trunk
12:17
Remove a redundant parameter extraction call from the percentile.c extension. check-in: d49c32e6e7 user: drh tags: trunk
2019-03-01
21:37
Merge recent changes from trunk. check-in: f270245a7b user: drh tags: apple-osx
21:33
The fts3_tokenizer() function returns NULL if the SQLITE_DBCONFIG_ENABLE_FTS_TOKENIZER setting is disabled, which is is by default. check-in: f5732f4caf user: drh tags: trunk
21:12
Fix a minor comment typo. No code changes. check-in: 9a0a93c89d user: drh tags: trunk
18:27
Merge the latest enhancements from trunk. check-in: e64ded7b04 user: drh tags: apple-osx
18:07
In a query that uses a partial index, the expression that is the WHERE clause of the partial index must always be true. Use this fact to avoid evaluating identical terms in the WHERE clause of the query. check-in: 9b2879629c user: drh tags: trunk
2019-02-28
20:10
Add the ".parameter" command to the CLI. check-in: 1f9fa58541 user: drh tags: trunk
17:29
Add the new "bind_fallback" method to the "sqlite3" object in the TCL interface. check-in: c7f70b6d96 user: drh tags: trunk
14:09
New test case loaded into test/fuzzdata8.db. check-in: 00ae0c6c48 user: drh tags: trunk
13:41
Avoid an assert() failure and an undefined left-shift operation in the fts3 snippet() function that could occur if the database was corrupt. check-in: d5250db632 user: dan tags: trunk
13:21
Add an "|| CORRUPT_DB" term to an assert() statement in the btree defragmenter. check-in: 6bfd8655f0 user: drh tags: trunk
2019-02-27
23:05
Enable the LIKE optimization when the ESCAPE keyword is present and the PRAGMA case_sensitive_like pragma is ON. check-in: 6ae4b8c525 user: drh tags: trunk
19:59
Fix the readfile() UDF so that it returns an empty BLOB, not an OOM error, when reading an empty file. check-in: 0edad5339e user: drh tags: trunk
16:38
Add the "-returntype" option to the "db function" Tcl method. check-in: 789a492b68 user: dan tags: trunk
15:26
Verify that fts5 auxiliary functions cannot be used in aggregate queries. check-in: 122330dba3 user: dan tags: trunk
2019-02-26
19:16
Reformat the white-space in a few test cases so that the tests work with Tcl 8.6.9. check-in: 29d02bf2fa user: dan tags: trunk
18:21
Minor change to dbfuzz2 that allows it to be compiled against older versions of SQLite. check-in: 6d39d6a68b user: drh tags: trunk
17:52
New test cases added to test/fuzzdata8.db. check-in: 61fdfc57b9 user: drh tags: trunk
17:49
Allocate a few extra bytes for the pager temp page as an overrun buffer while processing corrupt database files. check-in: e7aca0714b user: drh tags: trunk
16:36
Update doc/shared_schema.md to describe the shell tool ".shared-schema" dot-command. check-in: 0ce2092a59 user: dan tags: reuse-schema
16:17
Use unsigned integers to count the number of pages in a freelist during an integrity_check, to avoid any possibility of a signed integer overflow. check-in: 05b87e0755 user: drh tags: trunk
16:13
Add new test file reuse5.test. For testing the shell tool ".shared-schema" command. check-in: fa6008d547 user: dan tags: reuse-schema
16:11
Fix a harmless compiler warning that only comes up during debug builds. check-in: 848869ced9 user: drh tags: trunk
15:43
Add the ".shared-schema check|fix DB1 DB2..." command to the shell tool. For checking if a database is eligible to share an in-memory with the main database, and for fixing small problems that prevent it from being so. check-in: 7d8e8a9572 user: dan tags: reuse-schema
12:29
Update the configure-generated makekfile to generate a portable pkgIndex.tcl. check-in: 35cbee7fe4 user: drh tags: trunk
2019-02-25
19:23
Fix a comment in build.c. check-in: d6a9bff6f5 user: dan tags: reuse-schema
18:43
Enhance the command-line shell to accept bound parameters, using the TEMP table named "$Parameters" to look up the values for bound parameters. check-in: 7c941ce5bc user: drh tags: trunk
18:07
Merge latest trunk changes into this branch. check-in: 5c1cf30859 user: dan tags: reuse-schema
17:54
Where possible, avoid loading all schemas into memory for PRAGMA statements. check-in: 64f97530ad user: dan tags: reuse-schema
16:06
Version 3.27.2 check-in: bd49a8271d user: drh tags: release, branch-3.27, version-3.27.2
15:55
Internally, remove all references to a Window object that belongs to an expression in an ORDER BY clause if that expression is converted to an alias of a result-set expression. check-in: a21ffcd817 user: drh tags: branch-3.27
15:43
This was originally intended to be the 3.27.2 release, but then I realized that I left out an important patch. Closed-Leaf check-in: 6c5e5e2ee0 user: drh tags: mistake
14:52
Update comments on the fossildelta extension. No changes to code. check-in: 9da4fb59b2 user: drh tags: trunk
14:25
Fix a typo in the documentation for sqlite3_total_changes(). check-in: 4febdfb37b user: drh tags: branch-3.27
14:16
Fix a typo in the documentation for sqlite3_total_changes(). check-in: 8474c1560e user: drh tags: trunk
2019-02-23
20:48
Fix a couple of assert() statements in fts3 that can be false if the database is corrupt. check-in: 84162af521 user: dan tags: trunk
00:56
Import from trunk the new fix to ticket [df46dfb631f75694] in which all ephemeral tables used as the RHS of an IN operator be index btrees and never table btrees so that they can always be reused. check-in: 0e64ac122a user: drh tags: branch-3.27
00:21
Check-in [fa792714ae62fa98] is incorrect. Add a test case to refute it and also a fix to make it right. Then add an alternative fix to ticket [df46dfb631f75694] in which all ephemeral tables used as the RHS of an IN operator be index btrees and never table btrees so that they can always be reused. check-in: d3915230e3 user: drh tags: trunk
00:08
Remove a testcase() macro which is now unreachable due to the contraction of the use of IN_INDEX_ROWID. Closed-Leaf check-in: 90c5a17cd5 user: drh tags: tkt-df46dfb631
2019-02-22
23:29
Make all ephemeral tables built to hold the RHS of an IN operator be index-btrees, never table-btrees, regardless of whether or not they are used as IN_INDEX_LOOP or IN_INDEX_MEMBERSHIP. That way, the same ephmerial table can be reused for both cases. check-in: c2d50df8fd user: drh tags: tkt-df46dfb631
21:33
Check-in [fa792714ae62fa980] is not a valid fix for ticket [df46dfb631f75694], as the new test case in this check-in demonstrates. The fix here causes test cases for the [df46dfb631f75694] bug to fail again, so this check-in is on a branch. A new fix is needed for [df46dfb631f75694]. check-in: 0d456456da user: drh tags: tkt-df46dfb631
19:24
Internally, remove all references to a Window object that belongs to an expression in an ORDER BY clause if that expression is converted to an alias of a result-set expression. Fix for [4feb3159c6]. check-in: 579b66eaa0 user: dan tags: trunk