SQLite

Timeline
Login
Advanced Search

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

2100 ticket changes occurring around 98a53d91f6c0c269.

2024-09-16
23:34 • Ticket [accfef3317] 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 [16e5fb9e72] order-by-subquery optimization not working on NATURAL JOIN. (artifact: 02d45e344a user: drh)
2024-06-04
18:53 • Fixed ticket [6e3ace1270]: Table-valued functions with required parameters plus 5 other changes (artifact: 33adbb1216 user: drh)
2024-05-28
00:20 • Fixed ticket [8ff324e120]: Unwarranted use of automatic index plus 6 other changes (artifact: 089ea52120 user: drh)
2024-05-23
20:33 • New ticket [6e3ace1270] Table-valued functions with required parameters. (artifact: 8801ed008f user: drh)
20:11 • New ticket [8ff324e120] Unwarranted use of automatic index. (artifact: f133691aee user: drh)
2024-05-19
18:29 • Ticket [accfef3317] 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 [accfef3317]. (artifact: d26a2e1ddf user: larrybr)
14:11 • Ticket [accfef3317]: 6 changes (artifact: 3ee06aed19 user: larrybr)
2024-04-29
17:44 • New ticket [accfef3317]. (artifact: 385fc2cfff user: drh)
2023-04-08
20:07 • Closed ticket [667014c20b]: Missed optimization when LHS of IN is an expression plus 6 other changes (artifact: 2fec6f5975 user: drh)
2023-03-30
11:42 • Fixed ticket [b50528af44]: "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 [b50528af44]: 6 changes (artifact: 36a9201c8a user: dan)
21:55 • New ticket [b50528af44]. (artifact: 59f2b8878f user: dan)
2023-03-20
01:33 • Fixed ticket [33aa4c0de8]: Heap buffer overflow on SQL input plus 4 other changes (artifact: e15b6d38c7 user: drh)
2023-03-19
23:38 • Open ticket [33aa4c0de8]. (artifact: ffd764b4ca user: drh)
2023-03-17
00:46 • Fixed ticket [4f19d72774]: Heap buffer overflow on SQL input (4) plus 8 other changes (artifact: 9f194f5150 user: drh)
00:45 • Fixed ticket [2971fbe3f9]: Heap buffer overflow on SQL input (3) plus 8 other changes (artifact: bf582baa6b user: drh)
00:45 • Fixed ticket [b97e6c5e6a]: Heap buffer overflow on SQL input (2) plus 5 other changes (artifact: dae3d93d37 user: drh)
00:44 • Fixed ticket [33aa4c0de8]: Heap buffer overflow on SQL input plus 7 other changes (artifact: 33ab54ec1e user: drh)
00:04 • Fixed ticket [89d259d45b]: Assertion fault on SQL input (2) plus 7 other changes (artifact: c0aca9b7e8 user: drh)
00:03 • Fixed ticket [d15b3a4ea9]: Assertion fault on SQL input plus 7 other changes (artifact: 211c780065 user: drh)
2023-03-16
21:03 • Fixed ticket [d6fd512f50]: Segfault on SQL input (3) plus 6 other changes (artifact: d6898bc56e user: drh)
21:02 • Fixed ticket [4051a7f931]: Segfault on SQL input (2) plus 6 other changes (artifact: 802d288564 user: drh)
21:01 • Fixed ticket [c36cdb4afd]: Segfault due to SQL inputs plus 6 other changes (artifact: 5a92b32c9f user: drh)
20:35 • Ticket [b97e6c5e6a] Heap buffer overflow on SQL input (2) status still Open with 6 other changes (artifact: d0fee4a695 user: drh)
20:30 • New ticket [d6fd512f50] Segfault on SQL input (3). (artifact: e936e0bfc0 user: drh)
20:29 • New ticket [4051a7f931] Segfault on SQL input (2). (artifact: 9c59650e48 user: drh)
20:28 • New ticket [c36cdb4afd] Segfault due to SQL inputs. (artifact: f56af9e71d user: drh)
20:27 • New ticket [4f19d72774] Heap buffer overflow on SQL input (4). (artifact: e6541a762d user: drh)
20:26 • New ticket [2971fbe3f9] Heap buffer overflow on SQL input (3). (artifact: abd0366dd1 user: drh)
20:25 • New ticket [b97e6c5e6a] Heap buffer overflow on SQL input (2). (artifact: cf68035943 user: drh)
20:23 • New ticket [33aa4c0de8] Heap buffer overflow on SQL input. (artifact: 23d642d6f7 user: drh)
20:22 • New ticket [89d259d45b] Assertion fault on SQL input (2). (artifact: 96d64a2594 user: drh)
20:19 • New ticket [d15b3a4ea9] Assertion fault on SQL input. (artifact: f61bb278f6 user: drh)
2023-03-10
20:23 • New ticket [667014c20b] Missed optimization when LHS of IN is an expression. (artifact: e3c39d9817 user: drh)
2023-02-24
16:04 • Fixed ticket [0b75886e6d]: Allow some sqlite3_config() calls after sqlite3_initialize(). plus 5 other changes (artifact: 3215cd3477 user: drh)
2023-02-22
21:47 • Fixed ticket [eaed8e36ce]: Enable SQLITE_COUNTOFVIEW_OPTIMIZATION by default plus 5 other changes (artifact: b2144b318f user: drh)
21:11 • Fixed ticket [baa5bb76c3]: UNION ALL view does not use a covering index plus 3 other changes (artifact: 7377070fa6 user: drh)
2023-02-18
15:05 • New ticket [0b75886e6d] Allow some sqlite3_config() calls after sqlite3_initialize().. (artifact: ce89be2998 user: drh)
14:50 • New ticket [eaed8e36ce] Enable SQLITE_COUNTOFVIEW_OPTIMIZATION by default. (artifact: 3818fef5f6 user: drh)
2023-02-16
17:15 • Ticket [baa5bb76c3] UNION ALL view does not use a covering index status still Open with 6 other changes (artifact: 3bdd160b88 user: drh)
17:14 • Ticket [a7f5b0856f] 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 [a7f5b0856f]. (artifact: 878e0ebe8f user: drh)
20:12 • New ticket [baa5bb76c3] UNION ALL view does not use a covering index. (artifact: 8e353e53b0 user: drh)
2022-12-14
18:35 • Fixed ticket [73ebbb3a3d]: View ought not be materialized plus 3 other changes (artifact: e973c9e32a user: drh)
2022-12-13
00:59 • Fixed ticket [57c47526c3]: Incorrect answer when flattening a UNION ALL compound plus 3 other changes (artifact: b6b7910615 user: drh)
2022-12-10
19:37 • Fixed ticket [679ed6a282]: Different affinities in CREATE VIEW depending if column names declared plus 3 other changes (artifact: 351328ce85 user: drh)
13:34 • Ticket [679ed6a282]: 5 changes (artifact: b9a91241d2 user: drh)
13:34 • Ticket [73ebbb3a3d] View ought not be materialized status still Open with 3 other changes (artifact: f0e33ae3ee user: drh)
13:31 • Open ticket [57c47526c3]: Incorrect answer when flattening a UNION ALL compound plus 4 other changes (artifact: 0f2348432b user: drh)
2022-12-06
19:58 • New ticket [679ed6a282] Different affinities in CREATE VIEW depending if column names declared. (artifact: 7a0f43e8cd user: drh)
2022-12-05
17:31 • Ticket [73ebbb3a3d] View ought not be materialized status still Open with 6 other changes (artifact: 1faa067bd6 user: drh)
02:53 • Fixed ticket [e8b6742419]: Query planner chooses an inefficient algorithm. plus 5 other changes (artifact: a9db5f9587 user: drh)
2022-11-28
19:43 • Fixed ticket [695a1a53de]: Better choice of indexes with covering indexes on expressions plus 3 other changes (artifact: 82a258332a user: drh)
2022-11-25
18:45 • Ticket [695a1a53de]: 3 changes (artifact: d5202fa021 user: drh)
18:40 • Ticket [695a1a53de]: 6 changes (artifact: 5ad6703c81 user: drh)
16:12 • Fixed ticket [9937817793]: Use indexed expressions in an aggregate query plus 6 other changes (artifact: fb3dc805a8 user: drh)
2022-11-19
00:08 • Fixed ticket [53043c9793]: deserialized DB has a sqlite3_db_filename() contrary to docs plus 3 other changes (artifact: 91d1a5cfb3 user: drh)
2022-11-18
21:23 • Ticket [53043c9793]: 6 changes (artifact: f1738a9d6e user: drh)
2022-11-11
13:51 • Closed ticket [ee4b2b48f5]: Prepared statement cache plus 5 other changes (artifact: c40bea5050 user: drh)
13:17 • Fixed ticket [6c266900a2]: 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 [73ebbb3a3d] View ought not be materialized. (artifact: 60c699c856 user: drh)
11:59 • New ticket [9937817793] Use indexed expressions in an aggregate query. (artifact: 9593cae7fd user: drh)
11:35 • New ticket [695a1a53de] Better choice of indexes with covering indexes on expressions. (artifact: f6561b0c33 user: drh)
2022-11-01
12:11 • Fixed ticket [57c47526c3]: Incorrect answer when flattening a UNION ALL compound plus 5 other changes (artifact: a68a3ebad5 user: drh)
2022-10-31
13:24 • New ticket [57c47526c3]. (artifact: 8ff47cd8d2 user: drh)
2022-02-01
16:45 • Closed ticket [bd375c20c7]: Potential bug in FTS5 plus 7 other changes (artifact: c8f5a48243 user: dan)
15:23 • New ticket [bd375c20c7]. (artifact: 4232ec8645 user: mrigger)
2021-11-02
22:26 • Fixed ticket [5981a8c041]: Incorrect answer on a SeekScan query plus 6 other changes (artifact: fba198c9c3 user: drh)
20:38 • New ticket [5981a8c041]. (artifact: 2d2d692312 user: drh)
2021-08-18
22:27 • Fixed ticket [f2be158c57]: 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 [f2be158c57]. (artifact: a0e62f7b55 user: drh)
2021-07-23
23:49 • Fixed ticket [c88f3036a2]: ALTER TABLE DROP COLUMN may corrupt data plus 5 other changes (artifact: 8840c8df3b user: drh)
2021-06-25
14:49 • Fixed ticket [6dcbfd11cf]: Incorrect query result due to the SeekScan optimization plus 6 other changes (artifact: 92dc041354 user: drh)
14:27 • New ticket [6dcbfd11cf]. (artifact: e40291a6a2 user: drh)
2021-04-23
13:43 • Closed ticket [c66298e288]: Inconsistent iterations of WhereClause->nTerm plus 6 other changes (artifact: e3978f196b user: drh)
02:58 • New ticket [c66298e288]. (artifact: baf40b6ea5 user: yongheng)
2021-04-18
05:42 • New ticket [c88f3036a2] ALTER TABLE DROP COLUMN may corrupt data. (artifact: aa54a7381b user: dan)
2021-04-15
09:29 • New ticket [53043c9793] deserialized DB has a sqlite3_db_filename() contrary to docs. (artifact: cfab3052b1 user: larrybr)
2021-03-30
19:18 • Fixed ticket [de7db14784]: subquery with limit clause fails as EXISTS operand plus 6 other changes (artifact: 5cfeb90df3 user: drh)
19:17 • Fixed ticket [132994c8b1]: RETURNING old.* seg-faults plus 6 other changes (artifact: 88a4c19d2b user: drh)
00:47 • Ticket [132994c8b1]: 3 changes (artifact: 2559d91f47 user: drh)
2021-03-29
23:55 • Ticket [132994c8b1]: 3 changes (artifact: f8527c33a3 user: larrybr)
23:40 • Ticket [132994c8b1]: 6 changes (artifact: 0177493069 user: larrybr)
23:11 • New ticket [de7db14784] subquery with limit clause fails as EXISTS operand. (artifact: 794b3b3870 user: larrybr)
22:57 • New ticket [132994c8b1] RETURNING old.* seg-faults. (artifact: 05ea74f5f7 user: larrybr)
2021-03-18
16:48 • Fixed ticket [bb8a9fd4a9]: Crash due to MATERIALIZED plus 5 other changes (artifact: cea551f89c user: drh)
12:00 • Ticket [bb8a9fd4a9]: 7 changes (artifact: bb2dea5f23 user: drh)
11:59 • New ticket [bb8a9fd4a9]. (artifact: 81e8c371c7 user: drh)
2021-03-16
18:42 • Fixed ticket [2c6c8689fb]: Non-deterministic date/time function identified as deterministic. plus 5 other changes (artifact: 7a5eabeaab user: drh)
18:27 • New ticket [2c6c8689fb]. (artifact: 35992390e1 user: drh)
12:36 • Ticket [a753a8567d] 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 [a753a8567d]. (artifact: b0d9e62024 user: dan)
12:06 • New ticket [a753a8567d]. (artifact: 95c2baf675 user: dan)
2021-03-15
14:58 • Fixed ticket [1c24a659e6]: DROP COLUMN leaves behind an index plus 5 other changes (artifact: eccc143704 user: drh)
2021-03-14
12:01 • Ticket [1c24a659e6]: 6 changes (artifact: 1d3d0461a3 user: drh)
01:20 • New ticket [1c24a659e6]. (artifact: e3f3b036db user: drh)
2021-03-02
16:27 • Fixed ticket [22dea1cfdb]: Misoptimization in ieee754func plus 5 other changes (artifact: 1ec183f033 user: drh)
2021-02-25
06:40 • Ticket [22dea1cfdb]: 3 changes (artifact: 6c03195f19 user: yongheng)
06:36 • Ticket [22dea1cfdb]: 6 changes (artifact: eb002bda1c user: yongheng)
06:20 • New ticket [22dea1cfdb]. (artifact: 3c741eba3c user: yongheng)
2021-02-15
17:02 • Fixed ticket [c0aeea67d5]: Incorrect LIKE result plus 5 other changes (artifact: 7b22614c38 user: drh)
16:51 • New ticket [c0aeea67d5]. (artifact: 1fd8c4af66 user: drh)
2021-01-27
19:15 • Fixed ticket [ee51301f31]: Incorrect optimization of IN operator. plus 5 other changes (artifact: 8a0867c579 user: drh)
16:06 • New ticket [ee51301f31]. (artifact: 2d6e840056 user: drh)
2020-10-05
03:24 • Fixed ticket [95302bdb08]: WHERE clause that uses a NUMERIC cast influences the result type plus 5 other changes (artifact: 50e0d5ea4c user: drh)
2020-10-03
17:08 • Closed ticket [e33ee62575]: Segfault using a CROSS JOIN on a table using the experimental trigram tokenizer plus 6 other changes (artifact: 47c0d456b6 user: dan)
15:44 • New ticket [e33ee62575]. (artifact: 3b682278d5 user: mrigger)
14:37 • Closed ticket [2ba5930b27]: Unexpected FTS5 integrity-check failure for the experimental trigram tokenizer plus 4 other changes (artifact: dd78ada384 user: dan)
14:37 • Ticket [2ba5930b27]: 6 changes (artifact: f7d2992849 user: dan)
2020-10-02
21:16 • New ticket [95302bdb08] WHERE clause that uses a NUMERIC cast influences the result type. (artifact: bd7d181bc4 user: mrigger)
20:44 • New ticket [2ba5930b27] Unexpected FTS5 integrity-check failure for the experimental trigram tokenizer. (artifact: 851e0fc355 user: mrigger)
20:19 • Closed ticket [0f586dbeb3]: FTS4 integrity-check fails for UTF16 encoding plus 4 other changes (artifact: 845723a5e7 user: dan)
20:17 • Ticket [0f586dbeb3]: 6 changes (artifact: 6c7bdf81d4 user: dan)
20:04 • New ticket [0f586dbeb3]. (artifact: 7cccafc763 user: mrigger)
2020-10-01
14:36 • Fixed ticket [2d5a316356]: Segmentation fault in CROSS JOIN and the rtree extension plus 3 other changes (artifact: ea3a828515 user: drh)
13:33 • Ticket [2d5a316356]: 6 changes (artifact: 5275fb849f user: drh)
11:35 • New ticket [2d5a316356]. (artifact: 2ee12a62ed user: mrigger)
2020-09-30
17:33 • Fixed ticket [5c4e7aa793]: Incorrect result for comparison with NULL plus 6 other changes (artifact: 1091db2ab8 user: drh)
17:18 • New ticket [5c4e7aa793]. (artifact: c71d1ae4f7 user: mrigger)
15:46 • Fixed ticket [66e4b0e271]: Incorrect result for LEFT JOIN plus 7 other changes (artifact: 000faea09a user: drh)
12:47 • New ticket [66e4b0e271]. (artifact: 2d62d6474e user: mrigger)
2020-09-29
11:52 • Ticket [c51489c3b8] Incorrect result from WITH RECURSIVE using DISTINCT status still Fixed with 3 other changes (artifact: 465c627583 user: drh)
2020-09-17
00:47 • Fixed ticket [c51489c3b8]. (artifact: bc9cfc49fb user: drh)
00:00 • New ticket [c51489c3b8]. (artifact: bc4760677c user: drh)
2020-08-27
13:33 • Closed ticket [be31cf009c]: Unexpected result for % and '1E1' plus 3 other changes (artifact: 928fed832c user: drh)
13:21 • Ticket [be31cf009c]: 6 changes (artifact: 8b261c7523 user: drh)
2020-08-26
14:12 • New ticket [be31cf009c]. (artifact: 3102412d99 user: mrigger)
2020-08-24
10:53 • Ticket [f3ff147288] Incorrect result for IN expression with right-hand IS TRUE sub-expression status still Closed with 3 other changes (artifact: 8f15b88088 user: dan)
10:53 • Closed ticket [f3ff147288]. (artifact: f4e913c006 user: dan)
08:17 • New ticket [f3ff147288]. (artifact: 009010c075 user: mrigger)
2020-06-25
03:17 • Ticket [3211687148] Inconsistent result in sum status still Closed with 3 other changes (artifact: b04433e084 user: yongheng)
03:12 • Closed ticket [9c14a0c7ee]: Another inconsistent result plus 7 other changes (artifact: 0636b7056c user: drh)
03:06 • Closed ticket [3211687148]: Inconsistent result in sum plus 7 other changes (artifact: 4fcdd13ddd user: drh)
2020-06-24
19:05 • New ticket [9c14a0c7ee] Another inconsistent result. (artifact: b08b9ad84c user: yongheng)
18:55 • New ticket [3211687148] Inconsistent result in sum. (artifact: e795d09b2f user: yongheng)
2020-06-15
13:56 • Fixed ticket [8f157e8010]: Heap Buffer Overflow in multiSelectOrderBy plus 7 other changes (artifact: 60b1a173cf user: drh)
2020-06-14
20:14 • New ticket [8f157e8010]. (artifact: 5a6a79fc6c user: yongheng)
13:42 • Fixed ticket [9fb26d37ce]: Assertion `flags3==pIn3->flags' failed. plus 6 other changes (artifact: ea0dfdf786 user: drh)
03:57 • New ticket [9fb26d37ce]. (artifact: 5c0fa89b79 user: yongheng)
2020-06-13
21:43 • Fixed ticket [e367f31901]: Assertion `pExpr->pAggInfo==pAggInfo' failed. plus 5 other changes (artifact: c3117e46b1 user: drh)
18:52 • New ticket [e367f31901]. (artifact: 838e3099af user: yongheng)
2020-06-11
16:04 • Fixed ticket [b706351ce2]: Segfault in sqlite3Select plus 3 other changes (artifact: 0131405205 user: drh)
01:12 • Ticket [b706351ce2]: 6 changes (artifact: b07b31dde3 user: drh)
2020-06-10
21:19 • New ticket [b706351ce2]. (artifact: 5b0601cecf user: yongheng)
2020-06-09
23:50 • Fixed ticket [7c6d876f84]: Use after free in resetAccumulator. plus 5 other changes (artifact: 0f214f19d9 user: drh)
2020-06-08
20:26 • New ticket [7c6d876f84]. (artifact: c4f17a319f user: yongheng)
11:38 • Closed ticket [f7d890858f]: Segfault in moveToRoot plus 6 other changes (artifact: 41c2d826a6 user: drh)
2020-06-07
03:01 • New ticket [f7d890858f]. (artifact: 88abc01a39 user: yongheng)
00:43 • Fixed ticket [e5504e987e]: Segfault in sqlite3VdbeCursorMoveto plus 5 other changes (artifact: 42cf529a17 user: drh)
2020-06-06
23:21 • New ticket [e5504e987e]. (artifact: bc502e9362 user: yongheng)
19:36 • Fixed ticket [1f6f353b68]: Segfault in sqlite3VdbeExec plus 5 other changes (artifact: 94be72fccf user: drh)
17:03 • New ticket [1f6f353b68]. (artifact: 955543e288 user: yongheng)
14:44 • Fixed ticket [0899cf62f5]: Segfault in sqlite3VdbeExec plus 5 other changes (artifact: b4bdfecefd user: drh)
2020-06-05
23:21 • New ticket [0899cf62f5]. (artifact: caa07d55de user: yongheng)
15:26 • Fixed ticket [c8d3b9f0a7]: Use after free in resetAccumulator. plus 5 other changes (artifact: a22f5809c5 user: drh)
01:52 • New ticket [c8d3b9f0a7]. (artifact: cd708fa84d user: yongheng)
2020-06-03
19:31 • Fixed ticket [810dc80388]: COMMIT command succeeds even though it didn't commit. plus 6 other changes (artifact: 0f4da86434 user: drh)
19:24 • New ticket [810dc80388]. (artifact: f620056cd8 user: drh)
2020-05-24
03:39 • Fixed ticket [7a5279a25c]: Segfault in sqlite3ExprCodeTarget plus 5 other changes (artifact: b803c5fed4 user: drh)
2020-05-23
20:03 • Fixed ticket [23439ea582]: Stack overflow in sqlite3_str_vappendf, caused by int overflow plus 7 other changes (artifact: 126aa8d463 user: drh)
17:53 • New ticket [7a5279a25c] Segfault in sqlite3ExprCodeTarget. (artifact: 420e884fd5 user: yongheng)
17:52 • New ticket [23439ea582] Stack overflow in sqlite3_str_vappendf, caused by int overflow. (artifact: e6eaff95c9 user: yongheng)
2020-04-25
15:02 • Closed ticket [45f4bf4eb4]: UNION operator malfunctions in LEFT JOIN on view plus 5 other changes (artifact: 62ca919c05 user: dan)
08:52 • New ticket [45f4bf4eb4]. (artifact: 5b488139aa user: mrigger)
2020-04-04
00:16 • Fixed ticket [51166be015]: Assertion `pC!=0' failed. plus 5 other changes (artifact: 70b9fa516e user: drh)
2020-04-03
20:08 • Closed ticket [fd1bda016d]: Assertion `flags3==pIn3->flags' failed plus 5 other changes (artifact: 4eb60b8b5e user: dan)
15:51 • New ticket [51166be015] Assertion `pC!=0' failed.. (artifact: a0b07baabc user: yongheng)
15:46 • New ticket [fd1bda016d] Assertion `flags3==pIn3->flags' failed. (artifact: 7c5be25142 user: yongheng)
13:19 • Fixed ticket [af4556bb5c]: Segfault while trying to prepare a malformed window-function query plus 5 other changes (artifact: 2a937ba0a5 user: drh)
12:05 • Fixed ticket [a10a14e9b4]: Assertion fault while renaming a table. plus 5 other changes (artifact: f31c6a01ff user: drh)
11:45 • New ticket [af4556bb5c] Segfault while trying to prepare a malformed window-function query. (artifact: f36b87cd50 user: drh)
11:28 • New ticket [a10a14e9b4] Assertion fault while renaming a table.. (artifact: ba03dc25a9 user: drh)
11:26 • Fixed ticket [4722bdab08]: Another renameTokenCheckAll() fault plus 5 other changes (artifact: 9ea5881e85 user: drh)
2020-04-02
22:55 • New ticket [4722bdab08]. (artifact: 2c14577f7e user: drh)
2020-03-22
03:20 • Ticket [5829597ac4] SEGV in sqlite3.c:80685 sqlite3VdbeCursorMoveto status still Fixed with 3 other changes (artifact: 51ef94738e user: drh)
02:34 • Ticket [5829597ac4]: 3 changes (artifact: f772d7686f user: yongheng)
2020-03-21
23:12 • Fixed ticket [5829597ac4]. (artifact: 06f786d0c4 user: drh)
22:17 • Ticket [5829597ac4]: 3 changes (artifact: 17b0a22852 user: drh)
20:46 • Ticket [5829597ac4]: 6 changes (artifact: cf86a492e3 user: yongheng)
20:46 • New ticket [5829597ac4]. (artifact: d094ac53cd user: yongheng)
2020-03-16
19:00 • Closed ticket [618156e3f6]: clearSelect: Assertion `p->pWin==0' failed. plus 5 other changes (artifact: 5d2842adc3 user: dan)
17:35 • New ticket [618156e3f6]. (artifact: d39dfc6c5c user: yongheng)
03:19 • Fixed ticket [82b588d342]: Assertion `memIsValid(&r.aMemii)' failed. plus 6 other changes (artifact: f92b45354a user: drh)
2020-03-15
21:01 • New ticket [82b588d342]. (artifact: da43a6e886 user: yongheng)
2020-03-11
19:56 • Fixed ticket [3c9eadd2a6]: PRAGMA integrity_check fails due to CHECK constraint even without records plus 4 other changes (artifact: 55c5b3243f user: drh)
2020-03-10
11:51 • Fixed ticket [e0c2ad1aa8]: GROUP BY causes unexpected conversion plus 5 other changes (artifact: 1c704188fb user: drh)
09:33 • New ticket [e0c2ad1aa8]. (artifact: 08bec9f539 user: mrigger)
2020-03-06
00:15 • Fixed ticket [fa146dcfe6]: Unexpected result for MIN on string that contains a null character plus 7 other changes (artifact: 12df899fa7 user: drh)
2020-03-05
16:37 • New ticket [fa146dcfe6]. (artifact: 33ec640208 user: mrigger)
16:26 • Fixed ticket [1b8d726456]: MAX yields unexpected result for UTF-16 plus 6 other changes (artifact: bf4e521e96 user: drh)
2020-03-04
22:56 • New ticket [1b8d726456]. (artifact: f1ec275c17 user: mrigger)
2020-03-03
20:49 • Fixed ticket [c4c56482ce]: Assertion `(p->flags & ~(MEM_Null|MEM_Term|MEM_Subtype|MEM_FromBind |MEM_Dyn|MEM_Ephem|MEM_Static))==0' failed. plus 6 other changes (artifact: a601222f65 user: drh)
20:06 • Fixed ticket [d165ad781b]: Assertion `(mFlags&(MEM_Str|MEM_Blob))==0 || (pMem->n==pX->n && pMem->z==pX->z)' failed. plus 6 other changes (artifact: 4f20d6927b user: drh)
19:42 • New ticket [d165ad781b]. (artifact: c714956cba user: yongheng)
19:04 • New ticket [c4c56482ce] Assertion `(p->flags & ~(MEM_Null|MEM_Term|MEM_Subtype|MEM_FromBind |MEM_Dyn|MEM_Ephem|MEM_Static))==0' failed.. (artifact: 636e77d7f1 user: yongheng)
2020-03-02
01:51 • Fixed ticket [da5a09be6d]: UAF in sqlite3BlobCompare plus 6 other changes (artifact: d1264e41dd user: drh)
01:30 • Ticket [e12a0ae526] Assertion `memIsValid(&aMempOp->p1)' failed status still Fixed with 3 other changes (artifact: 87fc6c958c user: drh)
01:16 • Fixed ticket [e12a0ae526]. (artifact: bf149b87f2 user: drh)
2020-02-29
21:41 • New ticket [da5a09be6d] UAF in sqlite3BlobCompare. (artifact: 806f997729 user: yongheng)
21:39 • New ticket [e12a0ae526] Assertion `memIsValid(&aMempOp->p1)' failed. (artifact: 72a8701aa3 user: yongheng)
2020-02-28
16:04 • Fixed ticket [e63b4d1a65]: Query on rtree unexpectedly yields 0 rather than 0.0 plus 5 other changes (artifact: 7861527daa user: drh)
14:49 • New ticket [e63b4d1a65]. (artifact: 5e3591cf8a user: mrigger)
2020-02-23
17:38 • Fixed ticket [f50af3e8a5]: OOB memory access on a table rename plus 5 other changes (artifact: 929fcf1da9 user: drh)
16:16 • Ticket [f50af3e8a5]: 6 changes (artifact: 569133e78e user: drh)
16:09 • New ticket [f50af3e8a5]. (artifact: 8fb06da974 user: drh)
2020-02-22
13:07 • Fixed ticket [aa43786930]: sqlite3.c:87338: int sqlite3VdbeExec(Vdbe *): Assertion `sqlite3BtreeCursorIsValid(pCrsr)' failed. plus 6 other changes (artifact: 9fee20675e user: drh)
04:18 • New ticket [aa43786930]. (artifact: ba0b33c0f8 user: yongheng)
2020-02-17
00:12 • Fixed ticket [4374860b29]: Segmentation fault in isAuxiliaryVtabOperator plus 5 other changes (artifact: 971c60ab36 user: drh)
2020-02-16
20:37 • New ticket [4374860b29]. (artifact: 35dadd9276 user: yongheng)
2020-02-13
22:12 • Fixed ticket [1dcb4d4496]: Incorrect query result when redundant terms appears in WHERE clause plus 5 other changes (artifact: 1a3d605b90 user: drh)
20:37 • New ticket [1dcb4d4496]. (artifact: 2274c85b7a user: drh)
11:47 • Fixed ticket [41c1456a6e]: Assertion `pColl1 && (pParse->nErr || pColl2)' failed. plus 6 other changes (artifact: c72a159dcf user: drh)
02:13 • New ticket [41c1456a6e]. (artifact: 9c16e62231 user: yongheng)
2020-02-12
13:02 • Fixed ticket [fb8c538a8f]: Incorrect sorting when a column uses BINARY collation in the ORDER BY, but is constrained by an == with a different collation in the WHERE clause plus 3 other changes (artifact: 96f91c7db6 user: drh)
11:18 • Ticket [fb8c538a8f]: 6 changes (artifact: 19ffc8588b user: drh)
06:21 • New ticket [fb8c538a8f]. (artifact: c83cd179b0 user: dan)
2020-02-04
03:01 • Fixed ticket [f07d71bb49]: Assertion `pOp->p4type==P4_FUNCCTX' failed. plus 6 other changes (artifact: ed88e6592e user: drh)
02:52 • New ticket [f07d71bb49]. (artifact: ffc7e9ddf1 user: yongheng)
01:50 • Fixed ticket [86ba67afaf]: Incorrect affinity for CHECK constraints plus 5 other changes (artifact: 36a81307ca user: drh)
01:49 • Fixed ticket [9d3666754a]: int sqlite3VdbeExec(Vdbe *): Assertion `memIsValid(pCtx->argvi)' failed. plus 5 other changes (artifact: bfde5dc28a user: drh)
2020-02-03
22:45 • New ticket [9d3666754a]. (artifact: 2c85b4bc16 user: yongheng)
16:07 • Ticket [86ba67afaf] Incorrect affinity for CHECK constraints status still Open with 6 other changes (artifact: 625d7cb6b4 user: drh)
2020-02-01
14:30 • New ticket [86ba67afaf]. (artifact: 605ae30539 user: drh)
2020-01-29
23:19 • Closed ticket [1dc432db3b]: FTS4 integrity-check results in "database disk image is malformed" for UTF-16 encoding plus 4 other changes (artifact: 10166d7b08 user: drh)
10:10 • Ticket [1dc432db3b]: 3 changes (artifact: 68d922e497 user: mrigger)
2020-01-22
23:13 • Fixed ticket [b985f0bd16]: Assertion `0' failed in sqlite3IsLikeFunction plus 6 other changes (artifact: 076ee1f865 user: drh)
21:49 • New ticket [b985f0bd16]. (artifact: caa141c601 user: yongheng)
2020-01-18
21:35 • Closed ticket [830277d9db]: Non-deterministic date/time functions allowed in CHECK constraints plus 5 other changes (artifact: dfd3e472d1 user: drh)
2020-01-15
16:20 • Fixed ticket [a08879a4a4]: Assertion `pKeyInfo->enc==ENC(db)' failed. plus 6 other changes (artifact: c6b7444e68 user: drh)
14:38 • New ticket [a08879a4a4]. (artifact: 2c879cc963 user: yongheng)
2020-01-12
22:20 • Fixed ticket [614b25314c]: Assertion (pTabItem0.fg.jointype & JT_LEFT)==0 || ExprHasProperty(pOrExpr, EP_FromJoin) failed plus 5 other changes (artifact: 6def3b4465 user: drh)
21:51 • New ticket [614b25314c]. (artifact: 5e9929959e user: yongheng)
2020-01-10
01:33 • Ticket [5c5a16ec29] Test ticket status still Closed with 3 other changes (artifact: 740a156071 user: yongheng)
01:32 • Fixed ticket [a148d923bf]: Assertion `memIsValid(pCtx->argvi)' failed. plus 5 other changes (artifact: 702ee02fc3 user: yongheng)
01:31 • New ticket [a148d923bf]. (artifact: 336e7b2ff9 user: yongheng)
01:13 • Closed ticket [c45762c806]: Second test ticket plus 5 other changes (artifact: 73c47a4b58 user: drh)
01:13 • New ticket [c45762c806]. (artifact: 38466a0f1b user: drh)
01:12 • Closed ticket [5c5a16ec29]: Test ticket plus 4 other changes (artifact: ee338488d4 user: drh)
01:11 • Ticket [5c5a16ec29]: 7 changes (artifact: d74550710d user: drh)
01:10 • New ticket [5c5a16ec29]. (artifact: 4db4ce7495 user: drh)
2020-01-09
20:21 • Fixed ticket [678ecf429f]: Assertion `pWin==pMWin || sqlite3WindowCompare(pParse,pWin,pMWin,0)==0' failed plus 5 other changes (artifact: d900f336e7 user: drh)
17:44 • New ticket [678ecf429f]. (artifact: 4d0daf8517 user: yongheng)
2020-01-08
12:17 • Fixed ticket [9eda2697f5]: Incorrect result for COUNT(), UTF16be encoding and SUBSTR plus 5 other changes (artifact: e2b031bd69 user: drh)
10:37 • New ticket [9eda2697f5]. (artifact: d39be4d2eb user: mrigger)
01:44 • Fixed ticket [82ac75ba00]: Incorrect result for query with 0 >= t0.c0 AND t0.c0 = v0.c0 condition plus 6 other changes (artifact: fc968219cd user: drh)
2020-01-07
21:41 • New ticket [82ac75ba00]. (artifact: f92e43ead6 user: mrigger)
2020-01-06
22:48 • Ticket [bbd55a97e6] Global heap over flow in sqlite3VdbeMemPrettyPrint status still Fixed with 3 other changes (artifact: c7a5e7e243 user: yongheng)
20:49 • Ticket [bbd55a97e6]: 3 changes (artifact: 59ee204fa7 user: drh)
20:11 • Ticket [bbd55a97e6]: 3 changes (artifact: 2cd745359d user: yongheng)
20:04 • Ticket [bbd55a97e6]: 3 changes (artifact: 223ff27bc9 user: drh)
20:01 • Ticket [bbd55a97e6]: 3 changes (artifact: 2f6036a635 user: yongheng)
19:45 • Ticket [bbd55a97e6]: 3 changes (artifact: d35b74d858 user: yongheng)
19:25 • Fixed ticket [bbd55a97e6]. (artifact: 03e0f8e947 user: drh)
18:39 • New ticket [bbd55a97e6]. (artifact: 344324224f user: yongheng)
17:47 • Fixed ticket [9c944882bf]: Assertion `pSub->pGroupBy==0' failed. plus 3 other changes (artifact: 9489ee7b5d user: yongheng)
17:42 • Ticket [9c944882bf]: 3 changes (artifact: 20a1811441 user: drh)
17:33 • Fixed ticket [304017f5f0]: Assertion `j>=pLoop->u.btree.nEq || (pLoop->aLTermj==0)==(j<pLoop->nSkip)' failed. plus 6 other changes (artifact: 47939094a5 user: drh)
17:31 • Ticket [9c944882bf] Assertion `pSub->pGroupBy==0' failed. status still Closed with 3 other changes (artifact: 03adca3b7b user: yongheng)
17:08 • Closed ticket [9c944882bf]. (artifact: 7c41abbf55 user: dan)
15:34 • New ticket [9c944882bf]. (artifact: 659941fa65 user: yongheng)
15:32 • New ticket [304017f5f0] Assertion `j>=pLoop->u.btree.nEq || (pLoop->aLTermj==0)==(j<pLoop->nSkip)' failed.. (artifact: ae409a95ae user: yongheng)
2020-01-04
20:07 • Ticket [a3713a5fca] DBSTAT query computes incorrect result for stat.aggregate = 1 condition status still Closed with 3 other changes (artifact: c646048c57 user: mrigger)
19:57 • Closed ticket [a3713a5fca]. (artifact: f38b95a7da user: drh)
19:26 • Ticket [a3713a5fca]: 3 changes (artifact: 2f01fa87c3 user: mrigger)
19:15 • Fixed ticket [a3713a5fca]. (artifact: 39eec80385 user: drh)
18:53 • Closed ticket [74a4c3860c]: DBSTAT query computes incorrect result for name column plus 5 other changes (artifact: 15c050928b user: dan)
18:51 • New ticket [a3713a5fca] DBSTAT query computes incorrect result for stat.aggregate = 1 condition. (artifact: 57f82aaf0e user: mrigger)
16:09 • New ticket [74a4c3860c] DBSTAT query computes incorrect result for name column. (artifact: 9d42cfcef4 user: mrigger)
15:23 • Fixed ticket [727074e2ae]: DBSTAT query computes incorrect result for aggregate column plus 5 other changes (artifact: 5400437ea7 user: drh)
11:22 • New ticket [727074e2ae]. (artifact: c7bce00a7e user: mrigger)
2020-01-02
16:24 • Closed ticket [771fe61761]: FTS5 integrity-check results in "database disk image is malformed" for UTF-16 encoding and SUBSTR plus 5 other changes (artifact: 0624b2adaa user: dan)
2020-01-01
22:29 • New ticket [771fe61761]. (artifact: a3dd00c021 user: mrigger)
2019-12-31
23:17 • Fixed ticket [46fcd700b8]: Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u.r' failed (2) plus 5 other changes (artifact: c8f7dc2b2b user: drh)
21:57 • New ticket [46fcd700b8]. (artifact: 78d95b9110 user: mrigger)
13:55 • Closed ticket [a0e88d8d7a]: Inconsistent handling of subqueries in index expressions plus 3 other changes (artifact: 85debbfbfe user: drh)
10:12 • Ticket [a0e88d8d7a]: 3 changes (artifact: 9ba36ec01c user: mrigger)
2019-12-30
23:50 • Fixed ticket [892575cdba]: Debug assertion codeVectorCompare: Assertion `0' failed plus 5 other changes (artifact: d64a681346 user: drh)
23:40 • Ticket [a0e88d8d7a] Inconsistent handling of subqueries in index expressions status still Open with 7 other changes (artifact: 25e555cf6a user: drh)
21:32 • New ticket [a0e88d8d7a]. (artifact: ef13ac13bb user: mrigger)
21:01 • New ticket [892575cdba] Debug assertion codeVectorCompare: Assertion `0' failed. (artifact: abf9d81f6e user: mrigger)
14:32 • Closed ticket [7c0e06b162]: NATURAL JOIN on virtual table results in "parse error in rank function" plus 5 other changes (artifact: 156c8eb026 user: dan)
10:42 • New ticket [7c0e06b162]. (artifact: 39d9de70b5 user: mrigger)
2019-12-29
22:09 • Fixed ticket [314cc133e5]: Trigger on normal table causes the database disk image to become malformed plus 7 other changes (artifact: 671eb125c8 user: drh)
17:14 • New ticket [314cc133e5]. (artifact: 8d33e67d8e user: mrigger)
00:56 • Ticket [ec8abb025e] Debug assertion sqlite3BtreeInsert: Assertion `pCur->curFlags & BTCF_ValidNKey' failed status still Fixed with 3 other changes (artifact: cc67369249 user: drh)
2019-12-28
01:53 • Fixed ticket [de4b04149b]: Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u.r' failed plus 5 other changes (artifact: 60b955f0b0 user: drh)
00:37 • Fixed ticket [5fbc159eeb]: Debug assertion sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed plus 5 other changes (artifact: 7c38a92691 user: drh)
00:37 • Fixed ticket [37823501c6]: Debug assertion sqlite3VdbeExec: Assertion `memIsValid(&aMempOp->p1)' failed. plus 5 other changes (artifact: 927f79f9fb user: drh)
2019-12-27
22:11 • New ticket [de4b04149b] Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Real)==0 || pMem->u.r==pX->u.r' failed. (artifact: 26b61d4b68 user: mrigger)
20:51 • New ticket [5fbc159eeb] Debug assertion sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed. (artifact: b481e01e81 user: mrigger)
20:06 • Closed ticket [36ffedcb9a]: Debug assertion exprSrcCount: Assertion `0' failed plus 5 other changes (artifact: e5b585aea1 user: dan)
19:39 • New ticket [36ffedcb9a]. (artifact: 2e9f813beb user: mrigger)
17:06 • New ticket [37823501c6] Debug assertion sqlite3VdbeExec: Assertion `memIsValid(&aMempOp->p1)' failed.. (artifact: dbba73b454 user: mrigger)
14:16 • Ticket [1dc432db3b] FTS4 integrity-check results in "database disk image is malformed" for UTF-16 encoding status still Open with 3 other changes (artifact: b88cf338eb user: dan)
14:14 • Ticket [1dc432db3b]: 6 changes (artifact: f9de0d3cc3 user: dan)
11:08 • New ticket [1dc432db3b]. (artifact: 8029c85801 user: mrigger)
01:51 • Fixed ticket [fb3b3024ea]: Debug assertion assert_pager_state: Assertion `pPager->changeCountDone==0 || pPager->eLock>=RESERVED_LOCK' failed plus 6 other changes (artifact: 2ca5097df4 user: drh)
00:26 • New ticket [fb3b3024ea]. (artifact: ea6d8c548d user: mrigger)
2019-12-26
23:40 • Fixed ticket [7c13db5c3b]: Debug assertion sqlite3FinishCoding: Assertion `!pParse->isMultiWrite || sqlite3VdbeAssertMayAbort(v, pParse->mayAbort)' failed plus 5 other changes (artifact: 4619817eeb user: drh)
23:26 • Fixed ticket [ec8abb025e]: Debug assertion sqlite3BtreeInsert: Assertion `pCur->curFlags & BTCF_ValidNKey' failed plus 5 other changes (artifact: 29436a02ca user: drh)
22:44 • New ticket [7c13db5c3b] Debug assertion sqlite3FinishCoding: Assertion `!pParse->isMultiWrite || sqlite3VdbeAssertMayAbort(v, pParse->mayAbort)' failed. (artifact: 0d7b74bccf user: mrigger)
18:50 • New ticket [ec8abb025e] Debug assertion sqlite3BtreeInsert: Assertion `pCur->curFlags & BTCF_ValidNKey' failed. (artifact: cc3e141d66 user: mrigger)
14:37 • Closed ticket [167b2aac34]: Debug assertion fts5CheckTransactionState: Assertion `iSavepoint<=p->ts.iSavepoint' failed plus 5 other changes (artifact: ab09a7ccec user: dan)
2019-12-25
23:54 • Fixed ticket [d87336c81c]: Debug assertion sqlite3TableColumnAffinity: Assertion `iCol<pTab->nCol' failed. plus 6 other changes (artifact: dbcd8756dd user: drh)
00:39 • New ticket [d87336c81c]. (artifact: f12666a770 user: mrigger)
2019-12-24
23:26 • New ticket [167b2aac34] Debug assertion fts5CheckTransactionState: Assertion `iSavepoint<=p->ts.iSavepoint' failed. (artifact: 332c48da61 user: mrigger)
21:09 • Closed ticket [56a74875be]: UPDATE causes "database table is locked" for rtree table plus 4 other changes (artifact: 8c1f571002 user: drh)
20:51 • Closed ticket [752fdbf6e7]: FTS database disk image is malformed for UTF-16 encoding and integrity check plus 5 other changes (artifact: f7cfb4b9b5 user: dan)
19:09 • New ticket [752fdbf6e7]. (artifact: d933cba92e user: mrigger)
16:20 • Closed ticket [df46a6f38e]: Debug assertion sqlite3Fts5HashScanNext: Assertion `!sqlite3Fts5HashScanEof(p)' failed plus 5 other changes (artifact: 4be9398182 user: dan)
15:04 • Fixed ticket [d62981b76d]: FTS database disk image is malformed for special characters in table plus 6 other changes (artifact: 8a7e748061 user: drh)
14:42 • New ticket [df46a6f38e] Debug assertion sqlite3Fts5HashScanNext: Assertion `!sqlite3Fts5HashScanEof(p)' failed. (artifact: a5edb1955a user: mrigger)
02:36 • Closed ticket [cafeafe605]: UPDATE with complex WHERE condition on rtree results in "database table is locked" error plus 7 other changes (artifact: 2298d6c32d user: drh)
01:53 • Fixed ticket [b383b90278]: Debug assertion sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed (2) plus 6 other changes (artifact: 8263e442ad user: drh)
2019-12-23
23:33 • New ticket [cafeafe605] UPDATE with complex WHERE condition on rtree results in "database table is locked" error. (artifact: 8d3ce16330 user: mrigger)
23:19 • New ticket [b383b90278] Debug assertion sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed (2). (artifact: ae0b568447 user: mrigger)
22:04 • New ticket [d62981b76d] FTS database disk image is malformed for special characters in table. (artifact: 9625949d9c user: mrigger)
20:42 • Fixed ticket [5eadca17c4]: Debug assertion rtreeRelease: Assertion `pRtree->nNodeRef==0 || pRtree->bCorrupt' failed plus 6 other changes (artifact: 92ea3691dd user: drh)
20:03 • New ticket [5eadca17c4]. (artifact: 736d6825c8 user: mrigger)
19:29 • Fixed ticket [56a74875be]: UPDATE causes "database table is locked" for rtree table plus 4 other changes (artifact: 5e486ff47a user: drh)
15:24 • Closed ticket [bf1aab8978]: FTS merge does not terminate plus 5 other changes (artifact: 962c97b52d user: dan)
15:17 • Closed ticket [dfd66334cf]: Debug assertion impliesNotNullRow: Assertion `pWalker->eCode==0' failed plus 5 other changes (artifact: a85ae69839 user: dan)
14:36 • Closed ticket [3ab4a9f02c]: Debug assertion sqlite3VdbeExec: Assertion `pC!=0' failed plus 6 other changes (artifact: 515462bc94 user: dan)
14:21 • Closed ticket [d9ed4ebef1]: SELECT on window function causes a segfault plus 5 other changes (artifact: ec51a80e4a user: dan)
13:36 • New ticket [dfd66334cf] Debug assertion impliesNotNullRow: Assertion `pWalker->eCode==0' failed. (artifact: e9d255c9f4 user: mrigger)
12:50 • Open ticket [56a74875be]: UPDATE causes "database table is locked" for rtree table plus 4 other changes (artifact: 583e16aec2 user: drh)
09:35 • New ticket [3ab4a9f02c] Debug assertion sqlite3VdbeExec: Assertion `pC!=0' failed. (artifact: 9719e5748a user: mrigger)
03:38 • Fixed ticket [0911b5d161]: Debug assertion sqlite3MemCompare: Assertion `pMem1->enc==pMem2->enc || pMem1->db->mallocFailed' failed plus 6 other changes (artifact: 2debfe3bf6 user: drh)
02:50 • Fixed ticket [9d708e4742]: Debug assertion sqlite3VdbeExec: Assertion `flags3==pIn3->flags' failed (2) plus 7 other changes (artifact: 29428a8724 user: drh)
02:33 • Ticket [5ad2aa6921] Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Str)==0 || (pMem->n==pX->n && pMem->z==pX->z)' failed status still Fixed with 3 other changes (artifact: 915996400f user: drh)
02:30 • Fixed ticket [c62c5e5852]: Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Str)==0 || (pMem->n==pX->n && pMem->z==pX->z)' failed (2) plus 5 other changes (artifact: 415adc126e user: drh)
00:08 • New ticket [9d708e4742] Debug assertion sqlite3VdbeExec: Assertion `flags3==pIn3->flags' failed (2). (artifact: 45ad40815b user: mrigger)
2019-12-22
23:48 • Fixed ticket [188f912b51]: Debug assertion sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed plus 6 other changes (artifact: c0d08373f3 user: drh)
23:43 • New ticket [0911b5d161] Debug assertion sqlite3MemCompare: Assertion `pMem1->enc==pMem2->enc || pMem1->db->mallocFailed' failed. (artifact: e85cfad542 user: mrigger)
23:06 • Ticket [c62c5e5852] Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Str)==0 || (pMem->n==pX->n && pMem->z==pX->z)' failed (2) status still Open with 6 other changes (artifact: d2e6a4e7a2 user: mrigger)
23:05 • New ticket [c62c5e5852]. (artifact: f2e35331b3 user: mrigger)
21:53 • New ticket [188f912b51] Debug assertion sqlite3VdbeExec: Assertion `pIn1!=pIn3' failed. (artifact: e375f380c5 user: mrigger)
20:29 • Fixed ticket [5ad2aa6921]: Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Str)==0 || (pMem->n==pX->n && pMem->z==pX->z)' failed plus 6 other changes (artifact: ba99796101 user: drh)
20:03 • Fixed ticket [7929c1efb2]: Debug assertion constructAutomaticIndex: Assertion `!ExprHasProperty(pExpr, EP_FromJoin) || pExpr->iRightJoinTable!=pSrc->iCursor || pLoop->prereq!=0' failed plus 6 other changes (artifact: c3e6d03f4d user: drh)
18:55 • Fixed ticket [b0cb8aff56]: Debug assertion sqlite3ExprSkipCollateAndLikely: Assertion `pExpr->op==TK_COLLATE' failed plus 6 other changes (artifact: 6d8d8ab778 user: drh)
18:23 • Fixed ticket [1b06916e01]: Debug assertion sqlite3VdbeExec: Assertion `flags3==pIn3->flags' failed plus 6 other changes (artifact: efa1ee41e5 user: drh)
17:53 • New ticket [d9ed4ebef1] SELECT on window function causes a segfault. (artifact: 87e12b7d61 user: mrigger)
17:32 • Closed ticket [f00d096cae]: Debug assertion sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed plus 5 other changes (artifact: 04aede2e44 user: dan)
17:09 • New ticket [1b06916e01] Debug assertion sqlite3VdbeExec: Assertion `flags3==pIn3->flags' failed. (artifact: 9911eeb574 user: mrigger)
14:30 • Closed ticket [9cb7d0ef44]: Debug assertion fts5StructureRead: Assertion `p->iStructVersion!=0' failed plus 5 other changes (artifact: 242ff056d1 user: dan)
10:47 • New ticket [f00d096cae] Debug assertion sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed. (artifact: eab346388d user: mrigger)
10:26 • New ticket [5ad2aa6921] Debug assertion sqlite3VdbeMemAboutToChange: Assertion `(mFlags&MEM_Str)==0 || (pMem->n==pX->n && pMem->z==pX->z)' failed. (artifact: e3743aaf0e user: mrigger)
10:16 • New ticket [7929c1efb2] Debug assertion constructAutomaticIndex: Assertion `!ExprHasProperty(pExpr, EP_FromJoin) || pExpr->iRightJoinTable!=pSrc->iCursor || pLoop->prereq!=0' failed. (artifact: ae5fa47a21 user: mrigger)
09:48 • New ticket [b0cb8aff56] Debug assertion sqlite3ExprSkipCollateAndLikely: Assertion `pExpr->op==TK_COLLATE' failed. (artifact: f6637b645a user: mrigger)
09:34 • New ticket [9cb7d0ef44] Debug assertion fts5StructureRead: Assertion `p->iStructVersion!=0' failed. (artifact: 7a458c2a5f user: mrigger)
00:21 • Ticket [56a74875be] UPDATE causes "database table is locked" for rtree table status still Closed with 3 other changes (artifact: 79022f698b user: drh)
2019-12-21
23:28 • Ticket [56a74875be]: 3 changes (artifact: 33d56bf510 user: mrigger)
20:43 • Closed ticket [cd3311e323]: FTS database disk image is malformed for update on languageid plus 5 other changes (artifact: e96fe9d946 user: dan)
13:35 • Ticket [56a74875be] UPDATE causes "database table is locked" for rtree table status still Closed with 3 other changes (artifact: f255e4e2d5 user: mrigger)
11:48 • Closed ticket [56a74875be]. (artifact: cdeb5a19f3 user: drh)
2019-12-20
22:47 • Fixed ticket [e0a8120553]: Incorrect result for BETWEEN and generated column plus 3 other changes (artifact: f5fab32b47 user: drh)
22:18 • New ticket [cd3311e323] FTS database disk image is malformed for update on languageid. (artifact: beaa2f54f4 user: mrigger)
20:56 • Ticket [e0a8120553] Incorrect result for BETWEEN and generated column status still Open with 8 other changes (artifact: 924f809648 user: drh)
19:41 • Closed ticket [e431c35542]: FTS database disk image is malformed for UTF-16 encoding plus 5 other changes (artifact: 8a229fe746 user: dan)
17:03 • New ticket [e431c35542]. (artifact: f0d87f64dd user: mrigger)
15:54 • New ticket [e0a8120553] Incorrect result for BETWEEN and generated column. (artifact: adb801d0d0 user: mrigger)
13:24 • Closed ticket [cf36cb4e02]: FTS database disk image is malformed for UTF-16 encoding after update plus 5 other changes (artifact: fc18f675b9 user: dan)
2019-12-19
23:08 • New ticket [56a74875be] UPDATE causes "database table is locked" for rtree table. (artifact: 9a7f78da2a user: mrigger)
2019-12-16
16:52 • Fixed ticket [3b84b42943]: LEFT JOIN malfunctions with generated column plus 6 other changes (artifact: 29fba8ed45 user: drh)
12:59 • New ticket [3b84b42943]. (artifact: 73baa93da5 user: mrigger)
2019-12-14
17:44 • Fixed ticket [b439bfcfb7]: REINDEX segfaults on table with generated columns plus 7 other changes (artifact: 71e9e32c60 user: drh)
16:37 • New ticket [b439bfcfb7]. (artifact: c94b851f42 user: mrigger)
2019-12-11
18:06 • New ticket [cf36cb4e02] FTS database disk image is malformed for UTF-16 encoding after update. (artifact: 2faceff94a user: mrigger)
2019-12-10
02:48 • Fixed ticket [d7c3f125c9]: REINDEX results in "UNIQUE constraint failed" for generated column plus 6 other changes (artifact: 4d7b8ca3eb user: drh)
2019-12-09
21:40 • New ticket [d7c3f125c9]. (artifact: 079c19d2a9 user: mrigger)
15:52 • Fixed ticket [bd8c280671]: PRAGMA integrity_check does not terminate on table with generated column plus 6 other changes (artifact: 260f1651e1 user: drh)
2019-12-08
00:23 • New ticket [bd8c280671]. (artifact: 1f693d5ede user: mrigger)
00:06 • Fixed ticket [b92e5e8ec2]: Query on table without rows and generated column results in "out of memory" error plus 6 other changes (artifact: 54256d7920 user: drh)
2019-12-07
14:11 • New ticket [b92e5e8ec2]. (artifact: bb5affde11 user: mrigger)
12:15 • Ticket [8bf76328ac] NOT NULL auxiliary column in rtree table malfunctions status still Fixed with 3 other changes (artifact: 062a7b575e user: drh)
11:12 • Ticket [8bf76328ac]: 3 changes (artifact: 72e38425fb user: mrigger)
2019-12-06
13:12 • Fixed ticket [367a86e288]: Incorrect result for predicate on rtree table plus 8 other changes (artifact: d6873fa321 user: drh)
11:17 • New ticket [367a86e288]. (artifact: 3c5c152860 user: mrigger)
09:39 • Ticket [8bf76328ac] NOT NULL auxiliary column in rtree table malfunctions status still Fixed with 3 other changes (artifact: 4a116ea84e user: mrigger)
03:04 • Fixed ticket [8bf76328ac]. (artifact: 8dcf669c9e user: drh)
01:38 • Fixed ticket [aa573a787b]: Comparison on INT column in rtree table malfunctions plus 7 other changes (artifact: 604df191d6 user: drh)
00:15 • New ticket [8bf76328ac] NOT NULL auxiliary column in rtree table malfunctions. (artifact: 8ae69a63f2 user: mrigger)
2019-12-05
23:06 • New ticket [aa573a787b] Comparison on INT column in rtree table malfunctions. (artifact: 14375ff98b user: mrigger)
21:46 • Fixed ticket [f096d191b6]: Row value comparison malfunctions with rtree table plus 6 other changes (artifact: 94427d7c8f user: drh)
15:08 • New ticket [f096d191b6]. (artifact: 6a830c857d user: mrigger)
14:42 • Fixed ticket [9fe487ba3c]: Join on two rtree tables malfunctions plus 6 other changes (artifact: 5a23b8cdf6 user: drh)
14:20 • New ticket [9fe487ba3c]. (artifact: 063de6e7be user: mrigger)
13:35 • Fixed ticket [30e2c183b6]: column = NULL predicate evaluates to TRUE for rtree table plus 6 other changes (artifact: 99c0d53b00 user: drh)
08:12 • New ticket [30e2c183b6]. (artifact: a39e83af28 user: mrigger)
00:45 • Fixed ticket [a55ab6d97d]: Incorrect result for TEXT comparison on rtree table plus 6 other changes (artifact: e215e3dc43 user: drh)
2019-12-04
22:53 • New ticket [a55ab6d97d]. (artifact: c51da1032c user: mrigger)
2019-12-02
11:15 • Ticket [3c9eadd2a6] PRAGMA integrity_check fails due to CHECK constraint even without records status still Open with 3 other changes (artifact: 3fcef5ea52 user: drh)
11:15 • Ticket [3c9eadd2a6]: 6 changes (artifact: dd60bfe984 user: drh)
2019-11-30
19:29 • Fixed ticket [7f39060a24]: LEFT JOIN malfunctions with partial ISNULL index plus 6 other changes (artifact: c520c39050 user: drh)
17:51 • New ticket [7f39060a24]. (artifact: 302b34f77f user: mrigger)
2019-11-18
12:28 • Ticket [8fe768e9c9] FTS integrity-check malfunctions status still Closed with 3 other changes (artifact: 3c6a3949cb user: drh)
2019-11-15
00:52 • Fixed ticket [2ae0c599b7]: Table-valued functions do not work as the right table of a LEFT JOIN plus 5 other changes (artifact: 95c1051da5 user: drh)
00:06 • New ticket [2ae0c599b7]. (artifact: 73457732e9 user: drh)
2019-11-08
20:28 • Fixed ticket [7e59041f9c]: DISTINCT malfunctions for VIEW with virtual table plus 7 other changes (artifact: 2f5eddbd8c user: drh)
2019-11-07
21:58 • New ticket [7e59041f9c]. (artifact: 3f8b5e74f1 user: mrigger)
14:51 • Fixed ticket [302027baf1]: VACUUM results in "database disk image is malformed" for PRIMARY KEY with duplicate column plus 3 other changes (artifact: 64dcc54ef4 user: drh)
14:27 • Ticket [302027baf1]: 4 changes (artifact: e4dac141e8 user: drh)
13:28 • Ticket [302027baf1]: 6 changes (artifact: 1f6bc01c5a user: drh)
10:12 • New ticket [302027baf1]. (artifact: c77ece6b21 user: mrigger)
02:33 • Fixed ticket [299b50ba81]: UPDATE on table with two generated columns and CHECK clause results in segfault plus 6 other changes (artifact: de304abd09 user: drh)
2019-11-06
23:10 • New ticket [299b50ba81]. (artifact: 627b555460 user: mrigger)
22:20 • Fixed ticket [4fc08501f4]: Segfault when inserting into table with generated columns plus 6 other changes (artifact: 635c203d34 user: drh)
17:31 • Fixed ticket [ce22a07731]: NULL WHERE condition unexpectedly results in row being fetched plus 6 other changes (artifact: d70a33c49d user: drh)
15:41 • New ticket [4fc08501f4] Segfault when inserting into table with generated columns. (artifact: 73daa54fdf user: mrigger)
15:16 • New ticket [ce22a07731] NULL WHERE condition unexpectedly results in row being fetched. (artifact: b13b7dce76 user: mrigger)
14:50 • Fixed ticket [2399f59861]: REPLACE on table with generated NOT NULL column results in segfault plus 6 other changes (artifact: 990c736a41 user: drh)
2019-11-05
22:31 • New ticket [2399f59861]. (artifact: c677a2c3da user: mrigger)
13:04 • Closed ticket [1cda8f4b54]: UNLIKELY in query causes row to not be fetched plus 6 other changes (artifact: 248d7d1e3f user: drh)
2019-11-04
21:30 • New ticket [1cda8f4b54]. (artifact: 8a94f363bd user: mrigger)
02:06 • Fixed ticket [02aa2bd02f]: Row value comparison malfunctions on view with left join plus 6 other changes (artifact: 9c9659a87b user: drh)
2019-11-03
10:51 • New ticket [02aa2bd02f]. (artifact: 0d1dbe8439 user: mrigger)
10:06 • New ticket [3c9eadd2a6] PRAGMA integrity_check fails due to CHECK constraint even without records. (artifact: d58c01a983 user: mrigger)
00:07 • Fixed ticket [623eff57e7]: LEFT JOIN in view malfunctions with partial index on table plus 6 other changes (artifact: 4895f3bf95 user: drh)
2019-11-02
21:41 • New ticket [623eff57e7]. (artifact: 4a2769593b user: mrigger)
13:33 • Fixed ticket [a9efb42811]: Incorrect result for GLOB operator plus 6 other changes (artifact: 5ddca41605 user: drh)
08:22 • New ticket [a9efb42811]. (artifact: 003e557ef7 user: mrigger)
2019-11-01
15:19 • Fixed ticket [c28a01da72]: REPLACE causes segfault in table with generated column and foreign key plus 6 other changes (artifact: 5ed2b8c295 user: drh)
08:00 • New ticket [c28a01da72]. (artifact: baaa9dacb4 user: mrigger)
2019-10-31
20:58 • Ticket [b9befa4b83] Segfault in table with generated column and foreign key status still Fixed with 3 other changes (artifact: 59afd142ac user: drh)
20:54 • Fixed ticket [b9befa4b83]. (artifact: af534faa92 user: drh)
20:02 • New ticket [b9befa4b83]. (artifact: 99d2ef1d78 user: mrigger)
13:16 • Fixed ticket [1d2a8efc6c]: VACUUM on table with generated column that uses TYPEOF results in an error plus 6 other changes (artifact: 6088e62985 user: drh)
09:42 • New ticket [1d2a8efc6c]. (artifact: c4ece77a79 user: mrigger)
2019-10-30
18:50 • Fixed ticket [830277d9db]: Non-deterministic date/time functions allowed in CHECK constraints plus 3 other changes (artifact: cfa6b87059 user: drh)
10:33 • Ticket [830277d9db]: 6 changes (artifact: e6974b73f5 user: drh)
02:09 • New ticket [830277d9db]. (artifact: 6591ab9b8c user: drh)
2019-10-29
16:19 • Fixed ticket [6484e6ce67]: VACUUM on table with generated column results in an error plus 6 other changes (artifact: 56f2a7d506 user: drh)
09:24 • New ticket [6484e6ce67]. (artifact: d41ad93dbf user: mrigger)
03:39 • Fixed ticket [166347c6fc]: VACUUM issue on table with generated column plus 6 other changes (artifact: 637c931785 user: drh)
03:30 • Fixed ticket [9621dd78a0]: Segfault when updating table with generated columns plus 5 other changes (artifact: 2ffdd4bb2d user: drh)
2019-10-28
22:13 • New ticket [9621dd78a0]. (artifact: 56e5d65e2e user: mrigger)
21:48 • New ticket [166347c6fc] VACUUM issue on table with generated column. (artifact: 40b5189a0e user: mrigger)
2019-10-27
22:22 • Fixed ticket [91e8695101]: Segfault in table with generated columns plus 6 other changes (artifact: fee5eb5300 user: drh)
21:29 • New ticket [91e8695101]. (artifact: 2061749a0a user: mrigger)
2019-10-26
23:52 • Fixed ticket [3ea1755124]: REINDEX causes "UNIQUE constraint failed" error for generated column plus 4 other changes (artifact: 9377cbb68f user: drh)
21:26 • Ticket [3ea1755124]: 3 changes (artifact: bc78fd24df user: mrigger)
20:24 • Ticket [3ea1755124]: 7 changes (artifact: be09321ca3 user: drh)
20:05 • New ticket [3ea1755124]. (artifact: b5cefca80b user: mrigger)
16:39 • Fixed ticket [c1e19e1204]: Trigger causes query to compute incorrect result plus 4 other changes (artifact: 03ce838d05 user: drh)
2019-10-25
23:56 • Ticket [c1e19e1204]: 3 changes (artifact: 9fe96f0f17 user: drh)
13:15 • Ticket [c1e19e1204]: 6 changes (artifact: d3b0913bf4 user: drh)
08:28 • New ticket [c1e19e1204]. (artifact: 2c9ab7661e user: mrigger)
2019-10-24
20:36 • Closed ticket [dd1f67bf25]: FTS integrity-check malfunctions nondeterministically with tokenize="ascii" plus 6 other changes (artifact: 85d26dd010 user: dan)
19:44 • New ticket [dd1f67bf25]. (artifact: c0870c48cc user: mrigger)
19:37 • Fixed ticket [50c09fc2cf]: Crash on REPLACE INTO of a table with an AFTER DELETE trigger. plus 3 other changes (artifact: 24cd9b60af user: drh)
19:33 • Ticket [50c09fc2cf]: 6 changes (artifact: 6e1ee2aff6 user: drh)
19:29 • New ticket [50c09fc2cf]. (artifact: 6efcc42979 user: drh)
2019-10-23
18:09 • Fixed ticket [135c9da751]: Comparison of row values with COLLATE NOCASE yields incorrect result plus 6 other changes (artifact: 8f2a03f897 user: drh)
16:46 • New ticket [135c9da751]. (artifact: ad3f184cda user: mrigger)
2019-10-22
19:51 • Fixed ticket [6ef984af89]: Row value comparison yields incorrect result plus 5 other changes (artifact: 52b4cb4450 user: drh)
14:05 • New ticket [6ef984af89]. (artifact: eb28040c9a user: mrigger)
10:43 • Ticket [b47e3627ec] Comparison of row values results in incorrect result status still Fixed with 3 other changes (artifact: e283b6c1b8 user: mrigger)
00:03 • Fixed ticket [b47e3627ec]. (artifact: f7f3b529b7 user: drh)
2019-10-21
14:45 • New ticket [b47e3627ec]. (artifact: fe31e25943 user: mrigger)
13:35 • Closed ticket [7fc8e5ff25]: INSERT into table with two triggers does not terminate plus 6 other changes (artifact: a6cbd20ab9 user: dan)
11:26 • New ticket [7fc8e5ff25]. (artifact: db71d36df4 user: mrigger)
2019-10-17
13:56 • New ticket [bf1aab8978] FTS merge does not terminate. (artifact: 45345701ad user: mrigger)
2019-10-16
14:56 • Fixed ticket [a8a4847a2d]: Trigger inserts duplicate value in UNIQUE column plus 6 other changes (artifact: 077f1b97cc user: drh)
13:18 • New ticket [a8a4847a2d]. (artifact: 89dcc9a07a user: mrigger)
2019-10-11
17:26 • Fixed ticket [278ac14262]: FTS integrity_check fails when inserting x'00' plus 6 other changes (artifact: 85b9e38f73 user: drh)
15:33 • Closed ticket [745f1abcdc]: FTS integrity-check malfunctions for transaction and the prefix option plus 5 other changes (artifact: 2e2548be4c user: dan)
14:28 • Closed ticket [8a6fa2bb22]: FTS order=DESC results into integrity-check failing plus 5 other changes (artifact: 9a6bda8036 user: dan)
2019-10-10
22:22 • New ticket [745f1abcdc] FTS integrity-check malfunctions for transaction and the prefix option. (artifact: c1f4fe86e8 user: mrigger)
21:47 • New ticket [8a6fa2bb22] FTS order=DESC results into integrity-check failing. (artifact: 1dabaa837c user: mrigger)
17:10 • Closed ticket [c31034044b]: LEFT JOIN in view malfunctions with NOTNULL plus 5 other changes (artifact: 2f2ef2bbf3 user: dan)
15:17 • Closed ticket [1079ad1999]: Crash in query with FILTER clause on normal aggregate that refers to a column of a subquery plus 3 other changes (artifact: c408da844b user: dan)
14:51 • Ticket [1079ad1999]: 6 changes (artifact: 322e6e80b5 user: dan)
14:12 • New ticket [c31034044b] LEFT JOIN in view malfunctions with NOTNULL. (artifact: d51a86967e user: mrigger)
13:58 • New ticket [1079ad1999] Crash in query with FILTER clause on normal aggregate that refers to a column of a subquery. (artifact: 70a97bc019 user: dan)
13:56 • Closed ticket [a976c487d1]: LEFT JOIN in view malfunctions plus 5 other changes (artifact: 48167f98d5 user: dan)
2019-10-09
21:28 • New ticket [278ac14262] FTS integrity_check fails when inserting x'00'. (artifact: fc89d33d0b user: mrigger)
20:33 • New ticket [a976c487d1] LEFT JOIN in view malfunctions. (artifact: fea9a0bf6f user: mrigger)
18:36 • Closed ticket [d392017c8e]: FTS rebuild in combination with crisismerge results in error "database or disk is full" plus 5 other changes (artifact: 6b56f867cc user: dan)
17:21 • New ticket [d392017c8e]. (artifact: 6582ea5b54 user: mrigger)
15:27 • Closed ticket [81a7f7b9e2]: FTS integrity-check indicates that the database disk image is malformed plus 5 other changes (artifact: 3a0ead5460 user: dan)
2019-10-08
17:33 • New ticket [81a7f7b9e2]. (artifact: e06f66e4d5 user: mrigger)
13:35 • Closed ticket [e258f008ce]: FTS rebuild in transaction causes integrity-check to fail plus 5 other changes (artifact: 947d92dff1 user: dan)
2019-10-07
21:07 • New ticket [e258f008ce]. (artifact: b0e4482231 user: mrigger)
20:36 • Closed ticket [265e935b26]: FTS pgsz option results in "database disk image is malformed" error plus 3 other changes (artifact: c7fc254eb3 user: dan)
19:26 • Ticket [265e935b26]: 6 changes (artifact: 2512703148 user: mrigger)
19:25 • New ticket [265e935b26]. (artifact: 8c4f9d9c0d user: mrigger)
18:44 • Closed ticket [8fe768e9c9]: FTS integrity-check malfunctions plus 5 other changes (artifact: c4fa0e068b user: dan)
01:07 • Fixed ticket [b2d4edaffd]: Comparison on view malfunctions plus 6 other changes (artifact: ce5528e079 user: drh)
2019-10-05
23:29 • New ticket [8fe768e9c9] FTS integrity-check malfunctions. (artifact: ee64201279 user: mrigger)
21:09 • New ticket [b2d4edaffd] Comparison on view malfunctions. (artifact: 8a9e27d71a user: mrigger)
2019-09-23
11:55 • Fixed ticket [99cd4807dc]: Scalar subquery with "LIMIT 0" should return NULL plus 5 other changes (artifact: 9f208d7db2 user: drh)
11:44 • New ticket [99cd4807dc]. (artifact: 56f51649ae user: drh)
2019-09-17
13:30 • Fixed ticket [587791f926]: Row is not fetched when using WHERE clause with INSTR() plus 6 other changes (artifact: d66ce425a5 user: drh)
2019-09-16
19:25 • New ticket [587791f926]. (artifact: aff07e7cfc user: mrigger)
18:20 • Fixed ticket [0f0428096f]: GLOB unexpectedly does not match plus 6 other changes (artifact: de4655d772 user: drh)
2019-09-11
11:30 • Closed ticket [18458b1ad6]: COLLATE issue in view plus 4 other changes (artifact: a386764941 user: dan)
2019-09-10
19:46 • Closed ticket [c4130c33be]: DISTINCT malfunctions for VIEW plus 6 other changes (artifact: 419e98d5f5 user: drh)
19:07 • New ticket [c4130c33be]. (artifact: 183f1b7c5a user: mrigger)
07:50 • Ticket [18458b1ad6] COLLATE issue in view status still Open with 7 other changes (artifact: 7a5fee4d76 user: drh)
2019-09-09
21:02 • New ticket [18458b1ad6]. (artifact: 54e5ff4cb0 user: mrigger)
20:18 • Closed ticket [a7debbe0ad]: BETWEEN issue in view plus 6 other changes (artifact: 2c6a62d634 user: dan)
2019-09-07
18:51 • New ticket [a7debbe0ad]. (artifact: fea928c9e5 user: mrigger)
2019-09-03
18:23 • New ticket [0f0428096f] GLOB unexpectedly does not match. (artifact: 6afdb3612a user: mrigger)
14:27 • Fixed ticket [767a8cbc6d]: COLLATE NOCASE string comparison yields incorrect result plus 6 other changes (artifact: 126c722541 user: drh)
13:35 • Fixed ticket [29f635e0af]: IS NULL unexpectedly evaluates to TRUE plus 6 other changes (artifact: be0508679b user: drh)
08:25 • New ticket [767a8cbc6d] COLLATE NOCASE string comparison yields incorrect result. (artifact: b41bd36068 user: mrigger)
2019-09-02
22:14 • Fixed ticket [29f635e0af]: IS NULL unexpectedly evaluates to TRUE plus 7 other changes (artifact: 781749e770 user: drh)
19:22 • New ticket [29f635e0af]. (artifact: 34ebd7c76e user: mrigger)
02:22 • Fixed ticket [2841e99d10]: Different rounding when converting TEXT to REAL plus 6 other changes (artifact: 59028a4071 user: drh)
00:58 • Fixed ticket [57af00b664]: Expression computed on row yields incorrect result plus 4 other changes (artifact: 608fe5664e user: drh)
2019-09-01
19:46 • Ticket [57af00b664]: 6 changes (artifact: 14089bcdef user: drh)
18:44 • New ticket [2841e99d10] Different rounding when converting TEXT to REAL. (artifact: 08df019d6c user: mrigger)
16:02 • New ticket [57af00b664] Expression computed on row yields incorrect result. (artifact: ece608d0fd user: mrigger)
2019-08-31
17:15 • Closed ticket [d6a0fbc14e]: REINDEX causes "UNIQUE constraint failed" error when using TRIGGER plus 6 other changes (artifact: 9c168f3506 user: dan)
06:17 • New ticket [d6a0fbc14e]. (artifact: 32d2e31d01 user: mrigger)
2019-08-30
23:56 • Fixed ticket [40812aea1f]: Incorrect result for comparison of large number plus 6 other changes (artifact: 0dea4a6a3d user: drh)
23:15 • Fixed ticket [5a3dba8104]: REINDEX causes "UNIQUE constraint failed" error plus 6 other changes (artifact: fedacb2dc8 user: drh)
20:28 • New ticket [40812aea1f] Incorrect result for comparison of large number. (artifact: 8188b7b46d user: mrigger)
19:41 • New ticket [5a3dba8104] REINDEX causes "UNIQUE constraint failed" error. (artifact: a6172ac698 user: mrigger)
16:01 • Fixed ticket [f8f472cbc7]: Partial index and BETWEEN issue plus 6 other changes (artifact: 03079b14a3 user: drh)
15:43 • New ticket [f8f472cbc7]. (artifact: bac716244f user: mrigger)
15:11 • Fixed ticket [fba33c8b1d]: Partial index causes row to not be fetched in BETWEEN expression plus 6 other changes (artifact: 9f4bc62d8d user: drh)
14:33 • New ticket [fba33c8b1d]. (artifact: aa64847632 user: mrigger)
13:07 • Fixed ticket [a6408d42b9]: Partial index causes row to not be fetched plus 6 other changes (artifact: 8b2e986d26 user: drh)
11:33 • New ticket [a6408d42b9]. (artifact: ba5257e350 user: mrigger)
2019-08-29
15:07 • Closed ticket [c03903637b]: Indexes causes row to not be fetched plus 6 other changes (artifact: f038f6f744 user: dan)
13:46 • New ticket [c03903637b]. (artifact: c89043678d user: mrigger)
12:54 • Closed ticket [51f5b6e427]: Short-circuit evaluation issue plus 8 other changes (artifact: 5e239be765 user: drh)
2019-08-28
21:11 • New ticket [51f5b6e427]. (artifact: 4fa98dbfbf user: mrigger)
2019-08-27
20:00 • Closed ticket [f8a7060ece]: Incorrect result for query that uses MIN() and a CAST on rowid plus 4 other changes (artifact: 400f3bdf30 user: dan)
17:01 • Fixed ticket [dbaf8a6820]: Unexpected affinity conversion is performed for the IN operator plus 6 other changes (artifact: afafc3043e user: drh)
15:14 • New ticket [dbaf8a6820]. (artifact: 8542c61ff8 user: mrigger)
10:09 • Fixed ticket [ac8dd4a32b]: Segfault when dropping a temp trigger on a database that has already been detached plus 5 other changes (artifact: 8eb244c91e user: drh)
09:42 • New ticket [ac8dd4a32b]. (artifact: 719304a838 user: dan)
2019-08-26
14:19 • Ticket [78acc9d40f] Assertion fault in row-value UPDATE status still Fixed with 3 other changes (artifact: dad9747084 user: drh)
14:18 • Fixed ticket [78acc9d40f]. (artifact: b9dddca62b user: drh)
13:24 • New ticket [78acc9d40f]. (artifact: a4def077f8 user: drh)
2019-08-22
16:39 • Fixed ticket [7e07a3dbf5]: LIKELY() seems to cause unexpected affinity conversion for rowid plus 6 other changes (artifact: 8584b3e41a user: drh)
14:34 • New ticket [7e07a3dbf5]. (artifact: ea40e09c44 user: mrigger)
11:14 • Fixed ticket [ac184eb571]: Row with comparison on TEXT UNIQUE column is not fetched plus 7 other changes (artifact: 924b1a42f1 user: drh)
09:44 • New ticket [ac184eb571]. (artifact: d99f1ffe83 user: mrigger)
00:55 • Fixed ticket [d9f584e936]: Row is not fetched in table with INTEGER PRIMARY KEY plus 7 other changes (artifact: 815dccddc6 user: drh)
2019-08-21
21:34 • New ticket [d9f584e936]. (artifact: d7eaf0333f user: mrigger)
14:55 • Closed ticket [b86894020e]: DISTINCT malfunctions for IS NULL plus 6 other changes (artifact: e33394d331 user: dan)
11:50 • New ticket [b86894020e]. (artifact: c70c47e772 user: mrigger)
2019-08-20
11:45 • Closed ticket [f043b1130b]: INDEXED BY results in row not being fetched plus 6 other changes (artifact: 2bf8bb5255 user: dan)
09:29 • New ticket [f043b1130b]. (artifact: 54e1cf0a23 user: mrigger)
2019-08-17
19:14 • Closed ticket [c7a1171907]: WHERE clause erroneously influences value of fetched column from view plus 6 other changes (artifact: fba835a5f0 user: dan)
18:05 • New ticket [c7a1171907]. (artifact: a07a8bacc6 user: mrigger)
17:11 • Fixed ticket [6710d2f7a1]: LEFT JOIN fails to fetch row plus 7 other changes (artifact: 12e735c034 user: drh)
14:43 • New ticket [6710d2f7a1]. (artifact: afe2e244b4 user: mrigger)
2019-08-15
14:36 • Fixed ticket [256741a16b]: null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...) plus 3 other changes (artifact: cf72f22097 user: drh)
14:35 • Fixed ticket [e4598ecbdd]: Division by zero in the query planner. plus 5 other changes (artifact: b83367a95c user: drh)
14:28 • New ticket [e4598ecbdd]. (artifact: d93508fc99 user: drh)
14:09 • Ticket [256741a16b] null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...) status still Open with 6 other changes (artifact: 6fef4d64c8 user: dan)
13:51 • New ticket [256741a16b]. (artifact: ef08d208ef user: dan)
2019-08-14
19:55 • Closed ticket [17db54d744]: Unexpected error in DELETE with existing trigger plus 6 other changes (artifact: dd9f8d3e0e user: dan)
19:47 • New ticket [17db54d744]. (artifact: f06e8c9d7b user: mrigger)
2019-08-12
18:26 • Fixed ticket [3cf9bb227e]: Database corruption caused by REPLACE plus 5 other changes (artifact: 927499fa0b user: drh)
18:25 • New ticket [3cf9bb227e]. (artifact: 4c0dd574d8 user: drh)
2019-08-10
15:06 • Fixed ticket [9080b6227f]: Constant expression in partial index results in row not being fetched plus 6 other changes (artifact: 53eb33a895 user: drh)
2019-08-09
23:00 • New ticket [9080b6227f]. (artifact: af49a21fc5 user: mrigger)
2019-08-08
08:31 • Ticket [f8a7060ece] Incorrect result for query that uses MIN() and a CAST on rowid status still Open with 3 other changes (artifact: 64317f51f1 user: dan)
2019-08-07
21:30 • Ticket [f8a7060ece]: 7 changes (artifact: 3bee902b96 user: drh)
20:20 • New ticket [f8a7060ece]. (artifact: 99392c9cfa user: mrigger)
2019-08-06
23:28 • Fixed ticket [0a5e2c1dcb]: Unexpected affinity conversion for view column in IN operator plus 6 other changes (artifact: d65bc0deae user: drh)
20:43 • New ticket [0a5e2c1dcb]. (artifact: 4bce8b022f user: mrigger)
17:05 • Fixed ticket [9f66f887d4]: EXPLAIN PRAGMA executes PRAGMA plus 8 other changes (artifact: f8525f6170 user: drh)
15:33 • Fixed ticket [61c853857f]: Row is not fetched in SELECT from VIEW plus 6 other changes (artifact: 505de8a796 user: drh)
2019-08-05
21:56 • New ticket [9f66f887d4] EXPLAIN PRAGMA executes PRAGMA. (artifact: 6c982a95f0 user: mrigger)
20:41 • Ticket [d52a29a9e6] Unexpected affinity conversion in view status still Fixed with 4 other changes (artifact: 7c0701014e user: drh)
15:09 • New ticket [61c853857f] Row is not fetched in SELECT from VIEW. (artifact: 82f66d84d3 user: mrigger)
13:06 • Fixed ticket [d52a29a9e6]: Unexpected affinity conversion in view plus 8 other changes (artifact: ac513e2ebb user: drh)
11:27 • New ticket [d52a29a9e6]. (artifact: c86e9f56c5 user: mrigger)
2019-08-03
16:51 • Closed ticket [71e183cab6]: MIN() malfunctions for a query with ISNULL condition plus 4 other changes (artifact: 3dfda9a4da user: dan)
14:30 • Ticket [71e183cab6]: 4 changes (artifact: afd8a0b21f user: drh)
13:44 • Ticket [71e183cab6]: 6 changes (artifact: 6226b17723 user: dan)
2019-08-02
22:32 • New ticket [71e183cab6]. (artifact: cb71fa4fed user: mrigger)
19:40 • Closed ticket [41866dc373]: MIN() malfunctions for UNIQUE column plus 6 other changes (artifact: 7206ad61d3 user: dan)
16:11 • New ticket [41866dc373]. (artifact: 467863cb07 user: mrigger)
2019-07-30
01:17 • Fixed ticket [ced41c7c7d]: Query with DISTINCT does not fetch all distinct rows plus 6 other changes (artifact: 8f62d6df85 user: drh)
2019-07-29
22:42 • New ticket [ced41c7c7d]. (artifact: 538cb2f4ad user: mrigger)
15:54 • Closed ticket [ccbe5759fb]: ANALYZE causes DISTINCT to malfunction in CROSS JOIN plus 5 other changes (artifact: 1931032462 user: dan)
09:28 • New ticket [ccbe5759fb]. (artifact: 6749cb3c5c user: mrigger)
06:07 • Fixed ticket [ba2f4585cf]: Query with ORDER BY results in "database disk image is malformed" error plus 6 other changes (artifact: 468ed18489 user: drh)
06:05 • Closed ticket [18ab5da2c0]: Issue with DISTINCT and COLLATE plus 7 other changes (artifact: 739f46ad35 user: drh)
2019-07-28
22:32 • New ticket [ba2f4585cf] Query with ORDER BY results in "database disk image is malformed" error. (artifact: be412e8439 user: mrigger)
21:53 • New ticket [18ab5da2c0] Issue with DISTINCT and COLLATE. (artifact: dd9a82ecff user: mrigger)
2019-07-24
23:15 • Fixed ticket [c52b09c7f3]: Assertion fault in the query planner on a deeply nested query plus 4 other changes (artifact: f92124ec28 user: drh)
22:44 • Ticket [c52b09c7f3]: 7 changes (artifact: 7a3aa0efe1 user: drh)
21:03 • New ticket [c52b09c7f3]. (artifact: c09fa4b934 user: drh)
2019-07-17
15:47 • Fixed ticket [1be72aab92]: CHECK constraint using COLLATE with CASE or BETWEEN plus 3 other changes (artifact: fd3c95a425 user: drh)
14:28 • Ticket [1be72aab92]: 3 changes (artifact: 551d972b09 user: drh)
14:27 • Ticket [1be72aab92]: 6 changes (artifact: 5a7be49752 user: drh)
13:36 • New ticket [1be72aab92]. (artifact: 50f9f11e5a user: drh)
13:10 • Fixed ticket [fd3aec0c7e]: Valgrind warning if PK has more columns than the table. plus 5 other changes (artifact: c294e6d98f user: drh)
01:27 • New ticket [fd3aec0c7e]. (artifact: 6e4769b46d user: drh)
2019-07-08
12:03 • Closed ticket [9ece23d2ca]: Default collation sequences and affinities lost when window function added to query plus 3 other changes (artifact: 295dff1c14 user: dan)
12:03 • Ticket [9ece23d2ca]: 3 changes (artifact: f5d6cde21b user: dan)
11:50 • Ticket [9ece23d2ca]: 6 changes (artifact: e496cf62f1 user: dan)
11:48 • New ticket [9ece23d2ca]. (artifact: facd5361ea user: dan)
2019-06-27
02:23 • Fixed ticket [9cdc5c4662]: Incorrect result from second execution of correlated scalar sub-query that uses a partial sort plus 6 other changes (artifact: 694cf21b62 user: drh)
2019-06-26
20:00 • New ticket [9cdc5c4662]. (artifact: 1f188ca25a user: dan)
2019-06-16
14:57 • Fixed ticket [e1e07ef202]: COLLATE in BETWEEN expression is ignored plus 6 other changes (artifact: 97ce28ab54 user: drh)
2019-06-15
21:41 • New ticket [e1e07ef202]. (artifact: 1c102a81ae user: mrigger)
2019-06-14
13:25 • Fixed ticket [f1580ba1b5]: Built-in RTRIM collating sequence yields incorrect comparisons plus 8 other changes (artifact: 71c96e66f5 user: drh)
12:29 • Fixed ticket [ce8717f088]: LIKE malfunctions for UNIQUE COLLATE NOCASE column plus 6 other changes (artifact: 751df5f033 user: drh)
11:03 • New ticket [f1580ba1b5] Row is not fetched in WITHOUT ROWID table and a composite primary key. (artifact: 253e38a485 user: mrigger)
10:01 • New ticket [ce8717f088] LIKE malfunctions for UNIQUE COLLATE NOCASE column. (artifact: 81eff85613 user: mrigger)
2019-06-12
20:53 • Fixed ticket [674385aeba]: CAST('-0.0' AS NUMERIC) computes 0.0 rather than 0 plus 4 other changes (artifact: bacc0175a8 user: drh)
20:32 • Fixed ticket [b148fa6105]: CAST takes implicit COLLATE of its operand plus 8 other changes (artifact: bed43b4e69 user: drh)
15:37 • New ticket [b148fa6105]. (artifact: 985e96ae55 user: mrigger)
14:12 • Ticket [674385aeba] CAST('-0.0' AS NUMERIC) computes 0.0 rather than 0 status still Open with 3 other changes (artifact: e0c5eb961e user: mrigger)
13:50 • Closed ticket [4d01eda811]: IS TRUE operator malfunctions with COLLATE and REAL value plus 6 other changes (artifact: 75b45c09ca user: dan)
13:25 • Ticket [674385aeba] CAST('-0.0' AS NUMERIC) computes 0.0 rather than 0 status still Open with 7 other changes (artifact: e68e7d1605 user: drh)
12:58 • New ticket [674385aeba]. (artifact: 5ea2d3c32f user: mrigger)
12:41 • New ticket [4d01eda811] IS TRUE operator malfunctions with COLLATE and REAL value. (artifact: 9726435c93 user: mrigger)
2019-06-11
21:02 • Fixed ticket [0c620df60b]: LIKELY(), UNLIKELY() and LIKELIHOOD() have affinities plus 6 other changes (artifact: dd95f0b102 user: drh)
19:24 • New ticket [0c620df60b]. (artifact: f0e8580003 user: mrigger)
18:08 • Fixed ticket [57353f8243]: COLLATE expression in the right side of an IN operator results in an affinity conversion plus 6 other changes (artifact: 1e6103e9e7 user: drh)
16:02 • Closed ticket [afdc5a29dc]: Lossless conversion when casting a large TEXT number to NUMERIC is not performed plus 8 other changes (artifact: 0d2ad198e6 user: drh)
14:06 • New ticket [afdc5a29dc]. (artifact: 446e6ab323 user: mrigger)
13:43 • Fixed ticket [1819598c09]: -'1.0' computes -1.0 rather than -1 plus 7 other changes (artifact: 070c163445 user: drh)
11:50 • New ticket [57353f8243] COLLATE expression in the right side of an IN operator results in an affinity conversion. (artifact: 0e9aa5fa09 user: mrigger)
09:47 • New ticket [1819598c09] -'1.0' computes -1.0 rather than -1. (artifact: 20490a7c1d user: mrigger)
03:00 • Fixed ticket [d60b3cd7cb]: COLLATE expression has an affinity plus 8 other changes (artifact: 8270b2b987 user: drh)
02:43 • Fixed ticket [533010b8ca]: Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" plus 3 other changes (artifact: e17361d221 user: drh)
2019-06-10
23:45 • Fixed ticket [412bba9b22]: CAST('.' AS NUMERIC) computes 0.0 rather than 0 plus 6 other changes (artifact: f3f09094f7 user: drh)
21:58 • Open ticket [533010b8ca]: Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" plus 3 other changes (artifact: f065e4ab82 user: mrigger)
20:46 • New ticket [d60b3cd7cb] COLLATE expression has an affinity. (artifact: 17666839a7 user: mrigger)
19:53 • New ticket [412bba9b22] CAST('.' AS NUMERIC) computes 0.0 rather than 0. (artifact: 27de823723 user: mrigger)
19:18 • Closed ticket [533010b8ca]: Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" plus 6 other changes (artifact: 8f1e45446f user: dan)
19:07 • Fixed ticket [5e0423b058]: xAccess behaviour is not documented, changed in Windows 3.7.0 plus 3 other changes (artifact: c703cfe188 user: drh)
18:51 • Closed ticket [31c6e64ff9]: ALTER TABLE fails if a trigger references a non-existant table. plus 6 other changes (artifact: d4a0d54d81 user: drh)
18:33 • Fixed ticket [dd6bffbfb6]: CAST to NUMERIC no longer converts to INTEGER plus 3 other changes (artifact: b853530b61 user: drh)
18:27 • Ticket [dd6bffbfb6]: 7 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)
20:49 • Ticket [787fa716be]: 3 changes (artifact: 838f5f420d user: drh)
19:27 • Ticket [787fa716be]: 6 changes (artifact: 7da230dd8d user: drh)
15:06 • New ticket [787fa716be]. (artifact: 03d1034319 user: drh)
2018-11-05
13:42 • Fixed ticket [1a84668dcf]: Assertion fault due to malformed PRIMARY KEY plus 5 other changes (artifact: 4912034c3a user: drh)
08:09 • Fixed ticket [65eb38f6e4]: Incorrect answer on LEFT JOIN when STAT4 is enabled plus 6 other changes (artifact: 88c47ba1e7 user: drh)
07:34 • New ticket [65eb38f6e4]. (artifact: cf10feffbe user: drh)
2018-11-03
12:36 • New ticket [1a84668dcf] Assertion fault due to malformed PRIMARY KEY. (artifact: 25fe2f85fe user: drh)
2018-10-25
15:17 • Fixed ticket [cf5ed20fc8]: Incorrect join result with duplicate WHERE clause constraint plus 5 other changes (artifact: a7a056a8e8 user: drh)
11:39 • New ticket [cf5ed20fc8]. (artifact: 419091deae user: drh)
2018-10-03
23:10 • New ticket [31c6e64ff9] ALTER TABLE fails if a trigger references a non-existant table.. (artifact: d457452a79 user: drh)
15:34 • New ticket [e8b6742419] Query planner chooses an inefficient algorithm.. (artifact: 8b272a1b71 user: drh)
2018-10-02
16:45 • New ticket [43ddc85a63] ALTER TABLE fails when there is an INSTEAD-OF trigger of a VIEW. (artifact: c07d43a25f user: drh)
2018-09-27
20:20 • Fixed ticket [69d642332d]: The typeof() and length() functions fail in some virtual tables. plus 5 other changes (artifact: 8d26e66af7 user: drh)
20:04 • New ticket [69d642332d]. (artifact: 43a256c6a1 user: drh)
13:02 • Fixed ticket [e8275b415a]: Assertion fault from window function inside of recursive CTE plus 5 other changes (artifact: 8e72ee7c80 user: drh)
11:03 • New ticket [e8275b415a]. (artifact: 0d057e123b user: drh)
2018-09-24
14:11 • Fixed ticket [f25d5ceebe]: INTEGER PRIMARY KEY WITHOUT ROWID virtual table crash plus 5 other changes (artifact: b01c7b393a user: drh)
14:10 • New ticket [f25d5ceebe]. (artifact: 0f28c7fced user: drh)
2018-09-17
15:30 • Fixed ticket [510cde2777]: Endless loop on a query with window functions, ORDER BY, and LIMIT plus 5 other changes (artifact: c0db9c3972 user: drh)
15:29 • Fixed ticket [b41031ea2b]: ALTER TABLE returns an error on certain schemas plus 3 other changes (artifact: fea593b6ba user: drh)
14:28 • New ticket [510cde2777] Endless loop on a query with window functions, ORDER BY, and LIMIT. (artifact: 614870a83e user: drh)
2018-09-16
20:33 • Ticket [b41031ea2b] ALTER TABLE returns an error on certain schemas status still Open with 3 other changes (artifact: 90eeaef70d user: drh)
20:33 • Ticket [b41031ea2b]: 6 changes (artifact: e331b118d2 user: drh)
20:03 • New ticket [b41031ea2b]. (artifact: 65efc0ddbb user: drh)
2018-09-10
14:49 • Fixed ticket [9936b2fa44]: Infinite loop due to the ORDER BY LIMIT optimization plus 3 other changes (artifact: 7fafa41ff1 user: drh)
12:41 • Fixed ticket [c94369cae9]: Wrong answer due to the LIKE optimization plus 3 other changes (artifact: 0606ed8e26 user: drh)
10:16 • Ticket [c94369cae9]: 6 changes (artifact: 9aeb839f49 user: drh)
2018-09-09
10:46 • New ticket [c94369cae9]. (artifact: ffd4cb432b user: drh)
2018-09-08
17:43 • Ticket [9936b2fa44] Infinite loop due to the ORDER BY LIMIT optimization status still Open with 6 other changes (artifact: 959f3745c1 user: dan)
03:22 • New ticket [9936b2fa44]. (artifact: 9b89fdd3fe user: drh)
2018-08-14
15:13 • Fixed ticket [908f001483]: UPSERT does not work like PostgreSQL plus 3 other changes (artifact: d55756a6af user: drh)
11:06 • Ticket [908f001483]: 6 changes (artifact: c781e55dac user: drh)
11:01 • New ticket [908f001483]. (artifact: 3f51aa1a6a user: drh)
2018-07-24
22:02 • Fixed ticket [c694113e50]: Unnecessary ABORT with unhelpful error message plus 5 other changes (artifact: 21658c4e66 user: drh)
20:57 • New ticket [c694113e50]. (artifact: b1a19bff7c user: drh)
2018-07-11
13:37 • Fixed ticket [79cad5e4b2]: UPSERT results in a corrupt database plus 4 other changes (artifact: 2f1cb38602 user: drh)
12:50 • Ticket [79cad5e4b2]: 3 changes (artifact: 131ac5b232 user: drh)
12:12 • Ticket [79cad5e4b2]: 6 changes (artifact: bea01e21f6 user: drh)
12:11 • New ticket [79cad5e4b2]. (artifact: 151ec23765 user: drh)
2018-06-11
18:07 • Fixed ticket [c2432ef908]: Assertion fault due to column cache malfunction plus 5 other changes (artifact: fe1c1495dd user: drh)
11:14 • New ticket [c2432ef908]. (artifact: de9d04b2b3 user: drh)
2018-06-07
15:23 • Fixed ticket [7be932dfa6]: Adverse interaction between .stats and .eqp in the CLI plus 5 other changes (artifact: 07775835d6 user: drh)
15:11 • New ticket [7be932dfa6]. (artifact: facdb8d39f user: drh)
2018-05-23
17:53 • Fixed ticket [d8dc2b3a58]: Crash when the schema for sqlite_sequence is corrupt plus 5 other changes (artifact: de111d9d6d user: drh)
15:28 • New ticket [d8dc2b3a58]. (artifact: 82d3a7b33b user: drh)
2018-05-08
23:20 • Fixed ticket [e63a34a004]: Incorrectly formatted output for the ".fullschema" command in the CLI plus 5 other changes (artifact: cbaa390e8e user: drh)
23:15 • New ticket [e63a34a004]. (artifact: b316ee8ea2 user: drh)
2018-04-26
15:50 • Fixed ticket [d85fffd6ff]: VDBE program uses an expired value plus 3 other changes (artifact: 678425b148 user: drh)
15:07 • Ticket [d85fffd6ff]: 6 changes (artifact: 9d7dfa453b user: drh)
12:45 • New ticket [d85fffd6ff]. (artifact: 4af4529426 user: drh)
2018-04-24
17:34 • Fixed ticket [4ba5abf65c]: Index on expression leads to an incorrect LEFT JOIN plus 5 other changes (artifact: f7d169fcd7 user: drh)
14:42 • Fixed ticket [7fa8049685]: Incorrect result on a LEFT JOIN when using an index plus 5 other changes (artifact: d10434c3e5 user: drh)
14:30 • New ticket [4ba5abf65c] Index on expression leads to an incorrect LEFT JOIN. (artifact: e5a141f806 user: drh)
12:48 • New ticket [7fa8049685] Incorrect result on a LEFT JOIN when using an index. (artifact: 66d12dea70 user: drh)
2018-04-10
12:20 • Fixed ticket [1e39b966ae]: LEFT JOIN strength reduction optimization causes an error. plus 5 other changes (artifact: f7116625fb user: drh)
12:20 • Fixed ticket [fac496b617]: Over-aggressive LEFT JOIN optimization on virtual tables plus 3 other changes (artifact: 57618283d2 user: drh)
12:05 • New ticket [1e39b966ae] LEFT JOIN strength reduction optimization causes an error.. (artifact: 99d5851c0d user: drh)
2018-04-09
15:58 • Fixed ticket [2b8aed9f7c]: Misbehavior in the FTS5 xBestIndex method plus 5 other changes (artifact: 89584454c8 user: drh)
14:20 • New ticket [2b8aed9f7c]. (artifact: e5d670802d user: drh)
2018-04-06
12:55 • Fixed ticket [093420fc0e]: Virtual Machine references an uninitialized register plus 5 other changes (artifact: 31842ae5e4 user: drh)
2018-04-05
11:47 • New ticket [093420fc0e]. (artifact: 4524671d83 user: drh)
2018-04-03
14:37 • Ticket [fac496b617] Over-aggressive LEFT JOIN optimization on virtual tables status still Open with 5 other changes (artifact: 2466fb913e user: drh)
13:38 • Ticket [fac496b617]: 6 changes (artifact: eedbb46e37 user: drh)
12:48 • New ticket [fac496b617]. (artifact: fd18820b04 user: drh)
2018-02-26
15:28 • Fixed ticket [36fae083b4]: Inconsistent interpretation of truth plus 6 other changes (artifact: 9eea40131e user: drh)
15:14 • New ticket [36fae083b4]. (artifact: a9d7468cc5 user: drh)
2018-02-13
19:16 • Fixed ticket [f484b65f3d]: Incorrect result from row-value comparison in WHERE clause plus 6 other changes (artifact: 79ae33f754 user: drh)
18:05 • New ticket [f484b65f3d]. (artifact: e19d690677 user: drh)
16:35 • Fixed ticket [d6ec09eccf]: Assertion fault in FTS4 plus 5 other changes (artifact: 3f87a311b0 user: drh)
16:12 • New ticket [d6ec09eccf]. (artifact: e62a329ab0 user: drh)
2018-02-01
16:17 • Fixed ticket [343634942d]: Index on expression goes corrupt from valid SQL plus 6 other changes (artifact: fb5194040a user: drh)
00:08 • New ticket [343634942d]. (artifact: bc6f47b386 user: drh)
2018-01-27
13:56 • Fixed ticket [ec32177c99]: Incorrect result with complex OR-connected WHERE and STAT4 plus 3 other changes (artifact: 83c4e1e229 user: drh)
04:43 • Ticket [ec32177c99]: 6 changes (artifact: f5d59ef08d user: drh)
04:10 • New ticket [ec32177c99]. (artifact: 014b03109f user: drh)
2018-01-26
23:48 • Fixed ticket [80177f0c22]: Incorrect result when join condition uses a table-valued function plus 5 other changes (artifact: ca393f736f user: drh)
22:26 • New ticket [80177f0c22]. (artifact: 8e86e0cc81 user: drh)
2018-01-23
18:00 • Fixed ticket [7310e2fb3d]: Valid row-value syntax is rejected plus 6 other changes (artifact: e1e0573aca user: drh)
17:59 • New ticket [7310e2fb3d]. (artifact: f3e9ec9998 user: drh)
2018-01-16
13:50 • Fixed ticket [47b2581aa9]: Infinite loop on UPDATE plus 5 other changes (artifact: ceefd4de8f user: drh)
12:54 • New ticket [47b2581aa9]. (artifact: 0e79b53b99 user: drh)
2018-01-02
18:11 • Fixed ticket [dc3f932f5a]: Assertion fault doing a REPLACE with index on an expression. plus 5 other changes (artifact: c50c85c73a user: drh)
17:40 • New ticket [dc3f932f5a]. (artifact: efd28bca19 user: drh)
2017-12-23
12:34 • Fixed ticket [3b44500725]: Inconsistent column names plus 3 other changes (artifact: 549aa631b9 user: drh)
2017-12-22
19:36 • Ticket [3b44500725]: 6 changes (artifact: 1920066348 user: drh)
19:28 • New ticket [3b44500725]. (artifact: 6ebc7575be user: drh)
2017-12-13
18:02 • Fixed ticket [123c9ba321]: Incorrect result when an index is used for an ordered join plus 5 other changes (artifact: fa2161e11f user: drh)
16:33 • New ticket [123c9ba321]. (artifact: da421d67ab user: drh)
2017-11-26
00:49 • Fixed ticket [d4beea1633]: DELETE with a LIMIT does not work for WITHOUT ROWID tables plus 5 other changes (artifact: e11d4c75d7 user: drh)
2017-11-23
00:48 • Fixed ticket [ef9318757b]: Incorrect result due to the skip-ahead-distinct optimization plus 3 other changes (artifact: 8331c214d4 user: drh)
00:16 • Ticket [ef9318757b]: 6 changes (artifact: 0dfce83018 user: drh)
2017-11-21
15:19 • New ticket [ef9318757b]. (artifact: 00f210e18c user: drh)
2017-11-08
22:39 • New ticket [d4beea1633] DELETE with a LIMIT does not work for WITHOUT ROWID tables. (artifact: ae6f207afe user: drh)
2017-11-06
12:04 • Ticket [aa98619ad0] Assertion fault on an IN operator using a constant index status still Fixed with 3 other changes (artifact: 9ee09f8b0e user: dan)
12:01 • Ticket [aa98619ad0]: 3 changes (artifact: a4182e9351 user: dan)
2017-10-10
13:37 • Fixed ticket [e651b13418]: DROP TABLE fails for WITHOUT ROWID tables an SQLITE_OMIT_AUTOVACUUM plus 5 other changes (artifact: 814c1b73e5 user: drh)
13:36 • New ticket [e651b13418]. (artifact: b70e09fd6b user: drh)
2017-09-11
23:55 • Fixed ticket [cfa2c908f2]: Assertion fault in STAT4 on a double-negation plus 5 other changes (artifact: 1f00b87ef5 user: drh)
23:47 • Fixed ticket [b899b6042f]: Segfault on correlated subquery on the RHS of an IN operator in the WHERE clause plus 5 other changes (artifact: b9905e1460 user: drh)
2017-09-03
23:27 • New ticket [b899b6042f]. (artifact: 95580e0c99 user: drh)
2017-08-28
11:13 • Fixed ticket [02f0f4c54f]: The ".dump" comman crashes following PRAGMA empty_result_callbacks=1 plus 5 other changes (artifact: c54498abb1 user: drh)
10:57 • New ticket [02f0f4c54f]. (artifact: db4451b8f4 user: drh)
2017-08-24
14:25 • Closed ticket [88af8923dc]: plus 5 other changes (artifact: a7d394dc86 user: drh)
13:55 • Fixed ticket [7486aa54b9]: Assertion fault caused by sqlite3_result_pointer() plus 5 other changes (artifact: 9747bf4814 user: drh)
13:45 • New ticket [7486aa54b9]. (artifact: ace65a0c51 user: drh)
2017-08-18
13:25 • Fixed ticket [e20dd54ab0]: COLLATE sequence for ORDER/GROUP BY ignored when using an index-on-expression plus 3 other changes (artifact: 56c729e77b user: drh)
10:27 • Ticket [e20dd54ab0]: 6 changes (artifact: ab63b0fa04 user: dan)
07:14 • New ticket [e20dd54ab0]. (artifact: 752ae671e2 user: dan)
2017-08-17
14:48 • Fixed ticket [be436a7f45]: Use-after-free on schema change where RTREE is used inside of a trigger plus 5 other changes (artifact: f77fb5a0d6 user: drh)
02:25 • New ticket [be436a7f45]. (artifact: 580eefd3a1 user: drh)
2017-08-14
14:53 • Fixed ticket [aa98619ad0]: Assertion fault on an IN operator using a constant index plus 5 other changes (artifact: a39886d07b user: drh)
14:44 • Closed ticket [8897054d95]: lsm1 does not overwrite values for duplicate keys plus 5 other changes (artifact: 58f8ad3c86 user: drh)
14:02 • New ticket [8897054d95]. (artifact: a4e8662c09 user: anonymous)
12:52 • New ticket [aa98619ad0] Assertion fault on an IN operator using a constant index. (artifact: ce951f50b2 user: drh)
2017-08-11
18:42 • New ticket [88af8923dc] . (artifact: 180b87179f user: anonymous)
2017-08-01
19:53 • Fixed ticket [cb91bf4290]: Assertion fault following PRAGMA reverse_unordered_selects=ON plus 5 other changes (artifact: 1e861ce071 user: drh)
18:21 • New ticket [cb91bf4290]. (artifact: b9784104c0 user: drh)
2017-07-31
16:42 • Fixed ticket [de3403bf5a]: Column name shift due to LEFT JOIN query flattening plus 3 other changes (artifact: 726bbd3893 user: drh)
11:26 • Fixed ticket [bc11554113]: Assertion fault on a dodgy CREATE TABLE statement using WITHOUT ROWID plus 5 other changes (artifact: 3f6c11e5f6 user: drh)
2017-07-30
18:25 • New ticket [bc11554113]. (artifact: 23e3c07ed9 user: drh)
2017-07-29
17:47 • Ticket [de3403bf5a] Column name shift due to LEFT JOIN query flattening status still Open with 6 other changes (artifact: 84cc8ca46c user: drh)
03:26 • New ticket [de3403bf5a]. (artifact: e6b7df6949 user: drh)
2017-07-21
19:33 • Fixed ticket [ce68383bf6]: Incorrect LEFT JOIN result with IS operator in WHERE clause and auto-index plus 5 other changes (artifact: 6637feea06 user: drh)
2017-07-18
16:57 • New ticket [ce68383bf6]. (artifact: 4776331e7f user: drh)
2017-07-15
20:38 • Fixed ticket [a4e06e75a9]: False-positive from "PRAGMA integrity_check" plus 6 other changes (artifact: d02faf2717 user: drh)
19:32 • New ticket [a4e06e75a9]. (artifact: 1cd2172770 user: drh)
2017-06-27
23:36 • Fixed ticket [b9f0101077]: Violation of the Query Planner Stability Guarantee plus 3 other changes (artifact: 298567819f user: drh)
2017-06-23
19:38 • Ticket [b9f0101077]: 6 changes (artifact: ecf533654f user: drh)
19:21 • New ticket [b9f0101077]. (artifact: 81c613f2a8 user: drh)
2017-06-20
18:13 • Fixed ticket [892fc34f17]: Incorrect query result when a LEFT JOIN subquery is flattened plus 5 other changes (artifact: 879fcac86a user: drh)
16:15 • New ticket [892fc34f17]. (artifact: d28d654485 user: drh)
2017-06-13
03:55 • New ticket [cfa2c908f2] Assertion fault in STAT4 on a double-negation. (artifact: bea44233d6 user: drh)
2017-06-08
13:10 • Fixed ticket [fda2210880]: Corruption due to REPLACE in an auto-vacuumed database plus 3 other changes (artifact: eee8ce590c user: drh)
11:08 • Ticket [fda2210880]: 6 changes (artifact: 7b1cb0c798 user: drh)
11:07 • New ticket [fda2210880]. (artifact: 548c43a861 user: drh)
2017-05-25
16:28 • Fixed ticket [7fde638e94]: Assertion fault on a LEFT JOIN plus 5 other changes (artifact: f6f681e5c6 user: drh)
2017-05-24
22:39 • New ticket [7fde638e94]. (artifact: dcc0914b11 user: drh)
2017-05-23
19:16 • Fixed ticket [cad1ab4cb7]: Segfault due to LEFT JOIN flattening optimization plus 3 other changes (artifact: 83102567a5 user: drh)
15:18 • Open ticket [cad1ab4cb7]. (artifact: f952f39768 user: drh)
15:18 • Ticket [cad1ab4cb7]: 3 changes (artifact: 49dcb66aea user: drh)
12:35 • Ticket [cad1ab4cb7]: 3 changes (artifact: 88096b0cb3 user: drh)
01:29 • Fixed ticket [cad1ab4cb7]. (artifact: b4ade83baa user: drh)
01:17 • New ticket [cad1ab4cb7]. (artifact: 6e17327e62 user: drh)
2017-05-01
18:35 • Fixed ticket [f68dc596c4]: Database corruption on REPLACE with a mix of NULL and non-NULL rowids. plus 5 other changes (artifact: f8f6c4c104 user: drh)
18:09 • New ticket [f68dc596c4]. (artifact: 784838a8d5 user: drh)
2017-04-24
14:57 • Closed ticket [61fe97454c]: Duplicate result using an IN operator in the WHERE clause plus 6 other changes (artifact: 3998d56c23 user: dan)
13:49 • New ticket [61fe97454c]. (artifact: dde67a5380 user: drh)
2017-04-11
18:55 • Fixed ticket [981329adee]: Stack overflow while parsing deeply nested JSON plus 5 other changes (artifact: 86a95386f6 user: drh)
18:09 • New ticket [981329adee]. (artifact: 85802dae73 user: drh)
2017-04-10
12:25 • Fixed ticket [6c9b551407]: JSON allows unescaped control characters in strings plus 5 other changes (artifact: a23432495d user: drh)
12:14 • New ticket [6c9b551407]. (artifact: e6bb692a10 user: drh)
2017-04-08
18:18 • Fixed ticket [b93be8729a]: JSON extension accepts invalid numeric values plus 5 other changes (artifact: 39c0f43a1b user: drh)
17:54 • New ticket [b93be8729a]. (artifact: 72ad25bfc2 user: drh)
2017-03-24
19:14 • Fixed ticket [06796225f5]: Crash in recursive invocation of a trigger that uses an ephemeral table plus 3 other changes (artifact: 7a87396c94 user: drh)
15:55 • Ticket [06796225f5]: 6 changes (artifact: c5faf531b5 user: drh)
15:45 • New ticket [06796225f5]. (artifact: a9dc7f759f user: dan)
2017-03-02
23:41 • Fixed ticket [6097cb9274]: Broken 'start of day' modifier on date/time functions plus 5 other changes (artifact: 451609e4ec user: drh)
23:20 • New ticket [6097cb9274]. (artifact: dc7e78fb2b user: drh)
2017-02-11
14:58 • Fixed ticket [eb703ba7b5]: Incorrect result using index on expression with collating function plus 5 other changes (artifact: d0eb9fbf60 user: drh)
04:07 • New ticket [eb703ba7b5]. (artifact: d008a3ffd1 user: drh)
2017-01-25
19:04 • Fixed ticket [e6e962d6b0]: sqlite3_blob_reopen() misbehavior on ALTER-ed table plus 5 other changes (artifact: 3850384c85 user: drh)
04:28 • New ticket [e6e962d6b0]. (artifact: a6d71ce73f user: drh)
2017-01-16
18:10 • Fixed ticket [7ffd1ca1d2]: Incorrect affinity when using automatic indexes plus 5 other changes (artifact: d60e419467 user: drh)
15:10 • New ticket [7ffd1ca1d2]. (artifact: 9ce8b972f7 user: drh)
2017-01-10
17:46 • Fixed ticket [25e335f802]: Incorrect result when ON clause refers to table to the right plus 4 other changes (artifact: 70ac38b24c user: drh)
17:19 • Ticket [25e335f802]: 6 changes (artifact: b5f4cd3297 user: drh)
17:15 • New ticket [25e335f802]. (artifact: 464fffdcc3 user: drh)
2017-01-05
17:38 • Fixed ticket [190c2507ee]: Assertion fault on a query against a view plus 5 other changes (artifact: db3c58de87 user: drh)
16:34 • New ticket [190c2507ee]. (artifact: 5c88913817 user: drh)
14:23 • Fixed ticket [30027b613b]: DELETE trigger on WITHOUT ROWID table not fired for REPLACE op plus 4 other changes (artifact: 8389ee5382 user: drh)
2017-01-04
21:26 • Ticket [30027b613b]: 6 changes (artifact: 53472fbe9a user: drh)
19:12 • New ticket [30027b613b]. (artifact: b5b5fd5d6e user: dan)
2017-01-03
13:37 • Fixed ticket [8c9458e703]: row-value updates in triggers do not work. plus 5 other changes (artifact: 0395bbeaa1 user: drh)
2017-01-02
21:40 • New ticket [8c9458e703]. (artifact: 2e02cb7ed6 user: drh)
2016-12-01
23:37 • Fixed ticket [2df0107bd2]: Incorrect result from LEFT JOIN with a subquery on the LHS plus 3 other changes (artifact: 546ccb2197 user: drh)
19:34 • Ticket [2df0107bd2]: 6 changes (artifact: a123859247 user: drh)
19:11 • New ticket [2df0107bd2]. (artifact: 944f716f05 user: drh)
2016-11-24
00:00 • Fixed ticket [1a68465637]: Assertion fault on a conditional row-value expression plus 5 other changes (artifact: ddff0332d0 user: drh)
2016-11-23
23:59 • Fixed ticket [da78413751]: Query flattening causes bad byte-code for a vector IN operator plus 5 other changes (artifact: 10c8282517 user: drh)
23:49 • Fixed ticket [199df4168c]: Different answer with and without index on IN operator with type mismatch plus 3 other changes (artifact: d6505cbd38 user: drh)
18:36 • New ticket [1a68465637] Assertion fault on a conditional row-value expression. (artifact: 2564b3cd50 user: drh)
2016-11-17
05:51 • New ticket [da78413751] Query flattening causes bad byte-code for a vector IN operator. (artifact: ddc2e18789 user: drh)
2016-11-11
03:40 • Fixed ticket [2f1b168ab4]: Crash following syntax error on DETACH plus 5 other changes (artifact: 0a7d72a5b3 user: drh)
03:36 • New ticket [2f1b168ab4]. (artifact: e12fe9da63 user: drh)
2016-10-27
01:08 • Fixed ticket [fef4bb4bd9]: Incorrect result from a LEFT JOIN with a row-value constraint plus 5 other changes (artifact: 9eee2c5fac user: drh)
00:27 • New ticket [fef4bb4bd9]. (artifact: b2735a6472 user: drh)
2016-10-26
16:05 • Closed ticket [34a579141b]: Incorrect results with OR terms in the ON clause of a LEFT JOIN plus 3 other changes (artifact: eecf570bca user: dan)
16:05 • Ticket [34a579141b]: 6 changes (artifact: 0155188bca user: drh)
15:39 • New ticket [34a579141b]. (artifact: 79f8ae178b user: dan)
2016-10-12
15:35 • Fixed ticket [96c1454cbf]: Incorrect result with ORDER BY DESC and LIMIT (again) plus 5 other changes (artifact: a2a682f939 user: drh)
14:00 • New ticket [96c1454cbf]. (artifact: e3b3158ed3 user: drh)
2016-10-10
14:38 • Closed ticket [4766f44486]: ORDER BY handling with indexes on expressions plus 6 other changes (artifact: 498d1d7a4d user: dan)
14:20 • New ticket [4766f44486]. (artifact: 4860a299b6 user: dan)
14:18 • Fixed ticket [4baa464912]: NULL handling for indexes on expressions plus 5 other changes (artifact: 415f43e700 user: drh)
13:05 • New ticket [4baa464912]. (artifact: 976f36f6c0 user: drh)
2016-10-03
02:59 • Fixed ticket [7b3328086a]: AUTOINCREMENT problem with the INSERT xfer optimization plus 5 other changes (artifact: 509f81f358 user: drh)
02:01 • New ticket [7b3328086a]. (artifact: 5a826871e2 user: drh)
2016-09-20
22:04 • Fixed ticket [1ec41379c9]: Integer multiple fails to overflow to floating-point plus 5 other changes (artifact: db3108772f user: drh)
20:33 • New ticket [1ec41379c9]. (artifact: 6af4ab8802 user: drh)
2016-09-16
17:07 • Fixed ticket [0eab1ac759]: O(N*N) behavior where it should be O(N) plus 3 other changes (artifact: 8da4f27499 user: drh)
14:30 • Ticket [0eab1ac759]: 6 changes (artifact: 9aab0ed930 user: drh)
13:57 • New ticket [0eab1ac759]. (artifact: 62ca7f9b91 user: drh)
2016-09-07
01:56 • Fixed ticket [0c4df46116]: Incorrect result with ORDER BY DESC and LIMIT plus 5 other changes (artifact: 1f53b3e578 user: drh)
00:42 • New ticket [0c4df46116]. (artifact: 51389ac452 user: drh)
2016-09-03
15:24 • Ticket [199df4168c] Different answer with and without index on IN operator with type mismatch status still Open with 6 other changes (artifact: 6a41349726 user: drh)
14:19 • New ticket [199df4168c]. (artifact: 21640ea63e user: drh)
2016-08-26
12:01 • Fixed ticket [ef36060112]: Incorrect affinity transformations on DELETE plus 5 other changes (artifact: 06aa3be5e2 user: drh)
05:17 • New ticket [ef36060112]. (artifact: 21b6b00b7d user: drh)
2016-07-26
04:24 • Fixed ticket [a0bac8b3c3]: CREATE INDEX changes the answer plus 3 other changes (artifact: 17eb1530c4 user: drh)
04:21 • Ticket [a0bac8b3c3]: 6 changes (artifact: af44096dce user: drh)
03:31 • New ticket [a0bac8b3c3]. (artifact: f4aacbb673 user: drh)
2016-07-14
19:13 • Fixed ticket [f68bf68513]: ALTER TABLE corrupts DESC indexes plus 5 other changes (artifact: 50bb45fa47 user: drh)
18:46 • New ticket [f68bf68513]. (artifact: 2db52790f1 user: drh)
2016-07-01
20:12 • Fixed ticket [e8d439c776]: Crash on transitive WHERE constraint and undefined collation plus 6 other changes (artifact: b9baf11a50 user: drh)
20:08 • New ticket [e8d439c776]. (artifact: 647e33df82 user: drh)
2016-05-06
16:49 • Fixed ticket [16c9801ceb]: Segfault on DELETE with WHERE containing OR plus 3 other changes (artifact: 809d005fb4 user: drh)
16:05 • Ticket [16c9801ceb]: 3 changes (artifact: 387d6abf82 user: drh)
14:33 • Ticket [16c9801ceb]: 3 changes (artifact: bbb174fc68 user: drh)
03:56 • Ticket [16c9801ceb]: 6 changes (artifact: 35b41059a9 user: drh)
03:26 • New ticket [16c9801ceb]. (artifact: 79eb5be6ca user: drh)
2016-05-02
13:46 • Fixed ticket [dc6ebeda93]: Incorrect DELETE due to the one-pass optimization plus 6 other changes (artifact: d9f4aeb055 user: drh)
12:00 • New ticket [dc6ebeda93]. (artifact: 16a4e84314 user: drh)
2016-04-25
02:20 • Fixed ticket [f7f8c97e97]: Valid query fails to compile due to WHERE clause optimization plus 5 other changes (artifact: c320a9dd7c user: drh)
01:43 • New ticket [f7f8c97e97]. (artifact: 1db949b0bc user: drh)
2016-04-18
15:58 • Fixed ticket [7d7525cb01]: Compatibility break on INTEGER PRIMARY KEY columns. plus 5 other changes (artifact: 7d322fddac user: drh)
15:24 • New ticket [7d7525cb01]. (artifact: b61cd89a7b user: drh)
2016-04-09
17:20 • Fixed ticket [a306e56ff6]: Failed DELETE with PRAGMA reverse_unordered_selects plus 5 other changes (artifact: dd06e22d3b user: drh)
16:31 • New ticket [a306e56ff6]. (artifact: 66083a64cd user: drh)
2016-04-07
21:14 • Fixed ticket [7f7f8026ed]: Segfault following heavy SAVEPOINT usage plus 3 other changes (artifact: c9b6953fb1 user: drh)
21:07 • Ticket [7f7f8026ed]: 3 changes (artifact: 26ac4c61b3 user: drh)
20:54 • Ticket [7f7f8026ed]: 6 changes (artifact: 282da2641f user: drh)
18:31 • New ticket [7f7f8026ed]. (artifact: af77e0343b user: drh)
2016-03-09
15:09 • Fixed ticket [5e3c886796]: Correlated subquery on the RHS of an IN operator plus 5 other changes (artifact: f54cb73523 user: drh)
14:48 • New ticket [5e3c886796]. (artifact: ada44cb008 user: drh)
2016-02-19
18:55 • Ticket [dc9b1c91db] One trigger may use auxdata belonging to another. status still Closed with 3 other changes (artifact: c1b47ba65e user: dan)
18:55 • Closed ticket [dc9b1c91db]. (artifact: 0395b2958a user: dan)
18:55 • Ticket [dc9b1c91db]: 6 changes (artifact: 0bea5f1c53 user: dan)
17:22 • New ticket [dc9b1c91db]. (artifact: 018bf9a31d user: dan)
2016-02-09
14:12 • Fixed ticket [d06a25c844]: Incorrect result from a UNION with an ORDER BY plus 6 other changes (artifact: 1ef35260c9 user: drh)
2016-02-08
22:22 • New ticket [d06a25c844]. (artifact: 4685201918 user: drh)
2016-02-04
10:28 • Fixed ticket [ad2559db38]: JSON does not properly escape control characters plus 5 other changes (artifact: 0134f388c6 user: drh)
10:14 • New ticket [ad2559db38]. (artifact: 9f98f0013a user: drh)
2016-01-30
14:54 • Fixed ticket [f45ac567ea]: Invalid JSON generated by json_group_array() plus 7 other changes (artifact: 627a0c6288 user: drh)
13:56 • New ticket [f45ac567ea]. (artifact: 7ebe8f7333 user: drh)
2016-01-20
14:25 • Fixed ticket [80369eddd5]: Incorrect case folding in the LIKE operator plus 5 other changes (artifact: db994bd6ec user: drh)
14:07 • New ticket [80369eddd5]. (artifact: b3016558c5 user: drh)
2016-01-13
17:50 • Fixed ticket [cb3aa0641d]: Incorrect result from a subquery containing over-constrainted ORDER BY plus 3 other changes (artifact: bcde10d8f0 user: drh)
15:21 • Ticket [cb3aa0641d]: 6 changes (artifact: 5d76babb52 user: drh)
15:00 • New ticket [cb3aa0641d]. (artifact: ac020a732f user: drh)
2015-11-24
02:10 • Fixed ticket [e5c6268dd8]: Assertion fault on DISTINCT query containing a correlated aggregate. plus 5 other changes (artifact: 16a157aeb1 user: drh)
02:08 • New ticket [e5c6268dd8]. (artifact: 0d68ffc024 user: drh)
2015-11-21
13:24 • Fixed ticket [73eba7ba5c]: Table-valued function syntax allowed for ordinary tables and views plus 5 other changes (artifact: 189655c893 user: drh)
13:11 • New ticket [73eba7ba5c]. (artifact: f2c7d781f1 user: drh)
2015-11-13
17:39 • Fixed ticket [38a97a87a6]: Inaccurate int/float comparison results in corrupt index plus 5 other changes (artifact: 634702682b user: drh)
2015-11-06
00:36 • New ticket [38a97a87a6]. (artifact: 98d1f3aac6 user: drh)
2015-11-01
21:19 • Fixed ticket [ac661962a2]: Differing interpretation of historical schemas plus 5 other changes (artifact: 3ab30754d8 user: drh)
21:17 • New ticket [ac661962a2]. (artifact: 8c71f535b7 user: drh)
2015-10-24
20:34 • Ticket [8a2adec166] Problem creating automatic-indexes on sub-queries in the FROM clause of correlated scalar sub-queries status still Closed with 3 other changes (artifact: 831a2f9b1b user: dan)
20:34 • Closed ticket [8a2adec166]. (artifact: 5529b5aa43 user: dan)
19:32 • New ticket [8a2adec166]. (artifact: 13db9a5234 user: dan)
2015-10-16
15:16 • Fixed ticket [57eec374ae]: JSON1 accepts form-feed (char(12)) as a white-space character plus 5 other changes (artifact: c50665fed3 user: drh)
15:00 • New ticket [57eec374ae]. (artifact: b6d5677bb4 user: drh)
2015-10-06
17:27 • Fixed ticket [b65cb2c8d9]: Incorrect LIMIT on a UNION ALL query plus 5 other changes (artifact: 3cd675c689 user: drh)
13:26 • New ticket [b65cb2c8d9]. (artifact: b4cd8e8af6 user: drh)
2015-09-30
14:06 • Fixed ticket [1b266395d6]: INSERT OR REPLACE with a foreign key constraint leads to assertion fault plus 3 other changes (artifact: b42dc3716f user: drh)
12:36 • Ticket [1b266395d6]: 6 changes (artifact: f0a3eedde7 user: drh)
12:10 • New ticket [1b266395d6]. (artifact: 7f88fd969c user: drh)
2015-09-09
13:28 • Fixed ticket [acd1299088]: CREATE TABLE AS fails with a false report of database corruption plus 5 other changes (artifact: b2d6502f2b user: drh)
12:34 • New ticket [acd1299088]. (artifact: 16828871e7 user: drh)
2015-08-22
01:32 • Fixed ticket [c2a19d8165]: Incorrect LEFT JOIN when FROM clause contains nested subqueries plus 5 other changes (artifact: 05ca3244a6 user: drh)
2015-08-21
23:25 • New ticket [c2a19d8165]. (artifact: 7b645a97b0 user: drh)
2015-07-23
16:41 • Fixed ticket [8fd39115d8]: assertion fault on WITHOUT ROWID query using the OR optimization plus 7 other changes (artifact: 4bd51eb98f user: drh)
14:27 • New ticket [8fd39115d8]. (artifact: d63541a512 user: drh)
2015-06-18
14:33 • Fixed ticket [5f60b11fc8]: likely() function in the ON clause of a LEFT JOIN results in incorrect result plus 5 other changes (artifact: f317e943c8 user: drh)
14:31 • New ticket [5f60b11fc8]. (artifact: dd11c3b0b1 user: drh)
2015-06-16
16:39 • Fixed ticket [873cae2b6e]: Schema corruption after aborted CREATE TABLE AS plus 5 other changes (artifact: 8c915fd4e9 user: drh)
16:27 • New ticket [873cae2b6e]. (artifact: bdeb30943c user: drh)
2015-05-20
17:36 • Fixed ticket [f2ad7de056]: Corrupt table created by CREATE TABLE AS followed by compound SELECT plus 3 other changes (artifact: 81fc82f6fc user: drh)
15:52 • Ticket [f2ad7de056]: 6 changes (artifact: 8126358cb5 user: drh)
14:04 • New ticket [f2ad7de056]. (artifact: 86aa4e2262 user: drh)
2015-05-19
20:34 • Ticket [34cd55d68e] Database corruption following INSERT with a TRIGGER that does an affinity change status still Fixed with 3 other changes (artifact: c195566c38 user: drh)
19:55 • Fixed ticket [34cd55d68e]. (artifact: 4d04bea376 user: drh)
19:08 • New ticket [34cd55d68e]. (artifact: 208465f372 user: drh)
2015-04-11
11:45 • Closed ticket [7b4fee9f6c]: Expressions like (a IS NULL AND b = ?) optimized by a UNIQUE index matching a single row only plus 6 other changes (artifact: 51edb7d06b user: dan)
11:06 • New ticket [7b4fee9f6c]. (artifact: a72fb3c97e user: dan)
2015-03-07
13:57 • Fixed ticket [05f43be8fd]: Incorrect use of index with LIKE operators when the LHS is a blob plus 5 other changes (artifact: c140b281fa user: drh)
2015-03-06
13:14 • New ticket [05f43be8fd]. (artifact: 9a374a0d2d user: drh)
2015-02-24
20:21 • Fixed ticket [2326c258d0]: Incorrect result when a LEFT JOIN provides the qualifying constraint for a partial index plus 3 other changes (artifact: 28d4d42e5b user: drh)
18:13 • Ticket [2326c258d0]: 7 changes (artifact: 6c8344ce68 user: drh)
15:30 • New ticket [2326c258d0]. (artifact: f6a379b6db user: drh)
2015-02-17
02:06 • Fixed ticket [1c69be2daf]: Incorrect GROUP BY when input and output columns have the same name plus 3 other changes (artifact: c35d9445d6 user: drh)
2015-02-09
18:28 • Fixed ticket [ca0d20b6cd]: COLLATE operator masked by function calls plus 5 other changes (artifact: 9d7a17c87c user: drh)
18:28 • Fixed ticket [2f7170d73b]: "misuse of aggregate" error if aggregate column from FROM subquery is used in correlated subquery plus 5 other changes (artifact: 871a8aa973 user: drh)
15:16 • New ticket [ca0d20b6cd] COLLATE operator masked by function calls. (artifact: 616fce0c64 user: drh)
07:51 • New ticket [2f7170d73b] "misuse of aggregate" error if aggregate column from FROM subquery is used in correlated subquery. (artifact: 8dbaf78f17 user: dan)
2015-01-22
12:01 • Fixed ticket [32b63d5424]: Fuzzer induced crash plus 5 other changes (artifact: d184048555 user: drh)
11:41 • New ticket [32b63d5424]. (artifact: c108a800aa user: drh)
2015-01-20
18:11 • Fixed ticket [f97c463710]: Incorrect ordering with ORDER BY and LIMIT plus 4 other changes (artifact: ac59934aff user: drh)
2015-01-19
15:40 • Ticket [f97c463710]: 6 changes (artifact: 0c9d51dfc8 user: drh)
15:31 • New ticket [f97c463710]. (artifact: fc35a8b205 user: drh)
2015-01-09
01:27 • Fixed ticket [a59ae93ee9]: Crashes due to fuzzed input plus 5 other changes (artifact: 2907380e95 user: drh)
00:43 • New ticket [a59ae93ee9]. (artifact: 30acea0db0 user: drh)
2014-12-05
14:44 • Fixed ticket [e4a18565a3]: Stale KeyInfo object used in shared-cache mode plus 5 other changes (artifact: 002412e9be user: drh)
04:45 • New ticket [e4a18565a3]. (artifact: 45f4b5d250 user: drh)
2014-12-04
21:54 • Fixed ticket [c5ea805691]: Inverted sort order when using DISTINCT and a descending index plus 5 other changes (artifact: af5ba54444 user: drh)
21:29 • New ticket [c5ea805691]. (artifact: 9fb2d9230e user: drh)
16:35 • Fixed ticket [6f2222d550]: Incorrect output on a LEFT JOIN plus 6 other changes (artifact: 63d1ebb266 user: drh)
15:40 • New ticket [6f2222d550]. (artifact: 897deb67b3 user: drh)
2014-11-14
18:02 • Fixed ticket [db87229497]: Incorrect result when RHS of IN operator contains DISTINCT and LIMIT plus 5 other changes (artifact: 44893f7639 user: drh)
15:25 • New ticket [db87229497]. (artifact: b959ab7a02 user: drh)
2014-11-05
15:57 • Fixed ticket [094d39a4c9]: Assertion fault on CREATE TABLE ... AS SELECT ... plus 3 other changes (artifact: 3503a857f1 user: drh)
15:45 • Ticket [43107840f1] Assertion fault on UPDATE status still Fixed with 3 other changes (artifact: 22c1925546 user: drh)
15:44 • Ticket [094d39a4c9] Assertion fault on CREATE TABLE ... AS SELECT ... status still Open with 6 other changes (artifact: e881c36f31 user: drh)
14:53 • New ticket [094d39a4c9]. (artifact: b5f433e534 user: drh)
2014-10-29
00:58 • Fixed ticket [43107840f1]: Assertion fault on UPDATE plus 5 other changes (artifact: 224c3ec2f4 user: drh)
00:27 • New ticket [43107840f1]. (artifact: 0c3cdaf3bc user: drh)
2014-10-11
02:12 • Fixed ticket [ba7cbfaedc]: Wrong output order when a DESC index and GROUP BY and ORDER BY. plus 5 other changes (artifact: 7542bf3121 user: drh)
2014-10-10
19:58 • New ticket [ba7cbfaedc]. (artifact: 8a70e91f6b user: drh)
2014-10-02
21:52 • Fixed ticket [8c32a33a53]: Segfault on a syntax error involving the IS operator plus 5 other changes (artifact: ee9b9ce6d8 user: drh)
21:25 • New ticket [8c32a33a53]. (artifact: 7de8fdb304 user: drh)
2014-10-01
12:02 • Closed ticket [e3a290961a]: out-of-bounds write when using non-default malloc implementation and SQLITE_DIRECT_OVERFLOW_READ plus 6 other changes (artifact: 347802e2b6 user: dan)
11:54 • New ticket [e3a290961a]. (artifact: 72fdf8427d user: dan)
2014-09-29
15:00 • Fixed ticket [209d31e316]: Assertion fault when deleting a table out from under a SELECT plus 5 other changes (artifact: 12f3314f7e user: drh)
14:43 • New ticket [209d31e316]. (artifact: 442fc706a7 user: drh)
2014-09-24
13:20 • Fixed ticket [78c0c8c3c9]: Segfault when a DEFAULT value contains a bind parameter plus 5 other changes (artifact: 2d0ace2695 user: drh)
11:57 • New ticket [78c0c8c3c9]. (artifact: 066bb9abd3 user: drh)
2014-09-21
22:33 • Fixed ticket [d11a6e908f]: Query planner fault on three-way nested join with compound inner SELECT plus 3 other changes (artifact: 06237a2b97 user: drh)
2014-09-20
18:42 • Ticket [d11a6e908f]: 7 changes (artifact: aab722bac8 user: drh)
17:05 • New ticket [d11a6e908f]. (artifact: ce50af6bfe user: drh)
2014-08-27
17:41 • Fixed ticket [98d973b8f5]: Partial index gives incorrect query result plus 5 other changes (artifact: a75d6bfc0b user: drh)
17:31 • New ticket [98d973b8f5]. (artifact: a441e2a9d7 user: drh)
2014-08-21
15:57 • Fixed ticket [369d57fb8e]: DELETE with TRIGGER causes an assertion fault plus 5 other changes (artifact: 5709eef09c user: drh)
12:32 • New ticket [369d57fb8e]. (artifact: 40e9c6f0f3 user: drh)
2014-08-19
20:27 • Fixed ticket [11d5aa455e]: sqlite3_trace() sometimes does not invoke its callback plus 5 other changes (artifact: 2be037cd28 user: drh)
19:57 • New ticket [11d5aa455e]. (artifact: cc30ae3237 user: drh)
2014-08-06
00:29 • Fixed ticket [3a88d85f36]: Segfault when a DEFAULT value contains an aggregate function plus 5 other changes (artifact: 62aee611c9 user: drh)
2014-08-05
20:51 • New ticket [3a88d85f36]. (artifact: fcc55ce478 user: drh)
2014-07-30
14:44 • Fixed ticket [9a6daf340d]: UNIQUE not enforced on an index plus 5 other changes (artifact: 30408f14a0 user: drh)
12:33 • New ticket [9a6daf340d]. (artifact: 84f3a3153a user: drh)
2014-07-29
12:53 • Fixed ticket [d2889096e7]: Problem with rtree tables with IN() operators or as the inner loop of a join. plus 3 other changes (artifact: d17ac0ca06 user: drh)
11:18 • Ticket [d2889096e7]: 6 changes (artifact: c90fa76de3 user: dan)
11:15 • New ticket [d2889096e7]. (artifact: f95aae068e user: dan)
2014-06-30
18:58 • Fixed ticket [b2fa5424e6]: Incorrect STAT4 samples for WITHOUT ROWID tables plus 5 other changes (artifact: a9c56e5c96 user: drh)
13:06 • New ticket [b2fa5424e6]. (artifact: c4cd9e13cb user: drh)
2014-06-27
02:23 • Fixed ticket [9a8b09f8e6]: Affinity problem on "x IN (?)" plus 5 other changes (artifact: a198df4d6f user: drh)
2014-06-26
14:46 • New ticket [9a8b09f8e6]. (artifact: 7a0caf42b8 user: drh)
2014-06-10
20:11 • Open ticket [1c69be2daf]: Incorrect GROUP BY when input and output columns have the same name plus 4 other changes (artifact: a8a0089dfa user: drh)
2014-05-23
11:51 • Fixed ticket [e9654505cf]: Inifinite loop in INSERT statement. plus 5 other changes (artifact: 8389cd6e3f user: drh)
10:15 • New ticket [e9654505cf]. (artifact: cc3683f6f8 user: drh)
2014-05-07
17:19 • Fixed ticket [55746f9e65]: group_concat() returns NULL instead of an empty string plus 5 other changes (artifact: 63c1dfcf1e user: drh)
16:58 • New ticket [55746f9e65]. (artifact: cc9c07bcef user: drh)
2014-04-26
17:52 • Fixed ticket [f67b41381a]: "INSERT INTO tbl SELECT * FROM tbl2" statement may modify data if ALTER TABLE ADD COLUMN has been used on tbl2. plus 3 other changes (artifact: d52b6d756f user: drh)
12:36 • Ticket [f67b41381a]: 6 changes (artifact: a5228e13e1 user: dan)
12:18 • New ticket [f67b41381a]. (artifact: a35d5872cc user: dan)
2014-04-25
17:37 • Fixed ticket [388d01d4bb]: Crash on join with a virtual table, DISTINCT, and ORDER BY. plus 5 other changes (artifact: a6de697b34 user: drh)
14:04 • New ticket [388d01d4bb]. (artifact: da138a0b57 user: drh)
2014-04-21
13:39 • Fixed ticket [b75a9ca6b0]: ORDER BY ignored if query has identical GROUP BY plus 5 other changes (artifact: c5dd2e0dab user: drh)
2014-04-20
09:57 • Closed ticket [14b9ffb67f]: An ORDER BY clause with the same expressions as a GROUP BY clause may be ignored plus 6 other changes (artifact: 9dcbc9658a user: drh)
09:44 • Closed ticket [14b9ffb67f]. (artifact: 2ed6540f1a user: dan)
09:34 • New ticket [b75a9ca6b0] ORDER BY ignored if query has identical GROUP BY. (artifact: 886cb1c922 user: drh)
09:32 • New ticket [14b9ffb67f] An ORDER BY clause with the same expressions as a GROUP BY clause may be ignored. (artifact: 401ae53bb4 user: dan)
2014-04-14
19:48 • Fixed ticket [264b970c43]: Crash when calling sqlite_rename_parent() with NULL parameters. plus 5 other changes (artifact: b9804f7e44 user: drh)
19:46 • New ticket [264b970c43]. (artifact: 9c40070dd4 user: drh)
2014-04-13
19:28 • Fixed ticket [2ea3e9fe63]: Partial index causes assertion fault on UPDATE OR REPLACE plus 5 other changes (artifact: 50c5235f0e user: drh)
16:24 • New ticket [2ea3e9fe63]. (artifact: aee89fa172 user: drh)
2014-04-10
02:24 • Fixed ticket [10fb063b11]: Duplicate row output on an OR query plus 5 other changes (artifact: 1e34ba1a9e user: drh)
02:09 • New ticket [10fb063b11]. (artifact: 530cc4a7a2 user: drh)
2014-04-03
16:57 • Fixed ticket [98825a79ce]: Incorrect result from a DISTINCT + GROUP BY + ORDER BY query plus 5 other changes (artifact: 2c4eead474 user: drh)
15:17 • New ticket [98825a79ce]. (artifact: b556e7c999 user: drh)
2014-03-24
15:02 • Fixed ticket [a8a0d2996a]: Incorrect column data type reported plus 3 other changes (artifact: 7badd139e4 user: drh)
12:55 • Ticket [a8a0d2996a]: 4 changes (artifact: a8a9f0a1de user: drh)
11:32 • Ticket [a8a0d2996a]: 6 changes (artifact: 533558fc03 user: drh)
09:18 • New ticket [a8a0d2996a]. (artifact: c40b3fef63 user: dan)
2014-03-21
18:16 • Fixed ticket [07d6a0453d]: OFFSET ignored if there is no FROM clause plus 5 other changes (artifact: 9c43cbdc9e user: drh)
18:04 • New ticket [07d6a0453d]. (artifact: c9ba18a716 user: drh)
2014-03-20
13:31 • Fixed ticket [e39d032577]: Assertion fault on a query containing "x IN (?)" plus 6 other changes (artifact: 8a7c5a08b3 user: drh)
11:52 • New ticket [e39d032577]. (artifact: c3311ddb99 user: drh)
2014-03-11
13:20 • Closed ticket [0841d0f524]: Exclusive transactions do not work if same database multiply attached plus 4 other changes (artifact: e4ce6e4579 user: drh)
13:20 • Closed ticket [13137dccf3]: FTS3 and last_insert_rowid() plus 3 other changes (artifact: 81c931a1cb user: drh)
13:20 • Closed ticket [084941461f]: Some minor asyncvfs issues plus 2 other changes (artifact: 0895c6994a user: drh)
13:19 • Closed ticket [25e09aa2ab]: Lint mode plus 3 other changes (artifact: c165b8c802 user: drh)
13:18 • Fixed ticket [5ac9b497de]: Some issues with aliases, fully qualified identifiers, and * plus 3 other changes (artifact: 571628716f user: drh)
13:18 • Closed ticket [030632f55b]: make sqlite2 detect sqlite3 plus 3 other changes (artifact: dc3fdfa018 user: drh)
13:18 • Closed ticket [72b01a982a]: Per page/region checksums plus 4 other changes (artifact: 1b2cd92493 user: drh)
13:17 • Closed ticket [3671265894]: No error reporting on file open failure plus 3 other changes (artifact: a8c0cf879d user: drh)
13:17 • Closed ticket [af3450b763]: Recursive virtual tables plus 3 other changes (artifact: 46e25d4bfe user: drh)
13:17 • Fixed ticket [c25aab7e7e]: The ".import" command does not parse CSV correctly. plus 3 other changes (artifact: 5733c490a9 user: drh)
13:16 • Closed ticket [f817a45752]: CantOpen doesn't include name of file that can't be opened plus 4 other changes (artifact: 0309965386 user: drh)
13:15 • Fixed ticket [775b39dd3c]: Poor query planning with virtual tables, joins and ORDER BY. plus 2 other changes (artifact: f9f600d939 user: drh)
13:15 • Closed ticket [2e047cbefa]: select DISTINCT performance could be better plus 4 other changes (artifact: 397b2b896b user: drh)
13:14 • Fixed ticket [23b2128201]: Uninformative error message on check constraint failure plus 3 other changes (artifact: 56d0f0144e user: drh)
13:14 • Closed ticket [61d35ac210]: A way to tell if a journal should exist plus 3 other changes (artifact: 8cfcaee08e user: drh)
13:13 • Closed ticket [33fdaab1a0]: Need to cancel an integrity check in progress with sqlite3_interrupt plus 3 other changes (artifact: 6cf22fecb5 user: drh)
13:12 • Closed ticket [293860ac26]: Allow triggers to reference other databases plus 3 other changes (artifact: 72175e60e1 user: drh)
13:12 • Closed ticket [65a1fd4bab]: Shell should call rl_readline_name plus 4 other changes (artifact: 1553d73723 user: drh)
13:11 • Fixed ticket [bcff482dd6]: Explicit extended error code for deadlock with sqlite_busy plus 4 other changes (artifact: 17a60b18fe user: drh)
13:11 • Closed ticket [5896edbe46]: List available SQL functions plus 4 other changes (artifact: 902c82604b user: drh)
13:10 • Closed ticket [c276ee2e4e]: null should not be allowed in primary key plus 5 other changes (artifact: 9e0a2c0b1f user: drh)
13:09 • Fixed ticket [f711d5a937]: Windows DLL should have versioninfo resource plus 4 other changes (artifact: 3a0f905847 user: drh)
13:08 • Closed ticket [4d5c039d12]: Truncated database not detected well plus 3 other changes (artifact: af4312204a user: drh)
13:07 • Fixed ticket [de3ae967a0]: Insert multiple rows at once plus 3 other changes (artifact: 23340708ed user: drh)
13:06 • Closed ticket [c060923a54]: VFS filename truncation issues plus 3 other changes (artifact: fc3c4605e0 user: drh)
13:06 • Fixed ticket [f6ee7c1986]: Negative widths should right justify plus 4 other changes (artifact: 96dd07a820 user: drh)
13:05 • Fixed ticket [ba7fdb568d]: Page size should auto default to file system block size plus 3 other changes (artifact: 14d4023191 user: drh)
13:05 • Closed ticket [08595ca456]: INTERSECT operator should have higher precedence plus 5 other changes (artifact: 376a460dee user: drh)
13:04 • Closed ticket [ed2ff2f4ef]: Call progress callback while doing pragma integrity_check plus 4 other changes (artifact: 760956842d user: drh)
13:04 • Closed ticket [ebde3f66fc]: Shared cache has different busy behaviour than non-shared plus 3 other changes (artifact: 5d117cb602 user: drh)
13:03 • Closed ticket [d8fe6cef65]: Error return from VFS xUnlock ignored plus 4 other changes (artifact: 149285a538 user: drh)
13:02 • Closed ticket [1c67bd6ce9]: Shell Control-C (break) handling could be better plus 4 other changes (artifact: d49cecf221 user: drh)
13:00 • Closed ticket [1a1790ca1a]: No way to signal an error in collation callback plus 4 other changes (artifact: 1d03e3694a user: drh)
13:00 • Closed ticket [62359d6511]: xGetLastError should be dumped plus 4 other changes (artifact: b2d8d1119e user: drh)
12:59 • Closed ticket [efeeb90f2a]: error messages should be per-thread not global plus 4 other changes (artifact: 0fa3cc5d4a user: drh)
12:59 • Closed ticket [15e11a2c87]: IfEmpty(a,b) : a function like IfNull(a,b) but for empty strings plus 3 other changes (artifact: 1952615092 user: drh)
12:58 • Closed ticket [eaa105fe74]: (...) WHERE col IN (val1) not reflected in xBestIndex plus 3 other changes (artifact: d685d603f5 user: drh)
12:58 • Closed ticket [b803a45d50]: Feature Request: MATCHES(VAL1%, VAL2, %VALn%, ...) plus 4 other changes (artifact: 2882bfb8c8 user: drh)
12:57 • Ticket [084941461f] Some minor asyncvfs issues status still Open with 4 other changes (artifact: 1f0b55dd12 user: drh)
12:56 • Closed ticket [e33452c90f]: Query plan doesn't use existing index plus 3 other changes (artifact: 78867f00a3 user: drh)
12:56 • Closed ticket [89f7b55854]: RFE - Documentation in PDF format? plus 4 other changes (artifact: 44da06a86c user: drh)
12:56 • Closed ticket [2c5661c26a]: Thread safety: does SQLite handle pthread_cancel cleanly? plus 4 other changes (artifact: 766bc52d43 user: drh)
12:54 • Closed ticket [1248e6cda8]: Insufficient precision of sqlite3_column_text16() for floating point values plus 4 other changes (artifact: 467b6acba3 user: drh)
12:50 • Closed ticket [36769f697d]: termDataCmp in FTS3 should be __cdecl on Windows plus 4 other changes (artifact: b4aecdbd0e user: drh)
12:49 • Closed ticket [8f81455baf]: fts3GetVarint32 sets random number on error plus 3 other changes (artifact: 13cba602b0 user: drh)
12:48 • Ticket [13137dccf3] FTS3 and last_insert_rowid() status still Open with 3 other changes (artifact: c36c80902c user: drh)
12:47 • Ticket [5e0423b058] xAccess behaviour is not documented, changed in Windows 3.7.0 status still Open with 3 other changes (artifact: f57fde4855 user: drh)
12:47 • Fixed ticket [edb497982c]: FTS n-character prefix query returns incorrect results when using an n+1 character prefix index. plus 4 other changes (artifact: eb2d23d22d user: drh)
12:46 • Closed ticket [f48b7da35c]: Loadable extensions documentation bitrot plus 4 other changes (artifact: 662e23067f user: drh)
12:45 • Closed ticket [01b785eefa]: sqlite3.exe - wrong parameter charset plus 5 other changes (artifact: 481bb647cf user: drh)
12:44 • Ticket [6c266900a2] shell: The column mode (and width option) does not manage correctly UTF-8 status still Open with 3 other changes (artifact: ca97a463fe user: drh)
12:44 • Fixed ticket [beba9cae63]: Assertion fault on a valid query plus 5 other changes (artifact: f40290c295 user: drh)
12:41 • Fixed ticket [4eb3a0bd32]: Performance regression in Skrooge plus 5 other changes (artifact: bf79277f1c user: drh)
2014-03-05
15:07 • Fixed ticket [31a19d11b9]: Name resolution issue with compound SELECTs and Common Table Expressions plus 4 other changes (artifact: 833b3cf175 user: drh)
2014-03-04
13:03 • Ticket [4ef7e3cfca] Name resolution problem in sub-selects within triggers status still Closed with 3 other changes (artifact: 1d3f809204 user: drh)
11:38 • Closed ticket [4ef7e3cfca]. (artifact: c2b20d68d9 user: dan)
11:21 • New ticket [4ef7e3cfca]. (artifact: 552bb54d39 user: anonymous)
2014-02-26
02:26 • Fixed ticket [65bdeb9739]: "ORDER BY random()" gets optimized out plus 5 other changes (artifact: 3a37419679 user: drh)
00:48 • New ticket [65bdeb9739]. (artifact: 73ee3bfc27 user: drh)
2014-02-25
21:56 • Fixed ticket [8c63ff0eca]: Incorrect query result on a UNION ALL plus 6 other changes (artifact: 45daabfe46 user: drh)
18:46 • Add attachment b2.txt to ticket [8c63ff0eca] (artifact: dc9c8fcf65 user: drh)
18:46 • New ticket [8c63ff0eca] Incorrect query result on a UNION ALL. (artifact: d0eedcee6a user: drh)
2014-02-12
14:43 • Fixed ticket [c34d0557f7]: Name resolution issue with WITHOUT ROWID plus 5 other changes (artifact: b54bb68373 user: drh)
14:11 • New ticket [c34d0557f7]. (artifact: e16ef752fe user: drh)
2014-02-11
02:48 • Fixed ticket [4c86b126f2]: Incorrect query result with SQLITE_ENABLE_STAT4 plus 4 other changes (artifact: e8119ababb user: drh)
2014-02-10
23:50 • Ticket [4c86b126f2]: 6 changes (artifact: 6b737762b5 user: drh)
22:46 • New ticket [4c86b126f2]. (artifact: a444fa6b9b user: drh)
2014-02-09
02:15 • New ticket [31a19d11b9] Name resolution issue with compound SELECTs and Common Table Expressions. (artifact: 04200414ea user: drh)
2014-02-08
19:12 • Fixed ticket [fccbde530a]: DISTINCT thinks a zeroblob() and blob of all zeros are different plus 5 other changes (artifact: 609faf4cd2 user: drh)
18:47 • New ticket [fccbde530a]. (artifact: 74e2e6591f user: drh)
2014-01-20
19:56 • Closed ticket [1a1a194d1e]: Assertion fault on query of virtual table with cross-column constraints plus 3 other changes (artifact: fcc16e779b user: dan)
19:56 • Ticket [1a1a194d1e]: 6 changes (artifact: f74cd96f69 user: dan)
19:15 • New ticket [1a1a194d1e]. (artifact: ce84c7528f user: drh)
2013-12-31
18:29 • Ticket [ee4b2b48f5] Prepared statement cache status still Open with 4 other changes (artifact: 3dcbaae8a8 user: anonymous)
15:24 • Ticket [ee4b2b48f5]: 3 changes (artifact: d1a39bf376 user: anonymous)
2013-12-22
20:44 • Fixed ticket [520070ec7f]: Array overrun in the skip-scan optimization plus 5 other changes (artifact: c339a0e82b user: drh)
20:28 • New ticket [520070ec7f]. (artifact: 4753c7b2ab user: drh)
2013-11-12
12:31 • Closed ticket [4065ac8595]: LEFT JOIN with virtual table on left hand side may not return all rows plus 3 other changes (artifact: c37b27e922 user: dan)
11:59 • Ticket [4065ac8595]: 6 changes (artifact: 058e783fa5 user: dan)
11:51 • New ticket [4065ac8595]. (artifact: c1e6a5ea0b user: dan)
2013-10-28
20:39 • Fixed ticket [c620261b5b]: Incorrect result on query involving LEFT JOIN and transitive constraints plus 5 other changes (artifact: 566ec6c0bb user: drh)
15:50 • New ticket [c620261b5b]. (artifact: 06e06d2c96 user: drh)
2013-10-04
00:07 • Fixed ticket [a5c8ed66ca]: Incorrect count(*) when partial indices exist plus 5 other changes (artifact: ec7c3f4ce7 user: drh)
2013-10-03
23:45 • New ticket [a5c8ed66ca]. (artifact: e97050abae user: drh)
2013-09-30
10:19 • Fixed ticket [9fb5cd7c76]: "DELETE FROM tbl" statements do not obtain a shared-cache write-lock on table "tbl" plus 3 other changes (artifact: 8a2065a43f user: drh)
2013-09-26
14:24 • Ticket [9fb5cd7c76]: 6 changes (artifact: 7c401e0637 user: dan)
14:17 • New ticket [9fb5cd7c76]. (artifact: c0538984b8 user: dan)
2013-09-03
14:03 • Fixed ticket [be84e357c0]: Segfault during query involving LEFT JOIN column in the ORDER BY clause plus 5 other changes (artifact: 2da9116210 user: drh)
12:18 • New ticket [be84e357c0]. (artifact: 8e79360a8c user: drh)
2013-08-29
13:12 • Fixed ticket [9f2eb3abac]: A lookup on a primary key or unique index with more than 4 fields can cause a crash plus 5 other changes (artifact: c4f62d4593 user: drh)
08:50 • New ticket [9f2eb3abac]. (artifact: 4642c1bd95 user: dan)
07:22 • Closed ticket [2fd50fa665]: cygwin-1.7 issues: winFullPathname and tempname plus 5 other changes (artifact: 3bdba2059e user: mistachkin)
2013-08-28
16:27 • Fixed ticket [bc878246ea]: Incorrect result from LEFT JOIN query plus 5 other changes (artifact: 975cc6c5a4 user: drh)
14:29 • New ticket [bc878246ea]. (artifact: 9bb4830f72 user: drh)
2013-08-21
13:09 • Fixed ticket [d666d600a6]: COLLATE operator on lhs of BETWEEN expression is ignored. plus 3 other changes (artifact: 83f1d15630 user: drh)
10:57 • Ticket [d666d600a6]: 6 changes (artifact: 67e6e8db9e user: dan)
10:56 • New ticket [d666d600a6]. (artifact: aeee4a28a4 user: dan)
2013-08-15
22:42 • Fixed ticket [1c69be2daf]: Incorrect GROUP BY when input and output columns have the same name plus 5 other changes (artifact: 5edfd40f48 user: drh)
22:42 • Fixed ticket [f617ea3125]: Incorrect ORDER BY with colliding input and output column names plus 3 other changes (artifact: f37c56eddf user: drh)
20:11 • Ticket [f617ea3125]: 6 changes (artifact: cac895080f user: drh)
2013-08-14
20:24 • New ticket [f617ea3125]. (artifact: 818175f491 user: drh)
20:12 • New ticket [1c69be2daf] Incorrect GROUP BY when input and output columns have the same name. (artifact: 7bd16b7dd3 user: drh)
2013-07-18
18:45 • Fixed ticket [406d3b2ef9]: SQL function auxdata associated with parameters is not cleared plus 5 other changes (artifact: 52adadc1d5 user: drh)
14:15 • New ticket [406d3b2ef9]. (artifact: aec7efdd7b user: drh)
2013-07-17
11:54 • Fixed ticket [78588b938a]: Virtual Table Sync frees pVtab->zErrMsg without zeroing plus 5 other changes (artifact: 5ac587c30c user: drh)
04:15 • New ticket [78588b938a]. (artifact: 4b22f9e67c user: anonymous)
2013-07-09
14:49 • Fixed ticket [83e9014ec2]: Incorrect result from sqlite3_stmt_status with SQLITE_STMTSTATUS_FULLSCAN_STEP plus 5 other changes (artifact: 0ed0251ca0 user: drh)
14:49 • Fixed ticket [5ed1772895]: Incorrect ORDER BY on an indexed JOIN plus 3 other changes (artifact: d19dcda55f user: drh)
14:48 • Fixed ticket [bc1aea7b72]: Incorrect result on LEFT JOIN with OR constraints and an ORDER BY clause plus 3 other changes (artifact: a9504bb4f2 user: drh)
03:04 • Fixed ticket [490a4b7235]: "WHERE 0" on the first element of a UNION causes an assertion fault plus 5 other changes (artifact: 1df98610d5 user: drh)
02:24 • New ticket [490a4b7235]. (artifact: 3edae247fc user: drh)
2013-07-08
21:13 • Fixed ticket [d805526eae]: Incorrect join result or assertion fault due to transitive constraints plus 5 other changes (artifact: 13a3400d6e user: drh)
18:02 • New ticket [d805526eae]. (artifact: d1fbaa0a04 user: drh)
2013-07-01
17:27 • Fixed ticket [868145d012]: Assertion fault on double LEFT JOIN plus 5 other changes (artifact: 9030cb093a user: drh)
16:47 • New ticket [868145d012]. (artifact: 7bb99dad20 user: drh)
2013-06-27
17:40 • Fixed ticket [a589ec069e]: sqlite3_stmt_readonly() returns an incorrect value for come PRAGMAs plus 5 other changes (artifact: 8c32340d94 user: drh)
17:03 • New ticket [a589ec069e]. (artifact: 663c3f905e user: drh)
2013-06-14
13:52 • New ticket [83e9014ec2] Incorrect result from sqlite3_stmt_status with SQLITE_STMTSTATUS_FULLSCAN_STEP. (artifact: 09c2330b36 user: drh)
2013-06-04
14:56 • Ticket [5ed1772895] Incorrect ORDER BY on an indexed JOIN status still Open with 6 other changes (artifact: 114ba533cd user: drh)
14:48 • New ticket [5ed1772895]. (artifact: 33be471b72 user: drh)
2013-06-03
14:03 • Ticket [bc1aea7b72] Incorrect result on LEFT JOIN with OR constraints and an ORDER BY clause status still Open with 6 other changes (artifact: f0946db7ce user: drh)
13:23 • New ticket [bc1aea7b72]. (artifact: a92b978f85 user: drh)
2013-05-15
18:21 • Fixed ticket [e636a050b7]: Database corruption in shared cache mode plus 5 other changes (artifact: 79a6dca60f user: drh)
17:58 • Fixed ticket [0fc59f908b]: Missing COLLATE function does not result in an error plus 5 other changes (artifact: d9a6a8fcc0 user: drh)
13:23 • New ticket [0fc59f908b]. (artifact: a88ea24fa0 user: drh)
2013-05-13
18:00 • New ticket [e636a050b7] Database corruption in shared cache mode. (artifact: 2f2df1f319 user: drh)
2013-05-09
14:20 • Fixed ticket [f2369304e4]: Incorrect results when OR is used in the ON clause of a LEFT JOIN plus 5 other changes (artifact: 4712b561c4 user: drh)
13:38 • New ticket [f2369304e4]. (artifact: 979fa9ab39 user: drh)
2013-05-08
16:58 • Fixed ticket [6709574d2a]: COLLATE clause in ORDER BY causes incorrect EXCEPT plus 5 other changes (artifact: 63278902af user: drh)
2013-05-06
21:06 • Add attachment sk2.sql to ticket [4eb3a0bd32] (artifact: 6398d0f515 user: drh)
21:05 • New ticket [4eb3a0bd32] Performance regression in Skrooge. (artifact: 2fcf41f20b user: drh)
20:29 • Fixed ticket [2f96536e7f]: .tables output is not redirected into .output file plus 5 other changes (artifact: d54d7c3d55 user: drh)
18:49 • Fixed ticket [5eaa61ea18]: sigbus on disk ful in WAL mode plus 3 other changes (artifact: 77a9876b11 user: drh)
15:21 • New ticket [6709574d2a] COLLATE clause in ORDER BY causes incorrect EXCEPT. (artifact: 5bbf9ac188 user: drh)
13:45 • Ticket [0eb70d77cb] Invalid pointer passed to the authorizer callback status still Fixed with 3 other changes (artifact: ee1c6f48da user: drh)
13:23 • Fixed ticket [0eb70d77cb]. (artifact: 7fe0235d50 user: drh)
13:03 • New ticket [0eb70d77cb]. (artifact: 6ec5e901a4 user: drh)
2013-05-02
14:36 • New ticket [2f96536e7f] .tables output is not redirected into .output file. (artifact: 23dd941dfd user: anonymous)
2013-04-30
14:26 • Fixed ticket [19b44e3575]: sqlite3_bind_text inconsistent with NULL pointers, zero length etc plus 4 other changes (artifact: f0937c04cb user: drh)
14:07 • Fixed ticket [28c6e830f2]: Segfault while parsing/compiling an SQL statement plus 5 other changes (artifact: 6702b47b1d user: drh)
13:26 • New ticket [28c6e830f2]. (artifact: a81f8ab6a7 user: drh)
2013-04-22
22:29 • Fixed ticket [ba82a4a41e]: Query optimizer removes ORDER BY when it is needed plus 3 other changes (artifact: c1b7e29174 user: drh)
18:26 • Ticket [ba82a4a41e]: 6 changes (artifact: 294e00a493 user: drh)
18:16 • New ticket [ba82a4a41e]. (artifact: 393965027d user: drh)
2013-04-18
02:55 • Fixed ticket [f69b96e307]: Over-aggressive optimization of ORDER BY using a virtual table with IN operator plus 5 other changes (artifact: d6b7fea672 user: drh)
2013-04-17
23:38 • New ticket [f69b96e307]. (artifact: 2788bf1656 user: drh)
2013-04-14
23:51 • Fixed ticket [2500cdb9be]: COLLATE in ORDER BY clause breaks name resolution plus 4 other changes (artifact: 14e81f52fe user: drh)
2013-04-12
16:44 • New ticket [2500cdb9be]. (artifact: 616b041cd2 user: drh)
12:09 • Fixed ticket [7ff3120e4f]: Recovery race condition leads to database corruption on Windows plus 4 other changes (artifact: b25ed2ca14 user: drh)
12:02 • Ticket [7ff3120e4f]: 3 changes (artifact: 93a2d8316c user: drh)
2013-04-11
18:34 • Ticket [7ff3120e4f]: 6 changes (artifact: 55e0777128 user: drh)
18:04 • New ticket [7ff3120e4f]. (artifact: cc324cdb97 user: drh)
2013-03-27
21:12 • Fixed ticket [38b1ae018f]: Assertion fault on valid FTS4 query plus 5 other changes (artifact: 48cf60d576 user: drh)
21:11 • Fixed ticket [6bfb98dfc0]: False report of database corruption on an INSERT plus 5 other changes (artifact: f41e9efab1 user: drh)
17:20 • Fixed ticket [a179fe7465]: Incorrect output order on a join with an ORDER BY plus 3 other changes (artifact: 16d5b73121 user: drh)
14:28 • Ticket [a179fe7465]: 3 changes (artifact: 82a0e96f59 user: drh)
11:39 • Ticket [a179fe7465]: 7 changes (artifact: 41623a1ae4 user: drh)
02:54 • New ticket [6bfb98dfc0] False report of database corruption on an INSERT. (artifact: a6e343197b user: drh)
2013-03-26
15:36 • New ticket [a179fe7465] incorrect result in query with group by. (artifact: 8e3e9bb553 user: anonymous)
2013-03-24
20:45 • New ticket [38b1ae018f] Assertion fault on valid FTS4 query. (artifact: cb5486703f user: drh)
2013-03-20
12:45 • Fixed ticket [689137afb6]: Casting UTF16 to numeric types fails plus 6 other changes (artifact: f98188eb13 user: drh)
11:08 • New ticket [689137afb6]. (artifact: 4c66baf315 user: drh)
2013-03-13
00:13 • Fixed ticket [4dd95f6943]: Inverted result order with ORDER BY DESC and a DESC index. plus 5 other changes (artifact: 3016179dba user: drh)
2013-03-12
17:34 • New ticket [4dd95f6943]. (artifact: 8f4098676a user: drh)
2013-03-06
01:55 • Fixed ticket [fc7bd6358f]: Incorrect query result in a 3-way join due to affinity issues plus 4 other changes (artifact: 921b0574dc user: drh)
2013-03-05
19:20 • New ticket [fc7bd6358f]. (artifact: 13ecf3d1a7 user: drh)
2013-03-01
17:43 • Fixed ticket [7a31705a7e]: Name resolution fails when table name is a prefix of another table plus 4 other changes (artifact: 8184e2b889 user: drh)
2013-02-26
12:31 • New ticket [7a31705a7e]. (artifact: 542dd814e3 user: drh)
2013-02-20
21:49 • Ticket [25e09aa2ab] Lint mode status still Open with 3 other changes (artifact: c778ea40be user: anonymous)
2013-02-11
01:37 • Ticket [25e09aa2ab]: 6 changes (artifact: fadb9ad0f7 user: anonymous)
2013-01-29
23:55 • Fixed ticket [db4d96798d]: LIMIT does not work with nested views containing UNION ALL plus 3 other changes (artifact: fb99c7de2d user: drh)
23:32 • Ticket [db4d96798d]: 6 changes (artifact: 85bbb79f0d user: drh)
2013-01-28
19:34 • New ticket [db4d96798d]. (artifact: 8c39a3c9ee user: drh)
19:00 • Fixed ticket [d58ccbb3f1]: Segmentation fault on a valid query with "union" plus 6 other changes (artifact: df11176738 user: drh)
10:28 • New ticket [d58ccbb3f1]. (artifact: ff39df430c user: anonymous)
2013-01-15
15:28 • Closed ticket [7c6a01c6c5]: Multi-column index is not used with IN operator plus 6 other changes (artifact: cf1aa36725 user: dan)
08:18 • New ticket [7c6a01c6c5]. (artifact: 4be6b8e81e user: anonymous)
2013-01-09
14:43 • Fixed ticket [c997b11c4d]: ORDER BY clause ignored in 3-way join query plus 3 other changes (artifact: 6645b72352 user: drh)
09:39 • Ticket [c997b11c4d]: 3 changes (artifact: 45820a5886 user: dan)
09:39 • New ticket [c997b11c4d]. (artifact: 55771e4554 user: dan)
2013-01-03
15:27 • New ticket [beba9cae63] Assertion fault on a valid query. (artifact: abccd059f8 user: drh)
2013-01-02
21:16 • Ticket [5ac9b497de] Some issues with aliases, fully qualified identifiers, and * status still Open with 3 other changes (artifact: 59d155c926 user: anonymous)
12:50 • Ticket [5ac9b497de]: 7 changes (artifact: a2adb458a0 user: drh)
12:49 • Add attachment bugselect_test.sqlite to ticket [5ac9b497de] (artifact: 0a4eca845a user: nobody)
12:48 • Delete attachment "bugselect_test.sqlite" from ticket [5ac9b497de] (artifact: e72a5c8bd5 user: nobody)
12:47 • Ticket [5ac9b497de] Some issues with aliases, fully qualified identifiers, and * status still Open with 6 other changes (artifact: 98d95015ce user: anonymous)
04:46 • Ticket [6c266900a2] shell: The column mode (and width option) does not manage correctly UTF-8 status still Open with 5 other changes (artifact: 0d16918047 user: anonymous)
04:43 • Add attachment bug536662_test.result to ticket [6c266900a2] (artifact: 325f5c5653 user: nobody)
04:43 • Add attachment bug536662_test.sqlite to ticket [6c266900a2] (artifact: e20361ae6d user: nobody)
04:42 • Add attachment bugselect_test.sqlite to ticket [5ac9b497de] (artifact: 1830de9ab8 user: nobody)
04:34 • New ticket [5ac9b497de] Some issues with aliases, fully qualified identifiers, and *. (artifact: a020367881 user: anonymous)
00:08 • New ticket [6c266900a2] shell: The column mode (and width option) does not manage correctly UTF-8. (artifact: 3d7fc0e8a4 user: anonymous)
2012-12-31
17:21 • Ticket [030632f55b] make sqlite2 detect sqlite3 status still Open with 7 other changes (artifact: f996ecde62 user: anonymous)
17:12 • New ticket [030632f55b]. (artifact: 98b3dd45d4 user: anonymous)
2012-12-23
22:00 • Add attachment control_c.patch to ticket [1c67bd6ce9] (artifact: 3334cf6176 user: anonymous)
2012-12-21
16:16 • Closed ticket [0cfd98ee20]: Potential corruption of backup db when backing up a db last written by sqlite<3.7.0 plus 5 other changes (artifact: 82635d7daf user: dan)
16:01 • New ticket [0cfd98ee20]. (artifact: d23e911442 user: dan)
2012-12-19
16:58 • Fixed ticket [a7b7803e8d]: crash when filtering twice by same predicate using aliases plus 3 other changes (artifact: 947659403f user: drh)
15:17 • Fixed ticket [71e333e7d2]: COLLATE operator inside CHECK constraint fails in shared-cache mode plus 5 other changes (artifact: 5335c94798 user: drh)
15:16 • Ticket [a7b7803e8d] crash when filtering twice by same predicate using aliases status still Open with 4 other changes (artifact: 2cbd563d28 user: drh)
15:13 • Ticket [a7b7803e8d]: 6 changes (artifact: bef65fd55a user: anonymous)
15:01 • New ticket [a7b7803e8d]. (artifact: 275fd25264 user: anonymous)
12:46 • Closed ticket [dec444cd68]: rowid not usable in complex queries plus 6 other changes (artifact: 13db8a68b5 user: drh)
2012-12-18
20:41 • New ticket [dec444cd68]. (artifact: ae927fc3d5 user: anonymous)
14:04 • Closed ticket [df678d738a]: Cache corruption following IO error on systems supporting atomic-write plus 4 other changes (artifact: 500e2da731 user: dan)
11:57 • New ticket [df678d738a]. (artifact: b8af6f0928 user: dan)
2012-12-15
14:33 • Ticket [5eaa61ea18] sigbus on disk ful in WAL mode status still Open with 5 other changes (artifact: e816a1c27e user: drh)
11:09 • Open ticket [5eaa61ea18]. (artifact: 48a7ec3edb user: anonymous)
2012-12-07
19:41 • Closed ticket [d6b36be38a]: Sub-select in LIMIT clause may access db without locks. plus 1 other change (artifact: c347a2a0c7 user: dan)
19:02 • Ticket [d6b36be38a]: 1 change (artifact: af09caff61 user: dan)
18:57 • Ticket [d6b36be38a]: 3 changes (artifact: 04a65d27ea user: dan)
18:57 • New ticket [d6b36be38a]. (artifact: a12c51a20c user: dan)
2012-12-06
19:42 • Closed ticket [ae3c5670b6]: Bug caused by factoring of constants in trigger programs plus 1 other change (artifact: 559270931d user: dan)
19:42 • Ticket [ae3c5670b6]: 3 changes (artifact: 54f3173e8b user: dan)
18:48 • New ticket [ae3c5670b6]. (artifact: 61605c7d5f user: dan)
15:05 • New ticket [71e333e7d2] COLLATE operator inside CHECK constraint fails in shared-cache mode. (artifact: 7f899f32e4 user: drh)
2012-11-29
14:27 • Closed ticket [f46ca03b55]: The order of two operations in asyncLock() plus 6 other changes (artifact: d357b7346f user: drh)
08:31 • New ticket [f46ca03b55]. (artifact: e93ae3ff2a user: anonymous)
2012-11-21
15:52 • New ticket [01b785eefa] sqlite3.exe - wrong parameter charset. (artifact: ea4253eda4 user: anonymous)
2012-11-13
12:14 • Ticket [5eaa61ea18] sigbus on disk ful in WAL mode status still Fixed with 1 other change (artifact: b463520aff user: anonymous)
11:16 • Fixed ticket [5eaa61ea18]. (artifact: 9f45881f11 user: drh)
10:34 • Ticket [5eaa61ea18]: 1 change (artifact: f3ef76a5f9 user: drh)
09:28 • Ticket [5eaa61ea18]: 1 change (artifact: 428b056fa1 user: drh)
09:02 • Ticket [5eaa61ea18]: 1 change (artifact: ddb329113a user: anonymous)
01:28 • Ticket [5eaa61ea18]: 3 changes (artifact: d0be4458c5 user: drh)
01:24 • Ticket [5eaa61ea18]: 3 changes (artifact: ba0773221d user: drh)
2012-11-12
14:45 • New ticket [5eaa61ea18]. (artifact: a1fe498cdb user: anonymous)
2012-11-02
23:55 • Fixed ticket [bfbf38e5e9]: Segfault on a nested join plus 1 other change (artifact: 4bea13ecb1 user: drh)
23:43 • Fixed ticket [bfbf38e5e9]. (artifact: 172ff69b71 user: drh)
15:14 • Ticket [bfbf38e5e9]: 1 change (artifact: cabcf4a364 user: drh)
14:43 • Ticket [bfbf38e5e9]: 1 change (artifact: 62ed131e60 user: drh)
13:51 • Ticket [bfbf38e5e9]: 1 change (artifact: 06f5859993 user: drh)
12:58 • Ticket [bfbf38e5e9]: 3 changes (artifact: 23d9feb903 user: drh)
12:30 • New ticket [bfbf38e5e9]. (artifact: 20f0d40ca3 user: drh)
2012-10-04
19:41 • Fixed ticket [d02e1406a5]: LEFT JOIN with an OR in the ON clause causes segfault plus 2 other changes (artifact: 4a446dbee2 user: drh)
15:26 • New ticket [d02e1406a5]. (artifact: 28fef2d348 user: drh)
2012-05-21
21:26 • Fixed ticket [c2ad16f997]: Segfault on query involving deeply nested aggregate views plus 1 other change (artifact: 4ffb3f4ece user: drh)
17:14 • Ticket [c2ad16f997]: 1 change (artifact: b8ae6879bb user: drh)
16:54 • Ticket [c2ad16f997]: 1 change (artifact: ef46bef5de user: drh)
04:31 • Ticket [c2ad16f997]: 3 changes (artifact: 956d8d764d user: mistachkin)
03:24 • Add attachment c2ad16f99-bug.txt to ticket [c2ad16f997] (artifact: a5868656b0 user: drh)
03:21 • New ticket [c2ad16f997] Segfault on query involving deeply nested aggregate views. (artifact: 24e75e76ae user: drh)
03:15 • Fixed ticket [cfe84e8683]: The ".schema" command outputs nested VIEWS in the wrong order plus 2 other changes (artifact: 9e6d500ef7 user: drh)
03:01 • New ticket [cfe84e8683]. (artifact: 22b995250c user: drh)
2012-05-10
17:59 • Closed ticket [bdc6bbbb38]: Problem with FTS aux. functions when used with OR queries with enhanced query syntax enabled plus 1 other change (artifact: 3717f17147 user: dan)
17:58 • Ticket [bdc6bbbb38]: 1 change (artifact: f8aa38083b user: dan)
17:21 • Ticket [bdc6bbbb38]: 1 change (artifact: 1e6e7e61d0 user: dan)
17:21 • Ticket [bdc6bbbb38]: 3 changes (artifact: 3b1a498a87 user: dan)
17:19 • New ticket [bdc6bbbb38]. (artifact: c5f0ea023c user: dan)
2012-04-20
17:44 • Closed ticket [385a5b56b9]: A DISTINCT SELECT optimized using a UNIQUE index may allow duplicate NULL values. plus 3 other changes (artifact: 40ce6655a4 user: dan)
17:43 • Ticket [2a5629202f] Malfunctioning interaction between a multi-term ORDER BY clause and UNIQUE index containing NULL values status still Closed with 1 other change (artifact: 1d908f1b6a user: dan)
17:42 • Closed ticket [2a5629202f]. (artifact: 4323f4f0e2 user: dan)
17:41 • Ticket [2a5629202f]: 1 change (artifact: be0c3a7263 user: dan)
17:27 • Ticket [385a5b56b9] A DISTINCT SELECT optimized using a UNIQUE index may allow duplicate NULL values. status still Open with 1 other change (artifact: 2a938c789f user: dan)
16:53 • Ticket [385a5b56b9]: 1 change (artifact: f67e8bb0be user: dan)
16:03 • Ticket [385a5b56b9]: 1 change (artifact: 9955b5ab1e user: dan)
16:03 • Ticket [385a5b56b9]: 1 change (artifact: fa0c01c6b9 user: dan)
16:03 • Ticket [385a5b56b9]: 3 changes (artifact: d9f8fa19b0 user: dan)
16:02 • New ticket [385a5b56b9]. (artifact: 29daf903c1 user: dan)
14:58 • Ticket [2a5629202f] Malfunctioning interaction between a multi-term ORDER BY clause and UNIQUE index containing NULL values status still Open with 1 other change (artifact: d85ca2b45b user: dan)
14:58 • Ticket [2a5629202f]: 1 change (artifact: 50b1f4f6ca user: dan)
14:54 • Ticket [2a5629202f]: 3 changes (artifact: ac7b9f6671 user: dan)
14:54 • New ticket [2a5629202f]. (artifact: c5983115b9 user: dan)
2012-03-31
18:02 • Fixed ticket [27ca74af3c]: Nested SAVEPOINT release causes pending query abort plus 1 other change (artifact: e578202f60 user: drh)
17:15 • Ticket [27ca74af3c]: 3 changes (artifact: d44befae27 user: drh)
17:12 • New ticket [27ca74af3c]. (artifact: 806371a475 user: drh)
2012-03-20
01:35 • New ticket [25e09aa2ab] Lint mode. (artifact: c95b7bed7e user: rogerb)
2012-03-13
14:10 • Ticket [b7c8682cc1] Incorrect result from LEFT JOIN with OR in the WHERE clause status still Fixed with 1 other change (artifact: b6174c4afe user: drh)
01:15 • Fixed ticket [b7c8682cc1]. (artifact: 6361695945 user: drh)
2012-03-09
16:58 • New ticket [b7c8682cc1]. (artifact: 7aedf2b61a user: drh)
2012-03-07
19:40 • New ticket [f48b7da35c] Loadable extensions documentation bitrot. (artifact: 2cf4f9a24c user: rogerb)
2012-03-03
01:44 • Fixed ticket [3557ad65a0]: Incorrect DISTINCT on an indexed query with IN plus 1 other change (artifact: f0ee35461d user: drh)
01:35 • Ticket [3557ad65a0]: 3 changes (artifact: bf8e83bac7 user: drh)
00:17 • New ticket [3557ad65a0]. (artifact: 2c17c043c8 user: drh)
2012-02-03
19:59 • New ticket [72b01a982a] Per page/region checksums. (artifact: e51832f73d user: rogerb)
2012-02-01
01:14 • Fixed ticket [ae6794effd]: ALTER TABLE RENAME fails for triggers that use the table name with a different case plus 2 other changes (artifact: 9bd3e93a33 user: drh)
00:20 • New ticket [ae6794effd]. (artifact: 0694b46228 user: drh)
2012-01-30
18:41 • Fixed ticket [5f41597f7c]: sqlite3_uri_boolean defaults to true, documented as false, is a mess plus 2 other changes (artifact: b4e853973c user: drh)
2012-01-29
05:28 • New ticket [5f41597f7c]. (artifact: 1ac8d940b3 user: rogerb)
2012-01-28
21:09 • Fixed ticket [232637c465]: Dump code fails with 1002 columns plus 2 other changes (artifact: 366e3001fd user: drh)
21:09 • Fixed ticket [c04a8b8a4f]: Trailing comments not stripped from views, invalid dumps plus 2 other changes (artifact: 4d39035731 user: drh)
19:14 • New ticket [232637c465] Dump code fails with 1002 columns. (artifact: 7a83bc5181 user: rogerb)
2012-01-27
18:15 • New ticket [c04a8b8a4f] Trailing comments not stripped from views, invalid dumps. (artifact: a35724eba5 user: rogerb)
2012-01-25
19:04 • New ticket [edb497982c] FTS n-character prefix query returns incorrect results when using an n+1 character prefix index.. (artifact: 4cd1b8659f user: dan)
2012-01-14
15:35 • Fixed ticket [ff5be73dee]: Database corruption following power-loss in WAL mode plus 1 other change (artifact: 34016eef64 user: drh)
15:34 • Fixed ticket [a1fa75cbdd]: Database corruption following unlucky application crash in WAL mode with "PRAGMA journal_size_limit" plus 1 other change (artifact: bc95ad9349 user: drh)
2011-12-22
02:11 • Fixed ticket [ac0ff496b7]: Database corruption due to integer overflow with SQLITE_DIRECT_OVERFLOW_READ plus 2 other changes (artifact: 60b704870c user: drh)
2011-12-21
16:25 • New ticket [ac0ff496b7]. (artifact: 09f179ff4c user: drh)
2011-12-17
15:02 • Ticket [ff5be73dee] Database corruption following power-loss in WAL mode status still Open with 1 other change (artifact: d8c3481867 user: drh)
15:00 • Ticket [ff5be73dee]: 4 changes (artifact: adfc5396d1 user: drh)
2011-12-16
15:17 • New ticket [ff5be73dee]. (artifact: 9bc20a01df user: drh)
13:28 • Ticket [a1fa75cbdd] Database corruption following unlucky application crash in WAL mode with "PRAGMA journal_size_limit" status still Open with 3 other changes (artifact: 20ce49f1d9 user: dan)
13:22 • New ticket [a1fa75cbdd]. (artifact: 09de71310e user: dan)
2011-12-10
13:53 • Fixed ticket [7bbfb7d442]: Problem with using stale auto-indexes created on materialized sub-selects within trigger programs plus 2 other changes (artifact: 10dbc7dd9e user: drh)
2011-12-09
09:49 • New ticket [7bbfb7d442]. (artifact: bc4801fe7d user: dan)
2011-12-06
14:02 • Fixed ticket [3a77c9714e]: Malfunction involving temporary registers and sub-queries implemented by vdbe sub-routines. plus 2 other changes (artifact: 35e5e8495b user: drh)
13:21 • New ticket [3a77c9714e]. (artifact: 19436b594e user: dan)
2011-11-04
00:24 • Fixed ticket [676bc02b87]: Incorrect xfer optimization with INTERGER PRIMARY KEY ON CONFLICT REPLACE plus 2 other changes (artifact: 5d216ae9a8 user: drh)
00:09 • New ticket [676bc02b87]. (artifact: 8c3f44b3dd user: drh)
2011-10-31
18:46 • Closed ticket [8290242b2a]: ALTER TABLE RENAME fails if the database encoding is not UTF8 (artifact: 10e1dd3e36 user: drh)
18:46 • Closed ticket [3338b3fa19]: ambiguous column name when using multiple JOIN USING clauses and WHERE clause (artifact: 38e7c99010 user: drh)
18:45 • Closed ticket [f1c2a689c6]: configure script ignores ``--with-tcl'' option when tclsh8.4 is installed. (artifact: 54d52170b3 user: drh)
18:44 • Closed ticket [92bd6eaf04]: Suggestion to revise clean rule in main.mk. (artifact: 20aa3c3b78 user: drh)
18:44 • Closed ticket [57c971fc74]: Some user defined string functions do not operate correctly on strings with embedded nuls (artifact: 6cae2ae2a4 user: drh)
2011-10-29
11:54 • Ticket [48f299634a] Crash in SAVEPOINT within a transaction that writes to then drops an FTS table status still Closed with 1 other change (artifact: 0a2d10e31d user: dan)
11:46 • Closed ticket [48f299634a]. (artifact: 0d0b3bfb36 user: dan)
11:36 • Ticket [48f299634a]: 3 changes (artifact: a6be4fd073 user: dan)
11:31 • New ticket [48f299634a]. (artifact: e054b682d1 user: dan)
2011-10-18
22:08 • Fixed ticket [8290242b2a]: ALTER TABLE RENAME fails if the database encoding is not UTF8 plus 2 other changes (artifact: 10056736a5 user: drh)
21:31 • New ticket [8290242b2a]. (artifact: 29bc8a6fe5 user: drh)
18:10 • Fixed ticket [3338b3fa19]: ambiguous column name when using multiple JOIN USING clauses and WHERE clause plus 1 other change (artifact: f362734922 user: drh)
2011-10-13
18:33 • Fixed ticket [f1c2a689c6]: configure script ignores ``--with-tcl'' option when tclsh8.4 is installed. plus 3 other changes (artifact: b6fcb36707 user: drh)
18:26 • Closed ticket [d214d7b114]: FTS3 virtual table fails when names are quoted plus 3 other changes (artifact: db537fd833 user: drh)
18:25 • Closed ticket [9861b74ab9]: Fts3 offsets() function may report SQLITE_CORRUPT with empty string. plus 3 other changes (artifact: ccd01a1dc5 user: drh)
18:08 • Fixed ticket [92bd6eaf04]: Suggestion to revise clean rule in main.mk. plus 1 other change (artifact: 3fa6907f18 user: drh)
18:01 • Fixed ticket [57c971fc74]: Some user defined string functions do not operate correctly on strings with embedded nuls plus 3 other changes (artifact: b5983b3d0b user: drh)
17:34 • Ticket [9fd058691b] Problem with updating an FTS table that contains a single row status still Closed with 1 other change (artifact: 6796c36a2b user: dan)
17:34 • Closed ticket [9fd058691b]. (artifact: 2cdcb57615 user: dan)
17:33 • Ticket [9fd058691b]: 1 change (artifact: 110c165872 user: dan)
17:33 • Ticket [9fd058691b]: 4 changes (artifact: 565c4990d2 user: dan)
17:06 • New ticket [9fd058691b]. (artifact: 785ed2b12b user: dan)
16:32 • Closed ticket [4c9223e34e]: Vacuum fails within transaction but also rolls it back plus 2 other changes (artifact: a34156cba0 user: drh)
16:07 • Closed ticket [ab7498f2f6]: 54 seconds to sort two(2) rows only when LIKE operator is used in WHERE clause and the query also contains an order-by clause plus 1 other change (artifact: e275e42080 user: drh)
16:05 • Ticket [3671265894] No error reporting on file open failure status still Open with 3 other changes (artifact: 79cac66ccf user: drh)
16:02 • Fixed ticket [92af7da36b]: shell won't import large files plus 2 other changes (artifact: 046edba749 user: drh)
15:56 • Fixed ticket [0c80ff9f5a]: Quickstart missing include of stdlib.h plus 2 other changes (artifact: 79a5d8d6c3 user: drh)
15:38 • Fixed ticket [fa7bf5ec94]: String literal case confusion in aggregate query plus 3 other changes (artifact: 6c4389fa7f user: drh)
15:16 • New ticket [fa7bf5ec94]. (artifact: 02e4c841ea user: drh)
14:46 • Closed ticket [b2d64a52a0]: pkgIndex.tcl is being deleted by 'make clean' but it is not created by 'make' plus 2 other changes (artifact: bc412bc88c user: drh)
14:44 • Closed ticket [3338b3fa19]: ambiguous column name when using multiple JOIN USING clauses and WHERE clause plus 2 other changes (artifact: 2040c0e591 user: drh)
14:23 • Closed ticket [6e1086fb2c]: "create table as select" and "pragma *_column_names" plus 1 other change (artifact: f0f9668b1f user: drh)
14:13 • Ticket [af3450b763] Recursive virtual tables status still Open with 3 other changes (artifact: d9fd246364 user: drh)
14:12 • Fixed ticket [991789d9f3]: ext/fts? code uses tolower() when parsing tokens, which is problematic when using certain locales, such as tr_TR.UTF-8. plus 1 other change (artifact: 026d5b3671 user: drh)
14:05 • Fixed ticket [35c54c8749]: Some os win symbols should be declared static plus 2 other changes (artifact: 1182526ae4 user: drh)
13:53 • Fixed ticket [aa92c76cd4]: Problem with GROUP BY and the distinction between real and integer values plus 2 other changes (artifact: 9a2eee3d73 user: drh)
13:52 • Closed ticket [43d2aa29b9]: H13015 needs to be completed plus 2 other changes (artifact: f32fc486b7 user: drh)
13:52 • Closed ticket [4776dee07a]: Documentation and code about registering functions plus 1 other change (artifact: ca1846dafa user: drh)
13:35 • Closed ticket [ac55d88a33]: H10336 is no longer applicable plus 2 other changes (artifact: ed1c371593 user: drh)
13:34 • Fixed ticket [2466653295]: Various dump issues plus 1 other change (artifact: 3fcbbe87e0 user: drh)
13:25 • Fixed ticket [517e206abd]: Fix sqlite3_analyzer plus 2 other changes (artifact: de2e5dae9b user: drh)
13:24 • Closed ticket [5483170346]: H35230 & H35240 refer incorrectly to H35230 - should be H35220 plus 2 other changes (artifact: c5cb2722ef user: drh)
13:23 • Closed ticket [cbd054fa6b]: "out of memory" in ANALYZE with SQLITE_ENABLE_STAT2 (artifact: c7d03710e2 user: drh)
13:22 • Fixed ticket [9d68c88313]: Database corruption following OOM fault plus 2 other changes (artifact: a5cd168d0f user: drh)
13:21 • Fixed ticket [26ff0c82d1]: Incorrect result when using unnamed "?" bindings plus 2 other changes (artifact: f9fda6f1b1 user: drh)
13:20 • Ticket [c25aab7e7e] The ".import" command does not parse CSV correctly. status still Open with 2 other changes (artifact: 8a44239e2e user: drh)
13:19 • Fixed ticket [fc62af4523]: Executing "PRAGMA journal_mode" may delete journal file while it is in use. plus 1 other change (artifact: fe5973ee04 user: drh)
13:18 • Ticket [f817a45752] CantOpen doesn't include name of file that can't be opened status still Open with 3 other changes (artifact: 6864a9952e user: drh)
13:16 • Fixed ticket [54844eea3f]: Incorrect caching of sub-query results in the FROM clause of a scalar sub-query. plus 1 other change (artifact: 3894b5029f user: drh)
13:15 • Fixed ticket [e59bdf6116]: Possible database corruption following EINTR on unix plus 2 other changes (artifact: 5384614f2c user: drh)
13:13 • Fixed ticket [af95b8c609]: Vacuuming a WAL database resets the file header read and write versions to 1. plus 2 other changes (artifact: d2b24c044c user: drh)
00:42 • Fixed ticket [ee19e690ec]: If shell is interrupted while dumping it still produces commit (and invalid dump) plus 2 other changes (artifact: 607efff658 user: drh)
00:11 • Fixed ticket [7d32c69b50]: sqlite3LoadExtension truncates file names plus 2 other changes (artifact: d69605cf3a user: drh)
2011-10-12
23:50 • Fixed ticket [20f9d4fbbf]: sqlite3_overload_function ignores errors plus 2 other changes (artifact: 16e6acf2cc user: drh)
23:14 • Fixed ticket [0b803bff85]: Return (error code) of xCurrentTime is always ignored plus 2 other changes (artifact: 4120d6b5da user: drh)
2011-09-30
12:19 • Closed ticket [c48d99d690]: Crash in "INSERT INTO ... SELECT" when "PRAGMA count_changes=1" is configured plus 2 other changes (artifact: 9fbd73a1b8 user: dan)
12:19 • Ticket [c48d99d690]: 1 change (artifact: 5d611714cd user: dan)
12:02 • Ticket [c48d99d690]: 3 changes (artifact: ed761682cd user: dan)
11:42 • New ticket [c48d99d690]. (artifact: 64346b7194 user: dan)
2011-09-28
01:11 • Fixed ticket [d1d84037b9]: import doesn't work on attached databases due to unnecessary quoting plus 2 other changes (artifact: 31182e4407 user: drh)
2011-09-27
21:44 • Ticket [d1d84037b9]: 3 changes (artifact: e5821bc9e8 user: rogerb)
21:43 • New ticket [d1d84037b9]. (artifact: 0f51686d0b user: rogerb)
2011-09-26
23:07 • New ticket [57c971fc74] Some user defined string functions do not operate correctly on strings with embedded nuls. (artifact: e916c2f4a1 user: rogerb)
2011-09-19
20:43 • Ticket [bd484a090c] Date/time functions do not detect failure of localtime_r() status still Closed with 1 other change (artifact: d9993c4fc6 user: rogerb)
17:38 • Closed ticket [1a1308d253]: Nested correlated subquery fails when indices used (artifact: 83c8b6910b user: drh)
17:37 • Closed ticket [002caede89]: LEFT JOIN with OR terms in WHERE clause causes assertion fault (artifact: 3576c0c23a user: drh)
17:37 • Closed ticket [d635236375]: Assertion fault on a join with a repeated column (artifact: 32d3d34282 user: drh)
17:37 • Closed ticket [6c14288a47]: Virtual tables do not handle IS NOT NULL correctly (artifact: 62ce185b15 user: drh)
17:37 • Closed ticket [d6ddba6706]: Parser accepts invalid CREATE TRIGGER syntax (artifact: df4af5ed21 user: drh)
17:37 • Closed ticket [25ee812710]: PRAGMA case_sensitive_like=1 fails (artifact: dcb466d44a user: drh)
17:37 • Closed ticket [91e2e8ba6f]: Automatic indices cause undesirable type conversions (artifact: 7e15628660 user: drh)
17:36 • Closed ticket [bd484a090c]: Date/time functions do not detect failure of localtime_r() (artifact: d1ee170d8c user: drh)
2011-09-16
19:04 • Fixed ticket [1a1308d253]: Nested correlated subquery fails when indices used plus 2 other changes (artifact: 5264e14339 user: drh)
18:17 • Fixed ticket [002caede89]: LEFT JOIN with OR terms in WHERE clause causes assertion fault plus 2 other changes (artifact: a25beefa4e user: drh)
16:20 • New ticket [1a1308d253] Nested correlated subquery fails when indices used. (artifact: f68bc318a5 user: drh)
2011-09-15
18:54 • New ticket [002caede89] LEFT JOIN with OR terms in WHERE clause causes assertion fault. (artifact: 80aac1120a user: drh)
2011-09-14
11:16 • Closed ticket [56be976859]: Buffer overrun in FTS prefix queries plus 2 other changes (artifact: e4256312a2 user: dan)
11:13 • Ticket [56be976859]: 3 changes (artifact: bf07d2651b user: dan)
2011-09-13
18:48 • New ticket [56be976859]. (artifact: 424c0064a5 user: dan)
2011-08-23
10:56 • New ticket [af95b8c609] Vacuuming a WAL database resets the file header read and write versions to 1.. (artifact: 57bdcf3f79 user: dan)
2011-08-22
17:49 • Ticket [b1d3a2e531] Erroneous FK constraint failure when dropping table. status still Closed with 1 other change (artifact: 796ec9784d user: drh)
10:03 • Closed ticket [b1d3a2e531]. (artifact: 8bc5f804eb user: dan)
10:03 • Ticket [b1d3a2e531]: 1 change (artifact: 643bfe8566 user: dan)
09:55 • Ticket [b1d3a2e531]: 3 changes (artifact: 1a01bb2255 user: dan)
09:55 • Closed ticket [b1d3a2e531]. (artifact: e31b399b6a user: dan)
09:37 • New ticket [b1d3a2e531]. (artifact: 6d88e323ce user: dan)
2011-08-19
14:03 • New ticket [e59bdf6116] Possible database corruption following EINTR on unix. (artifact: 27019e2863 user: drh)
2011-08-03
16:40 • Fixed ticket [d635236375]: Assertion fault on a join with a repeated column plus 2 other changes (artifact: 852716c722 user: drh)
16:33 • New ticket [d635236375]. (artifact: 5cf0cd24c8 user: drh)
2011-08-02
01:57 • Fixed ticket [6c14288a47]: Virtual tables do not handle IS NOT NULL correctly plus 2 other changes (artifact: 037f544918 user: drh)
01:26 • New ticket [6c14288a47]. (artifact: 9bfe9ae2f7 user: drh)
2011-07-14
11:38 • Closed ticket [534aa198e1]: Build error: missing manifest.uuid file in 3.7.4 downloadable source code plus 3 other changes (artifact: e8bf2158d0 user: drh)
2011-07-13
22:32 • New ticket [534aa198e1]. (artifact: 20ebbfed84 user: anonymous)
2011-07-08
17:05 • Ticket [54844eea3f] Incorrect caching of sub-query results in the FROM clause of a scalar sub-query. status still Open with 1 other change (artifact: f512892342 user: drh)
16:00 • Ticket [54844eea3f]: 3 changes (artifact: cb377e7178 user: dan)
15:49 • New ticket [54844eea3f]. (artifact: 763a419edc user: dan)
2011-07-01
14:22 • Fixed ticket [d6ddba6706]: Parser accepts invalid CREATE TRIGGER syntax plus 2 other changes (artifact: 53a9818933 user: drh)
12:44 • New ticket [d6ddba6706]. (artifact: 817bd8a73a user: drh)
2011-06-27
17:08 • Fixed ticket [25ee812710]: PRAGMA case_sensitive_like=1 fails plus 2 other changes (artifact: 15b57cdcc5 user: drh)
2011-06-26
23:07 • New ticket [25ee812710]. (artifact: aab555b07e user: drh)
2011-06-23
16:18 • Fixed ticket [91e2e8ba6f]: Automatic indices cause undesirable type conversions plus 2 other changes (artifact: 74799351fc user: drh)
16:17 • New ticket [91e2e8ba6f]. (artifact: 43bb4571df user: drh)
2011-06-21
15:37 • Fixed ticket [bd484a090c]: Date/time functions do not detect failure of localtime_r() (artifact: 52af12214d user: drh)
12:59 • Ticket [bd484a090c]: 4 changes (artifact: d51061ca19 user: dan)
12:34 • New ticket [bd484a090c]. (artifact: bd384d354d user: drh)
2011-05-19
01:28 • Fixed ticket [2d1a5c67df]: Data loss on COMMIT in WAL mode plus 4 other changes (artifact: 98dc909fcf user: drh)
2011-05-18
22:43 • New ticket [2d1a5c67df]. (artifact: e84732d115 user: drh)
2011-04-24
23:02 • Fixed ticket [6284df89de]: INSERT INTO ... SELECT bypasses foreign key constraint checks plus 3 other changes (artifact: 04845188a4 user: drh)
21:29 • New ticket [6284df89de]. (artifact: 28fe8b2e02 user: drh)
2011-04-13
13:48 • Fixed ticket [bb3a86e890]: SQLITE_FCNTL_SIZE_HINT overflows an array plus 2 other changes (artifact: 9803459b54 user: drh)
13:22 • New ticket [bb3a86e890]. (artifact: 355cefba04 user: drh)
2011-03-30
14:54 • Fixed ticket [83ea97620b]: ANALYZE on empty tables prevents the use of indices plus 2 other changes (artifact: 045510fe3b user: drh)
13:34 • New ticket [83ea97620b]. (artifact: 9bc84d40b7 user: drh)
2011-03-19
02:04 • Fixed ticket [f7b4edece2]: sqlite3_update_hook gives incorrect table name with shared cache plus 2 other changes (artifact: 45ac238b90 user: drh)
2011-03-18
18:55 • New ticket [f7b4edece2]. (artifact: 126604a626 user: drh)
2011-02-22
05:24 • Ticket [b72787b1a7] Expiry mechanism causes incorrect collateral damage status still Fixed with 1 other change (artifact: 0994e86462 user: rogerb)
03:35 • Fixed ticket [b72787b1a7]. (artifact: cce089e183 user: drh)
2011-02-21
18:41 • Ticket [eebb8a2803] Inconsistent amalgamation zip archive file names status still Closed with 1 other change (artifact: 5bcf35674c user: rogerb)
15:36 • Closed ticket [eebb8a2803]. (artifact: 8310d6340f user: dan)
15:35 • Ticket [eebb8a2803]: 1 change (artifact: 85c4c246d7 user: dan)
2011-02-20
21:44 • Ticket [eebb8a2803]: 3 changes (artifact: 7fc11d5bad user: rogerb)
21:41 • New ticket [eebb8a2803]. (artifact: 56997c224f user: rogerb)
09:28 • New ticket [b72787b1a7] Expiry mechanism causes incorrect collateral damage. (artifact: 2db988da8a user: rogerb)
2011-02-11
20:54 • Fixed ticket [752e1646fc]: Wrong result if DISTINCT used on subquery which uses ORDER BY. plus 2 other changes (artifact: 3c1f4b42b6 user: shane)
2011-02-10
21:18 • New ticket [752e1646fc]. (artifact: bbc2da4fba user: shane)
19:24 • Fixed ticket [89b8c9ac54]: False reports of corruption after writing db with two different versions (3.7 and 3.6). plus 1 other change (artifact: 4ff25986d3 user: drh)
19:23 • Fixed ticket [77aa3b1e65]: Segfault on automatic index using unknown collating function plus 2 other changes (artifact: 9cd456497e user: drh)
17:26 • New ticket [77aa3b1e65]. (artifact: 9b5b954a39 user: drh)
2011-02-09
18:39 • Ticket [89b8c9ac54] False reports of corruption after writing db with two different versions (3.7 and 3.6). status still Open with 3 other changes (artifact: 58f6afac74 user: drh)
18:20 • Ticket [89b8c9ac54]: 2 changes (artifact: a149ec4f13 user: dan)
18:08 • New ticket [89b8c9ac54]. (artifact: c3bfe79ff1 user: dan)
2011-02-04
00:53 • Fixed ticket [9013e13dba]: ATTACH authorization fails when database name is not a literal plus 2 other changes (artifact: 6ae935d556 user: drh)
2011-02-03
15:42 • New ticket [9013e13dba]. (artifact: 967b045524 user: drh)
2011-01-27
14:33 • Fixed ticket [5d863f876e]: DB corruption following rollback-WAL-VACUUM-rollback plus 1 other change (artifact: df996354dd user: drh)
2011-01-17
18:36 • Ticket [5d863f876e]: 3 changes (artifact: 97c044e265 user: drh)
2011-01-15
16:42 • New ticket [5d863f876e]. (artifact: bb4c01f982 user: drh)
2010-12-07
15:10 • Fixed ticket [80ba201079]: Bug involving subqueries and the OR optimization plus 2 other changes (artifact: e6007e3815 user: drh)
2010-12-06
16:01 • New ticket [80ba201079]. (artifact: 4cebcddb11 user: dan)
2010-10-12
02:13 • Fixed ticket [860399cc40]: Potential memory leak in sqlite3_bind_text() plus 2 other changes (artifact: 5500258871 user: drh)
2010-10-11
19:06 • New ticket [860399cc40]. (artifact: 3b888a9049 user: drh)
18:53 • Fixed ticket [a04e42a3fc]: Memory leak in sqlite3_create_collation_v2() plus 2 other changes (artifact: 8aa0d17428 user: drh)
17:06 • New ticket [a04e42a3fc]. (artifact: b298c09f2a user: drh)
04:23 • Fixed ticket [0322cd49c0]: create_function_v2 that takes destructor plus 2 other changes (artifact: 5d3451cc26 user: rogerb)
2010-10-06
19:14 • Fixed ticket [38cb5df375]: LIMIT ignored on compound query with subqueries plus 1 other change (artifact: ed3eb2bd22 user: drh)
17:15 • Ticket [38cb5df375]: 3 changes (artifact: 9556d4b883 user: drh)
17:06 • New ticket [38cb5df375]. (artifact: 08decf09c5 user: drh)
2010-09-30
17:34 • Fixed ticket [3998683a16]: Some valid floating-point literals are not recognized. plus 2 other changes (artifact: b314a82831 user: drh)
16:26 • New ticket [3998683a16]. (artifact: 7d4b5cce32 user: drh)
14:48 • Fixed ticket [8454a207b9]: ALTER TABLE ADD COLUMN with negative DEFAULT value plus 2 other changes (artifact: 788cfd73d9 user: drh)
12:56 • New ticket [8454a207b9]. (artifact: 90b2b3d0d1 user: drh)
2010-09-28
07:21 • Fixed ticket [b351d95f9c]: Bug in "INSERT INTO ... SELECT" statements that use CASE plus 3 other changes (artifact: a657e41498 user: drh)
2010-09-27
13:41 • New ticket [b351d95f9c]. (artifact: d9aed8f7e4 user: dan)
2010-09-18
19:37 • Fixed ticket [313723c356]: Database corruption following an I/O error on xShmLock plus 2 other changes (artifact: 5dd6eebc73 user: drh)
19:34 • New ticket [313723c356]. (artifact: e8022d694d user: drh)
2010-08-23
17:08 • Fixed ticket [5e10420e8d]: Free-list corruption in incremental-vacuum mode plus 5 other changes (artifact: cfdf952b96 user: drh)
15:35 • New ticket [5e10420e8d]. (artifact: 9ae8829066 user: drh)
2010-08-13
16:50 • Closed ticket [e4b8a2ba6e]: Problem with DISTINCT in sub-queries in a FROM clause. plus 3 other changes (artifact: 20f7d054d2 user: dan)
16:19 • New ticket [e4b8a2ba6e]. (artifact: f77237eecc user: dan)
2010-08-05
03:24 • Fixed ticket [13f033c865]: Performance regression plus 2 other changes (artifact: c1ac827867 user: drh)
2010-08-04
18:43 • New ticket [13f033c865]. (artifact: 07edd854b5 user: drh)
11:40 • Ticket [51ae9cad31] Database corruption by alternating writes from 3.7.0 and 3.6.23 status still Fixed with 1 other change (artifact: 19099f9f29 user: dan)
11:39 • Fixed ticket [51ae9cad31]. (artifact: 26a33213e5 user: dan)
11:39 • Ticket [51ae9cad31]: 3 changes (artifact: 93da284aea user: dan)
11:30 • New ticket [51ae9cad31]. (artifact: 254d411d0d user: drh)
2010-08-03
13:09 • Fixed ticket [c38baa3d96]: REPLACE on a CHECK constraint does not work as advertised plus 2 other changes (artifact: 0f5aa05f8b user: drh)
12:59 • New ticket [c38baa3d96]. (artifact: 564db3d998 user: drh)
2010-08-01
22:25 • Fixed ticket [168d0f7176]: Segfault while reading database with a corrupt index plus 3 other changes (artifact: 184435bff0 user: drh)
22:25 • New ticket [168d0f7176]. (artifact: 04fbf617b5 user: drh)
2010-07-31
20:55 • Fixed ticket [ce7c133ea6]: Foreign key constraint fails when it should succeed. (artifact: 7b3f9b1433 user: drh)
06:57 • Ticket [ce7c133ea6]: 1 change (artifact: 093918391e user: anonymous)
06:49 • Ticket [ce7c133ea6]: 1 change (artifact: c23a1b20dd user: anonymous)
06:43 • Open ticket [ce7c133ea6]. (artifact: 822455e902 user: anonymous)
2010-07-30
11:37 • Fixed ticket [f3e5abed55]: Problems retrying COMMIT after SQLITE_BUSY on multi-file transaction plus 2 other changes (artifact: d07c280083 user: drh)
2010-07-29
19:02 • Add attachment tkt-f3e5abed55.test to ticket [f3e5abed55] (artifact: aee9538cdc user: dan)
18:59 • New ticket [f3e5abed55] Problems retrying COMMIT after SQLITE_BUSY on multi-file transaction. (artifact: fd92e3d40e user: dan)
10:08 • Fixed ticket [c43940c49b]: sqlite3_profile gives milliseconds (was nanoseconds in earlier releases) plus 1 other change (artifact: 057fea7330 user: drh)
04:58 • Ticket [c43940c49b]: 3 changes (artifact: 5ea7d43a0f user: rogerb)
04:54 • New ticket [c43940c49b]. (artifact: 5ad542d17f user: rogerb)
01:55 • Fixed ticket [ce7c133ea6]: Foreign key constraint fails when it should succeed. plus 1 other change (artifact: b3a12114ca user: drh)
01:55 • Ticket [ce7c133ea6]: 4 changes (artifact: 6fb11fefa6 user: drh)
2010-07-28
20:57 • New ticket [ce7c133ea6]. (artifact: 4202cdf359 user: drh)
02:53 • Fixed ticket [8011086c85]: Query planner creates unnecessary and expensive automatic index plus 2 other changes (artifact: b5dd6bce40 user: drh)
00:33 • New ticket [8011086c85]. (artifact: 333f2a707d user: drh)
2010-07-22
17:50 • Fixed ticket [4711020446]: should use collate nocase index even if column isn't declared nocase plus 1 other change (artifact: b9e1ea8ef7 user: drh)
12:34 • Fixed ticket [e090183531]: like should use index when pattern has no wildcard plus 1 other change (artifact: e78b5e5681 user: drh)
06:11 • Ticket [5e0423b058] xAccess behaviour is not documented, changed in Windows 3.7.0 status still Open with 3 other changes (artifact: 6365a76ded user: rogerb)
05:46 • New ticket [5e0423b058]. (artifact: a9b24d321c user: rogerb)
2010-07-21
22:22 • Ticket [e090183531] like should use index when pattern has no wildcard status still Open with 3 other changes (artifact: 7a237684b4 user: drh)
22:21 • Ticket [4711020446] should use collate nocase index even if column isn't declared nocase status still Open with 3 other changes (artifact: 92b593d292 user: drh)
22:06 • New ticket [4711020446]. (artifact: 8e7db3c957 user: aswift)
22:01 • New ticket [e090183531] like should use index when pattern has no wildcard. (artifact: 5484eb7b10 user: aswift)
2010-07-19
05:27 • New ticket [f817a45752] CantOpen doesn't include name of file that can't be opened. (artifact: 57c188aa57 user: rogerb)
05:00 • Closed ticket [30349e0f68]: Yet more FTS3 symbols need to be made private plus 3 other changes (artifact: d0851a8e05 user: rogerb)
2010-07-14
18:24 • Fixed ticket [80e031a00f]: Result of IN should never be NULL if the RHS is empty plus 2 other changes (artifact: db6292423d user: drh)
15:48 • New ticket [80e031a00f]. (artifact: 9ad817855e user: drh)
2010-06-26
19:03 • Closed ticket [d11f09d36e]: Cache corruption caused by ROLLBACK with synchronous=NORMAL plus 1 other change (artifact: ea8ae4aa43 user: dan)
16:30 • Ticket [d11f09d36e]: 1 change (artifact: 16a03c7557 user: dan)
16:17 • Ticket [d11f09d36e]: 3 changes (artifact: 1f6fb18eb7 user: dan)
15:40 • New ticket [d11f09d36e]. (artifact: 4fd136eab8 user: dan)
2010-06-17
13:22 • Ticket [fc62af4523] Executing "PRAGMA journal_mode" may delete journal file while it is in use. status still Open with 1 other change (artifact: 068d606ebb user: drh)
10:45 • Ticket [fc62af4523]: 1 change (artifact: deedf4616a user: dan)
10:44 • Ticket [fc62af4523]: 1 change (artifact: 5f28458129 user: dan)
09:52 • Ticket [fc62af4523]: 4 changes (artifact: c98b414755 user: dan)
09:37 • New ticket [fc62af4523]. (artifact: f0c7acf8ea user: dan)
2010-06-09
16:16 • Fixed ticket [f973c7ac31]: Incorrect affinity for indexed range constraint plus 2 other changes (artifact: 9b2cbacd90 user: drh)
15:20 • New ticket [f973c7ac31]. (artifact: def6ef2209 user: drh)
2010-05-14
19:24 • Fixed ticket [dd08e5a988]: Foreign key constraint fails to prevent consistency error. plus 2 other changes (artifact: d0c360fce3 user: drh)
18:20 • New ticket [dd08e5a988]. (artifact: 9f47adfdd6 user: drh)
2010-05-13
23:00 • Ticket [51914f6acd] nRef and owner should be #ifdef SQLITE_DEBUG status still Fixed with 1 other change (artifact: 2aeade5666 user: rogerb)
20:19 • Fixed ticket [51914f6acd]. (artifact: 0e16051dfe user: drh)
2010-05-12
23:41 • New ticket [51914f6acd]. (artifact: 5fe8ccfeb5 user: rogerb)
17:53 • Ticket [c25aab7e7e] The ".import" command does not parse CSV correctly. status still Open with 2 other changes (artifact: 3d07a0d47a user: anonymous)
12:12 • New ticket [26ff0c82d1] Incorrect result when using unnamed "?" bindings. (artifact: 3e0dd9c8b5 user: drh)
2010-04-30
21:03 • Fixed ticket [3dbdcdb14e]: Assertion fault using indices with redundant columns plus 2 other changes (artifact: 7ab2adf41d user: drh)
20:35 • New ticket [3dbdcdb14e]. (artifact: ced410c432 user: drh)
06:00 • Closed ticket [c39ff61c43]: Erroneous FK constraint failure when reusing statement plus 2 other changes (artifact: 07e0b1880e user: dan)
2010-04-29
22:55 • Add attachment fk_bug.c to ticket [c39ff61c43] (artifact: ea5803991b user: dan)
22:53 • New ticket [c39ff61c43] Erroneous FK constraint failure when reusing statement. (artifact: 0e827cdafb user: dan)
2010-04-22
12:08 • Closed ticket [bb1977f6e9]: Concatenation can create very invalid strings plus 2 other changes (artifact: 5349395933 user: drh)
2010-04-19
17:38 • Ticket [bb1977f6e9]: 3 changes (artifact: 7095de75ef user: rogerb)
16:58 • New ticket [bb1977f6e9]. (artifact: a6915b38a9 user: rogerb)
2010-04-15
23:26 • Fixed ticket [02a8e81d44]: LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly plus 2 other changes (artifact: 052b48efab user: drh)
14:43 • Ticket [02a8e81d44]: 3 changes (artifact: c271e30545 user: drh)
14:28 • New ticket [02a8e81d44]. (artifact: 5b18826a94 user: dan)
2010-04-09
19:20 • New ticket [9d68c88313] Database corruption following OOM fault. (artifact: e44fcd7e72 user: drh)
2010-04-05
06:35 • New ticket [30349e0f68] Yet more FTS3 symbols need to be made private. (artifact: bc1fcc3bb6 user: rogerb)
2010-04-03
23:57 • Verified ticket [775b39dd3c]: Poor query planning with virtual tables, joins and ORDER BY. plus 6 other changes (artifact: 136d8ef9fc user: anonymous)
23:49 • Ticket [775b39dd3c]: 1 change (artifact: 58ca3c1451 user: anonymous)
2010-03-31
15:11 • Ticket [883034dcb5] Column cache problem with aggregate queries status still Closed with 1 other change (artifact: 2602409665 user: dan)
15:10 • Closed ticket [883034dcb5]. (artifact: f4abbf8f3c user: dan)
14:49 • New ticket [883034dcb5]. (artifact: 739f88197f user: dan)
11:57 • Fixed ticket [e063139eb3]: Download .zip excludes shell but .tar includes it plus 1 other change (artifact: e50018de6d user: drh)
10:35 • Ticket [e063139eb3]: 2 changes (artifact: c4e414cdbb user: anonymous)
2010-03-30
13:43 • Closed ticket [f3162063fd]: Crash compiling "INSERT INTO tbl DEFAULT VALUES" if tbl has BEFORE or INSTEAD OF triggers. plus 1 other change (artifact: 2eb0c08326 user: dan)
12:34 • Ticket [f3162063fd]: 3 changes (artifact: 978e7e12f2 user: drh)
11:59 • New ticket [f3162063fd]. (artifact: 4f5b53a558 user: dan)
2010-03-27
16:52 • Ticket [7d96113ff0] SQLite fails to build when TCL isn't installed status still Fixed with 1 other change (artifact: cf173fb30b user: anonymous)
09:11 • Ticket [775b39dd3c] Poor query planning with virtual tables, joins and ORDER BY. status still Open with 3 other changes (artifact: 88fa634239 user: dan)
09:09 • New ticket [775b39dd3c]. (artifact: f936d94af3 user: dan)
2010-03-26
01:54 • Ticket [cbd054fa6b] "out of memory" in ANALYZE with SQLITE_ENABLE_STAT2 status still Open with 3 other changes (artifact: ef5f324c9c user: shane)
01:05 • New ticket [cbd054fa6b]. (artifact: 7eb8c2fa3b user: shane)
2010-03-25
04:43 • Ticket [13137dccf3] FTS3 and last_insert_rowid() status still Open with 3 other changes (artifact: f80f3de508 user: dan)
2010-03-24
15:38 • New ticket [9861b74ab9] Fts3 offsets() function may report SQLITE_CORRUPT with empty string.. (artifact: 0888a21a26 user: dan)
2010-03-22
17:47 • Closed ticket [015d3820f2]: Missing call to xSync() following rollback. (artifact: 67e76ed664 user: dan)
17:46 • Ticket [015d3820f2]: 2 changes (artifact: f7fe6d805c user: dan)
17:45 • New ticket [015d3820f2]. (artifact: 27d0f9153a user: dan)
2010-03-19
19:11 • Closed ticket [dd3ba6063a]: rtree module does not support last_insert_rowid() plus 2 other changes (artifact: c88f050744 user: dan)
18:58 • New ticket [dd3ba6063a]. (artifact: b8192d22e7 user: dan)
2010-03-18
16:35 • Fixed ticket [b1552d0fa7]: Symbols not declared private that should be plus 2 other changes (artifact: a96079dd9c user: drh)
2010-03-16
08:40 • New ticket [b1552d0fa7]. (artifact: e6f8cfab18 user: rogerb)
2010-03-15
20:53 • Fixed ticket [170872f1c3]: Unmatched double-quote causes problems for FTS3 plus 2 other changes (artifact: ac003677b1 user: drh)
19:28 • Fixed ticket [42d45a693e]: Spurious log message from FTS3 plus 2 other changes (artifact: 83956ad4df user: drh)
2010-03-12
23:30 • New ticket [170872f1c3] Unmatched double-quote causes problems for FTS3. (artifact: 84e2594f43 user: drh)
23:27 • New ticket [42d45a693e] Spurious log message from FTS3. (artifact: 3d6049ee63 user: drh)
2010-03-05
13:23 • New ticket [aa92c76cd4] Problem with GROUP BY and the distinction between real and integer values. (artifact: 14f2f1f348 user: dan)
2010-03-04
18:00 • Closed ticket [9abd6aa831]: buffer overread in sqlite3_printf functions. plus 2 other changes (artifact: 911370593c user: dan)
17:47 • New ticket [9abd6aa831]. (artifact: 41b75b039f user: dan)
2010-02-27
12:30 • Ticket [ebdbadade5] LEFT JOIN incorrect when ON clause does not reference right table. status still Fixed with 1 other change (artifact: 7017709a6b user: drh)
2010-02-25
04:16 • Fixed ticket [ebdbadade5]. (artifact: 89d8406eaa user: drh)
2010-02-24
22:36 • Ticket [ebdbadade5]: 3 changes (artifact: 2267692434 user: drh)
22:35 • New ticket [ebdbadade5]. (artifact: e3450baa28 user: drh)
19:55 • Ticket [2e047cbefa] select DISTINCT performance could be better status still Open with 4 other changes (artifact: 8a75f8251b user: anonymous)
15:11 • Fixed ticket [d2f02d37f5]: Assertion fault on UPDATE involving two virtual tables. plus 1 other change (artifact: fe19816b76 user: drh)
14:03 • Ticket [d2f02d37f5]: 3 changes (artifact: 150a3df0c3 user: drh)
13:52 • New ticket [d2f02d37f5]. (artifact: 29a566c9c2 user: drh)
2010-02-22
23:19 • Fixed ticket [da1151f97d]: Assertion fault on VACUUM in an auto_vacuumed database. plus 2 other changes (artifact: dd36168aad user: drh)
22:57 • New ticket [da1151f97d]. (artifact: e9ecc159f4 user: drh)
2010-02-16
11:00 • Fixed ticket [e9a9fde1f4]: rtree module malfunctions if db page-size is changed plus 1 other change (artifact: 16ae4f5ce9 user: dan)
10:46 • Ticket [e9a9fde1f4]: 3 changes (artifact: 5dc651f7a7 user: dan)
10:46 • New ticket [e9a9fde1f4]. (artifact: 5c5e964df2 user: dan)
2010-02-15
18:05 • Fixed ticket [13336e9c3c]: ALTER TABLE RENAME fails to update foreign key references plus 2 other changes (artifact: 3686318514 user: drh)
17:47 • New ticket [13336e9c3c]. (artifact: 91486f00ee user: drh)
16:55 • Fixed ticket [985771e116]: CREATE TRIGGER confused by TEMP/MAIN table name overlap plus 2 other changes (artifact: 239613c656 user: drh)
16:37 • New ticket [985771e116]. (artifact: cecc6bdc3d user: drh)
2010-02-02
20:53 • Closed ticket [8905af11a0]: NOT NULL interferes with ON CONFLICT REPLACE plus 2 other changes (artifact: e1bcfd4d59 user: drh)
20:43 • Ticket [8905af11a0]: 3 changes (artifact: 07ca30ad81 user: drh)
20:38 • New ticket [8905af11a0]. (artifact: 978be6a70e user: drh)
2010-01-26
01:26 • Fixed ticket [b80eeab588]: Respect custom page size for temp tables, indices, etc plus 2 other changes (artifact: 31635a695f user: drh)
2010-01-22
22:24 • New ticket [b80eeab588]. (artifact: 524f3adfab user: aswift)
2010-01-21
23:13 • Fixed ticket [1258875e07]: Undefined collating sequence on LIKE causes segfault plus 3 other changes (artifact: 69302bfe88 user: drh)
23:05 • New ticket [1258875e07]. (artifact: 6477f5ee07 user: drh)
2010-01-18
18:16 • Ticket [eb620916be] Shell doesn't print header if multiple statements on one line status still Fixed with 1 other change (artifact: c11d4043ee user: shane)
2010-01-13
13:24 • Fixed ticket [eb942c64a1]: PRAGMA reverse_unordered_selects causes schema parse to fail plus 3 other changes (artifact: 2c0af9bfdb user: drh)
08:26 • Ticket [f51d950180] memset warning with gcc 4.3.3 status still Closed with 1 other change (artifact: 22713762a2 user: rogerb)
2010-01-12
23:32 • New ticket [eb942c64a1] PRAGMA reverse_unordered_selects causes schema parse to fail. (artifact: 96f2acba93 user: drh)
2010-01-11
14:13 • Ticket [f51d950180] memset warning with gcc 4.3.3 status still Closed with 1 other change (artifact: 09223e4fd8 user: anonymous)
2010-01-07
15:17 • Fixed ticket [360c6073e1]: Aggregate MAX() function with COLLATE clause plus 2 other changes (artifact: 0f3eb0efce user: drh)
13:25 • Ticket [360c6073e1]: 3 changes (artifact: 65071972f7 user: drh)
00:53 • New ticket [360c6073e1]. (artifact: 754dfdf2bb user: drh)
2010-01-06
15:37 • Ticket [c25aab7e7e] The ".import" command does not parse CSV correctly. status still Open with 1 other change (artifact: 8fce5cd8f8 user: anonymous)
2009-12-30
12:42 • Ticket [0d676cd6e6] Triggers: new/old.oid is interpreted as the IPK, even if there is another column "oid" status still Closed with 1 other change (artifact: e9d7c6d120 user: drh)
07:41 • Closed ticket [0d676cd6e6]. (artifact: b7dd924dba user: dan)
07:35 • New ticket [0d676cd6e6]. (artifact: 39984b58ce user: dan)
2009-12-29
23:39 • Fixed ticket [34d2ae1c6d]: Overloaded column named "ROWID" mishandled in triggers. plus 3 other changes (artifact: e1cacfb412 user: drh)
21:59 • New ticket [34d2ae1c6d]. (artifact: 94513543f4 user: drh)
2009-12-24
16:01 • Fixed ticket [eb5548a849]: CAST in WHERE clause causes inconsistent query results plus 3 other changes (artifact: 5ad1607e97 user: drh)
13:16 • New ticket [eb5548a849]. (artifact: cd72ca771a user: drh)
2009-12-17
22:18 • Ticket [356c885b0b] sqlite3_complete() should return 0 on empty string status still Fixed with 1 other change (artifact: 9743fa039c user: shane)
22:18 • Fixed ticket [356c885b0b]. (artifact: 2492e5e86b user: shane)
22:14 • New ticket [356c885b0b]. (artifact: 737e3a5bd7 user: shane)
2009-12-16
22:11 • Fixed ticket [31338dca7e]: OR operator in WHERE clause gives wrong answer when indexed plus 2 other changes (artifact: 4fe3aebf59 user: drh)
16:52 • Ticket [31338dca7e]: 1 change (artifact: c9fd070a32 user: drh)
16:40 • Ticket [31338dca7e]: 1 change (artifact: df44f5155a user: drh)
15:18 • Ticket [31338dca7e]: 3 changes (artifact: eec39f02d8 user: drh)
15:10 • New ticket [31338dca7e]. (artifact: 654dbb4660 user: drh)
2009-12-10
17:09 • Ticket [8f81455baf] fts3GetVarint32 sets random number on error status still Open with 2 other changes (artifact: f8b280b488 user: anonymous)
2009-12-09
18:23 • Fixed ticket [f74beaabde]: Problem with 3-way joins and the USING clause plus 2 other changes (artifact: 04c1a6e96a user: drh)
16:42 • Ticket [f74beaabde]: 1 change (artifact: 2901c6ece1 user: drh)
16:27 • Ticket [f74beaabde]: 1 change (artifact: ae81c40e0a user: dan)
16:26 • Ticket [f74beaabde]: 3 changes (artifact: 13f47c66ea user: dan)
16:24 • New ticket [f74beaabde]. (artifact: ec5d8d0570 user: dan)
05:31 • Closed ticket [ff44d82f3b]: fts3ReallocOrFree and fts3InitVtab are not marked static plus 1 other change (artifact: 90ef5426c2 user: dan)
04:15 • Ticket [ff44d82f3b]: 4 changes (artifact: a2ad9e4be1 user: rogerb)
2009-12-08
14:43 • Fixed ticket [4abd1e4c00]: omitted.html still says recursive triggers are not supported plus 3 other changes (artifact: 8249a772c6 user: drh)
14:34 • Fixed ticket [78e04e52ea]: Assertion failure dropping table with zero length name plus 3 other changes (artifact: 17c1e71ae2 user: drh)
13:46 • Fixed ticket [abe728bbc3]: Crash committing multi-file transaction including temp file plus 3 other changes (artifact: bd0bb454b9 user: drh)
10:45 • Ticket [abe728bbc3]: 3 changes (artifact: 43184db831 user: dan)
10:10 • New ticket [abe728bbc3]. (artifact: fe930ae7aa user: dan)
2009-12-01
14:32 • Fixed ticket [97214a34d8]: Use of os2MutexNotheld before their definition plus 2 other changes (artifact: 8f8e1fad47 user: drh)
09:41 • New ticket [13137dccf3] FTS3 and last_insert_rowid(). (artifact: e514a43cf9 user: dan)
2009-11-28
19:36 • New ticket [92af7da36b] shell won't import large files. (artifact: d761eddfd8 user: rogerb)
02:27 • New ticket [3671265894] No error reporting on file open failure. (artifact: ca5ab7c59a user: rogerb)
2009-11-23
21:24 • Fixed ticket [16fbf14cb2]: Faulty VDBE code generated for certain third-party virtual tables plus 3 other changes (artifact: 9fbc5ffe4d user: drh)
21:17 • New ticket [16fbf14cb2]. (artifact: 9abfe1d928 user: drh)
2009-11-20
18:51 • Fixed ticket [564d412f15]: OOM on autovacuum of in-memory database causes problems. plus 3 other changes (artifact: 3ed1331e03 user: drh)
13:39 • New ticket [564d412f15]. (artifact: 5f5454d7ab user: drh)
2009-11-19
18:54 • New ticket [517e206abd] Fix sqlite3_analyzer. (artifact: 3db6963328 user: aswift)
12:06 • Ticket [23b2128201] Uninformative error message on check constraint failure status still Open with 1 other change (artifact: aa6ec7f3db user: anonymous)
2009-11-16
20:59 • Ticket [3211d778c0] replace function works on blobs status still Closed with 1 other change (artifact: 59f2850ced user: drh)
19:18 • Ticket [3211d778c0]: 1 change (artifact: 3e7126e5d8 user: rogerb)
13:24 • Ticket [e123bd2242] File handles aren't always immediately released on sqlite3_close status still Closed with 1 other change (artifact: 8c67bf45d9 user: drh)
12:51 • Ticket [6b00e0a34c] The great OP_If bug status still Fixed with 1 other change (artifact: a16d9fdfea user: drh)
12:47 • Closed ticket [702bbe755b]: Invalid VDBE program built if ORDER BY used plus 1 other change (artifact: e97a552510 user: drh)
12:43 • Fixed ticket [29ab7be99f]: Hitting NOT NULL constraint does not roll back statement transaction plus 1 other change (artifact: ba930fde9c user: drh)
12:42 • Ticket [58a75d62e0] encoding failure status still Closed with 2 other changes (artifact: 70c78f04f5 user: drh)
12:41 • Ticket [98f156c79b] status still Closed with 1 other change (artifact: 417f8c890c user: drh)
12:38 • Ticket [19b44e3575] sqlite3_bind_text inconsistent with NULL pointers, zero length etc status still Open with 1 other change (artifact: a6463ad073 user: drh)
12:36 • Closed ticket [3211d778c0]: replace function works on blobs plus 4 other changes (artifact: 3a08fd9532 user: drh)
12:34 • Ticket [8f81455baf] fts3GetVarint32 sets random number on error status still Open with 3 other changes (artifact: fb39b2d02e user: drh)
12:33 • Closed ticket [e123bd2242]: POSIX File handles aren't always immediately released on sqlite3_close plus 3 other changes (artifact: 344215c59e user: drh)
12:27 • Closed ticket [60f26ed786]: Empty Title plus 5 other changes (artifact: b17123de4e user: drh)
2009-11-11
21:55 • New ticket [60f26ed786]. (artifact: f1be9b9af3 user: anonymous)
04:17 • Fixed ticket [f5cb008a65]: Shell silently ignores extra parameters plus 3 other changes (artifact: e603814cb0 user: shane)
2009-11-10
23:31 • Ticket [61d35ac210] A way to tell if a journal should exist status still Open with 3 other changes (artifact: 24ad0a80d7 user: rogerb)
17:07 • Ticket [aeff892c57] -batch mode not creating DB in CLI status still Fixed with 1 other change (artifact: 2b554fd159 user: shane)
17:07 • Fixed ticket [aeff892c57]. (artifact: 16f4678b23 user: shane)
17:03 • Ticket [aeff892c57]: 3 changes (artifact: 18b9be5af5 user: shane)
17:03 • New ticket [aeff892c57]. (artifact: dfaabe4e54 user: shane)
2009-11-06
17:22 • Fixed ticket [f12a9eeedc]: Shell command argument parsing is lax plus 2 other changes (artifact: 84f729d1a8 user: shane)
04:42 • Ticket [33fdaab1a0] Need to cancel an integrity check in progress with sqlite3_interrupt status still Open with 3 other changes (artifact: 5b925ecaf4 user: rogerb)
04:41 • New ticket [33fdaab1a0]. (artifact: c1ba384681 user: rogerb)
04:15 • Fixed ticket [0bf974bdf9]: backup api asserts with zero length source file plus 5 other changes (artifact: daf649bb31 user: drh)
03:04 • New ticket [0bf974bdf9]. (artifact: fcecca71f3 user: shane)
2009-11-04
23:53 • Ticket [c25aab7e7e] The ".import" command does not parse CSV correctly. status still Open with 1 other change (artifact: d6615d6c42 user: shane)
2009-10-30
14:05 • Fixed ticket [6b00e0a34c]: The great OP_If bug plus 3 other changes (artifact: a67b11ba27 user: drh)
13:57 • New ticket [6b00e0a34c]. (artifact: 7684faf23b user: drh)
2009-10-28
18:23 • Ticket [aad47726e9] Generator of sqlite3UpperToLower&#91;&#93; and sqlite3CtypeMap&#91;&#93; for single lang status still Closed with 1 other change (artifact: c9898866e3 user: rogerb)
16:00 • Ticket [aad47726e9]: 1 change (artifact: 5503f0dd01 user: drh)
04:55 • Closed ticket [aad47726e9]. (artifact: 73ee984cb0 user: rogerb)
2009-10-27
21:17 • Ticket [c25aab7e7e] The ".import" command does not parse CSV correctly. status still Open with 1 other change (artifact: 6df67dd647 user: rogerb)
20:00 • Ticket [c25aab7e7e]: 1 change (artifact: bb94d6842d user: rogerb)
19:51 • Ticket [293860ac26] Allow triggers to reference other databases status still Open with 3 other changes (artifact: c0bba80e6b user: rogerb)
19:35 • New ticket [293860ac26]. (artifact: 1eeb802870 user: rogerb)
2009-10-26
08:30 • Ticket [d82e3f3721] VACUUM corrupts database when MAIN and TEMP table names overlap. status still Fixed with 1 other change (artifact: f9ff61b459 user: rogerb)
08:27 • Ticket [d82e3f3721]: 1 change (artifact: f1d202f05f user: rogerb)
02:45 • New ticket [0841d0f524] Exclusive transactions do not work if same database multiply attached. (artifact: ae88673605 user: rogerb)
02:33 • New ticket [65a1fd4bab] Shell should call rl_readline_name. (artifact: a57a34fa1d user: rogerb)
02:15 • New ticket [bcff482dd6] Explicit extended error code for deadlock with sqlite_busy. (artifact: 5b874c1a7c user: rogerb)
01:57 • New ticket [5896edbe46] List available SQL functions. (artifact: 03997a6922 user: rogerb)
01:55 • Ticket [2466653295] Various dump issues status still Open with 1 other change (artifact: 1f7b39d0bd user: rogerb)
01:35 • Ticket [2466653295]: 1 change (artifact: 445d723899 user: shane)
2009-10-25
20:26 • New ticket [c276ee2e4e] null should not be allowed in primary key. (artifact: fc4d7e2fe4 user: rogerb)
2009-10-24
02:06 • Fixed ticket [2cb66577f6]: Diagnostic message is unintentionally printed in batch mode plus 3 other changes (artifact: f04adecb1b user: shane)
02:00 • Fixed ticket [6da68f691b]: tables says you provide a like pattern but it adds % in code plus 3 other changes (artifact: ac365444bf user: shane)
01:48 • Ticket [3fe897352e] Malformed UTF16 leads to a 2-byte buffer overread status still Fixed with 1 other change (artifact: 1b24ca61f0 user: shane)
01:40 • Ticket [4c9223e34e] Vacuum fails within transaction but also rolls it back status still Open with 3 other changes (artifact: cfe528a0ba user: rogerb)
01:07 • New ticket [0c80ff9f5a] Quickstart missing include of stdlib.h. (artifact: 5bacd2ef82 user: rogerb)
01:04 • New ticket [f711d5a937] Windows DLL should have versioninfo resource. (artifact: 2105fd2bf7 user: rogerb)
00:49 • New ticket [5483170346] H35230 & H35240 refer incorrectly to H35230 - should be H35220. (artifact: 0c36327685 user: rogerb)
2009-10-23
18:16 • Fixed ticket [3fe897352e]: Malformed UTF16 leads to a 2-byte buffer overread plus 1 other change (artifact: dcecbfdd25 user: drh)
17:23 • Ticket [3fe897352e]: 3 changes (artifact: 5db5602a91 user: drh)
17:22 • New ticket [3fe897352e]. (artifact: 1f13ae4dbc user: drh)
12:22 • Closed ticket [f80d443a3b]: pragma cache size doesn report actual size (min is 10) plus 1 other change (artifact: d6a5b1fe1a user: drh)
09:31 • New ticket [4c9223e34e] Vacuum fails within transaction but also rolls it back. (artifact: a63f8a145c user: rogerb)
08:36 • New ticket [36769f697d] termDataCmp in FTS3 should be __cdecl on Windows. (artifact: 091cb9754a user: rogerb)
08:31 • New ticket [61d35ac210] A way to tell if a journal should exist. (artifact: 7b540e42f5 user: rogerb)
02:11 • Open ticket [f80d443a3b]: pragma cache size doesn report actual size (min is 10) plus 1 other change (artifact: 62f1778f70 user: shane)
01:27 • Fixed ticket [beb2dd69ad]: do_meta_command inconsistent return values plus 3 other changes (artifact: 9521cb1f4f user: shane)
00:37 • Fixed ticket [bd770b2c52]: shell doesn't return error exit code on import errors plus 3 other changes (artifact: aeaae62165 user: shane)
2009-10-22
21:27 • Ticket [7b61b6c6ce] insert mode is incorrectly converting text to numbers status still Fixed with 1 other change (artifact: b8c779e7ff user: shane)
21:27 • Ticket [72adc99de9] shell mode insert doesn't output blobs as blobs status still Fixed with 1 other change (artifact: b4739ea677 user: shane)
21:26 • Fixed ticket [eb620916be]: Shell doesn't print header if multiple statements on one line plus 3 other changes (artifact: 8b2e3b3dce user: shane)
19:38 • Fixed ticket [7b61b6c6ce]: insert mode is incorrectly converting text to numbers plus 4 other changes (artifact: 91fba9fd6a user: shane)
18:15 • Fixed ticket [72adc99de9]: shell mode insert doesn't output blobs as blobs (artifact: 9e48202700 user: shane)
18:15 • Ticket [72adc99de9]: 1 change (artifact: 4fc3cc9ef5 user: shane)
17:30 • Review ticket [72adc99de9]. (artifact: 4eac1d2339 user: shane)
2009-10-21
14:09 • Fixed ticket [dc3a6e5b31]: Shell doesn't htmlify column headers plus 3 other changes (artifact: 7cdb6d1d87 user: shane)
13:50 • Fixed ticket [6f8b0c5855]: Some minor genfkey fixups plus 3 other changes (artifact: 3466fb4d1d user: shane)
13:49 • Ticket [6f8b0c5855]: 3 changes (artifact: 729515dbd8 user: shane)
04:39 • New ticket [78e04e52ea] Assertion failure dropping table with zero length name. (artifact: 5cb1c29080 user: rogerb)
03:56 • Ticket [39c85e8a4e] FormatMessage incorrectly used (Windows VFS) status still Fixed with 2 other changes (artifact: 93778e6744 user: shane)
03:55 • Ticket [89668ca167] shell can support .timer on Windows status still Fixed with 2 other changes (artifact: 6af2d6e125 user: shane)
03:55 • Fixed ticket [43db771bb2]: Sqlite shell prints some error messages to stdout plus 4 other changes (artifact: 37488ae443 user: shane)
03:39 • Fixed ticket [89668ca167]: shell can support .timer on Windows plus 3 other changes (artifact: e0b743a349 user: shane)
01:59 • Fixed ticket [39c85e8a4e]: FormatMessage incorrectly used (Windows VFS) plus 3 other changes (artifact: 4d0dea8d69 user: shane)
2009-10-20
18:18 • Ticket [f80d443a3b] pragma cache size doesn report actual size (min is 10) status still Closed with 1 other change (artifact: f4adfa0f0b user: rogerb)
18:13 • Ticket [8440a8e22f] LENGTH & QUOTE stop at first zero status still Closed with 1 other change (artifact: 0382b1a95f user: rogerb)
15:31 • Closed ticket [8440a8e22f]. (artifact: 350ec879eb user: drh)
15:28 • Fixed ticket [f9af981dd2]: sqlite3_shutdown documentation needs to mention danger plus 3 other changes (artifact: 9bae21eefb user: drh)
15:06 • Fixed ticket [d82e3f3721]: VACUUM corrupts database when MAIN and TEMP table names overlap. plus 5 other changes (artifact: b986bc7f1c user: drh)
14:24 • Fixed ticket [1751725cd6]: sqlite_close doc should qualify advice plus 3 other changes (artifact: 27fd260282 user: drh)
14:15 • Ticket [4d5c039d12] Truncated database not detected well status still Open with 2 other changes (artifact: a153956721 user: drh)
13:49 • Closed ticket [f80d443a3b]: pragma cache size doesn report actual size (min is 10) plus 4 other changes (artifact: 426c6a9614 user: drh)
13:27 • Closed ticket [8d510499cc]: Repreparation errors are always returned as SQLITE_SCHEMA plus 2 other changes (artifact: 0e10289d76 user: drh)
06:31 • New ticket [f80d443a3b] pragma cache size doesn report actual size (min is 10). (artifact: 2f6d46c0c6 user: rogerb)
06:14 • Ticket [de3ae967a0] Insert multiple rows at once status still Open with 3 other changes (artifact: c6b3d9ad73 user: rogerb)
06:11 • New ticket [de3ae967a0]. (artifact: c2d4b44ea8 user: rogerb)
05:58 • New ticket [d214d7b114] FTS3 virtual table fails when names are quoted. (artifact: 105e07227b user: rogerb)
00:38 • Ticket [8d510499cc] Repreparation errors are always returned as SQLITE_SCHEMA status still Open with 1 other change (artifact: 6763db5cfc user: rogerb)
2009-10-19
21:05 • Fixed ticket [b73fb0bd64]: Natural self-join defect plus 2 other changes (artifact: 39153355fb user: drh)
19:47 • Ticket [b73fb0bd64]: 3 changes (artifact: 1a3635f577 user: drh)
11:43 • Deferred ticket [897b96d49d]: SQLITE_CANTOPEN when using journal_mode=persist and async IO plus 1 other change (artifact: 433a58d38a user: dan)
11:43 • Ticket [897b96d49d]: 3 changes (artifact: 75d8455ec2 user: dan)
10:04 • Closed ticket [94c04eaadb]: Crash in asyncRead() with large (>2GB) database file plus 2 other changes (artifact: 5332bbd487 user: dan)
06:14 • New ticket [39c85e8a4e] FormatMessage incorrectly used (Windows VFS). (artifact: 74e44cf7a7 user: rogerb)
05:48 • New ticket [d82e3f3721] temporary tables stay in sqlite_sequence over a vacuum and close. (artifact: 1a8a9f5f5e user: rogerb)
05:31 • Ticket [eb620916be] Shell doesn't print header if multiple statements on one line status still Open with 1 other change (artifact: 1c57be17df user: rogerb)
05:28 • Ticket [8d510499cc] Repreparation errors are always returned as SQLITE_SCHEMA status still Open with 3 other changes (artifact: 22707dc0cf user: rogerb)
05:23 • New ticket [8d510499cc]. (artifact: 85cf4da352 user: rogerb)
05:17 • Ticket [c060923a54] VFS filename truncation issues status still Open with 3 other changes (artifact: c2f7e29ddf user: rogerb)
05:12 • New ticket [f6ee7c1986] Negative widths should right justify. (artifact: 38ce681540 user: rogerb)
2009-10-18
18:19 • New ticket [b73fb0bd64] Natural self-join defect. (artifact: b9586609bb user: drh)
08:29 • Ticket [4d5c039d12] Truncated database not detected well status still Open with 3 other changes (artifact: 9dcd9bbbdb user: rogerb)
2009-10-16
20:55 • Fixed ticket [f777251dc7]: Assertion fault following ROLLBACK with running queries plus 3 other changes (artifact: d02149273e user: drh)
2009-10-15
21:01 • New ticket [1751725cd6] sqlite_close doc should qualify advice. (artifact: fa644bfd72 user: rogerb)
18:06 • Ticket [f777251dc7] Assertion fault following ROLLBACK with running queries status still Open with 1 other change (artifact: c960b09e8f user: drh)
17:17 • Ticket [f777251dc7]: 1 change (artifact: 0cd02a47af user: drh)
17:16 • Ticket [f777251dc7]: 3 changes (artifact: a05e9078d7 user: drh)
16:58 • New ticket [f777251dc7]. (artifact: de4eb17b5b user: drh)
2009-10-14
11:15 • Ticket [c25aab7e7e] The ".import" command does not parse CSV correctly. status still Open with 1 other change (artifact: 7466c10062 user: anonymous)
2009-10-13
15:44 • Fixed ticket [5ee23731f1]: assert() failure (or invalid error code) caused by opening statement transaction on read-only database with active read statements plus 3 other changes (artifact: b7a954b469 user: drh)
15:34 • New ticket [5ee23731f1]. (artifact: dee8fcc844 user: dan)
2009-10-12
21:22 • New ticket [7b61b6c6ce] insert mode is incorrectly converting text to numbers. (artifact: 7ec8cb6ef8 user: rogerb)
04:26 • New ticket [ee19e690ec] If shell is interrupted while dumping it still produces commit (and invalid dump). (artifact: c283c86ddb user: rogerb)
04:24 • Ticket [ba7fdb568d] Page size should auto default to file system block size status still Open with 3 other changes (artifact: 6fbe2d8769 user: rogerb)
04:15 • New ticket [ac55d88a33] H10336 is no longer applicable. (artifact: fed2312ba7 user: rogerb)
04:12 • New ticket [4d5c039d12] Truncated database not detected well. (artifact: d1730fa418 user: rogerb)
2009-10-11
07:36 • Ticket [ee4b2b48f5] Prepared statement cache status still Open with 4 other changes (artifact: b9ba3cb62a user: rogerb)
06:43 • New ticket [ee4b2b48f5]. (artifact: 77c1854d0f user: rogerb)
06:21 • New ticket [beb2dd69ad] do_meta_command inconsistent return values. (artifact: e428590bd7 user: rogerb)
06:04 • New ticket [08595ca456] INTERSECT operator should have higher precedence. (artifact: da23ad28c5 user: rogerb)
05:44 • New ticket [ed2ff2f4ef] Call progress callback while doing pragma integrity_check. (artifact: 64e43de70d user: rogerb)
05:33 • New ticket [2cb66577f6] Diagnostic message is unintentionally printed in batch mode. (artifact: a3219b5657 user: rogerb)
2009-10-10
03:18 • New ticket [c060923a54] VFS filename truncation issues. (artifact: 2b6ea7251a user: rogerb)
2009-10-08
11:54 • Ticket [ebde3f66fc] Shared cache has different busy behaviour than non-shared status still Open with 3 other changes (artifact: 637366419f user: drh)
11:23 • Ticket [23b2128201] Uninformative error message on check constraint failure status still Open with 1 other change (artifact: 79a907ef0d user: anonymous)
08:15 • New ticket [897b96d49d] SQLITE_CANTOPEN when using journal_mode=persist and async IO. (artifact: ae7a158a5f user: dan)
06:59 • Ticket [23b2128201] Uninformative error message on check constraint failure status still Open with 3 other changes (artifact: 18b14039c1 user: rogerb)
06:46 • New ticket [d8fe6cef65] Error return from VFS xUnlock ignored. (artifact: af15aaed65 user: rogerb)
06:39 • New ticket [23b2128201] Meangingless error message on check constraint failure. (artifact: addfa3c69f user: rogerb)
06:26 • New ticket [ebde3f66fc] Shared cache has different busy behaviour than non-shared. (artifact: 2a700451d8 user: rogerb)
2009-10-07
23:43 • Fixed ticket [8550ecca70]: findLockInfo uses memcmp on non-zeroed, = assigned struct plus 3 other changes (artifact: 0eeaeb3075 user: drh)
22:34 • New ticket [8550ecca70]. (artifact: c15f59e379 user: aswift)
13:55 • New ticket [94c04eaadb] Crash in asyncRead() with large (>2GB) database file. (artifact: 46c84addca user: dan)
2009-10-06
18:10 • Ticket [c25aab7e7e] The ".import" command does not parse CSV correctly. status still Open with 2 other changes (artifact: 1a724b756f user: rogerb)
2009-10-05
23:10 • New ticket [f9af981dd2] sqlite3_shutdown documentation needs to mention danger. (artifact: 857d880d7e user: rogerb)
22:23 • Ticket [2466653295] Various dump issues status still Open with 3 other changes (artifact: 37405da9f5 user: rogerb)
20:29 • New ticket [2466653295]. (artifact: d04e1565bf user: rogerb)
18:18 • Ticket [0322cd49c0] create_function_v2 that takes destructor status still Open with 3 other changes (artifact: fe12bfe170 user: rogerb)
18:05 • New ticket [1c67bd6ce9] Shell Control-C (break) handling could be better. (artifact: 4896d7b3fe user: rogerb)
04:16 • Ticket [6da68f691b] tables says you provide a like pattern but it adds % in code status still Open with 3 other changes (artifact: af7ddd7dac user: rogerb)
2009-10-04
23:37 • New ticket [ba7fdb568d] Page size should auto default to file system block size. (artifact: 1ddcd2017a user: rogerb)
23:03 • New ticket [0322cd49c0] create_function_v2 that takes destructor. (artifact: 1f590b7540 user: rogerb)
22:55 • Ticket [4776dee07a] Documentation and code about registering functions status still Open with 2 other changes (artifact: 2ab6434e73 user: rogerb)
21:14 • Ticket [4776dee07a]: 3 changes (artifact: 077366998b user: rogerb)
21:10 • New ticket [4776dee07a]. (artifact: 05a80aa339 user: rogerb)
20:35 • New ticket [89668ca167] shell can support .timer on Windows. (artifact: 66f863a473 user: rogerb)
2009-10-03
23:25 • New ticket [1a1790ca1a] No way to signal an error in collation callback. (artifact: 0210d47e96 user: rogerb)
07:56 • New ticket [6da68f691b] tables says you provide a like pattern but it adds % in code. (artifact: 8d9b39b237 user: rogerb)
04:05 • New ticket [8f81455baf] fts3GetVarint32 sets random number on error. (artifact: d84ee80c30 user: rogerb)
02:08 • New ticket [bd770b2c52] shell doesn't return error exit code on import errors. (artifact: 47ac7eadf3 user: rogerb)
02:02 • New ticket [2e047cbefa] select DISTINCT performance could be better. (artifact: f967d12b3e user: rogerb)
2009-10-02
19:54 • New ticket [f5cb008a65] Shell silently ignores extra parameters. (artifact: f0d1a7a863 user: rogerb)
2009-10-01
07:27 • Ticket [2fd50fa665] cygwin-1.7 issues: winFullPathname and tempname status still Open with 4 other changes (artifact: 07b923927e user: rogerb)
07:23 • New ticket [43d2aa29b9] H13015 needs to be completed. (artifact: ac8d312a42 user: rogerb)
07:17 • New ticket [3211d778c0] replace function works on blobs. (artifact: b3d4e9eb41 user: rogerb)
07:07 • New ticket [8440a8e22f] LENGTH & QUOTE stop at first zero. (artifact: 7a9cbc2f25 user: rogerb)
06:47 • Ticket [19b44e3575] sqlite3_bind_text inconsistent with NULL pointers, zero length etc status still Open with 3 other changes (artifact: 4fc1eaf923 user: rogerb)
06:44 • New ticket [19b44e3575]. (artifact: 44e184970d user: rogerb)
06:31 • New ticket [72adc99de9] shell mode insert doesn't output blobs as blobs. (artifact: 7fb1b8cba6 user: rogerb)
02:05 • Ticket [e063139eb3] Download .zip excludes shell but .tar includes it status still Open with 1 other change (artifact: 053b43a0cd user: rogerb)
02:04 • Ticket [f12a9eeedc] Shell command argument parsing is lax status still Open with 3 other changes (artifact: 8d0a5cd234 user: rogerb)
2009-09-30
16:07 • Ticket [e123bd2242] POSIX File handles aren't always immediately released on sqlite3_close status still Open with 3 other changes (artifact: 4a094ade6b user: drh)
09:01 • Ticket [e063139eb3] Download .zip excludes shell but .tar includes it status still Open with 3 other changes (artifact: 4bd0b35064 user: rogerb)
09:01 • New ticket [e063139eb3]. (artifact: f5a4f8bded user: rogerb)
08:55 • New ticket [e123bd2242] POSIX File handles aren't always immediately released on sqlite3_close. (artifact: cad71b4daa user: rogerb)
08:45 • New ticket [35c54c8749] Some os win symbols should be declared static. (artifact: e01d2e6b9b user: rogerb)
2009-09-29
18:26 • Closed ticket [668fe22637]: pragma table_info doesn't accept database names plus 2 other changes (artifact: 8a03db8f00 user: rogerb)
11:58 • Ticket [668fe22637]: 3 changes (artifact: dec53170b4 user: ralfjunker)
09:25 • New ticket [668fe22637]. (artifact: bdb4713be9 user: rogerb)
07:35 • New ticket [dc3a6e5b31] Shell doesn't htmlify column headers. (artifact: faa7bbfefe user: rogerb)
04:17 • Ticket [eb620916be] Shell doesn't print header if multiple statements on one line status still Open with 3 other changes (artifact: cc4a5b28d5 user: rogerb)
03:58 • New ticket [f12a9eeedc] Shell command argument parsing is lax. (artifact: a4c95c9f0d user: rogerb)
03:33 • New ticket [eb620916be] Shell doesn't print header if multiple statements on one line. (artifact: 6438035f67 user: rogerb)
2009-09-28
05:32 • New ticket [7d32c69b50] sqlite3LoadExtension truncates file names. (artifact: 5e9b718726 user: rogerb)
05:05 • New ticket [0b803bff85] Return (error code) of xCurrentTime is always ignored. (artifact: c4d1bfb5d6 user: rogerb)
05:02 • New ticket [20f9d4fbbf] sqlite3_overload_function ignores errors. (artifact: e201503146 user: rogerb)
04:58 • New ticket [62359d6511] xGetLastError should be dumped. (artifact: 148039b239 user: rogerb)
04:49 • New ticket [efeeb90f2a] error messages should be per-thread not global. (artifact: 0abb02116e user: rogerb)
2009-09-26
15:14 • Closed ticket [58a75d62e0]: encoding failure plus 3 other changes (artifact: 683a429351 user: drh)
14:20 • Closed ticket [cff1a52937]: sqlite3_get_table() returns wrong result when using where clause plus 3 other changes (artifact: 0d93ca4736 user: drh)
13:57 • Closed ticket [d77ffcd7a5]: Memory leak on failing INSERT statements on tables with UNIQUE INDEX plus 2 other changes (artifact: 10890730d0 user: drh)
12:06 • Ticket [d77ffcd7a5]: 3 changes (artifact: 9677292406 user: anonymous)
12:05 • Ticket [d77ffcd7a5]: 1 change (artifact: b2bffcc242 user: anonymous)
10:28 • New ticket [cff1a52937] sqlite3_get_table() returns wrong result when using where clause. (artifact: 504f4a7388 user: anonymous)
10:16 • Ticket [d77ffcd7a5] Memory leak on failing INSERT statements on tables with UNIQUE INDEX status still Open with 1 other change (artifact: d8074b889f user: anonymous)
09:31 • Ticket [d77ffcd7a5]: 1 change (artifact: 1c0ad2ba4a user: anonymous)
03:42 • Ticket [d77ffcd7a5]: 4 changes (artifact: 36a52f7b79 user: drh)
01:15 • Ticket [d77ffcd7a5]: 3 changes (artifact: 71206fb79a user: drh)
2009-09-25
21:20 • New ticket [d77ffcd7a5]. (artifact: 41297e8607 user: anonymous)
15:48 • New ticket [58a75d62e0] encoding failure. (artifact: 4b0b5f55b9 user: anonymous)
10:35 • Closed ticket [860d129c15]: builds with sqlite 3.6.18 depends on tchsh plus 2 other changes (artifact: 3e93f82920 user: drh)
08:05 • Ticket [860d129c15]: 3 changes (artifact: e19d686cc7 user: anonymous)
05:57 • New ticket [860d129c15]. (artifact: c9169d54da user: anonymous)
02:01 • Closed ticket [f7e3d17a34]: Memory accumulate without commit plus 5 other changes (artifact: 690b6b2cde user: drh)
01:26 • Ticket [f7e3d17a34]: 3 changes (artifact: 71d9c70484 user: anonymous)
01:23 • New ticket [f7e3d17a34]. (artifact: b9c871ca8f user: anonymous)
01:05 • Ticket [3338b3fa19] ambiguous column name when using multiple JOIN USING clauses and WHERE clause status still Open with 3 other changes (artifact: 1494b2de35 user: drh)
2009-09-24
23:55 • New ticket [3338b3fa19]. (artifact: 86489a5461 user: anonymous)
18:42 • Fixed ticket [4a03edc4c8]: Index corruption following aggressive use of ON CONFLICT clause. plus 3 other changes (artifact: cd3aa8c601 user: drh)
16:48 • Ticket [702bbe755b] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: c10814b9eb user: anonymous)
12:25 • Closed ticket [c9394a56c7]: Sqlite reading all column data on selects. plus 4 other changes (artifact: 3378c8472e user: drh)
12:05 • New ticket [c9394a56c7]. (artifact: 22660f2c2b user: anonymous)
2009-09-23
19:16 • New ticket [4a03edc4c8] Index corruption following aggressive use of ON CONFLICT clause.. (artifact: 360b463978 user: drh)
15:52 • Ticket [702bbe755b] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 54f202b46a user: drh)
15:41 • Ticket [702bbe755b]: 1 change (artifact: 58649bce9e user: anonymous)
13:42 • Ticket [702bbe755b]: 1 change (artifact: ef1b5a65fd user: drh)
11:54 • Ticket [f51d950180] memset warning with gcc 4.3.3 status still Closed with 1 other change (artifact: 9a6159ee36 user: drh)
11:54 • Closed ticket [f51d950180]. (artifact: 92e91053f1 user: drh)
11:22 • Closed ticket [98f156c79b]: plus 2 other changes (artifact: 586dfe12cd user: drh)
08:32 • New ticket [f51d950180] memset warning with gcc 4.3.3. (artifact: ac551f6db0 user: anonymous)
07:39 • New ticket [98f156c79b] . (artifact: 98fde03230 user: anonymous)
04:12 • Ticket [702bbe755b] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 8b058ffd3e user: anonymous)
2009-09-22
19:47 • Ticket [702bbe755b]: 1 change (artifact: 6d6ea85086 user: anonymous)
15:03 • Ticket [702bbe755b]: 1 change (artifact: 9cb27e4dcb user: drh)
14:24 • Ticket [702bbe755b]: 1 change (artifact: d93a1b1628 user: anonymous)
13:32 • Closed ticket [0bc616a2c8]: In wince 6.0, I can not compile sqlite. plus 4 other changes (artifact: 160f84c79e user: shane)
13:10 • Ticket [702bbe755b] Invalid VDBE program built if ORDER BY used status still Open with 3 other changes (artifact: 9c25e7f5fe user: anonymous)
13:09 • New ticket [702bbe755b]. (artifact: 5d285f81dd user: anonymous)
13:00 • Closed ticket [a8b1e82b8f]: CAST failing for numeric plus 3 other changes (artifact: 6d7d04236c user: drh)
12:14 • New ticket [a8b1e82b8f]. (artifact: 5f5ffda6ad user: anonymous)
2009-09-21
16:34 • Closed ticket [56928bd084]: Cannot compile with SQLITE_OMIT_UTF16 and SQLITE_ENABLE_STAT2 plus 2 other changes (artifact: 73b70a0ee2 user: dan)
16:14 • Ticket [c472df6c1c] Segmentation fault by instead of insert triggers status still Closed with 1 other change (artifact: 3b35f10062 user: dan)
16:08 • Closed ticket [1ff6d29030]: Compile fails with SQLITE_OMIT_TRIGGER plus 2 other changes (artifact: e3a1dc15d4 user: dan)
13:18 • Ticket [c472df6c1c] Segmentation fault by instead of insert triggers status still Closed with 1 other change (artifact: c0e263ac7d user: anonymous)
12:57 • Closed ticket [c472df6c1c]. (artifact: d02c4c220c user: drh)
12:45 • New ticket [c472df6c1c]. (artifact: 82e442f77e user: anonymous)
2009-09-20
08:02 • Ticket [1ff6d29030] Compile fails with SQLITE_OMIT_TRIGGER status still Open with 4 other changes (artifact: fbfe47f8cb user: anonymous)
2009-09-19
14:06 • Ticket [56928bd084] Cannot compile with SQLITE_OMIT_UTF16 and SQLITE_ENABLE_STAT2 status still Open with 1 other change (artifact: bae6a405db user: drh)
09:30 • New ticket [aad47726e9] Generator of sqlite3UpperToLower[] and sqlite3CtypeMap[] for single lang. (artifact: 92cd2993b0 user: anonymous)
09:03 • New ticket [0bc616a2c8] In wince 6.0, I can not compile sqlite.. (artifact: 40ad5afe9f user: anonymous)
07:25 • Ticket [56928bd084] Cannot compile with SQLITE_OMIT_UTF16 and SQLITE_ENABLE_STAT2 status still Open with 3 other changes (artifact: b7035268f3 user: anonymous)
07:19 • New ticket [6f8b0c5855] Some minor genfkey fixups. (artifact: 0af7a330e2 user: anonymous)
2009-09-18
23:53 • New ticket [56928bd084] Cannot compile with SQLITE_OMIT_UTF16 and SQLITE_ENABLE_STAT2. (artifact: 68e33d0422 user: anonymous)
12:06 • Ticket [15e11a2c87] IfEmpty(a,b) : a function like IfNull(a,b) but for empty strings status still Open with 3 other changes (artifact: b75af9a320 user: anonymous)
2009-09-17
21:22 • Ticket [f76cabebfd] xBestIndex/xFilter slight interface improvement status still Closed with 1 other change (artifact: c7a39ecfa3 user: anonymous)
21:01 • Ticket [eaa105fe74] (...) WHERE col IN (val1) not reflected in xBestIndex status still Open with 1 other change (artifact: 2074da8bd3 user: anonymous)
18:55 • New ticket [af3450b763] Recursive virtual tables. (artifact: 8b2bd18ca7 user: anonymous)
12:50 • New ticket [15e11a2c87] IfEmpty(a,b) : a function like IfNull(a,b) but for empty strings. (artifact: 79ae2f13e7 user: anonymous)
12:41 • New ticket [b803a45d50] Feature Request: MATCHES(VAL1%, VAL2, %VALn%, ...). (artifact: dcae36aa53 user: anonymous)
11:09 • Ticket [1ff6d29030] Compile fails with SQLITE_OMIT_TRIGGER status still Open with 3 other changes (artifact: c18f740830 user: anonymous)
11:09 • New ticket [1ff6d29030]. (artifact: bbe12f430c user: anonymous)
00:47 • Fixed ticket [e25d9ea771]: Cascading delete trigger fails. plus 4 other changes (artifact: df2f80f30b user: drh)
2009-09-16
21:31 • Ticket [e25d9ea771]: 3 changes (artifact: 60ac754662 user: drh)
20:48 • New ticket [e25d9ea771]. (artifact: d55a57ffea user: anonymous)
16:14 • New ticket [f1c2a689c6] configure script ignores ``--with-tcl'' option when tclsh8.4 is installed.. (artifact: 1fd89115c5 user: anonymous)
12:10 • Closed ticket [832b2f3e6e]: integrity_check error after backup restore plus 2 other changes (artifact: 8a05c5ead1 user: drh)
10:26 • Ticket [084941461f] Some minor asyncvfs issues status still Open with 3 other changes (artifact: 780b0f58c7 user: anonymous)
07:40 • Ticket [832b2f3e6e] integrity_check error after backup restore status still Open with 1 other change (artifact: 29caa96129 user: anonymous)
07:16 • Ticket [832b2f3e6e]: 1 change (artifact: 0a237bdd05 user: anonymous)
06:55 • Ticket [832b2f3e6e]: 3 changes (artifact: 4b3e723256 user: anonymous)
06:19 • New ticket [832b2f3e6e]. (artifact: 3a8b087ada user: anonymous)
2009-09-15
12:30 • Closed ticket [127c1c42ff]: Build error "C compiler cannot create executables" on debian lenny host plus 1 other change (artifact: bcff14c59f user: drh)
10:13 • Ticket [127c1c42ff]: 1 change (artifact: 22e984d941 user: anonymous)
10:11 • New ticket [084941461f] Some minor asyncvfs issues. (artifact: a3a2c2bebe user: anonymous)
00:03 • Fixed ticket [a696379c1f]: Access violation error trying to insert into triggered view plus 3 other changes (artifact: da685e3d7f user: drh)
2009-09-14
22:28 • Ticket [a696379c1f]: 1 change (artifact: 3e27afc20e user: drh)
21:59 • Ticket [a696379c1f]: 3 changes (artifact: c67c6343ea user: drh)
21:49 • New ticket [a696379c1f]. (artifact: 736b24e82f user: anonymous)
16:50 • Ticket [03b198a2fa] Getting several warnings when compiling in eVC++ 4 status still Fixed with 1 other change (artifact: b35459b139 user: drh)
15:50 • Fixed ticket [03b198a2fa]. (artifact: f8a4d8be67 user: shane)
15:35 • Closed ticket [806f3be2d7]: Proposal to inline some functions plus 3 other changes (artifact: 3322014691 user: drh)
15:28 • Ticket [806f3be2d7]: 1 change (artifact: 9463610d8c user: drh)
15:19 • Ticket [806f3be2d7]: 3 changes (artifact: 0fab25d284 user: drh)
15:17 • New ticket [806f3be2d7]. (artifact: a43fdbe809 user: anonymous)
14:24 • New ticket [ff44d82f3b] fts3ReallocOrFree is not marked static. (artifact: d62883f181 user: anonymous)
11:47 • Ticket [127c1c42ff] Build error "C compiler cannot create executables" on debian lenny host status still Open with 1 other change (artifact: 79cd2fea48 user: drh)
06:52 • Ticket [127c1c42ff]: 1 change (artifact: 402e8d7759 user: anonymous)
06:38 • Ticket [127c1c42ff]: 1 change (artifact: e8c3491b86 user: anonymous)
04:34 • Ticket [127c1c42ff]: 1 change (artifact: b45cc1b36f user: anonymous)
2009-09-13
20:30 • New ticket [4abd1e4c00] omitted.html still says recursive triggers are not supported. (artifact: 036e5f8904 user: anonymous)
20:17 • Open ticket [127c1c42ff]: Build error "C compiler cannot create executables" on debian lenny host plus 2 other changes (artifact: ec6d4ae3ee user: anonymous)
20:16 • Ticket [127c1c42ff]: 1 change (artifact: af9e651641 user: anonymous)
20:15 • Ticket [127c1c42ff]: 1 change (artifact: db2c04fdb8 user: anonymous)
12:27 • Closed ticket [127c1c42ff]. (artifact: 3f6f67ae18 user: anonymous)
07:34 • New ticket [127c1c42ff]. (artifact: cebc40af66 user: anonymous)
2009-09-12
16:29 • Ticket [ab7498f2f6] 54 seconds to sort two(2) rows only when LIKE operator is used in WHERE clause and the query also contains an order-by clause status still Open with 1 other change (artifact: 5a7b4f4b56 user: drh)
16:29 • Closed ticket [8c743979c2]: SQLite version correction on LIKE operator + ORDER BY bug I reported earlier today (artifact: 19e396159e user: drh)
16:28 • Tested ticket [8c743979c2]. (artifact: f5c8f57d14 user: drh)
16:11 • New ticket [8c743979c2]. (artifact: e739d6beba user: anonymous)
15:45 • Ticket [03b198a2fa] Getting several warnings when compiling in eVC++ 4 status still Open with 3 other changes (artifact: ae11fec617 user: drh)
15:43 • Ticket [ab7498f2f6] 54 seconds to sort two(2) rows only when LIKE operator is used in WHERE clause and the query also contains an order-by clause status still Open with 4 other changes (artifact: 7b35d5a02d user: drh)
13:52 • New ticket [ab7498f2f6]. (artifact: c3583803a5 user: anonymous)
04:06 • Fixed ticket [9a502b7a35]: datetime function has year 54079 bug plus 4 other changes (artifact: 0e7b45c285 user: drh)
02:51 • New ticket [9a502b7a35]. (artifact: c01d004486 user: anonymous)
2009-09-11
18:04 • Fixed ticket [65bbb65a47]: 'configure' file without +x permission in sqlite-3.6.18.tar.gz tarball plus 3 other changes (artifact: f0db359252 user: drh)
17:36 • New ticket [65bbb65a47]. (artifact: 1d5d325d76 user: anonymous)
11:16 • Ticket [6e1086fb2c] "create table as select" and "pragma *_column_names" status still Open with 3 other changes (artifact: 3e57dcbca8 user: drh)
09:09 • New ticket [6e1086fb2c]. (artifact: 086bd4ea7d user: anonymous)
2009-09-10
12:49 • Ticket [92bd6eaf04] Suggestion to revise clean rule in main.mk. status still Open with 3 other changes (artifact: d43e9b553d user: drh)
06:55 • New ticket [92bd6eaf04]. (artifact: b8ef9f1f2f user: anonymous)
2009-09-09
14:49 • Fixed ticket [7d96113ff0]: SQLite fails to build when TCL isn't installed plus 2 other changes (artifact: 5b8f84d886 user: drh)
14:31 • Closed ticket [4b81075908]: In mult-thread that have a problem of updata lost plus 2 other changes (artifact: 0e99c27ada user: drh)
14:26 • Fixed ticket [9fd0bc3663]: Add a new open flag to enable shared cache for a single db connection plus 3 other changes (artifact: afa0825e25 user: drh)
13:18 • Closed ticket [f76cabebfd]: xBestIndex/xFilter slight interface improvement plus 3 other changes (artifact: 3a27e2e809 user: drh)
12:50 • Closed ticket [3350da7d35]: Error: malformed database schema - near "VIRTUAL": syntax error plus 2 other changes (artifact: 51c0799189 user: drh)
12:46 • Ticket [3350da7d35]: 1 change (artifact: ae6384584f user: drh)
11:47 • Closed ticket [29ab7be99f]: Hitting NOT NULL constraint does not roll back statement transaction plus 3 other changes (artifact: 2e3bbe70ea user: dan)
10:31 • New ticket [29ab7be99f]. (artifact: b37d2263d5 user: dan)
10:06 • Ticket [3350da7d35] Error: malformed database schema - near "VIRTUAL": syntax error status still Open with 3 other changes (artifact: ad57431484 user: anonymous)
10:05 • New ticket [3350da7d35]. (artifact: 142606d87b user: anonymous)
08:09 • New ticket [f76cabebfd] xBestIndex/xFilter slight interface improvement. (artifact: 5c4161ba8f user: anonymous)
05:39 • Ticket [eaa105fe74] (...) WHERE col IN (val1) not reflected in xBestIndex status still Open with 1 other change (artifact: b2bdc0912e user: dan)
2009-09-08
22:15 • Ticket [eaa105fe74]: 6 changes (artifact: 110a50bdc0 user: drh)
21:25 • New ticket [b2d64a52a0] pkgIndex.tcl is being deleted by 'make clean' but it is not created by 'make'. (artifact: ec3afc0bb8 user: anonymous)
21:04 • New ticket [eaa105fe74] (...) WHERE col IN (val1) not reflected in xBestIndex. (artifact: 3d232dc874 user: anonymous)
2009-09-07
16:27 • Ticket [e33452c90f] Query plan doesn't use existing index status still Open with 4 other changes (artifact: d751e57bc0 user: drh)
16:20 • New ticket [e33452c90f]. (artifact: 9cf4610b27 user: anonymous)
14:43 • Fixed ticket [df2c3ad12a]: free() on unallocated memory when fts3 match phrase contains terms after "-" modifier plus 3 other changes (artifact: dfef7eddab user: dan)
2009-09-06
00:56 • Closed ticket [cbb5a315df]: Concatenating strings should be possible with a plus '+' operator plus 3 other changes (artifact: 617b297fcc user: drh)
2009-09-05
20:24 • New ticket [cbb5a315df]. (artifact: cbeb641cef user: anonymous)
2009-09-03
20:25 • New ticket [89f7b55854] RFE - Documentation in PDF format?. (artifact: 5e93da252f user: anonymous)
20:21 • New ticket [df2c3ad12a] free() on unallocated memory when fts3 match phrase contains terms after "-" modifier. (artifact: 99ab3ad4fc user: anonymous)
01:26 • Fixed ticket [2ea2425d34]: Assertion fault: Text encoding mismatch on value comparison plus 3 other changes (artifact: f0bfe8a8a5 user: drh)
00:53 • New ticket [2ea2425d34]. (artifact: f4234de905 user: drh)
2009-09-01
22:32 • New ticket [9fd0bc3663] Add a new open flag to enable shared cache for a single db connection. (artifact: 795f79c4a8 user: anonymous)
15:23 • Closed ticket [44a1b817c3]: Problem with Kaspersky Anti-Virus and SQLite plus 5 other changes (artifact: e7c0f4853a user: drh)
14:40 • New ticket [44a1b817c3]. (artifact: ee3bd144c8 user: anonymous)
2009-08-28
07:38 • Ticket [97214a34d8] Use of os2MutexNotheld before their definition status still Open with 3 other changes (artifact: 47304d7d08 user: anonymous)
07:35 • New ticket [97214a34d8]. (artifact: ff4d77053c user: anonymous)
2009-08-27
15:40 • Ticket [03b198a2fa] Getting several warnings when compiling in eVC++ 4 status still Open with 3 other changes (artifact: 92f927a83a user: drh)
15:19 • New ticket [03b198a2fa]. (artifact: 7c455645c8 user: anonymous)
2009-08-26
11:43 • Ticket [991789d9f3] ext/fts? code uses tolower() when parsing tokens, which is problematic when using certain locales, such as tr_TR.UTF-8. status still Open with 1 other change (artifact: 40da50a042 user: drh)
11:21 • Ticket [4b81075908] In mult-thread that have a problem of updata lost status still Open with 3 other changes (artifact: 2d58cf016f user: drh)
06:24 • New ticket [4b81075908]. (artifact: f8dc74a388 user: anonymous)
03:42 • Ticket [991789d9f3] ext/fts? code uses tolower() when parsing tokens, which is problematic when using certain locales, such as tr_TR.UTF-8. status still Open with 3 other changes (artifact: 0809a3743d user: anonymous)
03:36 • New ticket [991789d9f3]. (artifact: 4dddce6084 user: anonymous)
2009-08-24
12:17 • Closed ticket [d2b46cfc75]: sqlite3BitvecClear will clear all bit in aHash when iSize>BITVEC_NBIT plus 2 other changes (artifact: 8c4fdfeafd user: drh)
11:26 • Ticket [d2b46cfc75]: 3 changes (artifact: 95acdeb130 user: drh)
06:19 • New ticket [d2b46cfc75]. (artifact: a6abe734e0 user: anonymous)
05:53 • New ticket [2c5661c26a] Thread safety: does SQLite handle pthread_cancel cleanly?. (artifact: 4bfa031fcd user: anonymous)
01:37 • Fixed ticket [efc02f9779]: Trigger creation order affects query correctness plus 2 other changes (artifact: b60050895a user: drh)
00:24 • Ticket [efc02f9779]: 1 change (artifact: 9c473ca63f user: drh)
00:21 • Ticket [efc02f9779]: 1 change (artifact: ab46aeb224 user: drh)
2009-08-23
21:36 • Ticket [efc02f9779]: 3 changes (artifact: 58e20de13a user: drh)
20:36 • New ticket [efc02f9779]. (artifact: a0f7713912 user: anonymous)
2009-08-21
18:39 • New ticket [43db771bb2] Sqlite shell prints some error messages to stdout. (artifact: 9c82dc93b1 user: anonymous)
12:24 • Ticket [2fd50fa665] cygwin-1.7 support: winFullPathname status still Open with 1 other change (artifact: c4691a53d9 user: drh)
08:37 • Closed ticket [fc6f41426b]: update primary key failure plus 5 other changes (artifact: 6c207e1ad7 user: dan)
07:40 • Ticket [2fd50fa665] cygwin-1.7 support: winFullPathname status still Open with 3 other changes (artifact: 121d68a6c3 user: anonymous)
07:20 • New ticket [2fd50fa665]. (artifact: d43afa7549 user: anonymous)
2009-08-19
15:22 • Ticket [92c5deed07] FTS3 bug with multiple terms for exclusion status still Closed with 1 other change (artifact: a0e3345c24 user: drh)
15:21 • Fixed ticket [93fb9f89d6]: Index causes incorrect WHERE clause evaluation plus 3 other changes (artifact: 10bc68257e user: drh)
14:52 • Closed ticket [92c5deed07]: FTS3 bug with multiple terms for exclusion plus 2 other changes (artifact: ad3f5f6fc3 user: dan)
11:53 • New ticket [1248e6cda8] Insufficient precision of sqlite3_column_text16() for floating point values. (artifact: 0c1aeaa6f8 user: anonymous)
2009-08-18
23:08 • Ticket [92c5deed07] FTS3 bug with multiple terms for exclusion status still Open with 3 other changes (artifact: cb9aab0a51 user: anonymous)
23:07 • New ticket [92c5deed07]. (artifact: 0085a5c0d8 user: anonymous)
16:13 • Ticket [2d401a9428] Segfault on unknown SQL function status still Fixed with 1 other change (artifact: 0c0326a352 user: drh)
16:12 • Fixed ticket [2d401a9428]. (artifact: a3479931fc user: drh)
16:01 • New ticket [2d401a9428]. (artifact: 65da304369 user: drh)
03:22 • New ticket [fc6f41426b] update primary key failure. (artifact: 9a3f3e0325 user: anonymous)
2009-08-17
11:55 • Ticket [7d96113ff0] SQLite fails to build when TCL isn't installed status still Open with 1 other change (artifact: 24d082f8c4 user: anonymous)
2009-08-16
18:03 • Ticket [7d96113ff0]: 3 changes (artifact: 04ba10c92a user: drh)
02:34 • New ticket [7d96113ff0]. (artifact: 9261cc55b6 user: anonymous)
2009-08-13
16:43 • New ticket [93fb9f89d6] Index causes incorrect WHERE clause evaluation. (artifact: 235ce406de user: drh)
15:19 • Ticket [c25aab7e7e] The ".import" command does not parse CSV correctly. status still Open with 5 other changes (artifact: 1dae0db427 user: drh)
14:01 • New ticket [c25aab7e7e]. (artifact: 00da186adb user: anonymous)