Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around c9c2ab54ba.
|
2024-08-20
| ||
| 14:12 | When the database encoding is UTF-16LE and the GLOB optimization is used, it is ok to use the range search over an index, but it is not ok to disable the actual GLOB function call. (check-in: 3399698376 user: drh tags: trunk) | |
| 12:15 | The LIKE/GLOB optimization restricts its attention to the pattern prefix that is all ASCII. (check-in: 5815f13263 user: drh tags: branch-3.46) | |
| 12:09 | Fix for the UTF-16LE problem reporte by forum post dc7e1b7527e84343. Because of the unexpected ordering of characters using the default collation (memcmp() order) in UTF-16LE, the LIKE/GLOB optimization restricts its attention to the pattern prefix that is all ASCII, which is the common case. (check-in: a5797ebdea user: drh tags: trunk) | |
|
2024-08-19
| ||
| 23:43 | Earlier error detection while processing complex aggregate queries. dbsqlfuzz 5242c2f07f4aa031aa3c80461f18e9b7619ede9b (check-in: 70f4973078 user: drh tags: trunk) | |
| 22:48 | Refactor the SrcItem object so that information about subqueries is stored in a separately allocated Subquery object. This reduces the memory requirements for SrcItem and makes the code run faster. It also provides an expansion path for subquery processing that does not burden simple queries. The current checking mostly works, but there are still issues that need to be tracked down and fixed. (check-in: 8ff5dda844 user: drh tags: srcitem-opt) | |
| 20:35 | Update some comments that are processed into the fts5.html webpage. (check-in: 3e06ab218b user: dan tags: trunk) | |
| 14:33 | Add the fts5_locale() function and related functionality to fts5. (check-in: b963290010 user: dan tags: trunk) | |
| 14:23 | Fix leap-year handling for dates prior to 0400-03-01. (check-in: 6767bf1c67 user: drh tags: branch-3.46) | |
| 14:20 | Fix leap-year handling for dates prior to 0400-03-01. Forum post eaa0a09786c6368b. (check-in: 474b7e34b8 user: drh tags: trunk) | |
| 13:53 | New date/time test cases to validate ancient dates. (Closed-Leaf check-in: 82719074f0 user: drh tags: ancient-date-fix) | |
| 12:54 | Attempt to fix date/time calculations for days earlier than 0400-03-01. See forum thread eaa0a09786c6368b. (check-in: 00cae11fff user: drh tags: ancient-date-fix) | |
| 10:40 | Merge trunk changes into this branch. (Closed-Leaf check-in: 6787603bd0 user: dan tags: fts5-locale) | |
|
2024-08-18
| ||
| 14:46 | Fix a problem with detail=none, content='' tables. (check-in: 4b8070816a user: dan tags: fts5-locale) | |
| 09:53 | Automatically disable directory fsync when compiling for AIX. (check-in: 8d170e07e2 user: drh tags: trunk) | |
|
2024-08-17
| ||
| 23:23 | Give unique names to fields in the SrcItem object, to facilitate analysis of how those fields are used using "grep". (check-in: 9f5aeef3cb user: drh tags: srcitem-opt) | |
| 19:46 | Reduce the size of the SrcItem object by combining fields into a union. (check-in: a4c59ac3c6 user: drh tags: srcitem-opt) | |
| 19:40 | Fix a broken assert() in fts5_storage.c. (check-in: 01116e3279 user: dan tags: fts5-locale) | |
| 19:11 | Merge trunk changes into this branch. (check-in: 6a8ff9ba5e user: dan tags: fts5-locale) | |
| 19:07 | Tests to improve coverage of fts5_expr.c. (check-in: f4b839e526 user: dan tags: fts5-locale) | |
| 17:22 | Add tests to restore coverage of fts5_tokenizer.c. (check-in: 8f9257361b user: dan tags: fts5-locale) | |
| 16:17 | Adjust Makefile.in so that it outputs a slightly better error message on an attempt to build something that requires TCL libraries when HAVE_TCL is false. (check-in: a4043cbeb8 user: drh tags: trunk) | |
| 15:52 | Adjust the "configure" script so that it just disables the ability to run tests rather than erroring out if tclsh is unable to recommend a suitable tclConfig.sh. (check-in: 793ff83d09 user: drh tags: trunk) | |
| 14:59 | Fix a typo in an "ifdef" that broke SQLITE_OMIT_ANALYZE builds. (check-in: c09da26cb6 user: dan tags: trunk) | |
|
2024-08-16
| ||
| 19:05 | Add tests to restore coverage of fts5_config.c. (check-in: 9d971b31df user: dan tags: fts5-locale) | |
| 19:04 | Merge all the latest trunk enhancements, and especially the order-by-subquery optimization, into the bedrock branch, via wal2. (check-in: d0591db3bb user: drh tags: bedrock) | |
| 18:58 | Merge the latest trunk enhancements into the wal2 branch. (check-in: a78208b597 user: drh tags: wal2) | |
| 18:51 | If a subquery has an ORDER BY clause and that ordering is helpful in satisfying the ORDER BY or GROUP BY of the outer query without doing an extra sort, then omit or reduce the sort in the outer query. Call this the "order-by-subquery optimization". (check-in: 7a0cdc7edb user: drh tags: trunk) | |
| 17:54 | Add tests to restore coverage of fts5_storage.c. (check-in: 38841881a0 user: dan tags: fts5-locale) | |
| 16:20 | Add tests to restore coverage of fts5_main.c. (check-in: 681edd08ab user: dan tags: fts5-locale) | |
| 15:35 | Ensure that memory allocations in ANALYZE are always 8-byte aligned in order to satisfy a new assert() added by [539e4f661767ef90]. (check-in: a1915cbdec user: drh tags: trunk) | |
| 11:26 | Fix handling of COLLATE. Add test cases for the same. Code cleanup for improved understandability and maintainability. (Closed-Leaf check-in: 41a41c173a user: drh tags: order-by-subquery) | |
| 02:19 | Bug fix in the subquery ORDER BY propagator. (check-in: 5a9a3b8af7 user: drh tags: order-by-subquery) | |
| 00:37 | Improvements to the subquery ORDER BY decision algorithm. Fewer false-negatives. (check-in: b82421e3f5 user: drh tags: order-by-subquery) | |
|
2024-08-15
| ||
| 23:38 | If a subquery is materialized due to an ORDER BY and that ordering is useful in helping to satisfy the ORDER BY or GROUP BY in the order query without doing an extra sort, then omit the extra sort. (check-in: 2fbb4dc232 user: drh tags: order-by-subquery) | |
| 20:33 | Extra tests. (check-in: fb257540d3 user: dan tags: fts5-locale) | |
| 18:50 | Further tests and fixes for this branch. (check-in: d27985245a user: dan tags: fts5-locale) | |
| 15:31 | Improved help message for --disable-tcl on the configure script. (check-in: 96e6cfb211 user: drh tags: trunk) | |
| 15:23 | Reinstate the --disable-tcl option on ./configure. Forum thread 845d4a57becc7f3c. (check-in: de927016aa user: drh tags: trunk) | |
|
2024-08-14
| ||
| 20:00 | Doc typo correction reported in the forum. (check-in: 48900a867c user: stephan tags: trunk) | |
| 17:58 | Improved documentation for the sha3() SQL functions in the shathree.c extension in ext/misc. (check-in: 0ce609103e user: drh tags: trunk) | |
| 15:04 | Add a compile-time option that enables setting the encryption key. (Leaf check-in: dafc517415 user: drh tags: iotester) | |
| 14:50 | incremental improvements to iotester. (check-in: 51f5d3d991 user: drh tags: iotester) | |
| 14:26 | Fix an assert() in fts5 that might fail with an expression like "... NOT ''". (check-in: 317c91edfc user: dan tags: trunk) | |
| 14:12 | More incremental improvements to the iotester program. (check-in: 30a383fc3d user: drh tags: iotester) | |
| 13:31 | Further improvements to the new iotester program. (check-in: dd71dde547 user: drh tags: iotester) | |
|
2024-08-13
| ||
| 21:15 | More tests for the new code on this branch. (check-in: 00792e807f user: dan tags: fts5-locale) | |
| 21:04 | Add the sha3_agg() aggregate to the shathree extension. (check-in: c4d7f9996c user: drh tags: trunk) | |
| 20:16 | Use the xDelete method of the VFS rather than direct interation with the filesystem. (check-in: 96df5aa656 user: drh tags: iotester) | |
| 19:30 | Infrastructure for a new test program named "iotester" that strives to verify the operation of a VFS object. (check-in: b46d86c22b user: drh tags: iotester) | |
| 15:04 | Add tests and fix minor issues with the code on this branch. (check-in: def5243a7b user: dan tags: fts5-locale) | |
| 09:16 | Version 3.46.1 (check-in: c9c2ab54ba user: drh tags: release, branch-3.46, version-3.46.1) | |
|
2024-08-12
| ||
| 18:39 | Add extra documentation comments to fts5_main.c. (check-in: 1a7a9bd3f6 user: dan tags: fts5-locale) | |
| 17:28 | Fix problem with some fts5 aux function APIs with (locale=, detail=none/column) tables. (check-in: bf116dec6f user: dan tags: fts5-locale) | |
| 17:03 | Fix further issues to do with fts5 locale support. (check-in: e626123580 user: dan tags: fts5-locale) | |
| 13:31 | Merge current trunk into this branch. (check-in: 900a593ddf user: stephan tags: wasm-build-rework) | |
| 11:46 | Update the porter tokenizer to use locales. (check-in: 3291ce3a33 user: dan tags: fts5-locale) | |
| 11:13 | Update the auxiliary function API to include xTokenize_x2() instead of xSetLocale(). (check-in: f7d56a1f21 user: dan tags: fts5-locale) | |
| 09:49 | Resolve parameters Bind $int_N and $test_T in fuzzcheck inputs. (check-in: 9c10664416 user: drh tags: trunk) | |
|
2024-08-10
| ||
| 20:24 | Merge the latest trunk enhancements into main reuse-schema branch. (check-in: 31a71a79bf user: drh tags: reuse-schema) | |
| 20:22 | Merge all the branch-3.46 patches into the reuse-schema as a new sub-branch called reuse-schema-3.46. (Leaf check-in: a27b12ee22 user: drh tags: reuse-schema-3.46) | |
| 20:16 | Merge all the latest branch-3.46 changes into the bedrock-3.46 branch via the wal2-3.46 intermediary. (check-in: cfb334dc53 user: drh tags: bedrock-3.46) | |
| 20:03 | Merge trunk changes into this branch. (check-in: b243007525 user: dan tags: fts5-locale) | |
| 20:02 | Merge the latest branch-3.46 changes into wal2 as a new sub-branch called wal2-3.46. (Leaf check-in: b917d07fc6 user: drh tags: wal2-3.46) | |
| 19:59 | Merge all of the latest branch-3.46 into the begin-concurrent branch as a new sub-branch called begin-concurrent-3.46. (Leaf check-in: 6cc144624d user: drh tags: begin-concurrent-3.46) | |
| 19:57 | Prevent the fts5 xPhraseNext() or xPhraseFirst() APIs from returning an out-of-range column number, even if the database is corrupt. (check-in: d4014c87ba user: dan tags: trunk) | |
| 19:18 | Fix an uninitialized variable in fts5_tcl.c. (check-in: 924d3467ce user: dan tags: fts5-locale) | |
| 18:59 | Update the fts5_tokenizer_v2 API so that the locale is passed as parameter to xTokenize(), instead of via a separate call to xSetLocale(). (check-in: 03e63ed24e user: dan tags: fts5-locale) | |
| 16:29 | Revision to check-in d9f726ade6b258f8 so that OOM and other unrelated failures are not overridden by a syntax error in the tokenizer spec. (check-in: fc956353d3 user: drh tags: branch-3.46) | |
| 15:46 | Revision to check-in [d9f726ade6b258f8] so that OOM and other unrelated failures are not overridden by a syntax error in the tokenizer spec. (check-in: 3778b2a9ca user: drh tags: trunk) | |
| 15:05 | Fix harmless compiler warning related to the TCL8-to-TCL9 transition. This change in testing code only and is not relevante to the core SQLite. (check-in: c86ef65545 user: drh tags: trunk) | |
| 14:56 | Fix behavior change in the offset() SQL function introduced by check-in f0b671183f44d0ae. (check-in: d6fc6e5f0a user: drh tags: branch-3.46) | |
| 14:53 | Fix behavior change in the offset() SQL function introduced by check-in [f0b671183f44d0ae]. (check-in: c2ac17f183 user: drh tags: trunk) | |
| 13:45 | Cherrypick ALTER TABLE fixes from trunk so that ALTER TABLE no longer returns SQLITE_INTERNAL instead of SQLITE_ERROR after malformed input. (check-in: 6decf00f7c user: drh tags: branch-3.46) | |
| 11:02 | Cherrypick various minor fixes from trunk into branch-3.46. (check-in: 6047b18ee3 user: drh tags: branch-3.46) | |
| 10:14 | Enhancements to covering-index prediction. Add early detection of over-prediction of covering-indexes so that sqlite3_prepare() will return an error rather than just generate bad bytecode. (check-in: 4afe3201f0 user: drh tags: branch-3.46) | |
| 10:05 | Enhancements to covering-index prediction. In particular, avoid the false-positive prediction described by forum post e60e4c295d22f8ce. Add early detection of over-prediction of covering-indexes so that sqlite3_prepare() will return an error rather than just generate bad bytecode. (check-in: f0b671183f user: drh tags: trunk) | |
| 09:56 | Add an assert() to fix a harmless compiler warning in the recovery extension. (check-in: 2502339339 user: drh tags: trunk) | |
|
2024-08-09
| ||
| 22:48 | Fix a few minor TCL9 compatibilities issues. (check-in: 69eed19914 user: drh tags: trunk) | |
| 20:59 | Ensure tokenizers registered with xCreateTokenizer_v2() can be accessed using xFindTokenizer(), and that those registered with xCreateTokenizer() work with xFindTokenizer_v2(). (check-in: a3ef7d47b5 user: dan tags: fts5-locale) | |
| 18:53 | Import the second ALTER TABLE fix from trunk. (Closed-Leaf check-in: 1de3e58836 user: drh tags: covering-index-patch) | |
| 18:42 | Fix another instance where ALTER TABLE was returning SQLITE_INTERNAL instead of SQLITE_ERROR one malformed input. (check-in: b416756320 user: drh tags: trunk) | |
| 18:22 | Merge the error code fix from trunk. (check-in: 81dfb8cd5d user: drh tags: covering-index-patch) | |
| 18:18 | Fix the internal routine sqlite3ResolveExprListNames() so that it returns SQLITE_OK or SQLITE_ERROR instead of WRC_Continue or WRC_Abort. Without this fix, some times of obscure syntax errors end up returning SQLITE_INTERNAL rather than SQLITE_ERROR. (check-in: 9052187efd user: drh tags: trunk) | |
| 17:09 | Do not attempt to use a covering index based purely on columns-used when doing an UPDATE or DELETE of a WITHOUT ROWID table. Raise an SQLITE_INTERNAL error if there is ever a situation where a table reference cannot be converted into an index reference when the query planner thinks that a covering index is appropriate. (check-in: fae39ae932 user: drh tags: covering-index-patch) | |
| 13:56 | Add SQLITE_TESTCTRL_EDITSTMT for making rogue changes to the statement bytecode, to test the death-cursor error detection mechanism. (Closed-Leaf check-in: 58ffd5d97e user: drh tags: death-cursor) | |
| 12:35 | Bind the new debug parameters in fuzzinvariants.c. (check-in: 7e1dc26305 user: drh tags: trunk) | |
| 12:20 | Remove unused static var cBadGroup from ext/consio/console_io.c to resolve a compiler warning reported in the fossil forum. This is a build fix, not a functional change. (check-in: be3de2e600 user: stephan tags: branch-3.46) | |
| 12:19 | Remove unused static var cBadGroup from ext/consio/console_io.c to resolve a compiler warning reported in the fossil forum. This is a build fix, not a functional change. (check-in: fa047c3ea7 user: stephan tags: trunk) | |
| 10:56 | Fix some signed/unsigned compiler warnings on this branch. (check-in: 681d228023 user: dan tags: wal2) | |
| 10:50 | Fix some signed/unsigned compiler warnings on this branch. (check-in: d615d52918 user: dan tags: bedrock) | |
| 10:37 | Remove two unnecessary int casts, as reported in forum post 84fe63b7b3. (check-in: 137cc3e9e8 user: dan tags: begin-concurrent) | |
| 09:49 | Remove two unnecessary int casts, as reported in forum post 84fe63b7b3. (check-in: 1de0c1b574 user: stephan tags: bedrock) | |
| 02:10 | Change the null-cursor in the previous check-in into a death-cursor. Any access of the cursor causes the prepared statement to return an SQLITE_INTERNAL error. We'll need to add a way to edit the bytecode using sqlite3_test_control() in order to test the death-cursor code path. (check-in: 8894b243ef user: drh tags: death-cursor) | |
| 01:38 | If there is any question about whether or not the WHERE_IDX_ONLY flag in the query planner is correct, create a backup null-cursor for the table, so that we never try to run an OP_Column against an unopened cursor. (check-in: 7f1617f7bf user: drh tags: death-cursor) | |
|
2024-08-08
| ||
| 19:45 | Do not allow the WHERE_IDX_ONLY query planner result in cases where a partial index is used on an UPDATE or a DELETE, since the code might still need to access the original table due to parameterized terms in the WHERE clause of the partial index. (Closed-Leaf check-in: 7058d93b09 user: drh tags: partial-index-terms-patch) | |
| 16:04 | In the vdbe_addoptrace output, show OP_Column opcodes that fail to translate from table to index. This is an aid to testing and analysis only. No changes to production code. (Closed-Leaf check-in: 7f464793fc user: drh tags: extra-debug) | |
| 15:42 | Ensure sqlite3expert.c unregisters any SQL user-functions it registers with the database handle before returning. (check-in: 2708314448 user: dan tags: branch-3.46) | |
| 15:26 | Ensure sqlite3expert.c unregisters any SQL user-functions it registers with the database handle before returning. (check-in: 123b154ce3 user: dan tags: trunk) | |
| 15:07 | Add assert() statements and reorganize code slightly in fts3 and fts5 to make it easier to follow. (check-in: 797b0a13fd user: dan tags: trunk) | |
| 14:49 | Do not let the number of terms on a VALUES clause be limited by SQLITE_LIMIT_COMPOUND_SELECT, even if the VALUES clause contains elements that appear to be variables due to the use of double-quoted string literals. (check-in: 05dbfad70c user: drh tags: branch-3.46) | |