Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around 3ba6f790e029f8c6.
|
2019-06-11
| ||
| 16:06 | Off-by-one error in the CAST to NUMERIC logic. (check-in: 25b8963020 user: drh tags: trunk) | |
| 16:02 | • Closed ticket [afdc5a29dc]: Lossless conversion when casting a large TEXT number to NUMERIC is not performed plus 8 other changes (artifact: 0d2ad198e6 user: drh) ... 1 similar event omitted. | |
| 13:43 | • Fixed ticket [1819598c09]: -'1.0' computes -1.0 rather than -1 plus 7 other changes (artifact: 070c163445 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: f2c8179f3c user: dan tags: trunk) | |
| 11:50 | • New ticket [57353f8243] COLLATE expression in the right side of an IN operator results in an affinity conversion. (artifact: 0e9aa5fa09 user: mrigger) | |
| 10:43 | Add the new sqlite3ExprUnmapAndDelete() function and use it in place of separate calls to sqlite3RenameExprUnmap() and sqlite3ExprDelete(). (check-in: 36ea13e0a8 user: drh tags: trunk) | |
| 09:47 | • New ticket [1819598c09] -'1.0' computes -1.0 rather than -1. (artifact: 20490a7c1d user: mrigger) | |
| 03:00 | • Fixed ticket [d60b3cd7cb]: COLLATE expression has an affinity plus 8 other changes (artifact: 8270b2b987 user: drh) | |
| 02:43 | • Fixed ticket [533010b8ca]: Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" plus 3 other changes (artifact: e17361d221 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: 04bd5cb732 user: drh tags: trunk) | |
| 01:56 | Fix repeated test numbers in the altertab2.test file. (check-in: e82f235e72 user: drh tags: trunk) | |
| 01:30 | Remove a comment made obsolete by check-in [71643deb6bbad4b4]. No changes to code. (check-in: 211c8002d5 user: drh tags: trunk) | |
|
2019-06-10
| ||
| 23:45 | • Fixed ticket [412bba9b22]: CAST('.' AS NUMERIC) computes 0.0 rather than 0 plus 6 other changes (artifact: f3f09094f7 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: 5705016229 user: drh tags: trunk) | |
| 21:58 | • Open ticket [533010b8ca]: Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" plus 3 other changes (artifact: f065e4ab82 user: mrigger) | |
| 20:46 | • New ticket [d60b3cd7cb] COLLATE expression has an affinity. (artifact: 17666839a7 user: mrigger) | |
| 19:53 | • New ticket [412bba9b22] CAST('.' AS NUMERIC) computes 0.0 rather than 0. (artifact: 27de823723 user: mrigger) | |
| 19:18 | • Closed ticket [533010b8ca]: Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" plus 6 other changes (artifact: 8f1e45446f 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: 71643deb6b user: dan tags: trunk) | |
| 19:07 | • Fixed ticket [5e0423b058]: xAccess behaviour is not documented, changed in Windows 3.7.0 plus 3 other changes (artifact: c703cfe188 user: drh) | |
| 19:07 | Improvements to the documentation for the xAccess method of the VFS. Ticket [5e0423b058fa5adf] (check-in: 7078d77eff user: drh tags: trunk) | |
| 18:51 | • Closed ticket [31c6e64ff9]: ALTER TABLE fails if a trigger references a non-existant table. plus 6 other changes (artifact: d4a0d54d81 user: drh) | |
| 18:33 | • Fixed ticket [dd6bffbfb6]: CAST to NUMERIC no longer converts to INTEGER plus 3 other changes (artifact: b853530b61 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: c0c90961b4 user: drh tags: trunk) | |
| 18:27 | • Ticket [dd6bffbfb6] CAST to NUMERIC no longer converts to INTEGER status still Open with 7 other changes (artifact: 7bfbf7b8b3 user: drh) | |
| 18:15 | • New ticket [533010b8ca] Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()". (artifact: 0aff6c3fc3 user: mrigger) | |
| 15:35 | • Closed ticket [fd76310a5e]: TEXT value interpreted as column name in an index with empty list in an IN expression plus 5 other changes (artifact: f453906cff user: dan) | |
| 15:35 | • Edit [567b13093956185b|567b130939]: Edit check-in comment. (artifact: fed869acf2 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: 567b130939 user: dan tags: trunk) | |
| 13:52 | • Fixed ticket [b1d8c79314]: LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column plus 6 other changes (artifact: 974e3f5cec 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: 94b58ab059 user: dan tags: trunk) | |
| 11:28 | • New ticket [b1d8c79314] LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column. (artifact: 899d46d175 user: mrigger) | |
| 00:14 | • New ticket [fd76310a5e] TEXT value interpreted as column name in an index with empty list in an IN expression. (artifact: 683171cbee user: mrigger) | |
|
2019-06-08
| ||
| 21:31 | • New ticket [dd6bffbfb6] CAST to NUMERIC no longer converts to INTEGER. (artifact: f550c0f017 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: b141bae3f6 user: drh tags: trunk) | |
| 22:26 | • Fixed ticket [4c2d7639f0]: CAST('-' AS NUMERIC) computes 0.0 plus 6 other changes (artifact: 2c9d148c85 user: drh) | |
| 22:26 | • Fixed ticket [e8bedb2a18]: Incorrect result when subtracting a large integer number from a TEXT value plus 6 other changes (artifact: 8ea84fcb40 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: 67a68af557 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: efbf31b82e user: dan tags: trunk) | |
| 18:53 | Upgrade the config.guess script to the latest version. (check-in: be8438133f user: dan tags: trunk) | |
|
2019-06-05
| ||
| 14:29 | CLI enhancements: Add the ".filectrl" command. Make the ".testctrl" command visible to ".help". (check-in: 7b3a99fce8 user: drh tags: trunk) | |
| 13:14 | Add a test case for the unix SQLITE_FCNTL_CHUNK_SIZE file-control. (check-in: 3a477fd0c9 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: 4979f138e8 user: drh tags: trunk) | |
| 15:47 | New dbsqlfuzz test cases add to test/fuzzdata8.db. (check-in: 873aa46da3 user: drh tags: trunk) | |
| 13:11 | Fix a segfault in fts3 that could occur when processing corrupt fts records. (check-in: dff24c6c7a user: dan tags: trunk) | |
|
2019-06-03
| ||
| 15:10 | Fix harmless compiler warning in lemon. (check-in: 3a05242953 user: mistachkin tags: branch-3.28) | |
| 15:09 | Fix harmless compiler warning in lemon. (check-in: 2da0eea02d user: mistachkin tags: trunk) | |
| 14:02 | Updates to the shared_schema.md notes document. (check-in: 51af2ade8e 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: 583e5a0ab6 user: mistachkin tags: branch-3.28) | |
| 13:46 | In the CLI, add ".help" text for the .shared-schema command. (check-in: 3ba6f790e0 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: e95138f5f4 user: drh tags: trunk) | |
| 00:46 | Smaller and faster sqlite3IsNaN() implementation makes deserialization of floating point values much faster. (check-in: ea748edecb user: drh tags: trunk) | |
|
2019-05-29
| ||
| 21:18 | Much faster implementation of applyNumericAffinity() by avoiding some unnecessary calls to sqlite3Atoi64(). (check-in: c1d8a3f654 user: drh tags: trunk) | |
| 18:33 | Add an assert() as an additional test for fix in check-in [523b42371122d9e1b3]. (check-in: f9e85e6c79 user: drh tags: trunk) | |
| 17:22 | • Fixed ticket [c41afac34f]: LIMIT applied globally rather than locally plus 5 other changes (artifact: d33af184ff user: drh) | |
| 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: 523b423711 user: drh tags: trunk) | |
| 16:04 | • New ticket [c41afac34f] LIMIT applied globally rather than locally. (artifact: 67d7ba1715 user: drh) | |
|
2019-05-28
| ||
| 14:42 | Fix an assert() in fts3 that could fail when processing corrupt records. Also some minor sanitizer warnings. (check-in: c736c40aab 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: 7cbb9a5fe8 user: drh tags: trunk) | |
| 11:09 | Fix a memory leak in the delta_parse() table-valued function of the fossildelta.c extension. (check-in: c86ca3f022 user: drh tags: trunk) | |
| 00:29 | Improved rounding even on systems with an 8-byte "long double" type. (check-in: 15202aee15 user: drh tags: trunk) | |
|
2019-05-26
| ||
| 09:53 | • New ticket [e8bedb2a18] Incorrect result when subtracting a large integer number from a TEXT value. (artifact: 15289795de user: mrigger) | |
|
2019-05-25
| ||
| 18:17 | Performance enhancement in sqlite3AtoF(). About 8% faster. (check-in: 81721aa545 user: drh tags: trunk) | |
| 17:41 | Use "long double" literals to initialize an array of "long double" objects. (check-in: 2e2ebad3ab 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: b84e7057c0 user: drh tags: trunk) | |
| 10:06 | • New ticket [4c2d7639f0] CAST('-' AS NUMERIC) computes 0.0. (artifact: 25245da464 user: mrigger) | |
| 00:17 | Disable the new rounding tests on systems without long double support. (check-in: ed250b4e18 user: drh tags: trunk) | |
|
2019-05-24
| ||
| 22:58 | Improvements to rounding behavior in the round() and printf() functions. (check-in: 641b2d2105 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: 0913ff4dc3 user: drh tags: reuse-schema) | |
| 13:04 | Merge recent enhancements from trunk. (check-in: ff9f3e0951 user: drh tags: reuse-schema) | |
| 11:55 | Fix an fts5 segfault that could occur after parsing a corrupt structure record. (check-in: 600daa9c27 user: dan tags: trunk) | |
|
2019-05-23
| ||
| 16:40 | Add test cases for the fix in the previous commit. (check-in: c1057b2a60 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: d2fe370caf 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: cb1d06521d user: drh tags: trunk) | |
| 22:49 | • Fixed ticket [ce82323194]: Duplicate CTE name gives incorrect result plus 5 other changes (artifact: 65d134bbb7 user: drh) | |
| 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: 3cacc4b940 user: drh tags: trunk) | |
| 22:44 | • New ticket [ce82323194] Duplicate CTE name gives incorrect result. (artifact: fe37540714 user: drh) | |
| 14:35 | New dbsqlfuzz find added to test/fuzzdata8.db. (check-in: 42af7c819b user: drh tags: trunk) | |
| 14:22 | Fix a buffer overread that could in fts3 when dealing with corrupt records. (check-in: 1660d7733e 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: b3692c406f user: drh tags: trunk) | |
| 16:32 | Fix a problem in [b5ca442a] causing an assert() to fail in REINDEX commands. (check-in: a3e77c7776 user: dan tags: trunk) | |
| 14:46 | • Closed ticket [b5ca442af9]: "Malformed database schema" when creating a failing index within a transaction plus 3 other changes (artifact: f72ccfccaf user: dan) | |
| 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: b8071d10cb user: dan tags: trunk) | |
| 10:20 | • Ticket [b5ca442af9] "Malformed database schema" when creating a failing index within a transaction status still Open with 6 other changes (artifact: eba0221de5 user: mrigger) ... 1 similar event omitted. | |
|
2019-05-20
| ||
| 19:46 | Fix a segfault that could occur in sqlite3session_diff() if NULL were passed as the pzErrMsg argument. (check-in: aee73fd28f 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: b7aad92961 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: 3e1b55f3ab user: drh tags: trunk) | |
| 17:15 | • Closed ticket [9b78184be2]: Index on non-existing column results in a fabricated value being fetched plus 6 other changes (artifact: 6093aca95b user: dan) | |
| 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: 1685610ef8 user: dan tags: trunk) | |
| 12:35 | • Fixed ticket [d3e7f2ba5b]: Nested boolean formula with IN operator computes an incorrect result plus 5 other changes (artifact: eaeb86ad08 user: drh) ... 1 similar event omitted. | |
| 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: 99eba69b3a user: dan tags: trunk) | |
| 10:23 | • Ticket [d3e7f2ba5b] Nested boolean formula with IN operator computes an incorrect result status still Open with 6 other changes (artifact: de5658313f user: dan) ... 1 similar event omitted. | |
|
2019-05-19
| ||
| 17:01 | • Ticket [787fa716be] Assertion fault when multi-use subquery implemented by co-routine status still Fixed with 3 other changes (artifact: 929aa10917 user: mrigger) | |
| 09:44 | • New ticket [9b78184be2] Index on non-existing column results in a fabricated value being fetched. (artifact: e26938aa9b user: mrigger) | |
|
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: 778b1224a3 user: dan tags: trunk) | |
| 21:22 | • Ticket [787fa716be] Assertion fault when multi-use subquery implemented by co-routine status still Fixed with 3 other changes (artifact: fe9414e3d3 user: mrigger) | |