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) | |