/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 most recent ticket changes

2019-06-16
14:57 Fixed ticket [e1e07ef2]: COLLATE in BETWEEN expression is ignored plus 6 other changes artifact: 97ce28ab user: drh
2019-06-15
21:41 New ticket [e1e07ef2]. artifact: 1c102a81 user: mrigger
2019-06-14
13:25 Fixed ticket [f1580ba1]: Built-in RTRIM collating sequence yields incorrect comparisons plus 8 other changes artifact: 71c96e66 user: drh
12:29 Fixed ticket [ce8717f0]: LIKE malfunctions for UNIQUE COLLATE NOCASE column plus 6 other changes artifact: 751df5f0 user: drh
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-12
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:32 Fixed ticket [b148fa61]: CAST takes implicit COLLATE of its operand plus 8 other changes artifact: bed43b4e user: drh
15:37 New ticket [b148fa61]. 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: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
12:58 New ticket [674385ae]. artifact: 5ea2d3c3 user: mrigger
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
19:24 New ticket [0c620df6]. 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
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
14:06 New ticket [afdc5a29]. artifact: 446e6ab3 user: mrigger
13:43 Fixed ticket [1819598c]: -'1.0' computes -1.0 rather than -1 plus 7 other changes artifact: 070c1634 user: drh
11:50 New ticket [57353f82] COLLATE expression in the right side of an IN operator results in an affinity conversion. artifact: 0e9aa5fa user: mrigger
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
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
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:07 Fixed ticket [5e0423b0]: xAccess behaviour is not documented, changed in Windows 3.7.0 plus 3 other changes artifact: c703cfe1 user: drh
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:27 Ticket [dd6bffbf]: 7 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
13:52 Fixed ticket [b1d8c793]: LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column plus 6 other changes artifact: 974e3f5c user: dan
11:28 New ticket [b1d8c793]. 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: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
2019-05-29
17:22 Fixed ticket [c41afac3]: LIMIT applied globally rather than locally plus 5 other changes artifact: d33af184 user: drh
16:04 New ticket [c41afac3]. artifact: 67d7ba17 user: drh
2019-05-26
09:53 New ticket [e8bedb2a] Incorrect result when subtracting a large integer number from a TEXT value. artifact: 15289795 user: mrigger
2019-05-25
10:06 New ticket [4c2d7639] CAST('-' AS NUMERIC) computes 0.0. artifact: 25245da4 user: mrigger
2019-05-22
22:49 Fixed ticket [ce823231]: Duplicate CTE name gives incorrect result plus 5 other changes artifact: 65d134bb user: drh
22:44 New ticket [ce823231]. artifact: fe375407 user: drh
2019-05-21
14:46 Closed ticket [b5ca442a]: "Malformed database schema" when creating a failing index within a transaction plus 3 other changes artifact: f72ccfcc user: dan
10:20 Ticket [b5ca442a]: 6 changes artifact: eba0221d user: mrigger
10:04 New ticket [b5ca442a]. artifact: 329bdfc0 user: mrigger
2019-05-20
17:15 Closed ticket [9b78184b]: Index on non-existing column results in a fabricated value being fetched plus 6 other changes artifact: 6093aca9 user: dan
12:35 Fixed ticket [d3e7f2ba]: Nested boolean formula with IN operator computes an incorrect result plus 5 other changes artifact: eaeb86ad user: drh
11:07 Ticket [d3e7f2ba]: 3 changes artifact: b9e29307 user: mrigger
10:23 Ticket [d3e7f2ba]: 6 changes artifact: de565831 user: dan
2019-05-19
18:23 New ticket [d3e7f2ba]. artifact: 972faf8c user: mrigger
17:01 Ticket [787fa716] Assertion fault when multi-use subquery implemented by co-routine status still Fixed with 3 other changes artifact: 929aa109 user: mrigger
09:44 New ticket [9b78184b] Index on non-existing column results in a fabricated value being fetched. artifact: e26938aa user: mrigger
2019-05-18
21:22 Ticket [787fa716] Assertion fault when multi-use subquery implemented by co-routine status still Fixed with 3 other changes artifact: fe9414e3 user: mrigger
2019-05-17
20:40 Closed ticket [f4ec2509]: Malformed image when using no journal mode, zero cache size, and failing when creating an index. plus 6 other changes artifact: 90d3b35d user: drh
20:07 Fixed ticket [3c27b97e]: REAL rounding seems to depend on FROM clause plus 3 other changes artifact: 8b824eda user: drh
12:48 New ticket [f4ec2509] Malformed image when using no journal mode, zero cache size, and failing when creating an index.. artifact: 7c739489 user: mrigger
2019-05-16
19:09 Ticket [3c27b97e] REAL rounding seems to depend on FROM clause status still Open with 3 other changes artifact: f8ef4408 user: drh
19:02 Ticket [3c27b97e]: 6 changes artifact: 23cdb676 user: dan
17:52 New ticket [3c27b97e]. artifact: e97acd84 user: mrigger
2019-05-14
00:43 Fixed ticket [bba7b69f]: REINDEX on WITHOUT ROWID table with DESC PRIMARY KEY corrupts automatic UNIQUE index plus 3 other changes artifact: a5855767 user: drh
00:22 Ticket [bba7b69f]: 7 changes artifact: 20ef9db5 user: drh
2019-05-13
20:44 New ticket [bba7b69f]. artifact: cde5e5f5 user: dan
2019-05-11
13:05 Closed ticket [80256748]: Incorrect use of "WHERE x NOT NULL" index for query with a "WHERE x IS NOT ?" term plus 4 other changes artifact: 6f695f82 user: dan
12:56 Ticket [80256748]: 6 changes artifact: 01b34370 user: dan
12:53 New ticket [80256748]. artifact: a9b75711 user: dan
2019-05-09
17:10 Fixed ticket [6c1d3feb]: REAL PRIMARY KEY leads to a missing entry in the index. plus 5 other changes artifact: 605b3649 user: drh
15:07 New ticket [6c1d3feb]. artifact: 2609d9f9 user: drh
2019-05-08
17:29 Closed ticket [a340eef4]: PRAGMA case_sensitive_like can corrupt some databases. plus 2 other changes artifact: c318aa85 user: drh
17:28 Deferred ticket [a340eef4]. artifact: 09375ae5 user: drh
14:03 Ticket [9cf6c9bb] "<" or "<=" comparison of rowid and non-numeric text value sometimes gets the wrong answer. status still Closed with 4 other changes artifact: bbfde8a2 user: drh
11:54 Ticket [9cf6c9bb]: 3 changes artifact: 8cbc4833 user: dan
11:53 Closed ticket [9cf6c9bb]. artifact: 4ec82a65 user: dan
11:40 Ticket [9cf6c9bb]: 6 changes artifact: 4622d12d user: dan
11:37 New ticket [9cf6c9bb]. artifact: c18df1c4 user: dan
2019-05-07
20:06 Fixed ticket [e63cbcfd]: Database table/index contents mismatch (corruption) caused by FK processing plus 3 other changes artifact: c199eb6b user: drh
19:13 Ticket [e63cbcfd]: 6 changes artifact: 55c1efff user: dan
19:09 New ticket [e63cbcfd]. artifact: 6f81b88f user: dan
2019-05-04
17:34 Fixed ticket [5c695520]: Incorrect result on a table scan of a partial index plus 4 other changes artifact: 0e40db40 user: drh
17:00 Ticket [5c695520]: 6 changes artifact: 597550cf user: drh
16:59 New ticket [5c695520]. artifact: d567b0d2 user: drh
2019-05-01
19:01 Fixed ticket [ae0f637b]: REINDEX fails on a UNIQUE index on the GLOB operator of a REAL column plus 5 other changes artifact: 7cb9c498 user: drh
15:32 Fixed ticket [3be1295b]: Inconsistent behavior of a unique constraint on a boolean expression. plus 5 other changes artifact: 1100ca34 user: drh
14:28 New ticket [3be1295b]. artifact: f434cc99 user: drh
13:59 New ticket [ae0f637b] REINDEX fails on a UNIQUE index on the GLOB operator of a REAL column. artifact: 823e1833 user: drh
13:09 New ticket [a340eef4] PRAGMA case_sensitive_like can corrupt some databases.. artifact: 42a32680 user: drh
2019-04-29
13:50 Fixed ticket [3182d387]: COLLATE nocase index on a WITHOUT ROWID table malfunctions plus 5 other changes artifact: 22383dee user: drh
2019-04-28
15:07 New ticket [3182d387]. artifact: 6afe3360 user: drh
2019-04-19
18:23 Fixed ticket [f00d7b65]: ALTER TABLE corrupts the schema for tables that start with "sqlite" plus 5 other changes artifact: c58968e5 user: drh
16:26 New ticket [f00d7b65]. artifact: dacc8af2 user: drh
2019-03-15
16:28 Closed ticket [596d059a]: Committing a transaction with a failed ALTER TABLE may subtly corrupt schema plus 4 other changes artifact: ffd8a4ff user: dan
16:28 Ticket [596d059a]: 3 changes artifact: 1a66d00d user: dan
16:27 Ticket [596d059a]: 6 changes artifact: 75efc5ac user: dan
15:43 New ticket [596d059a]. artifact: 0acc8b25 user: dan
2019-02-23
00:21 Fixed ticket [df46dfb6]: Assertion fault in self-join with a IN constraint plus 3 other changes artifact: 8e1fc5b8 user: drh
2019-02-22
21:35 Fixed ticket [4feb3159]: Crash due to misuse of window functions. plus 5 other changes artifact: 17c4d9a5 user: drh