SQLite

Timeline
Login

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)