/ Timeline
Login

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

100 most recent check-ins that include changes to files matching 'ext/*'

2020-01-17
21:12
The compress() function should not be deterministic since the same input can have multiple possible compressed outputs. The uncompress() function, on the other hand, is deterministic. check-in: 84f31490 user: drh tags: trunk
14:30
Import the 3.31.0-beta FTS3/4 code directly into the 3.28 branch, thus providing 3.28 with all the latest 3.31 fixes. FTS3 has not been enhanced to use any core functionality that was not already available in 3.23, so no modifications were made to FTS3 sources for this import. check-in: be4269c6 user: drh tags: branch-3.28
14:18
Import all FTS3/4 enhancements and fixes that exist on the latest trunk (3.31.0-beta) that do not require extensive change to the SQLite core into the 3.22 branch. Basically, the 3.31.0 FTS3 sources are copied into 3.22.0, with minor changes to work around core enhancements that are not available in 3.22.0. Leaf check-in: cbcbb1e5 user: drh tags: branch-3.22
2020-01-15
14:26
Merge all recent enhancements and fixes from trunk. check-in: f7839178 user: drh tags: reuse-schema
14:21
Merge in the latest trunk changes via the begin-concurrent-pnu branch. Leaf check-in: 350627f3 user: drh tags: begin-concurrent-pnu-wal2
14:11
Merge recent enhancements and fixes from trunk. Leaf check-in: 35eae71a user: drh tags: wal2
13:48
Merge all recent enhancements and fixes from trunk. Leaf check-in: 110a081f user: drh tags: begin-concurrent-pnu
13:34
Merge fixes and enhancements from trunk into begin-concurrent. Leaf check-in: 95ba2f50 user: drh tags: begin-concurrent
12:49
Merge all recent enhancements and fixes from trunk into the apple-osx branch. Leaf check-in: dadedf41 user: drh tags: apple-osx
2020-01-14
16:50
Fix the urifuncs.c extension (used for testing and debugging only) so that the sqlite3_filename_database() SQL function and its siblings correctly handle an invalid schema name passed in as the argument. check-in: 3d7434a9 user: drh tags: trunk
16:33
Add the new noop_nd() debugging function to the noop.c extension. check-in: 72911fb1 user: drh tags: trunk
2020-01-12
22:25
Change the zipfile virtual table so that the xBestIndex method gives a reasonable cost estimate even if no filename is specified. The missing filename error continues to be raised in the xFilter method. Meanwhile, the more reasonable cost estimate avoids unnecessary wierdness in the query planner. check-in: 0e468aa6 user: drh tags: trunk
2020-01-11
21:08
New apis: sqlite3_filename_database(), sqlite3_filename_journal(), and sqlite3_filename_wal(). Also sqlite3_uri_key(). And the other sqlite3_uri functions now work using the journal or wal filename in addition to the database file. And the sqlite3_db_filename() result is guaranteed to work as an argument to the sqlite3_uri functions. check-in: fd7bcc53 user: drh tags: trunk
16:08
Redesign for better legacy compatibility. Add the sqlite3_uri_key() interface. check-in: bcb43d11 user: drh tags: enhanced-uri
2020-01-09
23:07
Fix the fossildelta.c extension so that it will compile on mingw. check-in: 20237d5d user: drh tags: trunk
20:44
Merge in the untrusted-schema enhancements. See doc/trusted-schema.md for details. check-in: 5720924c user: drh tags: trunk
20:33
Only register the fts3_tokenizer() function using a single text encoding. check-in: 966964af user: drh tags: trunk
2020-01-08
15:43
Fix the rot13.c extension to be deterministic. Add the noop.c extension. check-in: a679122c user: drh tags: new-security-options
2020-01-07
19:45
Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set the risk rank for many virtual tables. check-in: 4c21373c user: drh tags: new-security-options
15:44
Merge recent fixes from trunk. check-in: 5dfa33a0 user: drh tags: new-security-options
14:51
Provide the ability to tag an application-defined function as "testonly". Leaf check-in: e6f5c0e0 user: drh tags: testonly-functions
09:06
Fix an instance of an undefined behaviour (a left-shift of a 64-bit unsigned integer by a value greater than 64) that could occur in fts3. check-in: e1f12978 user: dan tags: trunk
2020-01-04
15:37
Merge the latest fixes from trunk. check-in: 26ef709a user: drh tags: new-security-options
01:43
Enhance PRAGMA function_list so that it shows all instances of each FuncDef, the number of arguments, the encoding, the type, and the flags. Use this capability to locate and fix incorrect function flags in the standard build. check-in: 9ca906d2 user: drh tags: new-security-options
2020-01-03
20:16
In fts3, avoid making a very large memory allocation if the merge-hint record is corrupt. check-in: 9add58fe user: dan tags: trunk
16:38
Improvement to check-in [7405e98225761180] so that missing or null filenames given to the zipfile extension throw an immediate error. check-in: 523e09bd user: drh tags: trunk
2020-01-02
23:50
Merge enhancements from trunk. check-in: 091403a6 user: drh tags: new-security-options
21:41
Merge the latest enhancements from trunk. check-in: bd57e6d9 user: drh tags: two-size-lookaside
21:30
Do not allow the zipfile virtual table to start a transaction if no filename has been specified. check-in: 7405e982 user: drh tags: trunk
16:24
Handle blobs that are the return values of functions being cast to text in utf16 databases in the same way as blobs read directly from the database. Fix for [771fe617]. check-in: e782096a user: dan tags: trunk
2019-12-31
18:12
Set the SQLITE_DIRECTONLY flag on the fts3_tokenizer() function of FTS3, thus preventing that function from being called from within a trigger or view. check-in: f3171dc2 user: drh tags: trunk
14:49
Merge recent enhancements from trunk. check-in: 39d55579 user: drh tags: two-size-lookaside
2019-12-30
14:32
Do not use HIDDEN columns for NATURAL joins. Fix for [7c0e06b16]. check-in: ab09ef42 user: dan tags: trunk
2019-12-27
00:19
Fix buffer underflows in the zipfile extension associated with zero-length or NULL filename in the ZIP archive. But report on the mailing list by Yongheng and Rui. check-in: 465a15c5 user: drh tags: trunk
2019-12-26
14:36
Fix an assert() in fts5 that could fail if an xSavepoint() call on another vtab fails. Fix for [167b2aac] . check-in: a5d7f5d2 user: dan tags: trunk
2019-12-24
20:51
Fix a problem causing fts5 integrity-check failures if numeric values are inserted into a table within a utf-16 database. Fix for [752fdbf6]. check-in: bae060f3 user: dan tags: trunk
18:53
Make the zipfile() extension function more robust against zero-length filenames. check-in: b9c2005f user: drh tags: trunk
16:20
Fix another case where malformed utf-8 was being mishandled in fts5. Fix for [df46a6f3]. check-in: 1c0a05b0 user: dan tags: trunk
15:35
Fix an assert() added as part of commit [a11b393dc] that can fail if fts5 database records are corrupt. check-in: 4630c1ec user: dan tags: trunk
14:27
Fix a spurious report of corruption that could be made by the fts5 integrity-check in SQLITE_DEBUG builds if the fts5 index contains malformed utf text. Ticket [d62981b76de521e3] check-in: a11b393d user: dan tags: trunk
2019-12-23
21:04
Fix the zipfile() function in the zipfile extension so that it is able to deal with goofy filenames that contain embedded zeros. check-in: cc0fb00a user: drh tags: trunk
20:41
Thoroughly reset the rtree cursor at the start of each VFilter operation, including clearing its cache. This prevents left over pages in the cache which can cause problems on shutdown after a LEFT JOIN. Ticket [5eadca17c4dde90c] check-in: 4c50afaf user: drh tags: trunk
20:07
Remove an extra deflateInit2() call accidently left in check-in [f5ee30426e8876e7] check-in: 953e6aa6 user: drh tags: trunk
2019-12-22
14:29
Fix "PRAGMA data_version" so that it works the same way with locking_mode=PERSIST and journal_mode=PERSIST configured. Fix for 7a458c2a5f. check-in: 45748e2d user: dan tags: trunk
2019-12-21
20:43
Fix a spurious report of corruption from the fts3/4 integrity-check triggered by using the languageid option. check-in: 70815e27 user: dan tags: trunk
2019-12-20
20:03
Fix a bad interaction between RBU and [df51ae19]. check-in: 0b9d8a12 user: dan tags: trunk
19:41
Fix two more cases in fts5 where sqlite3_value_bytes() was being called before sqlite3_value_text(). Fix for e431c355. check-in: a1ba9a37 user: dan tags: trunk
14:08
Fix harmless compiler warnings. check-in: 2bbd014c user: drh tags: trunk
13:24
Ensure fts5 consistently calls sqlite3_value_text() before sqlite3_value_bytes(). This matters when storing blobs in fts5 tables within utf-16 databases. Fix for [cf36cb4e02]. check-in: c16305eb user: dan tags: trunk
2019-12-19
21:11
Fix the regexp extension so that it correctly translates all over-length 3-byte UTF8 sequences into 0xfffd. check-in: 3d4c0bf8 user: drh tags: trunk
15:15
Fix the zipfile extension so that INSERT works even if the pathname of the file being inserted is a NULL. Bug discovered by the Yongheng and Rui fuzzer. check-in: a80f84b5 user: drh tags: trunk
2019-12-14
14:15
Fix problems in fts3 with processing corrupt records and undefined integer overflows. check-in: 3b873029 user: dan tags: trunk
2019-12-10
03:40
Avoid a buffer overread in fts5 that could occur when parsing corrupt configuration records. check-in: 355afd77 user: dan tags: trunk
2019-12-09
02:20
Fix possible null pointer dereferences in the fts5_expr() scalar function. check-in: c5d44143 user: dan tags: trunk
2019-12-07
12:13
Ignore type affinity for auxiliary columns in RTREE as it is too error-prone to try to parse out the type from other constraints. Ticket [8bf76328ac940d52] check-in: 7fa664ea user: drh tags: trunk
2019-12-06
19:07
Early detection and reporting of too few columns in an rtree CREATE VIRTUAL TABLE statement. check-in: ef73107f user: drh tags: trunk
13:10
In the rtree extension, actively suppress extra tokens on the column names, and be pedantic about column affinities. Ticket [367a86e28859f1ff] check-in: 97fb5a72 user: drh tags: trunk
01:38
Further enhancements to RTREE, following up to check-in [f898d04cf272ef01] so that constraints are allowed to be compared to strings that look like numbers. Ticket [aa573a787b8f1fdf] check-in: 32772dfd user: drh tags: trunk
2019-12-05
21:46
Fix to the rowvalue logic that avoids disabling rowvalue inequality contraints on a virtual table when the virtual table sets the omit flag. The logic has been incorrect since row-values were added. However, this does not come up often as very few virtual tables implement inequality constraints using the omit flag. Ticket [f096d191b6641daa] check-in: b7810062 user: drh tags: trunk
14:42
Make sure the rowid of an RTREE virtual table has integer affinity. Ticket [9fe487ba3c064b4e] check-in: 7ae8c0d5 user: drh tags: trunk
13:34
Be strict about type enforcement on rowid look-ups in the RTREE extension. Ticket [30e2c183b6b356e4] check-in: d43e0efb user: drh tags: trunk
00:44
Enhance the RTREE extension so that it give correct query results even if the query uses non-numeric constraints. Ticket [a55ab6d97d01ecbc] check-in: f898d04c user: drh tags: trunk
2019-12-04
03:46
Fix a buffer overread that could occur in fts3 with corrupt %_stat records. check-in: e01fdbf9 user: dan tags: trunk
2019-12-03
03:31
Avoid a harmless zero offset of a null pointer in FTS3, so as to not provoke unnecessary warnings from run-time checkers. check-in: 85d95abe user: drh tags: trunk
2019-11-26
14:24
Fix various documentation typos suggested by Mark Benningfield. No changes to code. check-in: 08f09dc4 user: drh tags: trunk
11:10
Fix to check-in [5d9a369301a65f32] so that it compiles without SQLITE_DEBUG. check-in: fefe2d04 user: drh tags: trunk
02:03
Fix an assert() in fts3 that could fail due to corrupt database records. check-in: 5d9a3693 user: dan tags: trunk
2019-11-23
08:51
Enhance the path arguments in JSON functions to access "#-N" array indexes. check-in: ffeec62c user: drh tags: trunk
08:36
Fix a memory leak in fts5 error handling code. check-in: de6637e1 user: dan tags: trunk
2019-11-22
17:37
Extend the json-path mechanism with array indexes of the form "#" or "#-n" for some positive number "n", to reference the end of an array. Closed-Leaf check-in: 35ed68a6 user: drh tags: json-path-enhancement
2019-11-21
14:20
Prevent direct and indirect recursive content= options in fts3/4 and fts5. check-in: 2eb99732 user: dan tags: trunk
2019-11-20
13:31
Further improve detection of corrupt records in fts3. Also fix an error with check-in [dfcf081d842629a0] check-in: a0f6d526 user: dan tags: trunk
12:07
Changes to extensions and test logic so that the build works with gcc and with -std=iso9899:1999 check-in: 2575a68c user: drh tags: trunk
2019-11-18
14:04
Improvements to detection of corruption in the %_stat shadow table of FTS4. check-in: 6b67eba5 user: drh tags: trunk
12:04
Further improvements to shadow table corruption detection in FTS3. check-in: e35d8c76 user: drh tags: trunk
11:14
Detect and prevent infinite recursion in fts3SelectLeaf() due to a malformed FTS3 btree. check-in: dfcf081d user: drh tags: trunk
10:37
Improved detection of corruption in the %_stat table of FTS4. Chromium ticket 1025467. check-in: 10f8a3b7 user: drh tags: trunk
2019-11-17
02:41
Better detection of corruption in the %_stat and %_docsize shadow tables of FTS3. check-in: 1e449687 user: drh tags: trunk
00:08
Remove a reachable NEVER() in FTS3. check-in: 8bd75bf6 user: drh tags: trunk
2019-11-16
23:47
More improvements to shadow table corruption detection in FTS3. check-in: 51525f9c user: drh tags: trunk
21:40
Improved detection of corrupt shadow tables in FTS3. Enable the debugging special-inserts for FTS3 for both SQLITE_DEBUG and SQLITE_TEST. check-in: 04b2873b user: drh tags: trunk
2019-11-15
02:52
Merge the version 3.30.1 changes into the apple-osx branch. check-in: 2c8af352 user: drh tags: apple-osx
2019-11-14
15:21
Merge recent enhancements from trunk. check-in: b8a631fd user: drh tags: hard-heap-limit
2019-11-13
18:50
Add header guard to the expert extension. check-in: 7e315185 user: mistachkin tags: trunk
2019-11-10
11:09
Proper surrogate pair decoding added to JSON functions. See the mailing list bug report and https://bugs.python.org/issue38749. More test cases needed here, but it seems to work so far. check-in: 51027f08 user: drh tags: trunk
2019-11-01
13:37
Fix an fts3 assert() that could fail when operating on a database containing corrupt records. check-in: 7c52f547 user: dan tags: trunk
2019-10-30
18:50
Always disallow the use of non-deterministic functions in CHECK constraints, even date/time functions that use the 'now' or similar keywords. Provide improved error messages when this requirement is not met. Ticket [830277d9db6c3ba1] check-in: 2978b65e user: drh tags: trunk
2019-10-28
13:54
Fix a problem in fts3 causing it to report corruption if a doclist contains consectutive rowid entries that differ by more than 2^63. check-in: 0b0a3048 user: dan tags: trunk
2019-10-24
23:43
Merge fixes from trunk. Closed-Leaf check-in: 4ec57d88 user: drh tags: generated-columns
20:35
In fts5, fix a case of overreading a buffer by 1 byte when counting characters in malformed utf-8. Fix for [dd1f67bf]. check-in: 8d964e1c user: dan tags: trunk
2019-10-23
21:00
Add an experimental set of UUID processing functions as the uuid.c extension in ext/misc/uuid.c. check-in: 1a6e0093 user: drh tags: trunk
2019-10-22
12:02
Merge changes on trunk into the generated-columns branch. check-in: ba123b8c user: drh tags: generated-columns
2019-10-20
08:26
Fix a resource leak in fts5 that could occur if an auxiliary function is called from within a query that does not use the full-text index. check-in: b528bdcd user: dan tags: trunk
2019-10-18
17:47
Merge trunk enhancements into the generated-columns branch. check-in: 85bc4524 user: drh tags: generated-columns
2019-10-17
15:41
Avoid an infinite loop in fts3/4 incremental-merge in the case where the lowest level in the database contains segments but no data (because there is a delete-marker for each valid entry). Fix for [bf1aab89]. check-in: 35beaee0 user: dan tags: trunk
2019-10-14
15:15
Fix a problem with row-value IN(...) operators and virtual tables. check-in: aa57d7ab user: dan tags: trunk
2019-10-11
18:55
Update the zipfile extension to use deflateBound(), instead of compressBound(), to learn the maximum possible size of a deflate()d buffer. check-in: f5ee3042 user: dan tags: trunk
15:33
Ensure fts3/4 prefix indexes are flushed to disk before an 'optimize' command. Fix for [745f1abc]. check-in: 4ed905b1 user: dan tags: trunk
14:27
Fix the fts3/4 integrity-check command so that it works with "ORDER=DESC" tables. Fix for [8a6fa2bb]. check-in: 5863546d user: dan tags: trunk
11:21
Merge the 3.30.1 changes into reuse-schema. Leaf check-in: eff7cd7f user: drh tags: reuse-schema-3.30