Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
378 check-ins using file test/window1.test version 8d453bfa
|
2022-08-09
| ||
| 20:22 | Fix a rounding error caused by scalar->logarithm->scalar conversion when using stat4 data to estimate some range scans. (check-in: 68d86f2b user: drh tags: branch-3.28) | |
|
2021-07-12
| ||
| 14:38 | Fix a defect in the query-flattener optimization identified by ticket [8f157e8010b22af0]. This fix is associated with CVE-2020-15358. (check-in: 9e001b63 user: dan tags: branch-3.28a) | |
|
2020-10-22
| ||
| 18:58 | Minor tweaks to query planning weights so that when STAT4 is enabled and functioning, a full table scan is more likely to be selected if that seems like the fastest solution. Only do this when STAT4 info is available because an error has a large potential downside. (check-in: 263293f1 user: drh tags: branch-3.28) | |
|
2020-10-02
| ||
| 13:57 | Import further corner-case fixes for the in-scan-vs-index or OP_SeekScan optimization from trunk. (check-in: c144d640 user: drh tags: branch-3.28) | |
| 12:11 | For the OP_SeekScan optimization, the OP_IdxGT does not necessarily come right after the OP_SeekGE. So use the P2 operand of OP_SeekScan to point to the first instruction after OP_IdxGT. Problem found by dbsqlfuzz. (check-in: ec37744c user: drh tags: branch-3.28) | |
| 02:07 | Disable the OP_SeekScan opcode of the in-scan-vs-index optimization when in PRAGMA reverse_unordered_selects mode, as the OP_SeekScan only works with forwards scans. Thanks to OSSFuzz for pointing out the problem to us. (check-in: 9a1cdf7e user: drh tags: branch-3.28) | |
|
2020-09-30
| ||
| 18:22 | Improved query optimization for multi-column indexes where the second or later columns are constrained by an IN operator and the earlier index columns limit the search to a small number of rows. Use the new OP_SeekScan opcode which does scanning of the relevant range of the index but gives up and falls back to doing a seek if the number of rows scanned grows to large, in order to guard against pathological cases where the estimated number of rows to be scanned is far too small. (check-in: f07ac3fb user: drh tags: branch-3.28) | |
|
2020-09-01
| ||
| 02:02 | Improvements to the IN-early-out optimization so that it works more efficiently when there are two or more indexed IN clauses on a single table. (check-in: 49b7631e user: drh tags: branch-3.28) | |
|
2020-08-31
| ||
| 19:19 | An attempt to improve the performance of the IN-early-out optimization (see check-in [09fffbdf9f2f6ce3]) by avoiding unnecessary calls to the b-tree search algorithm in OP_IfNoHope when the index key is at hand and the same answer can be obtained by doing a quick key comparison. Update: Experiment did not work out. (Closed-Leaf check-in: 8301da31 user: drh tags: branch-3.28-in-early-out-fail) | |
|
2020-08-17
| ||
| 21:03 | When doing an UPDATE or DELETE using a multi-column index where only a few of the earlier columns of the index are useful for the index lookup, postpone doing the main table seek until after all WHERE clause constraints have been evaluated, in case those constraints can be covered by unused later terms of the index, thus avoiding unnecessary main table seeks. (check-in: 0ecda433 user: dan tags: branch-3.28) | |
|
2020-05-06
| ||
| 18:46 | Provide the SQLITE_DEFAULT_LEGACY_ALTER_TABLE compile-time option. (check-in: b2325a6e user: drh tags: branch-3.28) | |
|
2020-01-17
| ||
| 15:33 | More restrictions on changes to shadow tables when in defensive mode. (check-in: b302b260 user: drh tags: branch-3.28) | |
| 15:24 | Validate the type, name, and tbl_name fields of the sqlite_master table when loading the schema, unless writable_schema is engaged. (check-in: 3d13fbf2 user: drh tags: branch-3.28) | |
| 14:56 | Do not allow shadow tables to be dropped in defensive mode. (check-in: ad1f760f user: drh tags: branch-3.28) | |
| 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) | |
|
2019-07-18
| ||
| 20:55 | Fix a problem where self-joins on views that are aggregate queries may return the wrong result. Cherrypick of [74ef97bf51dd531a]. (check-in: 2f0a564f user: mistachkin tags: branch-3.28) | |
| 19:50 | Add a ctime.c entry for SQLITE_ENABLE_SHARED_SCHEMA. (check-in: 892ac945 user: drh tags: reuse-schema) | |
| 13:33 | Modify the bits used for special flags on this branch to account for the fact that some of them are now used for other purposes. (check-in: 5a8d0f50 user: dan tags: reuse-schema) | |
|
2019-07-17
| ||
| 18:19 | When processing a BETWEEN or CASE expression, avoid transforming a node of the original expression into a TK_REGISTER node. Instead, take a copy and use it instead. Fix for [1be72aab9]. (check-in: bc6b0d73 user: drh tags: branch-3.29) | |
| 18:11 | Fix problems with duplicate fields in the PRIMARY KEYs of WITHOUT ROWID tables. (check-in: bda25883 user: drh tags: branch-3.29) | |
|
2019-07-13
| ||
| 17:21 | Fix a double-quoted string literal used in the ".schema" command of the CLI. (check-in: fcd937d9 user: drh tags: trunk) | |
| 16:39 | Add support for attaching a FILTER clause to an aggregate function. (check-in: ee293e5a user: dan tags: trunk) | |
| 16:22 | Rework the FILTER clause implementation to share more code with window functions. (Leaf check-in: 5dac8c38 user: dan tags: filter-clause) | |
| 16:15 | Remove unreachable "break" statements to silence harmless compiler warnings from ICC. (check-in: 0d7287e1 user: drh tags: trunk) | |
| 09:56 | Merge latest trunk changes into this branch. (check-in: 86ab963c user: dan tags: filter-clause) | |
| 09:55 | Trivial performance improvement for balance(). (check-in: c7920f55 user: dan tags: filter-clause) | |
|
2019-07-12
| ||
| 15:15 | Minor performance improvement in vdbeRecordCompareString(). (check-in: 777fec84 user: dan tags: filter-clause) | |
|
2019-07-11
| ||
| 19:50 | Improved comments and extra testcase() macros on the serial-type computation logic in the OP_MakeRecord opcode. (check-in: 18bfb217 user: drh tags: trunk) | |
| 19:27 | Increase the version number to 3.30.0 for the next release cycle. (check-in: 2578e3c6 user: drh tags: trunk) | |
| 19:22 | Move the sqlite3VdbeSerialType() routine in-line in the OP_MakeRecord opcode. Optimizing compilers were doing this already. By doing it manually, we can omit some redundant tests and make the whole thing run a million cycles faster and use about 80 bytes less code space. (check-in: d837ab0d user: drh tags: trunk) | |
| 18:43 | Change the parser on this branch to more closely match trunk. This saves a few more cycles. (check-in: be01b801 user: dan tags: filter-clause) | |
|
2019-07-10
| ||
| 20:16 | Minor performance improvement in sqlite3ExprDeleteNN(). (check-in: bcc8b38a user: dan tags: filter-clause) | |
| 18:45 | Merge the version 3.29.0 release enhancements into the reuse-schema branch. (check-in: 9819ead0 user: drh tags: reuse-schema) | |
| 18:40 | Merge the 3.29.0 updates into the begin-concurrent-pnu-wal2 branch. (check-in: 627b428f user: drh tags: begin-concurrent-pnu-wal2) | |
| 18:30 | Merge the 3.29.0 release into the wal2 branch. (check-in: 8baa4022 user: drh tags: wal2) | |
| 18:21 | Merge the 3.29.0 changes into the begin-concurrent-pnu branch. (check-in: c89949cc user: drh tags: begin-concurrent-pnu) | |
| 18:11 | Merge the 3.29.0 release into the begin-concurrent branch. (check-in: 983733ae user: drh tags: begin-concurrent) | |
| 17:58 | Merge the 3.29.0 release into the apple-osx branch. (check-in: 87aa1d70 user: drh tags: apple-osx) | |
| 17:32 | Version 3.29.0 (check-in: fc82b73e user: drh tags: trunk, release, version-3.29.0) | |
|
2019-07-09
| ||
| 23:35 | Add the "LL" suffix on a pair of larger integer literals, for compatibility with older C compilers. (check-in: 6f328c35 user: drh tags: trunk) | |
| 17:36 | Update rtree.c so that SQLITE_DEBUG is required to turn on assert() statements, even if it is compiled separately from the amalgamation. (check-in: b6e17f01 user: dan tags: trunk) | |
| 12:03 | Fix a test script problem in windowfault.test. (check-in: 47010bf1 user: dan tags: trunk) | |
|
2019-07-08
| ||
| 21:32 | Merge recent trunk enhancements into the reuse-schema branch. (check-in: fae92fee user: drh tags: reuse-schema) | |
| 21:25 | Merge enhancments from wal2, which also merges trunk enhancements. (check-in: 08dcb459 user: drh tags: begin-concurrent-pnu-wal2) | |
| 21:19 | Merge all enhancements from trunk into the wal2 branch. (check-in: dcbcbc2a user: drh tags: wal2) | |
| 21:12 | Merge enhancements from trunk into the begin-concurrent-pnu branch. (check-in: 05aa93af user: drh tags: begin-concurrent-pnu) | |
| 21:06 | Merge recent trunk enhancements into the begin-concurrent branch. (check-in: 7fff0803 user: drh tags: begin-concurrent) | |
| 20:59 | Merge recent enhancements from trunk into apple-osx. (check-in: de88ed86 user: drh tags: apple-osx) | |
| 18:35 | Fix dbfuzz2 so that it will compile on systems that do not support getrlimit(). (check-in: 36295dce user: drh tags: trunk) | |
| 13:45 | Fix an assert() that [28196d89] caused to fail. (check-in: 8fb0c6d5 user: dan tags: trunk) | |
| 12:44 | Comment improvements. No changes to code. (Leaf check-in: b0629132 user: drh tags: tkt9b78184b-alt) | |
| 12:01 | Ensure collation sequences and affinities work in window function queries. Fix for [9ece23d2]. (check-in: 28196d89 user: dan tags: trunk) | |
|
2019-07-05
| ||
| 19:10 | Another very small performance improvement. (check-in: 7a1e30a1 user: dan tags: filter-clause) | |
| 17:38 | Minor tweak to patch on this branch to reclaim some cycles. (check-in: 81eed055 user: dan tags: filter-clause) | |
| 15:16 | Fix a valgrind problem in fts3corrupt4.test. (check-in: cb3dec42 user: dan tags: trunk) | |
|
2019-07-04
| ||
| 19:19 | As it requires wal mode support, do not run test file chunksize.test as part of the "journaltest" permutation. (check-in: acd2df36 user: dan tags: trunk) | |
| 16:30 | Fix a typo in the wapptest.tcl script. (check-in: 971b4422 user: dan tags: trunk) | |
| 16:06 | Have wapptest.tcl run at least one threadtest with an SQLITE_ENABLE_MEMORY_MANAGEMENT build. (check-in: d6131caf user: dan tags: trunk) | |
| 16:05 | Fix a race condition that could occur in SQLITE_ENABLE_MEMORY_MANAGEMENT builds when two threads simultaneously open the first two database connections in the process. (check-in: 5ea3f6fc user: dan tags: trunk) | |
|
2019-07-03
| ||
| 18:31 | Add tests for the FILTER clause. And a bugfix. (check-in: 28aa1702 user: dan tags: filter-clause) | |
|
2019-07-02
| ||
| 20:10 | Have ALTER TABLE detect and error out for the case where renaming a column changes a the interpretation of a double-quoted identifier in the database schema from an SQL literal to a column reference. (check-in: 5dbb0734 user: dan tags: tkt9b78184b-alt) | |
| 12:23 | Restore the legacy behavior of enabling double-quoted string literals in all contexts. But also provide a new compile-time option (SQLITE_DQS) to change the default to something more restrictive. (check-in: 97a94446 user: drh tags: trunk) | |
| 11:56 | Experimental implementation of FILTER clause for aggregate functions. (check-in: 1f1ae2d6 user: dan tags: filter-clause) | |
|
2019-06-28
| ||
| 07:08 | Use the OP_Sequence opcode for generating unique rowid values for an autoindex on a co-routine implementation of a subquery. (check-in: eab42975 user: drh tags: trunk) | |
|
2019-06-26
| ||
| 21:04 | Ensure that when an ephemeral cursor is reopened with a second invocation of to OP_OpenEphemeral, the sequence counter is reset and the cache marked as stale. Fix for [9cdc5c46]. (check-in: 5fd20e09 user: dan tags: trunk) | |
|
2019-06-21
| ||
| 14:05 | Fix a typo in an option name for the .dbconfig command in shell.c.in: s/wriable_schema/writable_schema/ (check-in: 1c58522e user: dan tags: trunk) | |
|
2019-06-17
| ||
| 14:50 | Fix a problem with handling with handling quoted path elements in extension functions json_set() and json_insert() reported on the mailing list. (check-in: 45bfcb88 user: dan tags: trunk) | |
| 14:13 | New sqlite3_db_config() options: SQLITE_DBCONFIG_LEGACY_ALTER_TABLE, SQLITE_DBCONFIG_DQS_DML, and SQLITE_DBCONFIG_DQS_DDL. (check-in: a61db8ff user: drh tags: trunk) | |
| 13:56 | Improved interface to double-quoted string literal enabling/disabling. (Closed-Leaf check-in: 923cfd53 user: drh tags: new-dbconfig-options) | |
|
2019-06-16
| ||
| 14:56 | Avoid transforming TK_COLLATE or TK_UNLIKELY Expr nodes to TK_REFERENCE. Instead, transform the uppermost Expr node in the expression tree that is not of this type. Fix for [e1e07ef2]. (check-in: 54110870 user: drh tags: trunk) | |
| 08:58 | Avoid transforming TK_COLLATE or TK_UNLIKELY Expr nodes to TK_REFERENCE. Instead, transform the uppermost Expr node in the expression tree that is not of this type. Fix for [e1e07ef2]. (Closed-Leaf check-in: ba7870e2 user: dan tags: tkt-e1e07ef2) | |
|
2019-06-15
| ||
| 15:32 | Fix minor problems in the test code in test_demovfs.c. (check-in: ca4ddfef user: dan tags: trunk) | |
| 15:27 | Add extra test case for one of the problems fixed by the previous commit. (check-in: 0bbceebb user: dan tags: trunk) | |
| 15:21 | Ensure that sqlite3RenameExprUnmap() does an unmap of the result set alias names in subqueries when ALTER TABLE fails because of a syntax error in a trigger. (check-in: d3b6f166 user: drh tags: trunk) | |
|
2019-06-14
| ||
| 21:25 | Add SQLITE_DBCONFIG options LEGACY_ALTER_TABLE, NO_DQS_SCHEMA, and NO_DQS. (check-in: 1fad2092 user: drh tags: new-dbconfig-options) | |
| 17:37 | Deprecate the SQLITE_ALLOW_COVERING_INDEX_SCAN compile-time option when it is turned off. This probably will impact no-one. If it does, they will get an error message instructing them to contact developers, so that we can get feedback that somebody is actually using this feature. Start-time disabling of covering index scan is not affected. (check-in: 23e49f99 user: drh tags: trunk) | |
| 13:24 | Fix the implementation of the built-in RTRIM collating sequence so that it works for control characters at the end of the string. Ticket [f1580ba1b574e9e9] (check-in: 86fa0087 user: drh tags: trunk) | |
| 12:28 | Refactor the LIKE optimization decision logic so that it uses sqlite3AtoF() on both boundary keys to determine if the optimization can be used when the LHS is something that might not have TEXT affinity. Ticket [ce8717f0885af975]. See also [c94369cae9b561b1], [b043a54c3de54b28], [fd76310a5e843e07], and [158290c0abafde67]. (check-in: b4a9e09e user: drh tags: trunk) | |
|
2019-06-13
| ||
| 16:14 | Add a new requirement mark on the ctime.c code. (check-in: c4b40568 user: drh tags: trunk) | |
| 14:07 | Do not use the %lld printf conversion in the platform printf() as some legacy platforms do not support it. (check-in: f8696b60 user: drh tags: trunk) | |
| 13:52 | Fix a minor error in a test script, and harmless compiler warnings in the CLI code. (check-in: eaa34626 user: drh tags: trunk) | |
|
2019-06-12
| ||
| 22:46 | Adjust requirements marks and add new requirements tests. (check-in: ebb81dad user: drh tags: trunk) | |
| 20:51 | As a special case, casting '-0.0' into numeric should yield 0. Fix for ticket [674385aeba91c774]. (check-in: 491f0f9b user: drh tags: trunk) | |
| 20:11 | Enhancements to the printf() logic in order to render a negative zero with a minus sign. (Leaf check-in: 6ba4be66 user: drh tags: negative-zero) | |
| 13:49 | Handle expressions like "expr IS TRUE COLLATE xyz" in the same way as "expr IS TRUE". Fix for [4d01eda8115b10d1]. (check-in: 5c6146b5 user: dan tags: trunk) | |
|
2019-06-11
| ||
| 21:02 | The affinity of the unlikely() function and its cousins should be "none". Ticket [0c620df60bffd9ef] (check-in: 614ecb0a user: drh tags: trunk) | |
| 18:07 | Make sure the affinity of the RHS of an IN operator does not affect the outcome even if the RHS expression contains a COLLATE clause. Ticket [57353f8243c637c0] (check-in: 0f748fe5 user: drh tags: trunk) | |
| 16:43 | Mark an unreachable branch with an ALWAYS macro. (check-in: d4755aca user: drh tags: trunk) | |
| 16:07 | New test case in fuzzdata8.db. (check-in: e96641f0 user: drh tags: trunk) | |
| 16:06 | Off-by-one error in the CAST to NUMERIC logic. (check-in: 25b89630 user: drh tags: trunk) | |
| 12:03 | Have the ALTER TABLE code handle the case where an entire expression that includes a sub-select is excluded from a view, trigger or index. (check-in: f2c8179f user: dan tags: trunk) | |
| 10:43 | Add the new sqlite3ExprUnmapAndDelete() function and use it in place of separate calls to sqlite3RenameExprUnmap() and sqlite3ExprDelete(). (check-in: 36ea13e0 user: drh tags: trunk) | |
| 02:43 | The ALTER TABLE command should not attempt to rename objects that are contained within an expression tree that has been optimized out because it is the other branch of an "AND false" expression. Ticket [533010b8cacebe82] (check-in: 04bd5cb7 user: drh tags: trunk) | |
| 01:56 | Fix repeated test numbers in the altertab2.test file. (check-in: e82f235e user: drh tags: trunk) | |
| 01:30 | Remove a comment made obsolete by check-in [71643deb6bbad4b4]. No changes to code. (check-in: 211c8002 user: drh tags: trunk) | |
|
2019-06-10
| ||
| 23:45 | A string consisting of a single '.' is not a floating point literal with extra text at the end. Fix for ticket [412bba9b22c677da] (check-in: 57050162 user: drh tags: trunk) | |
| 19:17 | Have ALTER TABLE commands ignore the lhs of "expr IN ()" and "expr NOT IN ()" expressions, just as other queries do. Fix for [533010b8ca]. (check-in: 71643deb user: dan tags: trunk) | |
| 19:07 | Improvements to the documentation for the xAccess method of the VFS. Ticket [5e0423b058fa5adf] (check-in: 7078d77e user: drh tags: trunk) | |
| 18:33 | Make sure a CAST to "NUMERIC" results in an integer if the value can be losslessly expressed as an integer, as the documentation requires. Ticket [dd6bffbfb6e61db9]. (check-in: c0c90961 user: drh tags: trunk) | |
| 15:34 | Handle renaming a column or table when the schema contains a (meaningless) index on the constant expression ('text' IN ()) or ('text' NOT IN()). Fix for [fd76310a]. (check-in: 567b1309 user: dan tags: trunk) | |
| 13:46 | Do not attempt the LIKE optimization on a column with numeric affinity if the rhs of the operator begins with whitespace. Fix for ticket [fd76310a5e]. (check-in: 94b58ab0 user: dan tags: trunk) | |
|
2019-06-07
| ||
| 22:51 | Remove code in the round() SQL function that became unreachable due to the optimization of check-in [e95138f5f4febde5] (check-in: b141bae3 user: drh tags: trunk) | |
| 22:26 | When casting string values into numeric and the string has a prefix that looks like a number but total string is not a well-formed number, then take extra care that the result is either integer or real depending on what the prefix looks like. Fix for tickets [e8bedb2a184001] and [4c2d7639f076aa]. (check-in: 67a68af5 user: drh tags: trunk) | |
| 18:56 | Also upgrade script config.sub to the latest version. This should have been part of the previous commit. (check-in: efbf31b8 user: dan tags: trunk) | |
| 18:53 | Upgrade the config.guess script to the latest version. (check-in: be843813 user: dan tags: trunk) | |
|
2019-06-05
| ||
| 14:29 | CLI enhancements: Add the ".filectrl" command. Make the ".testctrl" command visible to ".help". (check-in: 7b3a99fc user: drh tags: trunk) | |
| 13:14 | Add a test case for the unix SQLITE_FCNTL_CHUNK_SIZE file-control. (check-in: 3a477fd0 user: dan tags: trunk) | |
|
2019-06-04
| ||
| 18:21 | In the CLI, add a small delay (0.1 seconds) after launching the output command for ".once" before deleting the temporary file. (check-in: 4979f138 user: drh tags: trunk) | |
| 15:47 | New dbsqlfuzz test cases add to test/fuzzdata8.db. (check-in: 873aa46d user: drh tags: trunk) | |
| 13:11 | Fix a segfault in fts3 that could occur when processing corrupt fts records. (check-in: dff24c6c user: dan tags: trunk) | |
|
2019-06-03
| ||
| 15:10 | Fix harmless compiler warning in lemon. (check-in: 3a052429 user: mistachkin tags: branch-3.28) | |
| 15:09 | Fix harmless compiler warning in lemon. (check-in: 2da0eea0 user: mistachkin tags: trunk) | |
| 14:02 | Updates to the shared_schema.md notes document. (check-in: 51af2ade user: drh tags: reuse-schema) | |
| 13:53 | Fix the count-of-view optimization so that it is (correctly) disabled for a query that includes a WHERE clause or a GROUP BY clause. Cherrypick of [05897ca48a40c6771]. (check-in: 583e5a0a user: mistachkin tags: branch-3.28) | |
| 13:46 | In the CLI, add ".help" text for the .shared-schema command. (check-in: 3ba6f790 user: drh tags: reuse-schema) | |
|
2019-05-30
| ||
| 13:47 | Optimization to the round() SQL function for large input values without a fractional part. (check-in: e95138f5 user: drh tags: trunk) | |
| 00:46 | Smaller and faster sqlite3IsNaN() implementation makes deserialization of floating point values much faster. (check-in: ea748ede user: drh tags: trunk) | |
|
2019-05-29
| ||
| 21:18 | Much faster implementation of applyNumericAffinity() by avoiding some unnecessary calls to sqlite3Atoi64(). (check-in: c1d8a3f6 user: drh tags: trunk) | |
| 18:33 | Add an assert() as an additional test for fix in check-in [523b42371122d9e1b3]. (check-in: f9e85e6c user: drh tags: trunk) | |
| 17:22 | Fix the query flattener optimization so that it preserve the "SF_Compound" bit when flattening a compound subquery into a non-compound outer query. Failure to preserve that bit could allow subsequent flattenings which are not valid. Fix for ticket [c41afac34f15781fe09cd]. (check-in: 523b4237 user: drh tags: trunk) | |
|
2019-05-28
| ||
| 14:42 | Fix an assert() in fts3 that could fail when processing corrupt records. Also some minor sanitizer warnings. (check-in: c736c40a user: dan tags: trunk) | |
|
2019-05-27
| ||
| 11:21 | Fix an error message on the blobread() extension function so that it says "read" instead of "write". (check-in: 7cbb9a5f user: drh tags: trunk) | |
| 11:09 | Fix a memory leak in the delta_parse() table-valued function of the fossildelta.c extension. (check-in: c86ca3f0 user: drh tags: trunk) | |
| 00:29 | Improved rounding even on systems with an 8-byte "long double" type. (check-in: 15202aee user: drh tags: trunk) | |
|
2019-05-25
| ||
| 18:17 | Performance enhancement in sqlite3AtoF(). About 8% faster. (check-in: 81721aa5 user: drh tags: trunk) | |
| 17:41 | Use "long double" literals to initialize an array of "long double" objects. (check-in: 2e2ebad3 user: drh tags: trunk) | |
| 13:14 | Add new cases to speedtest1 for measuring performance of binary to/from decimal conversions of floating point values. (check-in: b84e7057 user: drh tags: trunk) | |
| 00:17 | Disable the new rounding tests on systems without long double support. (check-in: ed250b4e user: drh tags: trunk) | |
|
2019-05-24
| ||
| 22:58 | Improvements to rounding behavior in the round() and printf() functions. (check-in: 641b2d21 user: drh tags: trunk) | |
| 13:15 | The ".shared-schema" command in the CLI requires the sqlite_dbpage table, so disable it if the build does not include that extension. (check-in: 0913ff4d user: drh tags: reuse-schema) | |
| 13:04 | Merge recent enhancements from trunk. (check-in: ff9f3e09 user: drh tags: reuse-schema) | |
| 11:55 | Fix an fts5 segfault that could occur after parsing a corrupt structure record. (check-in: 600daa9c user: dan tags: trunk) | |
|
2019-05-23
| ||
| 16:40 | Add test cases for the fix in the previous commit. (check-in: c1057b2a user: dan tags: trunk) | |
| 16:38 | Improvements to the view-self-join optimization so that it works on all VIEWs, not just on Common Table Expressions. (check-in: d2fe370c user: drh tags: trunk) | |
|
2019-05-22
| ||
| 23:12 | New test case for check-in [74ef97bf51dd531a] that takes the fix in the previous check-in into account. (check-in: cb1d0652 user: drh tags: trunk) | |
| 22:49 | Renumber the Select.selId values in the copies of SELECT statements that implement VIEWs when the VIEW is expanded, so that when the same VIEW is used twice in the same join, each expansion as a distinct selId. This fixes ticket [ce823231949d3abf42453c8]. (check-in: 3cacc4b9 user: drh tags: trunk) | |
| 14:35 | New dbsqlfuzz find added to test/fuzzdata8.db. (check-in: 42af7c81 user: drh tags: trunk) | |
| 14:22 | Fix a buffer overread that could in fts3 when dealing with corrupt records. (check-in: 1660d773 user: dan tags: trunk) | |
|
2019-05-21
| ||
| 17:04 | Combine the implementations of the key and hexkey pragmas into a single case. Have both pragmas return "ok" if they are implemented. (check-in: b3692c40 user: drh tags: trunk) | |
| 16:32 | Fix a problem in [b5ca442a] causing an assert() to fail in REINDEX commands. (check-in: a3e77c77 user: dan tags: trunk) | |
| 14:42 | Use a statement journal for all CREATE INDEX statements in case an indexed exprsesion throws an exception when it is evaluated. Fix for [b5ca442a]. (check-in: b8071d10 user: dan tags: trunk) | |
|
2019-05-20
| ||
| 19:46 | Fix a segfault that could occur in sqlite3session_diff() if NULL were passed as the pzErrMsg argument. (check-in: aee73fd2 user: dan tags: trunk) | |
| 18:43 | Improvements to the automatic compile-time selection of byte-order, as suggested on the mailing list by Seb Kemper. (check-in: b7aad929 user: drh tags: trunk) | |
| 18:35 | A minor variation on check-in [1685610ef8e0dc] which (hopefully) makes the logic a little easier to follow. Also disallows the use of the double-quoted string hack in the query expression used for VACUUM INTO, which is not strictly required, but moves us toward the goal of disallowing the double-quoted string hack everywhere. (check-in: 3e1b55f3 user: drh tags: trunk) | |
| 17:14 | Disallow string constants enclosed in double-quotes within new CREATE TABLE and CREATE INDEX statements. It is still possible to enclose column names in double-quotes, and existing database schemas that use double-quotes for strings can still be loaded. This addresses ticket [9b78184b]. (check-in: 1685610e user: dan tags: trunk) | |
| 10:36 | Update the sqlite3ExprCompare() routine so that it does not think "? IS NOT TRUE" is the same as "? IS TRUE". Fix for [d3e7f2ba5b3]. (check-in: 99eba69b user: dan tags: trunk) | |
|
2019-05-18
| ||
| 21:22 | Fix an assert() failure that could occur in a join query if the RHS of an IN() operator is a list containing correlated expressions. This problem was introduced by checkin [e130319317e7611938] which was part of the fix for ticket [787fa716be3a7f650c] - so this commit is part of that ticket's fix too. (check-in: 778b1224 user: dan tags: trunk) | |
| 19:49 | Avoid including the comment in the output of "PRAGMA table_info" in situations where there is a comment following a DEFAULT value within a CREATE TABLE statement. (check-in: d91095ba user: dan tags: trunk) | |
|
2019-05-17
| ||
| 20:37 | Disable PRAGMA journal_mode=OFF when SQLITE_DBCONFIG_DEFENSIVE is turned on. Ticket [f4ec250930342e0c]. (check-in: a0f5eb5c user: drh tags: trunk) | |
| 15:59 | Always store a REAL value in a column with REAL affinity if the integer equivalent would require 8 bytes of storage. Fix for [3c27b97e3]. (check-in: 14c00b10 user: dan tags: trunk) | |
|
2019-05-16
| ||
| 20:40 | Add test cases to test/fuzzdata7.db for (harmless) dbfuzz2 finds. (check-in: 1eb2a628 user: drh tags: trunk) | |
| 20:36 | Initialize the 18-byte overrun area on the buffer used to reconstruct overflow btree cells during a btree search, to avoid a harmless jump-depends-on-uninit-values warning. (check-in: 4b05caeb user: drh tags: trunk) | |
| 20:13 | Fix an assert() in the OP_Delete opcode that could fail with a corrupt database. (check-in: 915388ab user: dan tags: trunk) | |
| 16:44 | Add new test file fts5corrupt4.test. (check-in: 5dfc4fe9 user: dan tags: trunk) | |
| 11:47 | Fix a harmless use-of-initialized-value fault in the assert() logic added by check-in [d612fb7873cf59d] (check-in: 3dac9072 user: drh tags: trunk) | |
| 03:47 | Fix harmless compiler warning in the session extension. (check-in: dff823ca user: mistachkin tags: trunk) | |
| 01:22 | Make sure the OP_Concat opcode always correctly zero-terminates a UTF16 string, even if the input strings are ill-formed. This is a followup to check-in [3a16ddf91f0c9c516a7] that fixes a case the previous check-in missed. Also add assert()s to prove correct zero termination. (check-in: d612fb78 user: drh tags: trunk) | |
|
2019-05-15
| ||
| 18:42 | Fix the count-of-view optimization so that it is (correctly) disabled for a query that includes a WHERE clause or a GROUP BY clause. (check-in: 05897ca4 user: drh tags: trunk) | |
| 10:16 | Simplify the "Verifying Code Authenticity" section of the README.md file. No code changes. (check-in: adebffc1 user: drh tags: trunk) | |
|
2019-05-14
| ||
| 22:25 | Merge all the latest trunk enhancements into the reuse-schema branch. (check-in: 018f3199 user: drh tags: reuse-schema) | |
| 22:07 | Merge the latest trunk and wal2 enhancements. (check-in: 3deaa6e2 user: drh tags: begin-concurrent-pnu-wal2) | |
| 22:02 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 23ec34e4 user: drh tags: wal2) | |
| 21:51 | Merge the latest trunk enhancements into begin-concurrent-pnu. (check-in: e70878b3 user: drh tags: begin-concurrent-pnu) | |
| 21:51 | Merge the latest trunk enhancements into begin-concurrent. (check-in: 5d3a6e18 user: drh tags: begin-concurrent) | |
| 20:25 | Fix a problem with the fix for [9cf6c9bb51] (commit [658b84d7]) that could cause a cursor to be left in an invalid state following a (rowid < text-value) search. (check-in: bc7d2c16 user: dan tags: trunk) | |
| 19:39 | Merge recent enhancements from trunk into apple-osx. (check-in: 40362d51 user: drh tags: apple-osx) | |
| 19:20 | New test cases in test/fuzzdata8.db. (check-in: 228e1087 user: drh tags: trunk) | |
| 18:33 | Fix a problem with corrupt db handling in the fts5_vocab module. (check-in: 456ced57 user: dan tags: trunk) | |
| 11:33 | Fix an assert() and potential buffer overrun in fts5 that could occur if the database was corrupt. (check-in: 8be8bd0d user: dan tags: trunk) | |
| 00:43 | Disable index seek optimizations on REINDEX when the order of primary keys in the index differs from the main table. Fix for ticket [bba7b69f9849b5bf11b4]. (check-in: f7aadfab user: drh tags: trunk) | |
|
2019-05-13
| ||
| 11:52 | Fix an assert() failure in fts5 that could occur when processing a corrupt database. (check-in: f158c048 user: dan tags: trunk) | |
|
2019-05-11
| ||
| 19:36 | A new implementation for the sqlite3ExprImpliesExpr() theorem prover that does a better job of answering TRUE to "(NOT A) OR B" when B is a NOT NULL expression. (check-in: b3413197 user: drh tags: trunk) | |
| 16:14 | When considering partial indexes, do not assume that a "CASE x ..." expression implies "x IS NOT NULL". (check-in: 1b243032 user: dan tags: trunk) | |
| 13:04 | Do not assume that "x IS NOT ?" implies "x NOT NULL" when considering partial indexes. Fix for ticket [8025674847]. (check-in: 0ba6d709 user: dan tags: trunk) | |
|
2019-05-10
| ||
| 20:44 | Add tests for the RBU module. (check-in: a194e536 user: dan tags: trunk) | |
| 17:54 | Fix harmless compiler warnings. (check-in: 956ca2a4 user: drh tags: trunk) | |
| 17:50 | Fix harmless compiler warnings in the CLI. (check-in: 2846bc04 user: drh tags: trunk) | |
| 16:16 | Fix some harmless compiler warnings. (Closed-Leaf check-in: ca068d82 user: mistachkin tags: warnings) | |
| 14:34 | Ensure that the BtShared.nPage value is reset correctly on a SAVEPOINT ROLLBACK. (check-in: e6d5fee8 user: drh tags: trunk) | |
| 14:26 | Treat integer values in window definition ORDER BY clauses as constants, not as references to another expression. (check-in: 7e4809ea user: dan tags: trunk) | |
| 14:03 | Improved comments and extra assert() statements on the OP_Savepoint opcode, just to make the code a little easier to read and reason about. (check-in: e80b2d9f user: drh tags: trunk) | |
| 12:14 | Fix the previous check-in [db9acef14d492121] so that the amalgamation build works for systems for which lack HAVE_ISNAN. (check-in: 3cc55e09 user: drh tags: trunk) | |
| 12:06 | Fix the round() SQL function so that it handles infinities correctly. (check-in: db9acef1 user: drh tags: trunk) | |
|
2019-05-09
| ||
| 18:37 | Fix another small buffer overread in sqlite_dbdata triggered by a corrupt database page. (check-in: 1dfc95b8 user: dan tags: trunk) | |
| 18:33 | Fix a problem in the ".recover" command allowing a circular loop of b-tree pages in a database file to cause an infinite loop. (check-in: 8d2a062e user: dan tags: trunk) | |
| 18:13 | Make the ".schema" command in the CLI resistant to corrupt database files. (check-in: f22c7e22 user: drh tags: trunk) | |
| 17:54 | Fix a crash in the sqlite_dbdata module that could occur if a pointer within an overflow chain in a corrupt database pointed past the end of the db. (check-in: 3eae4e30 user: dan tags: trunk) | |
| 17:10 | Disable the optimization where a REAL value with no fractional part is stored as an INTEGER when the integer uses as much space as the real value it proposes to stand in for (8 bytes). This avoids corner cases of comparing integers against real values that are beyond the resolution of an IEEE 754 double. Fix for ticket [6c1d3febc00b22d457c78c2] (check-in: 9b091527 user: drh tags: trunk) | |
| 16:57 | Avoid long delays that can occur when ".recover"ing data from a database with a corrupt freelist. (check-in: 20f06bf2 user: dan tags: trunk) | |
| 16:22 | Improved debugging output from the OP_MakeRecord opcode. (check-in: ac790729 user: drh tags: trunk) | |
| 15:51 | Fix another corruption related buffer overread in the sqlite_dbdata module. (check-in: 5cd728fb user: dan tags: trunk) | |
| 15:07 | Fix further buffer overreads triggered by passing corrupt records to the sqlite_dbdata module. (check-in: dbc6a9f7 user: dan tags: trunk) | |
| 14:15 | Have ".recover" handle cases where the sqlite_master table contains malformed SQL statements. (check-in: e736da9c user: dan tags: trunk) | |
| 11:45 | Fix a problem with running the ".recover" command on a database that is zero pages in size. (check-in: 47fa6534 user: dan tags: trunk) | |
| 11:34 | Avoid reading outside a record buffer when extracting an SQL value in the sqlite_dbdata virtual table code. (check-in: d99bb0c1 user: dan tags: trunk) | |
| 11:21 | Merge accidental fork in trunk. (check-in: ec937303 user: dan tags: trunk) | |
| 11:19 | Fix a problem in the new code introduced by [658b84d7] causing corruption and other errors to be ignored. (check-in: 7ccf2e7d user: dan tags: trunk) | |
| 11:18 | Improved error handling for the ".open --hexdb" command of the CLI. (check-in: 4fa831d5 user: drh tags: trunk) | |
|
2019-05-08
| ||
| 23:55 | Ensure that the sqlite3BtreeLast() interface initializes the *pRes return to zero if the cursor is already sitting on the last entry of the table. Manuel Rigger found the obscure test case for which this makes a difference. (check-in: ebe4845c user: drh tags: trunk) | |
| 23:53 | This is part of the previous check-in that didn't get committed for some reason - probably because I failed to press the "Save" button on the text editor. (check-in: 51d32173 user: drh tags: trunk) | |
| 21:14 | Add another test case to cover a previously uncovered branch in the RBU module. (check-in: 30392985 user: dan tags: trunk) | |
| 19:55 | Fix another pattern for which the LIKE optimization does not work for a non-TEXT affinity. Case found by Manuel Rigger. (check-in: 74020110 user: drh tags: trunk) | |
| 19:32 | Simplification to the logic underlying PRAGMA case_sensitive_like. (check-in: ef0015fd user: drh tags: trunk) | |
| 19:06 | Avoid an excess register allocation in UPDATE, when possible. This improves speed (slightly) and reduces the code footprint. (check-in: 8658574e user: drh tags: trunk) | |
| 18:49 | Add tests to improve code coverage of the RBU module. (check-in: ecb56b75 user: dan tags: trunk) | |
| 17:27 | Provide the SQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA compile-time option to omit the case_sensitive_like pragma. This change, in combination with documentation changes, is the current solution to ticket [a340eef47b0cad5]. (check-in: eabe7f2d user: drh tags: trunk) | |
| 11:52 | Fix VDBE opcodes OP_SeekLT and OP_SeekLE so that they work on intkey tables with non-numeric text values. Fix for [9cf6c9bb]. (check-in: 658b84d7 user: dan tags: trunk) | |
| 11:42 | Fix VDBE opcodes OP_SeekLT and OP_SeekLE so that they work on intkey tables with non-numeric text values. (Closed-Leaf check-in: a870c196 user: dan tags: tkt-9cf6c9bb) | |
| 04:33 | Remove an ALWAYS() that was previously added by check-in [a0819086] but which turns out can sometimes be false. (check-in: ad8fc5d8 user: drh tags: trunk) | |
| 03:34 | Remove a NEVER() that was added in the previous check-in [a0819086a521f] because it is in fact reachable. (check-in: 74eba255 user: drh tags: trunk) | |
| 00:17 | Earlier detections of errors in the byte-offset-to-cell-content integer at offset 5 in the header of a btree page. (check-in: a0819086 user: drh tags: trunk) | |
|
2019-05-07
| ||
| 20:06 | Generate all records for INSERT or UPDATE prior to running foreign key constraint checks, since the FK checks might modify the datatype of registers used to generate the records. Fix for ticket [e63cbcfd3378afe6980d6]. (check-in: 3c75605b user: drh tags: trunk) | |
| 19:44 | Do not commit an "OR FAIL" statement that causes foriegn key constraint violations. (check-in: 659c551d user: dan tags: trunk) | |
| 19:21 | Add test cases for the fix on this branch. (Closed-Leaf check-in: 2e31abe0 user: dan tags: tkt-e63cbcfd) | |
| 19:13 | On an INSERT or UPDATE, generate the new table record prior to running foreign key checks, in case the foreign key checks changes datatypes on the registers holding column values. Proposed fix for ticket [e63cbcfd3378afe6980d626]. (check-in: 3f1c8051 user: drh tags: tkt-e63cbcfd) | |
| 17:47 | Strive to prevent harmless compiler warnings in GCC 4.8.5. (check-in: 8b6691f6 user: drh tags: trunk) | |
| 16:37 | Optimize the restarting of an RBU vacuum. (check-in: 82062351 user: dan tags: trunk) | |
| 16:28 | Remove some redundant code from sqlite3rbu.c. Add test cases for RBU vacuum. (Closed-Leaf check-in: 7b051698 user: dan tags: rbu-opt) | |
|
2019-05-06
| ||
| 20:40 | Optimize further cases of restarting an RBU vacuum. (check-in: 6b3261bf user: dan tags: rbu-opt) | |
| 16:15 | Fix a problem with renaming an INTEGER PRIMARY KEY column of a WITHOUT ROWID table using ALTER TABLE. (check-in: 91f701d3 user: dan tags: trunk) | |
|
2019-05-04
| ||
| 20:04 | Optimize some cases of restarting an RBU vacuum. (check-in: cdc09867 user: dan tags: rbu-opt) | |
| 17:32 | Fix the NOT NULL logic in the theorem prover that determines when a partial index can be used. Ticket [5c6955204c392ae763a95]. (check-in: c2e439bc user: drh tags: trunk) | |
| 03:56 | Fix harmless compiler warning seen with MSVC. (check-in: 5862b83e user: mistachkin tags: trunk) | |
| 01:41 | In the sqlite3_value or Mem object, make the MEM_IntReal type completely independent from MEM_Int and MEM_Real. This helps avoid problems when inserting non-float values into a "REAL" column. (check-in: 5a8a23ee user: drh tags: trunk) | |
| 01:29 | New testcase macros to ensure that MEM_IntReal is fully tested. (Closed-Leaf check-in: 8b8ef445 user: drh tags: int-real) | |
|
2019-05-03
| ||
| 21:17 | Add the SQLITE_TESTCTRL_RESULT_INTREAL test-control and use it to create the intreal() SQL function in testfixture. Write a few simple tests to prove this all works. TH3 will hold most of the INTREAL tests, probably. (check-in: c9838731 user: drh tags: int-real) | |
| 19:34 | Ensure that UTF16 strings are properly zero-terminated before returning them in an sqlite3_value_text16() request, even if the string is invalid UTF16 because it was formed from an arbitrary and/or odd-length BLOB. (check-in: 3a16ddf9 user: drh tags: trunk) | |
| 18:50 | Fix a memory-leak/segfault caused by using OP_OpenDup and OP_OpenEphemeral on the same VM cursor. (check-in: a9b90aa1 user: dan tags: trunk) | |
| 17:19 | Fix a problem where self-joins on views that are aggregate queries may return the wrong result. (check-in: 74ef97bf user: dan tags: trunk) | |
| 17:08 | Improved comments on the elements of the array constant used to implement the sqlite3_value_type() interface. (check-in: f73a7de7 user: drh tags: int-real) | |
| 02:41 | Fix the ".open --hexdb" command in the CLI so that it works even with terminal input. (check-in: 9b5d9434 user: drh tags: trunk) | |
|
2019-05-02
| ||
| 21:36 | Make MEM_IntReal a completely independent type, meaning a floating point value stored as an integer. This fixes a problem with arithmetic within arguments to string functions on indexes of expressions. But it is a big change and needs lots of new testcase() macros for MC/DC and so it is initially put on this branch. (check-in: dba836e3 user: drh tags: int-real) | |
| 17:45 | Ensure that the typeof() function always returns SQLITE_FLOAT for floating point values even when the value is stored as an integer to save space. (check-in: 48889530 user: drh tags: trunk) | |
| 17:06 | Add options to wapptest.tcl similar to those supported by releasetest.tcl. Also add the -noui switch, for running without wapp altogether. (check-in: 005a1694 user: dan tags: trunk) | |
| 15:56 | Earlier detection of a database corruption case in balance_nonroot(), to prevent a possible use of an uninitialized variable. (check-in: c509d8a8 user: drh tags: trunk) | |
| 14:15 | Merge enhancements from trunk (check-in: 3a4751a9 user: drh tags: hard-heap-limit) | |
| 01:41 | The "LIKE Optimization" (which converts a LIKE into a BETWEEN operator that is able to use an index) does not work and cannot be used if the collating sequence of the column is not TEXT and if the pattern starts with a "+" sign. This is another case of ticket [c94369cae9b561b1f996d005]. The new test case was discovered by Manuel Rigger. (check-in: b043a54c user: drh tags: trunk) | |
| 00:52 | Fix an issue (discovered by OSSFuzz) in the enhanced OP_Concat operator from check-in [713caa382cf7dd] earlier today. (check-in: 3e897702 user: drh tags: trunk) | |
|
2019-05-01
| ||
| 19:01 | Add a test case for ticket [ae0f637bddc5290b44669e066a]. (check-in: ece48169 user: drh tags: trunk) | |
| 18:59 | When values have real affinity and are converted into strings for CHECK constraints or index expressions, do the conversions into a real-number format even if the values are stored as integers for efficiency. This appears to fix ticket [ae0f637bddc5290b446]. (check-in: 5997d075 user: drh tags: trunk) | |
| 17:36 | Fix an incompatibility with -DSQLITE_OMIT_LOAD_EXTENSION=1 in dbdata.test. (check-in: a77cd85b user: dan tags: trunk) | |
| 17:32 | Fix a case in wapptest.tcl where a failed test might report 0 errors. (check-in: 2be1ed70 user: dan tags: trunk) | |
| 15:32 | Avoid unwelcomed side effects on the input operands in the OP_Concat operator. Fix for ticket [3be1295b264be2fac49b681] (check-in: 713caa38 user: drh tags: trunk) | |
| 15:25 | Update wapptest.tcl so that it deletes extra files if the "Keep files:" checkbox is clear. Set it by default. (check-in: 09623cc4 user: dan tags: trunk) | |
| 14:41 | In "PRAGMA vdbe_trace" output, show the results of OP_Affinity opcodes. (check-in: 56604bb6 user: drh tags: trunk) | |
| 08:48 | Fix an incompatibility with auto-vacuum mode in new test script recover.test. (check-in: 36dd5b08 user: dan tags: trunk) | |
|
2019-04-30
| ||
| 20:43 | Update wapptest.tcl to use a simpler slave script. And to leave scripts wapptest_configure.sh and wapptest_make.sh in each test directory. (check-in: 07e527d7 user: dan tags: trunk) | |
| 15:36 | Fix a problem allowing a Table object to be deleted from within a call to the xDestroy method of the associated virtual table, causing a use-after-free error. (check-in: 1dbbb010 user: dan tags: trunk) | |
| 14:26 | Fix an error message in the Lemon parser generator. (check-in: b6d7d42b user: drh tags: trunk) | |
| 11:54 | Small performance increase and size reduction in the implementation of the LIKE and GLOB operators. (check-in: f97626f9 user: drh tags: trunk) | |
| 01:08 | Slightly smaller and faster implementation of the OP_MakeRecord opcode. (check-in: 3bdce7ef user: drh tags: trunk) | |
|
2019-04-29
| ||
| 16:44 | Changes to oserror.test so that it works even on systems that allow an unusually large number of file descriptors. (check-in: a27b0b88 user: drh tags: trunk) | |
| 13:48 | Do not de-duplicate columns index columns associated with a WITHOUT ROWID table if the columns have different collating sequences. This is the fix for ticket [3182d3879020ef3b2]. There is one test case added, but most of the tests are done in TH3. (check-in: 1b1dd4d4 user: drh tags: trunk) | |
| 13:30 | Improved header comment and precondition checking for the new isDupColumn() function. (Closed-Leaf check-in: 740d5ff6 user: drh tags: tkt-3182d38790) | |
| 11:41 | Fix a buffer overwrite in shell.c.in (part of the new .recover code). (check-in: 92facbc7 user: dan tags: trunk) | |
| 11:27 | Fix a stack overflow that could occur when renaming a table that has a trigger containing a window function invocation that itself contains a specific syntax error. (check-in: c621fc66 user: dan tags: trunk) | |
|
2019-04-28
| ||
| 19:27 | Take collating sequence into account when removing redundant columns from indexes on WITHOUT ROWID tables. This is the first proof-of-concept fix for ticket [3182d3879020ef3]. More testing needed. (check-in: b34fa5bf user: drh tags: tkt-3182d38790) | |
|
2019-04-27
| ||
| 20:39 | Add the shardvtab virtual table that uses the new cost estimation functions. (Leaf check-in: 9404300a user: drh tags: cost-est) | |
| 20:30 | Add the ".recover" command to the shell tool. For recovering as much data as possible from corrupt databases. (check-in: 50fe4845 user: dan tags: trunk) | |
| 20:16 | Fix a minor typo in a comment. No changes to code. (check-in: 95209072 user: drh tags: trunk) | |
| 20:15 | Fix building the shell with SQLITE_OMIT_VIRTUAL_TABLE. And without SQLITE_ENABLE_DBPAGE_VTAB. (Closed-Leaf check-in: 425d708c user: dan tags: dbdata) | |
| 19:36 | Add comments and fix formatting issues in new code in shell.c.in. (check-in: b91d819b user: dan tags: dbdata) | |
| 18:47 | Add the "--lost-and-found" option to the ".recover" command. For setting the name of the orphaned rows table. (check-in: 67bb88e2 user: dan tags: dbdata) | |
| 15:35 | Fix a problem in the .recover command with recovering WITHOUT ROWID tables where the PK columns are not the leftmost in the CREATE TABLE statement. (check-in: 91df4b8e user: dan tags: dbdata) | |
|
2019-04-26
| ||
| 21:11 | Have .recover store all orphaned rows in a single table, with extra columns to indicate the orphaned page and sub-tree they were discovered within. (check-in: 7221f6e3 user: dan tags: dbdata) | |
| 17:20 | An experimental interface for retrieving the estimated cost and estimated number of output rows for a query. (check-in: 1b25fa10 user: drh tags: cost-est) | |
| 17:08 | Omit tests of the LIKE optimization in like3.test when SQLITE_ENABLE_ICU is defined. (check-in: af53c41a user: dan tags: trunk) | |
| 15:40 | Fix another problem with database freelist handling in the ".recover" command. (check-in: bee2652a user: dan tags: dbdata) | |
| 15:14 | Fix a locking-page related problem with the ".recover" command. (check-in: afdae104 user: dan tags: dbdata) | |
|
2019-04-25
| ||
| 20:06 | Merge latest trunk changes into this branch. (check-in: 1da302d8 user: dan tags: dbdata) | |
| 19:23 | Unless the "--freelist-corrupt" option is specified, do not have the .recover command attempt to recover data from pages that are on the database free-list. (check-in: 8d2f52bb user: dan tags: dbdata) | |
| 18:15 | Add the sqlite3_hard_heap_limit64() interface and the corresponding "PRAGMA hard_heap_limit=N" command. (check-in: b0ccef61 user: drh tags: hard-heap-limit) | |
| 16:20 | Fix a bug preventing .recover from working on databases where the final page of the db is corrupt. (check-in: 959bbd11 user: dan tags: dbdata) | |
|
2019-04-24
| ||
| 20:48 | Improve the performance of the .recover command. (check-in: a5076831 user: dan tags: dbdata) | |
| 17:04 | New test cases in test/fuzzdata8.db. (check-in: 7be6222c user: drh tags: trunk) | |
| 16:13 | Fix another instance in fts3 where a corrupt record can cause a buffer overflow. (check-in: e1724f1d user: dan tags: trunk) | |
| 15:57 | Fix a problem in fts5 where a corrupt position list could lead to a buffer overwrite. (check-in: 516ca894 user: dan tags: trunk) | |
| 15:13 | Fix an error in fts3_write.c allowing a corrupt database to cause a crash. (check-in: 6e4a5f22 user: dan tags: trunk) | |
| 04:53 | Correction to the #if in the previous check-in. (check-in: 30dc05ac user: mistachkin tags: trunk) | |
| 00:37 | Fix for 8-byte alignment asserts that can trigger in some circumstances with 32-bit MSVC. (check-in: 4c02832e user: mistachkin tags: trunk) | |
|
2019-04-23
| ||
| 22:00 | Make no atttempt to generate VDBE code for VACUUM after a syntax error. (check-in: 93084247 user: drh tags: trunk) | |
| 20:48 | Have ".recover" handle "\r" and "\n" in the same way as ".dump". (check-in: f95f0f02 user: dan tags: dbdata) | |
| 18:03 | Fixes for the ".recover" shell command. (check-in: 8dcc1d89 user: dan tags: dbdata) | |
| 15:30 | Changes to the --hexdb decoder option in the shell (and also in the TCL test code) so that it works on systems where sscanf() does not recognize "%hhx" as wanting to delivery results into a character-size variable. (check-in: 4258e42d user: drh tags: trunk) | |
| 15:21 | Minor simplification of NULL value handling for STAT4. Cherrypick of [69bad9257f8db6a2] from trunk. (check-in: 442c177d user: mistachkin tags: branch-3.28) | |
| 15:08 | Minor simplification of NULL value handling for STAT4. (check-in: 69bad925 user: mistachkin tags: trunk) | |
| 12:31 | New test cases in fuzzdata8.db. (check-in: 0fe3c3fd user: drh tags: trunk) | |
| 12:30 | Improvement on the previous check-in. Parse.rc is less reliable than Parse.nErr for detecting SQLITE_TOOBIG errors. (check-in: 8d478cfb user: drh tags: trunk) | |
|
2019-04-22
| ||
| 20:52 | Enhance the ".recover" command. Fix a problem with overflow pages in dbdata.c. (check-in: f193ca58 user: dan tags: dbdata) | |
| 20:05 | Early detection of SQLITE_TOOBIG when processing nested queries. (check-in: 5d85d80e user: drh tags: trunk) | |
| 11:47 | Fix an assert() that may be false for corrupt databases. (check-in: b2ce5ed1 user: dan tags: trunk) | |
|
2019-04-20
| ||
| 20:57 | Add the ".recovery" command to the shell tool. For recovering the maximum amount data from corrupt databases. Still needs work. (check-in: 7461d2e1 user: dan tags: dbdata) | |
|
2019-04-19
| ||
| 23:05 | Mark a single branch as no longer reachable. (check-in: 4f35b3b7 user: drh tags: trunk) | |
| 22:01 | Increase the version number to 3.29 for the next development cycle. (check-in: 6cf16703 user: drh tags: trunk) | |
| 18:10 | Mark two branches as unreachable. Oops - one of those branches was reachable via fuzzcheck tests. (Closed-Leaf check-in: 9b888fcc user: drh tags: mistake) | |
| 17:26 | Improved optimization of the AND and OR operators. (check-in: 0fbd154e user: drh tags: trunk) | |
| 16:34 | Fix a problem with renaming a table that starts with "sqlite". Fix for ticket [f00d7b65]. (check-in: a2ead8aa user: dan tags: trunk) | |
| 16:21 | Use macros to determine if an expression is always true or always false. (check-in: 6de980a0 user: drh tags: trunk) | |
| 13:38 | Streamline the processing of the AND operator. Slightly smaller and faster. (check-in: 7713996a user: drh tags: trunk) | |
|
2019-04-18
| ||
| 21:14 | Add the sqlite_dbptr virtual table to the dbdata extension. For querying the links between b-tree pages. (check-in: 3213a15f user: dan tags: dbdata) | |
| 19:21 | Minor simplification of NULL value handling for STAT4. (Closed-Leaf check-in: 5718a9d5 user: mistachkin tags: nullStat4) | |
| 17:37 | Undo change to 'analyze9.test' because the extra output can be useful for debugging. (Leaf check-in: f3081e59 user: mistachkin tags: msvc) | |
|
2019-04-17
| ||
| 23:56 | Fix a couple minor test issues. (check-in: 1f1866d1 user: mistachkin tags: msvc) | |
| 23:32 | Work around lack of a C99 feature in MSVC. (check-in: f6ebe1c2 user: mistachkin tags: msvc) | |
| 21:17 | Add the experimental dbdata extension. (check-in: a3ab5883 user: dan tags: dbdata) | |
| 21:12 | Small performance and size optimization in sqlite3WalFindFrame(). (check-in: 03f2e788 user: drh tags: trunk) | |
| 13:58 | Fix a typo in the CLI help output for the ".dump" command. (check-in: 57638248 user: drh tags: trunk) | |
| 13:23 | In the "pgidx" report from "showdb", also show the number of rows on each database btree page. (check-in: 2bda9dc4 user: drh tags: trunk) | |
| 12:29 | In the "pgidx" command of the showdb utility, try to identify orphaned pages and show when pages have been zeroed out. (check-in: eed701ef user: drh tags: trunk) | |
| 12:07 | Small performance improvement on the variable-length integer decoder: sqlite3GetVarint(). (check-in: 5df2bf62 user: drh tags: trunk) | |
| 11:34 | Faster and smaller implementation of sqlite3StrICmp(). (check-in: 7ac500fb user: drh tags: trunk) | |
|
2019-04-16
| ||
| 19:49 | Version 3.28.0 (check-in: 884b4b7e user: drh tags: trunk, release, version-3.28.0) | |
| 11:21 | Avoid a sanitizer error (pointer arithmatic overflow) in vdbesort.c. (check-in: af61a2fc user: dan tags: trunk) | |
| 10:51 | Avoid a sanitizer error in test1.c. Have releasetest.tcl/wapptest.tcl create a file called "makecommand.sh" that can be used to rerun a test from the command line. (check-in: 4de4480f user: dan tags: trunk) | |
|
2019-04-15
| ||
| 19:17 | Fix a bug in test module test_fs.c causing a segfault on OpenBSD. (check-in: ee886600 user: dan tags: trunk) | |
| 15:41 | Fix a problem with the user-auth extension and deserializing in-memory databases. (check-in: 09fa0b3c user: dan tags: trunk) | |
| 15:35 | Merge recent changes from trunk into reuse-schema (check-in: 5c6c9e7f user: drh tags: reuse-schema) | |
| 15:28 | Merge all recent enhancements. (check-in: 1cd536ec user: drh tags: begin-concurrent-pnu-wal2) | |
| 15:17 | Merge the latest trunk enhancements. (check-in: 8950f119 user: drh tags: wal2) | |
| 15:07 | Merge the latest enhancements from trunk. (check-in: 6caaaf21 user: drh tags: begin-concurrent-pnu) | |
| 14:59 | Merge the latest enhancements from trunk. (check-in: 7c328e88 user: drh tags: begin-concurrent) | |
| 14:49 | Bring in the latest enhancements from trunk. (check-in: 378230ae user: drh tags: apple-osx) | |
| 13:59 | Fix a test script problem in fts5corrupt3.test. (check-in: 734192d8 user: dan tags: trunk) | |
| 13:51 | Update tool/symbols.sh to ignore symbols from sessions and rebaser and to not try to compile with ICU which is not available on all platforms. (check-in: 0bab4ece user: drh tags: trunk) | |
|
2019-04-14
| ||
| 00:40 | Remove a stray tab from the source code. (check-in: 0ada58e9 user: drh tags: trunk) | |
| 00:34 | Fix an obsolete comment and other minor issues from code inspection. (check-in: cd084427 user: drh tags: trunk) | |
|
2019-04-13
| ||
| 16:50 | Fix a harmless compiler warning in test logic. (check-in: c3932e66 user: drh tags: trunk) | |
| 16:43 | Fix the fts3varint.test script so that it works even on versions of TCL for which Tcl_GetWideIntFromObj() does not work. (check-in: 53f787ad user: drh tags: trunk) | |
| 16:35 | Fix a test script problem in fts5corrupt3.test. (check-in: 858f6227 user: dan tags: trunk) | |
| 15:07 | Partially revert the test file changes in [4371a0c46e]. It is no longer required following [93ae382e97c23c90]. (check-in: 593a7e6e user: dan tags: trunk) | |
| 14:17 | Fix additional compiler warnings introduced by the previous check-in and found by MSVC. (check-in: 6fc0deff user: drh tags: trunk) | |
| 14:07 | Fixes for harmless compiler warnings. (check-in: c28c973a user: drh tags: trunk) | |
| 04:38 | Use the 64-bit memory allocator interfaces in extensions, whenever possible. (check-in: 07ee06fd user: drh tags: trunk) | |
| 04:01 | Enforce the SQLITE_LIMIT_COLUMN limit on virtual tables. (check-in: 0b6ae032 user: drh tags: trunk) | |
|
2019-04-12
| ||
| 20:33 | Add the socketvfs test extension. (Leaf check-in: f5b3ce94 user: dan tags: socketvfs) | |
| 16:25 | Test case changes so that they work with both Tcl8.6 and Tcl8.7. (check-in: 7b771405 user: drh tags: trunk) | |
| 13:40 | Tweaks to wapptest.tcl: Ensure that the "Debug" checkbox is disabled unless the app is in "config" state, and have Debug variants run "test" instead of "fulltest". (check-in: dd248c18 user: dan tags: trunk) | |
| 12:10 | Fix minor problems in tcl test scripts. (check-in: 56b66418 user: dan tags: trunk) | |
|
2019-04-11
| ||
| 19:07 | Add the test/wapptest.tcl script, an alternative to releasetest.tcl that uses wapp to provide the user-interface. (check-in: edd87cd6 user: dan tags: trunk) | |
| 19:04 | Merge trunk changes into this branch. (Closed-Leaf check-in: d805fc0c user: dan tags: wapptest) | |
| 19:03 | Further tweaks to wapptest.tcl. Add the ability to run the extra (n)debug tests that releasetest.tcl runs. (check-in: ec9c4f6d user: dan tags: wapptest) | |
| 17:06 | Remove the vfslog.c extension from the testfixture target in main.mk, as that extension has no TCL bindings and is inaccessible. (check-in: d71f8bbc user: drh tags: trunk) | |
| 16:54 | Fix RBU so that it does not write rows that should be excluded into partial indexes (corrupting the database). (check-in: 31eb27f4 user: dan tags: trunk) | |
| 06:50 | Fix the checksymbols target in Makefile.in. (check-in: 1956eb34 user: dan tags: wapptest) | |
|
2019-04-10
| ||
| 19:45 | Have wapptest.tcl display the name, OS and architecture of the host. (check-in: c47e53b4 user: dan tags: wapptest) | |
| 18:56 | Various fixes for the wapptest.tcl script. (check-in: cbf42365 user: dan tags: wapptest) | |
| 18:29 | Update the list of OMIT options in the omittest.tcl script. (check-in: f294cfc1 user: drh tags: trunk) | |
| 13:24 | Further refinement of the sqlite3VdbeMEmExpandBlob() fix of check-in [df58774e994bd] to prevent a reference to an unused variable - problem discovered by Valgrind. (check-in: 09435b57 user: drh tags: trunk) | |
| 12:02 | Change the name of some internal testing interfaces to avoid a name conflict in AIX. (check-in: c1cae7e7 user: drh tags: trunk) | |
| 00:58 | Do not place arbitrary restrictions on the length of the failure message for a uniqueness constraint. (check-in: 037da798 user: drh tags: trunk) | |
|
2019-04-09
| ||
| 21:37 | New test case for SQLITE_TOOBIG errors. (check-in: 4c77fbbe user: drh tags: trunk) | |
| 21:32 | Improved reporting of SQLITE_TOOBIG errors while parsing. (check-in: ea2d4b65 user: drh tags: trunk) | |
| 20:50 | Fix a problem caused by a small SQLITE_LIMIT_LENGTH value and a CREATE TABLE with a very large name. (Closed-Leaf check-in: 9b5d4088 user: dan tags: toobig-fix) | |
| 19:53 | Add test/wapptest.tcl, a wapp alternative to releasetest.tcl. (check-in: a4af0c2f user: dan tags: wapptest) | |
| 01:26 | Use an unsigned integer to count free pages in btree.c:freePage2(). (check-in: 88204085 user: drh tags: trunk) | |
|
2019-04-07
| ||
| 18:21 | Make the testcase() macro added in the previous check-in reachable for testing. (check-in: 80704a16 user: drh tags: trunk) | |
| 18:04 | Fix a faulty assert() in the sqlite3VdbeMemExpandBlob() routine. (check-in: df58774e user: drh tags: trunk) | |
|
2019-04-06
| ||
| 15:38 | Fix two assert() statements in fts5 that are only true if the database is not corrupt. (check-in: edb095a9 user: dan tags: trunk) | |
|
2019-04-05
| ||
| 21:17 | Remove some stale references to the addopcodes.tcl script from documentation. (check-in: c0381b0b user: drh tags: trunk) | |
| 20:56 | Eliminate the tool/addopcodes.tcl script. The purpose of that script was to keep the number of parser codes below 256 in order to save parser table space. But we have long since blown through that ceiling so the addopcodes.tcl script was just needless complexity. There is no longer any reason to keep it around. (check-in: d2728192 user: drh tags: trunk) | |
| 20:47 | Add further tests so that veryquick.test covers all vdbe branches. (check-in: cbc67de5 user: dan tags: trunk) | |
| 17:22 | Improved comment on the sqlite3FaultSim() function. No changes to code. (check-in: 08b29672 user: drh tags: trunk) | |
| 16:52 | In the test_vfs.c VFS, if a Tcl xWrite script returns "SQLITE_OMIT", silently omit the write() call. (check-in: 8b5a621e user: dan tags: trunk) | |
| 16:38 | Add the ability to override the new corruption detection logic of the previous checkin, in order to exercise downstream corruption detection during testing. (check-in: e859d318 user: drh tags: trunk) | |
| 15:44 | In the xfer-optimization, do early detection of when the source and destination index share the same btree, to avoid a long delay prior to reporting the database corruption. (check-in: af1e5873 user: drh tags: trunk) | |
|
2019-04-04
| ||
| 22:05 | Add the vtab enable/disable options to the sqlite3_db_config TCL command in the testfixture. (Leaf check-in: c7052428 user: drh tags: disable-vtab) | |
| 21:40 | Merge all the latest changes and enhancements from trunk. (check-in: 521d5186 user: drh tags: apple-osx) | |
| 20:55 | Add further test cases to improve VDBE branch coverage. (check-in: 51a95e52 user: dan tags: trunk) | |
| 20:21 | Provide a DBCONFIG to enable or disable virtual tables that match a LIKE pattern. (check-in: b40a4edc user: drh tags: disable-vtab) | |
| 19:21 | Fix a typo in the documentation for sqlite3_value_frombind(). Also add a new hyperlink to that same documentation. No code changes. (check-in: bf3cd936 user: drh tags: trunk) | |
| 18:20 | Minor fixes to requirements marks. (check-in: 02ebc60b user: drh tags: trunk) | |
| 17:58 | Add test cases to improve coverage of VDBE branches. Still some to go. (check-in: 4cef609d user: dan tags: trunk) | |
| 17:39 | Correctly initialize the loadable extension thunk. (check-in: 4fca46de user: drh tags: trunk) | |
| 15:25 | Simplification of the recent VACUUM changes that make the code more like what it was before the change. Also, make the VACUUM command a no-inline procedure to work around a performance regression. (check-in: 9cac5ac1 user: drh tags: trunk) | |
| 14:36 | Fix an incorrect comment on a test case for rowid renumbering in VACUUM. (check-in: 0d293fb4 user: drh tags: trunk) | |
| 14:00 | Only preserve rowid values for VACUUM INTO. Keep the legacy behavior of renumbering rowids for ordinary VACUUM. (check-in: 13a0ea64 user: drh tags: trunk) | |
|
2019-04-03
| ||
| 17:48 | Add a defense-in-depth NEVER() test to the WAL cleanup code. (check-in: 8d3af201 user: drh tags: trunk) | |
| 16:27 | Fix a couple of problems with "RANGE BETWEEN <expr> PRECEDING AND <expr> PRECEDING" frames. (check-in: 39225cc7 user: dan tags: trunk) | |