Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
97 events for the month beginning 2019-06-01
Following month ↑|
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) | |
| 15:35 | • Edit [567b13093956185b|567b1309]: Edit check-in comment. (artifact: fed869ac user: dan) | |
| 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:52 | • Fixed ticket [b1d8c793]: LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column plus 6 other changes (artifact: 974e3f5c user: dan) | |
| 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) | |
| 11:28 | • New ticket [b1d8c793] LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column. (artifact: 899d46d1 user: mrigger) | |
| 00:14 | • New ticket [fd76310a] TEXT value interpreted as column name in an index with empty list in an IN expression. (artifact: 683171cb user: mrigger) | |
|
2019-06-08
| ||
| 21:31 | • New ticket [dd6bffbf] CAST to NUMERIC no longer converts to INTEGER. (artifact: f550c0f0 user: mrigger) | |
|
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 | • Fixed ticket [4c2d7639]: CAST('-' AS NUMERIC) computes 0.0 plus 6 other changes (artifact: 2c9d148c user: drh) | |
| 22:26 | • Fixed ticket [e8bedb2a]: Incorrect result when subtracting a large integer number from a TEXT value plus 6 other changes (artifact: 8ea84fcb user: drh) | |
| 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) | |