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: 2724f7e650 user: drh) | |
2024-08-21
| ||
14:49 | • New ticket [16e5fb9e] order-by-subquery optimization not working on NATURAL JOIN. (artifact: 02d45e344a user: drh) | |
2024-06-04
| ||
18:53 | • Fixed ticket [6e3ace12]: Table-valued functions with required parameters plus 5 other changes (artifact: 33adbb1216 user: drh) | |
2024-05-28
| ||
00:20 | • Fixed ticket [8ff324e1]: Unwarranted use of automatic index plus 6 other changes (artifact: 089ea52120 user: drh) | |
2024-05-23
| ||
20:33 | • New ticket [6e3ace12] Table-valued functions with required parameters. (artifact: 8801ed008f user: drh) | |
20:11 | • New ticket [8ff324e1] Unwarranted use of automatic index. (artifact: f133691aee 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: b07e6e0798 user: larrybr) | |
2024-05-05
| ||
14:12 | • Closed ticket [accfef33]. (artifact: d26a2e1ddf user: larrybr) | |
14:11 | • Ticket [accfef33]: 6 changes (artifact: 3ee06aed19 user: larrybr) | |
2024-04-29
| ||
17:44 | • New ticket [accfef33]. (artifact: 385fc2cfff user: drh) | |
2023-04-08
| ||
20:07 | • Closed ticket [667014c2]: Missed optimization when LHS of IN is an expression plus 6 other changes (artifact: 2fec6f5975 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: 7a100abdad user: drh) | |
2023-03-29
| ||
22:05 | • Ticket [b50528af]: 6 changes (artifact: 36a9201c8a user: dan) | |
21:55 | • New ticket [b50528af]. (artifact: 59f2b8878f user: dan) | |
2023-03-20
| ||
01:33 | • Fixed ticket [33aa4c0d]: Heap buffer overflow on SQL input plus 4 other changes (artifact: e15b6d38c7 user: drh) | |
2023-03-19
| ||
23:38 | • Open ticket [33aa4c0d]. (artifact: ffd764b4ca user: drh) | |
2023-03-17
| ||
00:46 | • Fixed ticket [4f19d727]: Heap buffer overflow on SQL input (4) plus 8 other changes (artifact: 9f194f5150 user: drh) | |
00:45 | • Fixed ticket [2971fbe3]: Heap buffer overflow on SQL input (3) plus 8 other changes (artifact: bf582baa6b user: drh) | |
00:45 | • Fixed ticket [b97e6c5e]: Heap buffer overflow on SQL input (2) plus 5 other changes (artifact: dae3d93d37 user: drh) | |
00:44 | • Fixed ticket [33aa4c0d]: Heap buffer overflow on SQL input plus 7 other changes (artifact: 33ab54ec1e user: drh) | |
00:04 | • Fixed ticket [89d259d4]: Assertion fault on SQL input (2) plus 7 other changes (artifact: c0aca9b7e8 user: drh) | |
00:03 | • Fixed ticket [d15b3a4e]: Assertion fault on SQL input plus 7 other changes (artifact: 211c780065 user: drh) | |
2023-03-16
| ||
21:03 | • Fixed ticket [d6fd512f]: Segfault on SQL input (3) plus 6 other changes (artifact: d6898bc56e user: drh) | |
21:02 | • Fixed ticket [4051a7f9]: Segfault on SQL input (2) plus 6 other changes (artifact: 802d288564 user: drh) | |
21:01 | • Fixed ticket [c36cdb4a]: Segfault due to SQL inputs plus 6 other changes (artifact: 5a92b32c9f user: drh) | |
20:35 | • Ticket [b97e6c5e] Heap buffer overflow on SQL input (2) status still Open with 6 other changes (artifact: d0fee4a695 user: drh) | |
20:30 | • New ticket [d6fd512f] Segfault on SQL input (3). (artifact: e936e0bfc0 user: drh) | |
20:29 | • New ticket [4051a7f9] Segfault on SQL input (2). (artifact: 9c59650e48 user: drh) | |
20:28 | • New ticket [c36cdb4a] Segfault due to SQL inputs. (artifact: f56af9e71d user: drh) | |
20:27 | • New ticket [4f19d727] Heap buffer overflow on SQL input (4). (artifact: e6541a762d user: drh) | |
20:26 | • New ticket [2971fbe3] Heap buffer overflow on SQL input (3). (artifact: abd0366dd1 user: drh) | |
20:25 | • New ticket [b97e6c5e] Heap buffer overflow on SQL input (2). (artifact: cf68035943 user: drh) | |
20:23 | • New ticket [33aa4c0d] Heap buffer overflow on SQL input. (artifact: 23d642d6f7 user: drh) | |
20:22 | • New ticket [89d259d4] Assertion fault on SQL input (2). (artifact: 96d64a2594 user: drh) | |
20:19 | • New ticket [d15b3a4e] Assertion fault on SQL input. (artifact: f61bb278f6 user: drh) | |
2023-03-10
| ||
20:23 | • New ticket [667014c2] Missed optimization when LHS of IN is an expression. (artifact: e3c39d9817 user: drh) | |
2023-02-24
| ||
16:04 | • Fixed ticket [0b75886e]: Allow some sqlite3_config() calls after sqlite3_initialize(). plus 5 other changes (artifact: 3215cd3477 user: drh) | |
2023-02-22
| ||
21:47 | • Fixed ticket [eaed8e36]: Enable SQLITE_COUNTOFVIEW_OPTIMIZATION by default plus 5 other changes (artifact: b2144b318f user: drh) | |
21:11 | • Fixed ticket [baa5bb76]: UNION ALL view does not use a covering index plus 3 other changes (artifact: 7377070fa6 user: drh) | |
2023-02-18
| ||
15:05 | • New ticket [0b75886e] Allow some sqlite3_config() calls after sqlite3_initialize().. (artifact: ce89be2998 user: drh) | |
14:50 | • New ticket [eaed8e36] Enable SQLITE_COUNTOFVIEW_OPTIMIZATION by default. (artifact: 3818fef5f6 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: 3bdd160b88 user: drh) | |
17:14 | • Ticket [a7f5b085] Missed optimization for "constant IN (column1,column2)" status still Open with 6 other changes (artifact: e51f5dd9c2 user: drh) | |
2023-02-14
| ||
20:42 | • New ticket [a7f5b085]. (artifact: 878e0ebe8f user: drh) | |
20:12 | • New ticket [baa5bb76] UNION ALL view does not use a covering index. (artifact: 8e353e53b0 user: drh) | |
2022-12-14
| ||
18:35 | • Fixed ticket [73ebbb3a]: View ought not be materialized plus 3 other changes (artifact: e973c9e32a user: drh) | |
2022-12-13
| ||
00:59 | • Fixed ticket [57c47526]: Incorrect answer when flattening a UNION ALL compound plus 3 other changes (artifact: b6b7910615 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: 351328ce85 user: drh) | |
13:34 | • Ticket [679ed6a2]: 5 changes (artifact: b9a91241d2 user: drh) | |
13:34 | • Ticket [73ebbb3a] View ought not be materialized status still Open with 3 other changes (artifact: f0e33ae3ee user: drh) | |
13:31 | • Open ticket [57c47526]: Incorrect answer when flattening a UNION ALL compound plus 4 other changes (artifact: 0f2348432b user: drh) | |
2022-12-06
| ||
19:58 | • New ticket [679ed6a2] Different affinities in CREATE VIEW depending if column names declared. (artifact: 7a0f43e8cd user: drh) | |
2022-12-05
| ||
17:31 | • Ticket [73ebbb3a] View ought not be materialized status still Open with 6 other changes (artifact: 1faa067bd6 user: drh) | |
02:53 | • Fixed ticket [e8b67424]: Query planner chooses an inefficient algorithm. plus 5 other changes (artifact: a9db5f9587 user: drh) | |
2022-11-28
| ||
19:43 | • Fixed ticket [695a1a53]: Better choice of indexes with covering indexes on expressions plus 3 other changes (artifact: 82a258332a user: drh) | |
2022-11-25
| ||
18:45 | • Ticket [695a1a53]: 3 changes (artifact: d5202fa021 user: drh) | |
18:40 | • Ticket [695a1a53]: 6 changes (artifact: 5ad6703c81 user: drh) | |
16:12 | • Fixed ticket [99378177]: Use indexed expressions in an aggregate query plus 6 other changes (artifact: fb3dc805a8 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: 91d1a5cfb3 user: drh) | |
2022-11-18
| ||
21:23 | • Ticket [53043c97]: 6 changes (artifact: f1738a9d6e user: drh) | |
2022-11-11
| ||
13:51 | • Closed ticket [ee4b2b48]: Prepared statement cache plus 5 other changes (artifact: c40bea5050 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: 6fcbd02442 user: drh) | |
2022-11-03
| ||
18:46 | • New ticket [73ebbb3a] View ought not be materialized. (artifact: 60c699c856 user: drh) | |
11:59 | • New ticket [99378177] Use indexed expressions in an aggregate query. (artifact: 9593cae7fd user: drh) | |
11:35 | • New ticket [695a1a53] Better choice of indexes with covering indexes on expressions. (artifact: f6561b0c33 user: drh) | |
2022-11-01
| ||
12:11 | • Fixed ticket [57c47526]: Incorrect answer when flattening a UNION ALL compound plus 5 other changes (artifact: a68a3ebad5 user: drh) | |
2022-10-31
| ||
13:24 | • New ticket [57c47526]. (artifact: 8ff47cd8d2 user: drh) | |
2022-02-01
| ||
16:45 | • Closed ticket [bd375c20]: Potential bug in FTS5 plus 7 other changes (artifact: c8f5a48243 user: dan) | |
15:23 | • New ticket [bd375c20]. (artifact: 4232ec8645 user: mrigger) | |
2021-11-02
| ||
22:26 | • Fixed ticket [5981a8c0]: Incorrect answer on a SeekScan query plus 6 other changes (artifact: fba198c9c3 user: drh) | |
20:38 | • New ticket [5981a8c0]. (artifact: 2d2d692312 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: cddd457cb4 user: drh) | |
22:16 | • New ticket [f2be158c]. (artifact: a0e62f7b55 user: drh) | |
2021-07-23
| ||
23:49 | • Fixed ticket [c88f3036]: ALTER TABLE DROP COLUMN may corrupt data plus 5 other changes (artifact: 8840c8df3b user: drh) | |
2021-06-25
| ||
14:49 | • Fixed ticket [6dcbfd11]: Incorrect query result due to the SeekScan optimization plus 6 other changes (artifact: 92dc041354 user: drh) | |
14:27 | • New ticket [6dcbfd11]. (artifact: e40291a6a2 user: drh) | |
2021-04-23
| ||
13:43 | • Closed ticket [c66298e2]: Inconsistent iterations of WhereClause->nTerm plus 6 other changes (artifact: e3978f196b user: drh) | |
02:58 | • New ticket [c66298e2]. (artifact: baf40b6ea5 user: yongheng) | |
2021-04-18
| ||
05:42 | • New ticket [c88f3036] ALTER TABLE DROP COLUMN may corrupt data. (artifact: aa54a7381b user: dan) | |
2021-04-15
| ||
09:29 | • New ticket [53043c97] deserialized DB has a sqlite3_db_filename() contrary to docs. (artifact: cfab3052b1 user: larrybr) | |
2021-03-30
| ||
19:18 | • Fixed ticket [de7db147]: subquery with limit clause fails as EXISTS operand plus 6 other changes (artifact: 5cfeb90df3 user: drh) | |
19:17 | • Fixed ticket [132994c8]: RETURNING old.* seg-faults plus 6 other changes (artifact: 88a4c19d2b user: drh) | |
00:47 | • Ticket [132994c8]: 3 changes (artifact: 2559d91f47 user: drh) | |
2021-03-29
| ||
23:55 | • Ticket [132994c8]: 3 changes (artifact: f8527c33a3 user: larrybr) | |
23:40 | • Ticket [132994c8]: 6 changes (artifact: 0177493069 user: larrybr) | |
23:11 | • New ticket [de7db147] subquery with limit clause fails as EXISTS operand. (artifact: 794b3b3870 user: larrybr) | |
22:57 | • New ticket [132994c8] RETURNING old.* seg-faults. (artifact: 05ea74f5f7 user: larrybr) | |
2021-03-18
| ||
16:48 | • Fixed ticket [bb8a9fd4]: Crash due to MATERIALIZED plus 5 other changes (artifact: cea551f89c user: drh) | |
12:00 | • Ticket [bb8a9fd4]: 7 changes (artifact: bb2dea5f23 user: drh) | |
11:59 | • New ticket [bb8a9fd4]. (artifact: 81e8c371c7 user: drh) | |
2021-03-16
| ||
18:42 | • Fixed ticket [2c6c8689]: Non-deterministic date/time function identified as deterministic. plus 5 other changes (artifact: 7a5eabeaab user: drh) | |
18:27 | • New ticket [2c6c8689]. (artifact: 35992390e1 user: drh) | |
12:36 | • Ticket [a753a856] RENAME COLUMN incorrectly modifying column names in generated column expressions status still Fixed with 3 other changes (artifact: 8637b0d0a9 user: drh) | |
12:07 | • Fixed ticket [a753a856]. (artifact: b0d9e62024 user: dan) | |
12:06 | • New ticket [a753a856]. (artifact: 95c2baf675 user: dan) | |
2021-03-15
| ||
14:58 | • Fixed ticket [1c24a659]: DROP COLUMN leaves behind an index plus 5 other changes (artifact: eccc143704 user: drh) | |
2021-03-14
| ||
12:01 | • Ticket [1c24a659]: 6 changes (artifact: 1d3d0461a3 user: drh) | |
01:20 | • New ticket [1c24a659]. (artifact: e3f3b036db user: drh) | |
2021-03-02
| ||
16:27 | • Fixed ticket [22dea1cf]: Misoptimization in ieee754func plus 5 other changes (artifact: 1ec183f033 user: drh) | |
2021-02-25
| ||
06:40 | • Ticket [22dea1cf]: 3 changes (artifact: 6c03195f19 user: yongheng) | |