Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 ticket changes occurring around ab2ba8e732d4a813.
2019-06-10
| ||
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) | |
13:52 | • Fixed ticket [b1d8c79314]: LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column plus 6 other changes (artifact: 974e3f5cec user: dan) | |
11:28 | • New ticket [b1d8c79314]. (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: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) | |
2019-05-29
| ||
17:22 | • Fixed ticket [c41afac34f]: LIMIT applied globally rather than locally plus 5 other changes (artifact: d33af184ff user: drh) | |
16:04 | • New ticket [c41afac34f]. (artifact: 67d7ba1715 user: drh) | |
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
| ||
10:06 | • New ticket [4c2d7639f0] CAST('-' AS NUMERIC) computes 0.0. (artifact: 25245da464 user: mrigger) | |
2019-05-22
| ||
22:49 | • Fixed ticket [ce82323194]: Duplicate CTE name gives incorrect result plus 5 other changes (artifact: 65d134bbb7 user: drh) | |
22:44 | • New ticket [ce82323194]. (artifact: fe37540714 user: drh) | |
2019-05-21
| ||
14:46 | • Closed ticket [b5ca442af9]: "Malformed database schema" when creating a failing index within a transaction plus 3 other changes (artifact: f72ccfccaf user: dan) | |
10:20 | • Ticket [b5ca442af9]: 6 changes (artifact: eba0221de5 user: mrigger) | |
10:04 | • New ticket [b5ca442af9]. (artifact: 329bdfc011 user: mrigger) | |
2019-05-20
| ||
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) | |
12:35 | • Fixed ticket [d3e7f2ba5b]: Nested boolean formula with IN operator computes an incorrect result plus 5 other changes (artifact: eaeb86ad08 user: drh) | |
11:07 | • Ticket [d3e7f2ba5b]: 3 changes (artifact: b9e29307e6 user: mrigger) | |
10:23 | • Ticket [d3e7f2ba5b]: 6 changes (artifact: de5658313f user: dan) | |
2019-05-19
| ||
18:23 | • New ticket [d3e7f2ba5b]. (artifact: 972faf8c68 user: mrigger) | |
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 | • Ticket [787fa716be] Assertion fault when multi-use subquery implemented by co-routine status still Fixed with 3 other changes (artifact: fe9414e3d3 user: mrigger) | |
2019-05-17
| ||
20:40 | • Closed ticket [f4ec250930]: Malformed image when using no journal mode, zero cache size, and failing when creating an index. plus 6 other changes (artifact: 90d3b35d87 user: drh) | |
20:07 | • Fixed ticket [3c27b97e31]: REAL rounding seems to depend on FROM clause plus 3 other changes (artifact: 8b824eda8e user: drh) | |
12:48 | • New ticket [f4ec250930] Malformed image when using no journal mode, zero cache size, and failing when creating an index.. (artifact: 7c7394890c user: mrigger) | |
2019-05-16
| ||
19:09 | • Ticket [3c27b97e31] REAL rounding seems to depend on FROM clause status still Open with 3 other changes (artifact: f8ef4408b1 user: drh) | |
19:02 | • Ticket [3c27b97e31]: 6 changes (artifact: 23cdb6761c user: dan) | |
17:52 | • New ticket [3c27b97e31]. (artifact: e97acd84df user: mrigger) | |
2019-05-14
| ||
00:43 | • Fixed ticket [bba7b69f98]: REINDEX on WITHOUT ROWID table with DESC PRIMARY KEY corrupts automatic UNIQUE index plus 3 other changes (artifact: a585576722 user: drh) | |
00:22 | • Ticket [bba7b69f98]: 7 changes (artifact: 20ef9db5e6 user: drh) | |
2019-05-13
| ||
20:44 | • New ticket [bba7b69f98]. (artifact: cde5e5f5f0 user: dan) | |
2019-05-11
| ||
13:05 | • Closed ticket [8025674847]: Incorrect use of "WHERE x NOT NULL" index for query with a "WHERE x IS NOT ?" term plus 4 other changes (artifact: 6f695f82c4 user: dan) | |
12:56 | • Ticket [8025674847]: 6 changes (artifact: 01b34370d5 user: dan) | |
12:53 | • New ticket [8025674847]. (artifact: a9b757116f user: dan) | |
2019-05-09
| ||
17:10 | • Fixed ticket [6c1d3febc0]: REAL PRIMARY KEY leads to a missing entry in the index. plus 5 other changes (artifact: 605b36497f user: drh) | |
15:07 | • New ticket [6c1d3febc0]. (artifact: 2609d9f9d1 user: drh) | |
2019-05-08
| ||
17:29 | • Closed ticket [a340eef47b]: PRAGMA case_sensitive_like can corrupt some databases. plus 2 other changes (artifact: c318aa8541 user: drh) | |
17:28 | • Deferred ticket [a340eef47b]. (artifact: 09375ae500 user: drh) | |
14:03 | • Ticket [9cf6c9bb51] "<" or "<=" comparison of rowid and non-numeric text value sometimes gets the wrong answer. status still Closed with 4 other changes (artifact: bbfde8a2e2 user: drh) | |
11:54 | • Ticket [9cf6c9bb51]: 3 changes (artifact: 8cbc48333c user: dan) | |
11:53 | • Closed ticket [9cf6c9bb51]. (artifact: 4ec82a65a6 user: dan) | |
11:40 | • Ticket [9cf6c9bb51]: 6 changes (artifact: 4622d12dc3 user: dan) | |
11:37 | • New ticket [9cf6c9bb51]. (artifact: c18df1c460 user: dan) | |
2019-05-07
| ||
20:06 | • Fixed ticket [e63cbcfd33]: Database table/index contents mismatch (corruption) caused by FK processing plus 3 other changes (artifact: c199eb6b37 user: drh) | |
19:13 | • Ticket [e63cbcfd33]: 6 changes (artifact: 55c1efff56 user: dan) | |
19:09 | • New ticket [e63cbcfd33]. (artifact: 6f81b88f45 user: dan) | |
2019-05-04
| ||
17:34 | • Fixed ticket [5c6955204c]: Incorrect result on a table scan of a partial index plus 4 other changes (artifact: 0e40db4024 user: drh) | |
17:00 | • Ticket [5c6955204c]: 6 changes (artifact: 597550cf37 user: drh) | |
16:59 | • New ticket [5c6955204c]. (artifact: d567b0d26b user: drh) | |
2019-05-01
| ||
19:01 | • Fixed ticket [ae0f637bdd]: REINDEX fails on a UNIQUE index on the GLOB operator of a REAL column plus 5 other changes (artifact: 7cb9c4986d user: drh) | |
15:32 | • Fixed ticket [3be1295b26]: Inconsistent behavior of a unique constraint on a boolean expression. plus 5 other changes (artifact: 1100ca344f user: drh) | |
14:28 | • New ticket [3be1295b26]. (artifact: f434cc9980 user: drh) | |
13:59 | • New ticket [ae0f637bdd] REINDEX fails on a UNIQUE index on the GLOB operator of a REAL column. (artifact: 823e1833ec user: drh) | |
13:09 | • New ticket [a340eef47b] PRAGMA case_sensitive_like can corrupt some databases.. (artifact: 42a326805f user: drh) | |
2019-04-29
| ||
13:50 | • Fixed ticket [3182d38790]: COLLATE nocase index on a WITHOUT ROWID table malfunctions plus 5 other changes (artifact: 22383deed8 user: drh) | |
2019-04-28
| ||
15:07 | • New ticket [3182d38790]. (artifact: 6afe33604d user: drh) | |
2019-04-19
| ||
18:23 | • Fixed ticket [f00d7b651a]: ALTER TABLE corrupts the schema for tables that start with "sqlite" plus 5 other changes (artifact: c58968e526 user: drh) | |
16:26 | • New ticket [f00d7b651a]. (artifact: dacc8af23a user: drh) | |
2019-03-15
| ||
16:28 | • Closed ticket [596d059af7]: Committing a transaction with a failed ALTER TABLE may subtly corrupt schema plus 4 other changes (artifact: ffd8a4ff21 user: dan) | |
16:28 | • Ticket [596d059af7]: 3 changes (artifact: 1a66d00dba user: dan) | |
16:27 | • Ticket [596d059af7]: 6 changes (artifact: 75efc5ac8c user: dan) | |
15:43 | • New ticket [596d059af7]. (artifact: 0acc8b258a user: dan) | |
2019-02-23
| ||
00:21 | • Fixed ticket [df46dfb631]: Assertion fault in self-join with a IN constraint plus 3 other changes (artifact: 8e1fc5b8bc user: drh) | |
2019-02-22
| ||
21:35 | • Fixed ticket [4feb3159c6]: Crash due to misuse of window functions. plus 5 other changes (artifact: 17c4d9a567 user: drh) | |
21:35 | • Open ticket [df46dfb631]: Assertion fault in self-join with a IN constraint plus 4 other changes (artifact: 0bf6d95baa user: drh) | |
18:44 | • New ticket [4feb3159c6] Crash due to misuse of window functions.. (artifact: a24c0ec01b user: drh) | |
2019-02-20
| ||
12:59 | • Fixed ticket [df46dfb631]: Assertion fault in self-join with a IN constraint plus 6 other changes (artifact: 784f260621 user: drh) | |
01:39 | • New ticket [df46dfb631]. (artifact: 967c921be4 user: drh) | |
2019-02-08
| ||
04:20 | • Fixed ticket [4e8e4857d3]: Crash on query using an OR term in the WHERE clause plus 6 other changes (artifact: f29e381b52 user: drh) | |
03:01 | • New ticket [4e8e4857d3]. (artifact: 006561ff01 user: drh) | |
2019-02-05
| ||
14:36 | • Fixed ticket [5948e09b8c]: Incorrect result from LEFT JOIN plus 5 other changes (artifact: 5851ddcf8f user: drh) | |
13:55 | • New ticket [5948e09b8c]. (artifact: 5400ddb5c1 user: drh) | |
2019-01-25
| ||
20:09 | • Fixed ticket [bb4bdb9f7f]: Zeroblob truncated by an index on an expression plus 6 other changes (artifact: a2fbfd41cb user: drh) | |
20:01 | • New ticket [bb4bdb9f7f]. (artifact: f81a07993d user: drh) | |
2019-01-09
| ||
02:04 | • Fixed ticket [bc8d94f0fb]: RENAME COLUMN fails on tables with redundant UNIQUE constraints plus 6 other changes (artifact: 95951a2b4f user: drh) | |
01:51 | • New ticket [bc8d94f0fb]. (artifact: 0894c0ac18 user: drh) | |
2019-01-01
| ||
18:03 | • Fixed ticket [d0866b26f8]: Window function in correlated subquery causes assertion fault plus 4 other changes (artifact: c01f9c323b user: drh) | |
13:02 | • Open ticket [d0866b26f8]. (artifact: 55b13ed5ca user: drh) | |
2018-12-31
| ||
18:09 | • Fixed ticket [d0866b26f8]. (artifact: 0daee22580 user: drh) | |
09:14 | • New ticket [d0866b26f8]. (artifact: 8d3fa50779 user: dan) | |
2018-12-26
| ||
15:17 | • Closed ticket [43ddc85a63]: ALTER TABLE fails when there is an INSTEAD-OF trigger on a VIEW plus 7 other changes (artifact: fac61f277f user: drh) | |
2018-12-22
| ||
01:13 | • Fixed ticket [e6f1f2e34d]: REPLACE can insert a default NULL into a NOT NULL column plus 5 other changes (artifact: 84675e853a user: drh) | |
00:10 | • New ticket [e6f1f2e34d]. (artifact: 317b6a4e2e user: drh) | |
2018-12-20
| ||
17:33 | • Closed ticket [50d2a6c292]: Foreign key malfunction when parent and child are the same WITHOUT ROWID table and parent key is not also PRIMARY KEY plus 5 other changes (artifact: b81d056077 user: dan) | |
17:30 | • New ticket [50d2a6c292]. (artifact: 065d8026da user: dan) | |
2018-12-14
| ||
11:17 | • Fixed ticket [d96eba8769]: Incorrect results for OR query where both OR terms are different indexed expressions plus 3 other changes (artifact: 8279f19716 user: drh) | |
11:00 | • Ticket [d96eba8769]: 7 changes (artifact: 5f23241448 user: drh) | |
07:53 | • New ticket [d96eba8769]. (artifact: 180077be63 user: dan) | |
2018-12-08
| ||
20:30 | • Fixed ticket [1d958d9059]: Incorrect result with NOT IN operator and partial index plus 5 other changes (artifact: 06dc40aa36 user: drh) | |
13:06 | • New ticket [1d958d9059]. (artifact: 17e6b57565 user: drh) | |
2018-12-07
| ||
01:56 | • Fixed ticket [f09fcd1781]: Assertion fault when window functions are used. plus 5 other changes (artifact: d07f783fea user: drh) | |
2018-12-06
| ||
17:17 | • New ticket [f09fcd1781]. (artifact: f091087884 user: drh) | |
2018-11-09
| ||
14:18 | • Fixed ticket [787fa716be]: Assertion fault when multi-use subquery implemented by co-routine plus 3 other changes (artifact: f1d6807624 user: drh) | |
13:39 | • Ticket [787fa716be]: 4 changes (artifact: 23c14e4ae5 user: drh) | |
2018-11-08
| ||
22:03 | • Ticket [787fa716be]: 3 changes (artifact: 0d3537a720 user: drh) | |
20:52 | • Ticket [787fa716be]: 3 changes (artifact: 29699fe9da user: drh) | |