Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around c4b405687b010ee2.
|
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:03 | • Closed ticket [9ece23d2]: Default collation sequences and affinities lost when window function added to query plus 3 other changes (artifact: 295dff1c user: dan) ... 1 similar event omitted. | |
| 12:01 | Ensure collation sequences and affinities work in window function queries. Fix for [9ece23d2]. (check-in: 28196d89 user: dan tags: trunk) | |
| 11:50 | • Ticket [9ece23d2] Default collation sequences and affinities lost when window function added to query status still Open with 6 other changes (artifact: e496cf62 user: dan) ... 1 similar event omitted. | |
|
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:12 | • Added wiki page "branch/tkt9b78184b-alt" (artifact: 8acb2716 user: dan) | |
| 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-27
| ||
| 02:23 | • Fixed ticket [9cdc5c46]: Incorrect result from second execution of correlated scalar sub-query that uses a partial sort plus 6 other changes (artifact: 694cf21b user: drh) | |
|
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) | |
| 20:00 | • New ticket [9cdc5c46] Incorrect result from second execution of correlated scalar sub-query that uses a partial sort. (artifact: 1f188ca2 user: dan) | |
|
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:57 | • Fixed ticket [e1e07ef2]: COLLATE in BETWEEN expression is ignored plus 6 other changes (artifact: 97ce28ab user: drh) | |
| 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 | • Edit [ba7870e292919cf6|ba7870e2]: Edit check-in comment. (artifact: a1f749eb user: dan) | |
| 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
| ||
| 21:41 | • New ticket [e1e07ef2] COLLATE in BETWEEN expression is ignored. (artifact: 1c102a81 user: mrigger) | |
| 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:25 | • Fixed ticket [f1580ba1]: Built-in RTRIM collating sequence yields incorrect comparisons plus 8 other changes (artifact: 71c96e66 user: drh) | |
| 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:29 | • Fixed ticket [ce8717f0]: LIKE malfunctions for UNIQUE COLLATE NOCASE column plus 6 other changes (artifact: 751df5f0 user: drh) | |
| 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) | |
| 11:03 | • New ticket [f1580ba1] Row is not fetched in WITHOUT ROWID table and a composite primary key. (artifact: 253e38a4 user: mrigger) | |
| 10:01 | • New ticket [ce8717f0] LIKE malfunctions for UNIQUE COLLATE NOCASE column. (artifact: 81eff856 user: mrigger) | |
|
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:53 | • Fixed ticket [674385ae]: CAST('-0.0' AS NUMERIC) computes 0.0 rather than 0 plus 4 other changes (artifact: bacc0175 user: drh) | |
| 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:32 | • Fixed ticket [b148fa61]: CAST takes implicit COLLATE of its operand plus 8 other changes (artifact: bed43b4e user: drh) | |
| 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) | |
| 15:37 | • New ticket [b148fa61] CAST takes implicit COLLATE of its operand. (artifact: 985e96ae user: mrigger) | |
| 14:12 | • Ticket [674385ae] CAST('-0.0' AS NUMERIC) computes 0.0 rather than 0 status still Open with 3 other changes (artifact: e0c5eb96 user: mrigger) | |
| 13:50 | • Closed ticket [4d01eda8]: IS TRUE operator malfunctions with COLLATE and REAL value plus 6 other changes (artifact: 75b45c09 user: dan) | |
| 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) | |
| 13:25 | • Ticket [674385ae] CAST('-0.0' AS NUMERIC) computes 0.0 rather than 0 status still Open with 7 other changes (artifact: e68e7d16 user: drh) ... 1 similar event omitted. | |
| 12:41 | • New ticket [4d01eda8] IS TRUE operator malfunctions with COLLATE and REAL value. (artifact: 9726435c user: mrigger) | |
|
2019-06-11
| ||
| 21:02 | • Fixed ticket [0c620df6]: LIKELY(), UNLIKELY() and LIKELIHOOD() have affinities plus 6 other changes (artifact: dd95f0b1 user: drh) | |
| 21:02 | The affinity of the unlikely() function and its cousins should be "none". Ticket [0c620df60bffd9ef] (check-in: 614ecb0a user: drh tags: trunk) | |
| 19:24 | • New ticket [0c620df6] LIKELY(), UNLIKELY() and LIKELIHOOD() have affinities. (artifact: f0e85800 user: mrigger) | |
| 18:08 | • Fixed ticket [57353f82]: COLLATE expression in the right side of an IN operator results in an affinity conversion plus 6 other changes (artifact: 1e6103e9 user: drh) | |
| 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) | |
| 16:02 | • Closed ticket [afdc5a29]: Lossless conversion when casting a large TEXT number to NUMERIC is not performed plus 8 other changes (artifact: 0d2ad198 user: drh) ... 1 similar event omitted. | |
| 13:43 | • Fixed ticket [1819598c]: -'1.0' computes -1.0 rather than -1 plus 7 other changes (artifact: 070c1634 user: drh) | |
| 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) | |
| 11:50 | • New ticket [57353f82] COLLATE expression in the right side of an IN operator results in an affinity conversion. (artifact: 0e9aa5fa user: mrigger) | |
| 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) | |
| 09:47 | • New ticket [1819598c] -'1.0' computes -1.0 rather than -1. (artifact: 20490a7c user: mrigger) | |
| 03:00 | • Fixed ticket [d60b3cd7]: COLLATE expression has an affinity plus 8 other changes (artifact: 8270b2b9 user: drh) | |
| 02:43 | • Fixed ticket [533010b8]: Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" plus 3 other changes (artifact: e17361d2 user: drh) | |
| 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 | • Fixed ticket [412bba9b]: CAST('.' AS NUMERIC) computes 0.0 rather than 0 plus 6 other changes (artifact: f3f09094 user: drh) | |
| 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) | |
| 21:58 | • Open ticket [533010b8]: Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" plus 3 other changes (artifact: f065e4ab user: mrigger) | |
| 20:46 | • New ticket [d60b3cd7] COLLATE expression has an affinity. (artifact: 17666839 user: mrigger) | |
| 19:53 | • New ticket [412bba9b] CAST('.' AS NUMERIC) computes 0.0 rather than 0. (artifact: 27de8237 user: mrigger) | |
| 19:18 | • Closed ticket [533010b8]: Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" plus 6 other changes (artifact: 8f1e4544 user: dan) | |
| 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 | • Fixed ticket [5e0423b0]: xAccess behaviour is not documented, changed in Windows 3.7.0 plus 3 other changes (artifact: c703cfe1 user: drh) | |
| 19:07 | Improvements to the documentation for the xAccess method of the VFS. Ticket [5e0423b058fa5adf] (check-in: 7078d77e user: drh tags: trunk) | |
| 18:51 | • Closed ticket [31c6e64f]: ALTER TABLE fails if a trigger references a non-existant table. plus 6 other changes (artifact: d4a0d54d user: drh) | |
| 18:33 | • Fixed ticket [dd6bffbf]: CAST to NUMERIC no longer converts to INTEGER plus 3 other changes (artifact: b853530b user: drh) | |
| 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) | |
| 18:27 | • Ticket [dd6bffbf] CAST to NUMERIC no longer converts to INTEGER status still Open with 7 other changes (artifact: 7bfbf7b8 user: drh) | |
| 18:15 | • New ticket [533010b8] Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()". (artifact: 0aff6c3f user: mrigger) | |
| 15:35 | • Closed ticket [fd76310a]: TEXT value interpreted as column name in an index with empty list in an IN expression plus 5 other changes (artifact: f453906c user: dan) | |