SQLite

Timeline
Login

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

100 most recent ticket changes

2024-09-16
23:34 Ticket [accfef33] Unicode output from the CLI subprocess not displayed correctly on Windows. status still Closed with 3 other changes (artifact: 2724f7e6 user: drh)
2024-08-21
14:49 New ticket [16e5fb9e] order-by-subquery optimization not working on NATURAL JOIN. (artifact: 02d45e34 user: drh)
2024-06-04
18:53 Fixed ticket [6e3ace12]: Table-valued functions with required parameters plus 5 other changes (artifact: 33adbb12 user: drh)
2024-05-28
00:20 Fixed ticket [8ff324e1]: Unwarranted use of automatic index plus 6 other changes (artifact: 089ea521 user: drh)
2024-05-23
20:33 New ticket [6e3ace12] Table-valued functions with required parameters. (artifact: 8801ed00 user: drh)
20:11 New ticket [8ff324e1] Unwarranted use of automatic index. (artifact: f133691a user: drh)
2024-05-19
18:29 Ticket [accfef33] Unicode output from the CLI subprocess not displayed correctly on Windows. status still Closed with 3 other changes (artifact: b07e6e07 user: larrybr)
2024-05-05
14:12 Closed ticket [accfef33]. (artifact: d26a2e1d user: larrybr)
14:11 Ticket [accfef33]: 6 changes (artifact: 3ee06aed user: larrybr)
2024-04-29
17:44 New ticket [accfef33]. (artifact: 385fc2cf user: drh)
2023-04-08
20:07 Closed ticket [667014c2]: Missed optimization when LHS of IN is an expression plus 6 other changes (artifact: 2fec6f59 user: drh)
2023-03-30
11:42 Fixed ticket [b50528af]: "WHERE a=? AND b IN (?,?,...) AND c>?" query using the seekscan optimization sometimes returns extra rows. plus 3 other changes (artifact: 7a100abd user: drh)
2023-03-29
22:05 Ticket [b50528af]: 6 changes (artifact: 36a9201c user: dan)
21:55 New ticket [b50528af]. (artifact: 59f2b887 user: dan)
2023-03-20
01:33 Fixed ticket [33aa4c0d]: Heap buffer overflow on SQL input plus 4 other changes (artifact: e15b6d38 user: drh)
2023-03-19
23:38 Open ticket [33aa4c0d]. (artifact: ffd764b4 user: drh)
2023-03-17
00:46 Fixed ticket [4f19d727]: Heap buffer overflow on SQL input (4) plus 8 other changes (artifact: 9f194f51 user: drh)
00:45 Fixed ticket [2971fbe3]: Heap buffer overflow on SQL input (3) plus 8 other changes (artifact: bf582baa user: drh)
00:45 Fixed ticket [b97e6c5e]: Heap buffer overflow on SQL input (2) plus 5 other changes (artifact: dae3d93d user: drh)
00:44 Fixed ticket [33aa4c0d]: Heap buffer overflow on SQL input plus 7 other changes (artifact: 33ab54ec user: drh)
00:04 Fixed ticket [89d259d4]: Assertion fault on SQL input (2) plus 7 other changes (artifact: c0aca9b7 user: drh)
00:03 Fixed ticket [d15b3a4e]: Assertion fault on SQL input plus 7 other changes (artifact: 211c7800 user: drh)
2023-03-16
21:03 Fixed ticket [d6fd512f]: Segfault on SQL input (3) plus 6 other changes (artifact: d6898bc5 user: drh)
21:02 Fixed ticket [4051a7f9]: Segfault on SQL input (2) plus 6 other changes (artifact: 802d2885 user: drh)
21:01 Fixed ticket [c36cdb4a]: Segfault due to SQL inputs plus 6 other changes (artifact: 5a92b32c user: drh)
20:35 Ticket [b97e6c5e] Heap buffer overflow on SQL input (2) status still Open with 6 other changes (artifact: d0fee4a6 user: drh)
20:30 New ticket [d6fd512f] Segfault on SQL input (3). (artifact: e936e0bf user: drh)
20:29 New ticket [4051a7f9] Segfault on SQL input (2). (artifact: 9c59650e user: drh)
20:28 New ticket [c36cdb4a] Segfault due to SQL inputs. (artifact: f56af9e7 user: drh)
20:27 New ticket [4f19d727] Heap buffer overflow on SQL input (4). (artifact: e6541a76 user: drh)
20:26 New ticket [2971fbe3] Heap buffer overflow on SQL input (3). (artifact: abd0366d user: drh)
20:25 New ticket [b97e6c5e] Heap buffer overflow on SQL input (2). (artifact: cf680359 user: drh)
20:23 New ticket [33aa4c0d] Heap buffer overflow on SQL input. (artifact: 23d642d6 user: drh)
20:22 New ticket [89d259d4] Assertion fault on SQL input (2). (artifact: 96d64a25 user: drh)
20:19 New ticket [d15b3a4e] Assertion fault on SQL input. (artifact: f61bb278 user: drh)
2023-03-10
20:23 New ticket [667014c2] Missed optimization when LHS of IN is an expression. (artifact: e3c39d98 user: drh)
2023-02-24
16:04 Fixed ticket [0b75886e]: Allow some sqlite3_config() calls after sqlite3_initialize(). plus 5 other changes (artifact: 3215cd34 user: drh)
2023-02-22
21:47 Fixed ticket [eaed8e36]: Enable SQLITE_COUNTOFVIEW_OPTIMIZATION by default plus 5 other changes (artifact: b2144b31 user: drh)
21:11 Fixed ticket [baa5bb76]: UNION ALL view does not use a covering index plus 3 other changes (artifact: 7377070f user: drh)
2023-02-18
15:05 New ticket [0b75886e] Allow some sqlite3_config() calls after sqlite3_initialize().. (artifact: ce89be29 user: drh)
14:50 New ticket [eaed8e36] Enable SQLITE_COUNTOFVIEW_OPTIMIZATION by default. (artifact: 3818fef5 user: drh)
2023-02-16
17:15 Ticket [baa5bb76] UNION ALL view does not use a covering index status still Open with 6 other changes (artifact: 3bdd160b user: drh)
17:14 Ticket [a7f5b085] Missed optimization for "constant IN (column1,column2)" status still Open with 6 other changes (artifact: e51f5dd9 user: drh)
2023-02-14
20:42 New ticket [a7f5b085]. (artifact: 878e0ebe user: drh)
20:12 New ticket [baa5bb76] UNION ALL view does not use a covering index. (artifact: 8e353e53 user: drh)
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)