/ Timeline
Login

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

100 most recent ticket changes

2022-12-14
18:35 Fixed ticket [73ebbb3a]: View ought not be materialized plus 3 other changes (artifact: e973c9e3 user: drh)
2022-12-13
00:59 Fixed ticket [57c47526]: Incorrect answer when flattening a UNION ALL compound plus 3 other changes (artifact: b6b79106 user: drh)
2022-12-10
19:37 Fixed ticket [679ed6a2]: Different affinities in CREATE VIEW depending if column names declared plus 3 other changes (artifact: 351328ce user: drh)
13:34 Ticket [679ed6a2]: 5 changes (artifact: b9a91241 user: drh)
13:34 Ticket [73ebbb3a] View ought not be materialized status still Open with 3 other changes (artifact: f0e33ae3 user: drh)
13:31 Open ticket [57c47526]: Incorrect answer when flattening a UNION ALL compound plus 4 other changes (artifact: 0f234843 user: drh)
2022-12-06
19:58 New ticket [679ed6a2] Different affinities in CREATE VIEW depending if column names declared. (artifact: 7a0f43e8 user: drh)
2022-12-05
17:31 Ticket [73ebbb3a] View ought not be materialized status still Open with 6 other changes (artifact: 1faa067b user: drh)
02:53 Fixed ticket [e8b67424]: Query planner chooses an inefficient algorithm. plus 5 other changes (artifact: a9db5f95 user: drh)
2022-11-28
19:43 Fixed ticket [695a1a53]: Better choice of indexes with covering indexes on expressions plus 3 other changes (artifact: 82a25833 user: drh)
2022-11-25
18:45 Ticket [695a1a53]: 3 changes (artifact: d5202fa0 user: drh)
18:40 Ticket [695a1a53]: 6 changes (artifact: 5ad6703c user: drh)
16:12 Fixed ticket [99378177]: Use indexed expressions in an aggregate query plus 6 other changes (artifact: fb3dc805 user: drh)
2022-11-19
00:08 Fixed ticket [53043c97]: deserialized DB has a sqlite3_db_filename() contrary to docs plus 3 other changes (artifact: 91d1a5cf user: drh)
2022-11-18
21:23 Ticket [53043c97]: 6 changes (artifact: f1738a9d user: drh)
2022-11-11
13:51 Closed ticket [ee4b2b48]: Prepared statement cache plus 5 other changes (artifact: c40bea50 user: drh)
13:17 Fixed ticket [6c266900]: shell: The column mode (and width option) does not manage correctly UTF-8 plus 4 other changes (artifact: 6fcbd024 user: drh)
2022-11-03
18:46 New ticket [73ebbb3a] View ought not be materialized. (artifact: 60c699c8 user: drh)
11:59 New ticket [99378177] Use indexed expressions in an aggregate query. (artifact: 9593cae7 user: drh)
11:35 New ticket [695a1a53] Better choice of indexes with covering indexes on expressions. (artifact: f6561b0c user: drh)
2022-11-01
12:11 Fixed ticket [57c47526]: Incorrect answer when flattening a UNION ALL compound plus 5 other changes (artifact: a68a3eba user: drh)
2022-10-31
13:24 New ticket [57c47526]. (artifact: 8ff47cd8 user: drh)
2022-02-01
16:45 Closed ticket [bd375c20]: Potential bug in FTS5 plus 7 other changes (artifact: c8f5a482 user: dan)
15:23 New ticket [bd375c20]. (artifact: 4232ec86 user: mrigger)
2021-11-02
22:26 Fixed ticket [5981a8c0]: Incorrect answer on a SeekScan query plus 6 other changes (artifact: fba198c9 user: drh)
20:38 New ticket [5981a8c0]. (artifact: 2d2d6923 user: drh)
2021-08-18
22:27 Fixed ticket [f2be158c]: ON CONFLICT on a PK column in a WITHOUT ROWID table does not work plus 5 other changes (artifact: cddd457c user: drh)
22:16 New ticket [f2be158c]. (artifact: a0e62f7b user: drh)
2021-07-23
23:49 Fixed ticket [c88f3036]: ALTER TABLE DROP COLUMN may corrupt data plus 5 other changes (artifact: 8840c8df user: drh)
2021-06-25
14:49 Fixed ticket [6dcbfd11]: Incorrect query result due to the SeekScan optimization plus 6 other changes (artifact: 92dc0413 user: drh)
14:27 New ticket [6dcbfd11]. (artifact: e40291a6 user: drh)
2021-04-23
13:43 Closed ticket [c66298e2]: Inconsistent iterations of WhereClause->nTerm plus 6 other changes (artifact: e3978f19 user: drh)
02:58 New ticket [c66298e2]. (artifact: baf40b6e user: yongheng)
2021-04-18
05:42 New ticket [c88f3036] ALTER TABLE DROP COLUMN may corrupt data. (artifact: aa54a738 user: dan)
2021-04-15
09:29 New ticket [53043c97] deserialized DB has a sqlite3_db_filename() contrary to docs. (artifact: cfab3052 user: larrybr)
2021-03-30
19:18 Fixed ticket [de7db147]: subquery with limit clause fails as EXISTS operand plus 6 other changes (artifact: 5cfeb90d user: drh)
19:17 Fixed ticket [132994c8]: RETURNING old.* seg-faults plus 6 other changes (artifact: 88a4c19d user: drh)
00:47 Ticket [132994c8]: 3 changes (artifact: 2559d91f user: drh)
2021-03-29
23:55 Ticket [132994c8]: 3 changes (artifact: f8527c33 user: larrybr)
23:40 Ticket [132994c8]: 6 changes (artifact: 01774930 user: larrybr)
23:11 New ticket [de7db147] subquery with limit clause fails as EXISTS operand. (artifact: 794b3b38 user: larrybr)
22:57 New ticket [132994c8] RETURNING old.* seg-faults. (artifact: 05ea74f5 user: larrybr)
2021-03-18
16:48 Fixed ticket [bb8a9fd4]: Crash due to MATERIALIZED plus 5 other changes (artifact: cea551f8 user: drh)
12:00 Ticket [bb8a9fd4]: 7 changes (artifact: bb2dea5f user: drh)
11:59 New ticket [bb8a9fd4]. (artifact: 81e8c371 user: drh)
2021-03-16
18:42 Fixed ticket [2c6c8689]: Non-deterministic date/time function identified as deterministic. plus 5 other changes (artifact: 7a5eabea user: drh)
18:27 New ticket [2c6c8689]. (artifact: 35992390 user: drh)
12:36 Ticket [a753a856] RENAME COLUMN incorrectly modifying column names in generated column expressions status still Fixed with 3 other changes (artifact: 8637b0d0 user: drh)
12:07 Fixed ticket [a753a856]. (artifact: b0d9e620 user: dan)
12:06 New ticket [a753a856]. (artifact: 95c2baf6 user: dan)
2021-03-15
14:58 Fixed ticket [1c24a659]: DROP COLUMN leaves behind an index plus 5 other changes (artifact: eccc1437 user: drh)
2021-03-14
12:01 Ticket [1c24a659]: 6 changes (artifact: 1d3d0461 user: drh)
01:20 New ticket [1c24a659]. (artifact: e3f3b036 user: drh)
2021-03-02
16:27 Fixed ticket [22dea1cf]: Misoptimization in ieee754func plus 5 other changes (artifact: 1ec183f0 user: drh)
2021-02-25
06:40 Ticket [22dea1cf]: 3 changes (artifact: 6c03195f user: yongheng)
06:36 Ticket [22dea1cf]: 6 changes (artifact: eb002bda user: yongheng)
06:20 New ticket [22dea1cf]. (artifact: 3c741eba user: yongheng)
2021-02-15
17:02 Fixed ticket [c0aeea67]: Incorrect LIKE result plus 5 other changes (artifact: 7b22614c user: drh)
16:51 New ticket [c0aeea67]. (artifact: 1fd8c4af user: drh)
2021-01-27
19:15 Fixed ticket [ee51301f]: Incorrect optimization of IN operator. plus 5 other changes (artifact: 8a0867c5 user: drh)
16:06 New ticket [ee51301f]. (artifact: 2d6e8400 user: drh)
2020-10-05
03:24 Fixed ticket [95302bdb]: WHERE clause that uses a NUMERIC cast influences the result type plus 5 other changes (artifact: 50e0d5ea user: drh)
2020-10-03
17:08 Closed ticket [e33ee625]: Segfault using a CROSS JOIN on a table using the experimental trigram tokenizer plus 6 other changes (artifact: 47c0d456 user: dan)
15:44 New ticket [e33ee625]. (artifact: 3b682278 user: mrigger)
14:37 Closed ticket [2ba5930b]: Unexpected FTS5 integrity-check failure for the experimental trigram tokenizer plus 4 other changes (artifact: dd78ada3 user: dan)
14:37 Ticket [2ba5930b]: 6 changes (artifact: f7d29928 user: dan)
2020-10-02
21:16 New ticket [95302bdb] WHERE clause that uses a NUMERIC cast influences the result type. (artifact: bd7d181b user: mrigger)
20:44 New ticket [2ba5930b] Unexpected FTS5 integrity-check failure for the experimental trigram tokenizer. (artifact: 851e0fc3 user: mrigger)
20:19 Closed ticket [0f586dbe]: FTS4 integrity-check fails for UTF16 encoding plus 4 other changes (artifact: 845723a5 user: dan)
20:17 Ticket [0f586dbe]: 6 changes (artifact: 6c7bdf81 user: dan)
20:04 New ticket [0f586dbe]. (artifact: 7cccafc7 user: mrigger)
2020-10-01
14:36 Fixed ticket [2d5a3163]: Segmentation fault in CROSS JOIN and the rtree extension plus 3 other changes (artifact: ea3a8285 user: drh)
13:33 Ticket [2d5a3163]: 6 changes (artifact: 5275fb84 user: drh)
11:35 New ticket [2d5a3163]. (artifact: 2ee12a62 user: mrigger)
2020-09-30
17:33 Fixed ticket [5c4e7aa7]: Incorrect result for comparison with NULL plus 6 other changes (artifact: 1091db2a user: drh)
17:18 New ticket [5c4e7aa7]. (artifact: c71d1ae4 user: mrigger)
15:46 Fixed ticket [66e4b0e2]: Incorrect result for LEFT JOIN plus 7 other changes (artifact: 000faea0 user: drh)
12:47 New ticket [66e4b0e2]. (artifact: 2d62d647 user: mrigger)
2020-09-29
11:52 Ticket [c51489c3] Incorrect result from WITH RECURSIVE using DISTINCT status still Fixed with 3 other changes (artifact: 465c6275 user: drh)
2020-09-17
00:47 Fixed ticket [c51489c3]. (artifact: bc9cfc49 user: drh)
00:00 New ticket [c51489c3]. (artifact: bc476067 user: drh)
2020-08-27
13:33 Closed ticket [be31cf00]: Unexpected result for % and '1E1' plus 3 other changes (artifact: 928fed83 user: drh)
13:21 Ticket [be31cf00]: 6 changes (artifact: 8b261c75 user: drh)
2020-08-26
14:12 New ticket [be31cf00]. (artifact: 3102412d user: mrigger)
2020-08-24
10:53 Ticket [f3ff1472] Incorrect result for IN expression with right-hand IS TRUE sub-expression status still Closed with 3 other changes (artifact: 8f15b880 user: dan)
10:53 Closed ticket [f3ff1472]. (artifact: f4e913c0 user: dan)
08:17 New ticket [f3ff1472]. (artifact: 009010c0 user: mrigger)
2020-06-25
03:17 Ticket [32116871] Inconsistent result in sum status still Closed with 3 other changes (artifact: b04433e0 user: yongheng)
03:12 Closed ticket [9c14a0c7]: Another inconsistent result plus 7 other changes (artifact: 0636b705 user: drh)
03:06 Closed ticket [32116871]: Inconsistent result in sum plus 7 other changes (artifact: 4fcdd13d user: drh)
2020-06-24
19:05 New ticket [9c14a0c7] Another inconsistent result. (artifact: b08b9ad8 user: yongheng)
18:55 New ticket [32116871] Inconsistent result in sum. (artifact: e795d09b user: yongheng)
2020-06-15
13:56 Fixed ticket [8f157e80]: Heap Buffer Overflow in multiSelectOrderBy plus 7 other changes (artifact: 60b1a173 user: drh)
2020-06-14
20:14 New ticket [8f157e80]. (artifact: 5a6a79fc user: yongheng)
13:42 Fixed ticket [9fb26d37]: Assertion `flags3==pIn3->flags' failed. plus 6 other changes (artifact: ea0dfdf7 user: drh)
03:57 New ticket [9fb26d37]. (artifact: 5c0fa89b user: yongheng)
2020-06-13
21:43 Fixed ticket [e367f319]: Assertion `pExpr->pAggInfo==pAggInfo' failed. plus 5 other changes (artifact: c3117e46 user: drh)
18:52 New ticket [e367f319]. (artifact: 838e3099 user: yongheng)
2020-06-11
16:04 Fixed ticket [b706351c]: Segfault in sqlite3Select plus 3 other changes (artifact: 01314052 user: drh)
01:12 Ticket [b706351c]: 6 changes (artifact: b07b31dd user: drh)