Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
88 events for the month beginning 2015-05-01 by user dan
Following month ↑|
2015-05-30
| ||
| 11:49 | Remove the "#include sqlite3Int.h" from fts5Int.h. (check-in: e008c3c8 user: dan tags: fts5) | |
|
2015-05-29
| ||
| 19:00 | Add extra tests and fixes for multi-column matches. (check-in: ae6794ff user: dan tags: fts5) | |
| 15:55 | Add syntax to fts5 used to specify that a phrase or NEAR group should match a subset of columns. For example "[col1 col2 ...] : <phrase>". (check-in: 0fc0ea20 user: dan tags: fts5) | |
|
2015-05-28
| ||
| 19:57 | Optimizations for fts5 queries that match against a specific column. (check-in: b29ac50a user: dan tags: fts5) | |
| 14:37 | Remove some dead code from fts5. Add auxiliary function api tests to the same. (check-in: 0f9df202 user: dan tags: fts5) | |
|
2015-05-27
| ||
| 14:21 | A different approach to preventing buffer overreads when comparing a vector of values with a corrupt index record that spans at least one overflow page. (Closed-Leaf check-in: 7e9e1b61 user: dan tags: avoid-buffer-overread) | |
|
2015-05-26
| ||
| 20:31 | Avoid a buffer overread when comparing against a corrupt record that spans at least one overflow page. (check-in: 62a5b363 user: dan tags: trunk) | |
| 20:07 | Avoid branching on an uninitalized variable when comparing SQL values with the undefined serial types 10 and 11 (which only appear in corrupt databases). (check-in: b4a45d3b user: dan tags: trunk) | |
| 19:01 | Merge accidental fork. (Closed-Leaf check-in: e85628e3 user: dan tags: test-using-fuzzcheck) | |
| 18:58 | Fix a one-byte buffer overread that may follow a syntax error while preparing an SQL statement. (check-in: 07500393 user: dan tags: test-using-fuzzcheck) | |
| 18:22 | Simplifications and minor optimizations to fts5 prefix queries that cannot use a prefix index. (check-in: aef89d9f user: dan tags: fts5) | |
| 17:33 | Add a cast to one side of the test added by [97806a78] in order to avoid a signed/unsigned comparison warning. (check-in: 5b46d2a7 user: dan tags: trunk) | |
| 17:29 | Avoid using a zero-sized array within a struct in fts3 code. (check-in: b05cae36 user: dan tags: trunk) | |
| 14:57 | Update test cases in corruptI.test so that they work with both SQLITE_ENABLE_OVERSIZE_CELL_CHECK and SQLITE_DEFAULT_AUTOVACUUM builds. (check-in: 22a14663 user: dan tags: trunk) | |
| 12:18 | Return SQLITE_CORRUPT to the user if an attempt is made to add database page 1 to the free page list. (check-in: 68876003 user: dan tags: trunk) | |
| 11:53 | Fix a problem with ignoring UNIQUE constraints on WITHOUT ROWID tables rendered redundant by the PRIMARY KEY. (check-in: 3b936913 user: dan tags: trunk) | |
|
2015-05-25
| ||
| 20:04 | Fix a case of a corrupt database causing SQLite to read from up to 4 bytes before the start of a memory allocation. (check-in: 7d2c4f7b user: dan tags: trunk) | |
| 19:24 | Have the b-tree layer return SQLITE_CORRUPT to any attempt to open a cursor with a root page number less than 1. (check-in: aa18c8e9 user: dan tags: trunk) | |
| 18:47 | Fix a couple of btree asserts that would fail when encountering 32-bit rollover in cell payload size fields (cell payloads this large always indicate corruption). (check-in: 8fa0937a user: dan tags: trunk) | |
| 17:07 | Fix a case where database corruption may cause SQLite to write past the end of a buffer. (check-in: 97806a78 user: dan tags: trunk) | |
| 15:03 | Fix an assert() in btree routine freeSpace() that may be false if the database is corrupt. (check-in: 00a473c5 user: dan tags: trunk) | |
| 11:46 | Avoid redundant loads from the %_data table in the fts5 code. (check-in: 02069782 user: dan tags: fts5) | |
| 10:57 | Fix an fts4 matchinf() problem triggered by deferred tokens that are part of phrases that are part of AND expressions. (check-in: f1e942a1 user: dan tags: trunk) | |
|
2015-05-23
| ||
| 15:43 | Avoid making redundant copies of position-lists within the fts5 code. (check-in: 5165de54 user: dan tags: fts5) | |
|
2015-05-22
| ||
| 16:08 | Have r-tree prefer to use the constraint "col MATCH ?" over "rowid = ?". (check-in: b9fb9519 user: dan tags: trunk) | |
| 07:44 | Increase test coverage of fts5_vocab.c. (check-in: 065ab83a user: dan tags: fts5) | |
| 06:08 | Improve test coverage of fts5_unicode2.c. (check-in: fea8a4db user: dan tags: fts5) | |
|
2015-05-21
| ||
| 20:26 | Have r-tree prefer to use the constraint "col MATCH ?" over "rowid = ?". drh added later: All changes on this branch have been cherrypicked to trunk and will be merged into sessions from trunk. So this branch can close. (Closed-Leaf check-in: b9e45596 user: dan tags: sessions-value-dup) | |
| 17:24 | Prevent a virtual table from being destroyed while it is in use. Also: replace Vdbe.inVtabMethod with sqlite3.nVDestroy. Simplify the EXPLAIN output for P4.pVtab to only show the sqlite3_vtab pointer. Cherrypick of [cbeb9a1aed8c]. (check-in: b3bb660a user: dan tags: branch-3.8.6) | |
| 17:21 | Avoid ever writing before the start of an allocated buffer in the DIRECT_OVERFLOW_READ code. Fix for [e3a290961a6]. Cherrypick of [c3c15d20c691]. (check-in: 31b13eb5 user: dan tags: branch-3.8.6) | |
|
2015-05-20
| ||
| 20:50 | Fix a problem in test file e_reindex.test. Cherrypick of [5b3de9390f2f]. (check-in: 80633682 user: dan tags: branch-3.8.6) | |
| 20:34 | Fix a problem causing the fts3 integrity-check to fail if run inside a transaction. Cherrypick of [3b925189a75e]. (check-in: 7d7d633c user: dan tags: branch-3.8.6) | |
| 20:30 | Ensure that tables names are dequoted exactly once by the trigger and FK logic. Cherrypick of [59e92bd9521f] and [9d887b92f808]. (check-in: bd357739 user: dan tags: branch-3.8.6) | |
| 20:27 | Fix an obscure problem with "INSERT INTO tbl(cols) SELECT" statements where the SELECT is a compound with an ORDER BY and "cols" is a strict subset of tbl's columns. Cherrypick of [718d5d0eab04]. (check-in: 3cd2b772 user: dan tags: branch-3.8.6) | |
| 20:24 | Fix a potential NULL pointer deference on a corrupt database schema. Cherrypick of [dc61b292d8ea]. (check-in: 7f3943fb user: dan tags: branch-3.8.6) | |
| 20:21 | Fix a bug caused by cherrypicking from a branch that assumes sqlite3_stricmp() can handle NULL arguments. (check-in: 2c649cdf user: dan tags: branch-3.8.6) | |
| 19:57 | When parsing the schema, ignore any SQL that does not begin with "CREATE". Cherrypick of [d3c00d61581c]. (check-in: 0da229b8 user: dan tags: branch-3.8.6) | |
| 19:53 | Detect and report oversized records constructed from multiple zeroblobs. Cherrypick of [9e139afd9211]. (check-in: 4a08f6b8 user: dan tags: branch-3.8.6) | |
| 19:50 | Do not allow virtual table constructors to be called recursively. Cherrypick of [0a72726da215] (check-in: 023a29ba user: dan tags: branch-3.8.6) | |
| 19:48 | Avoid signed integer overflow when converting oversized in-line integer widths and precisions in printf(). Cherrypick of [c494171f77dc], [5ce4e7d7651e], [95625ef3adc3] and [8e4ac2ce2441]. (check-in: b330c7ff user: dan tags: branch-3.8.6) | |
| 19:44 | Ensure that comparison operators do not mess up the MEM_Dyn flag on registers when reverting affinity changes. Cherrypick of [02e3c88fbf6a]. (check-in: 4125477e user: dan tags: branch-3.8.6) | |
| 19:34 | Fix a problem causing collation sequence names to be dequoted multiple times under some circumstances. Cherrypick of [eddc05e7bb31]. (check-in: fc1a4f29 user: dan tags: branch-3.8.6) | |
| 19:32 | Silently ignore any attempt to add a prefix index for prefixes zero bytes in size to an fts3/4 table. Or any prefix index size so large that it overflows a 32-bit signed integer. Cherrypick of [ad4b19d2ac0889a2]. (check-in: ff7be4db user: dan tags: branch-3.8.6) | |
| 09:27 | Improve test coverage of fts5_tokenize.c. (check-in: 0e91a6a5 user: dan tags: fts5) | |
|
2015-05-19
| ||
| 19:44 | • Edit [f5d0ce80792d58ef|f5d0ce80]: Edit check-in comment. (artifact: 4e50b5ad user: dan) | |
| 19:44 | Ensure that when the VM applies TEXT affinity to a value it discards any existing REAL or INTEGER value. Fix for [34cd55d6]. (check-in: f5d0ce80 user: dan tags: trunk) | |
| 19:37 | Add tests for fts5 tokenizers. (check-in: 4f90ba20 user: dan tags: fts5) | |
| 17:48 | Remove the sqlite3ota_open_v2() API. Add a new parameter to sqlite3ota_open() instead. (check-in: c74e0bc4 user: dan tags: trunk) | |
| 16:50 | Merge the ota-update branch with trunk. (check-in: 08e2864e user: dan tags: trunk) | |
| 16:26 | Add a comment for SQLITE_FCNTL_OTA to sqlite.h.in. (Closed-Leaf check-in: efa20f8e user: dan tags: ota-update) | |
| 16:22 | Allow OTA update state data to be stored in a database separate from the OTA update database. (check-in: 5af8db56 user: dan tags: ota-update) | |
| 14:14 | Merge latest trunk changes with this branch. (check-in: 6055a672 user: dan tags: ota-update) | |
| 11:38 | Update Makefile.in so that the amalgamation files built by "make sqlite3.c" include fts5. (check-in: 2870a805 user: dan tags: fts5) | |
| 11:32 | Fix a memory leak that could follow an OOM condition in fts5. (check-in: de9f8ef6 user: dan tags: fts5) | |
|
2015-05-18
| ||
| 20:34 | Improve test coverage of fts5_storage.c. (check-in: 4dfe2e58 user: dan tags: fts5) | |
| 18:24 | Fix a bug in test script fts5fault4.test. (check-in: a5080593 user: dan tags: fts5) | |
| 18:03 | Add a test for an untested branch in fts5_expr.c. (check-in: ce08206b user: dan tags: fts5) | |
| 17:50 | Improve test coverage of fts5_config.c. (check-in: 47dbfadb user: dan tags: fts5) | |
|
2015-05-16
| ||
| 20:04 | Further test coverage improvements for fts5. (check-in: 927d9a64 user: dan tags: fts5) | |
|
2015-05-15
| ||
| 19:59 | Do not assume that "col IS ?" matches at most a single row of a UNIQUE column unless the column is also NOT NULL. (check-in: e038ce89 user: dan tags: trunk) | |
| 18:13 | Improve test coverage of fts5_index.c. (check-in: 7aea8c6d user: dan tags: fts5) | |
| 12:18 | Add test cases. And some fixes. (check-in: adee7885 user: dan tags: fts5) | |
|
2015-05-14
| ||
| 09:53 | Merge changes from the index-is-operator branch into this one. Drop the partial support added for IS on this branch by [52e73eec]. (check-in: 16ab9caf user: dan tags: ota-update) | |
| 08:58 | Merge latest trunk changes with this branch. (check-in: 299ed55c user: dan tags: ota-update) | |
|
2015-05-13
| ||
| 18:12 | Merge latest trunk changes with this branch. (check-in: b5f0e8c5 user: dan tags: fts5) | |
| 17:15 | Change fts5 doclist-index structures to be trees instead of flat lists. This only makes a difference for databases that contain millions of instances of the same token. (check-in: aa34bf66 user: dan tags: fts5) | |
|
2015-05-11
| ||
| 19:01 | Add new fts3 matchinfo option 'b'. Also optimize existing option 'y'. (check-in: 2e7679a1 user: dan tags: trunk) | |
| 18:46 | Merge latest trunk changes into this branch. (Closed-Leaf check-in: 82e5a6e0 user: dan tags: fts3-matchinfo-y) | |
| 06:22 | Change autoconf/Makefile.am to avoid building target sqlite3.o as part of both the shared library and shell tool. Doing so causes problems for parallel builds. (check-in: 85bfa9a6 user: dan tags: trunk) | |
|
2015-05-09
| ||
| 18:28 | Allow the fts5vocab table to optionally provide data on a per-column basis. (check-in: 39222761 user: dan tags: fts5) | |
|
2015-05-08
| ||
| 20:21 | Add the fts5vocab module, for direct access to the fts5 index. (check-in: 6bf93e3b user: dan tags: fts5) | |
| 09:21 | Improve the error message returned by FTS5 if it encounters an unknown file format. (check-in: f369caec user: dan tags: fts5) | |
|
2015-05-07
| ||
| 19:29 | Change to storing all keys in a single merge-tree structure instead of one main structure and a separate one for each prefix index. This is a file-format change. Also introduce a mechanism for managing file-format changes. (check-in: a684b5e2 user: dan tags: fts5) | |
|
2015-05-06
| ||
| 18:15 | Merge latest trunk changes with this branch. (check-in: 8a13e1fd user: dan tags: fts3-matchinfo-y) | |
| 17:51 | Remove some dead code from fts3_snippet.c. (check-in: 46b2d3ce user: dan tags: fts3-matchinfo-y) | |
| 17:41 | More optimization for the 'y' and 'b' matchinfo directives. (check-in: 8c5b9fed user: dan tags: fts3-matchinfo-y) | |
| 14:18 | Have the autoconf package build the shell tool with SQLite linked in statically. (check-in: 31834c3a user: dan tags: trunk) | |
| 08:43 | Further optimizations for the 'y' and 'b' matchinfo operators. (check-in: fbd038bb user: dan tags: fts3-matchinfo-y) | |
|
2015-05-05
| ||
| 20:39 | Add the fts3 matchinfo 'b' flag. (check-in: b9b77972 user: dan tags: fts3-matchinfo-y) | |
| 19:37 | Optimizations for the matchinfo() function, particularly the 'y' flag. (check-in: dddd7e18 user: dan tags: fts3-matchinfo-y) | |
| 10:03 | Fix a faulty assert() in the btree part of the "PRAGMA page_size = ?" code. (check-in: 90b19748 user: dan tags: trunk) | |
|
2015-05-04
| ||
| 12:29 | Add the 'y' flag to the fts3/4 matchinfo() function. (check-in: aef1e8f4 user: dan tags: trunk) | |
|
2015-05-02
| ||
| 20:35 | Reorganize some of the fts5 expression parsing code. Improve test coverage of the same. (check-in: c4456dc5 user: dan tags: fts5) | |
| 12:40 | Reorganize some multi-threaded code in vdbesort.c so that full MC/DC test coverage does not depend on the outcome of a race condition. (check-in: 78c7ec95 user: dan tags: trunk) | |
| 09:44 | Add the experimental matchinfo 'y' flag to fts3/4. (Closed-Leaf check-in: 92941609 user: dan tags: fts3-matchinfo-y) | |
|
2015-05-01
| ||
| 20:38 | Further improvements to test coverage of fts5 code. (check-in: d4331943 user: dan tags: fts5) | |
| 16:57 | Fix an assert() failure caused by setting "PRAGMA journal_mode=off" on an database in exclusive-mode that has already opened the journal file. (check-in: 40db3e40 user: dan tags: trunk) | |
| 12:14 | Improve test coverage of fts5.c. (check-in: add4f468 user: dan tags: fts5) | |