SQLite

Timeline
Login

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

100 ticket changes occurring around d75e67654aa9620b.

2018-09-27
13:02 Fixed ticket [e8275b41]: Assertion fault from window function inside of recursive CTE plus 5 other changes (artifact: 8e72ee7c user: drh)
11:03 New ticket [e8275b41]. (artifact: 0d057e12 user: drh)
2018-09-24
14:11 Fixed ticket [f25d5cee]: INTEGER PRIMARY KEY WITHOUT ROWID virtual table crash plus 5 other changes (artifact: b01c7b39 user: drh)
14:10 New ticket [f25d5cee]. (artifact: 0f28c7fc user: drh)
2018-09-17
15:30 Fixed ticket [510cde27]: Endless loop on a query with window functions, ORDER BY, and LIMIT plus 5 other changes (artifact: c0db9c39 user: drh)
15:29 Fixed ticket [b41031ea]: ALTER TABLE returns an error on certain schemas plus 3 other changes (artifact: fea593b6 user: drh)
14:28 New ticket [510cde27] Endless loop on a query with window functions, ORDER BY, and LIMIT. (artifact: 614870a8 user: drh)
2018-09-16
20:33 Ticket [b41031ea] ALTER TABLE returns an error on certain schemas status still Open with 3 other changes (artifact: 90eeaef7 user: drh)
20:33 Ticket [b41031ea]: 6 changes (artifact: e331b118 user: drh)
20:03 New ticket [b41031ea]. (artifact: 65efc0dd user: drh)
2018-09-10
14:49 Fixed ticket [9936b2fa]: Infinite loop due to the ORDER BY LIMIT optimization plus 3 other changes (artifact: 7fafa41f user: drh)
12:41 Fixed ticket [c94369ca]: Wrong answer due to the LIKE optimization plus 3 other changes (artifact: 0606ed8e user: drh)
10:16 Ticket [c94369ca]: 6 changes (artifact: 9aeb839f user: drh)
2018-09-09
10:46 New ticket [c94369ca]. (artifact: ffd4cb43 user: drh)
2018-09-08
17:43 Ticket [9936b2fa] Infinite loop due to the ORDER BY LIMIT optimization status still Open with 6 other changes (artifact: 959f3745 user: dan)
03:22 New ticket [9936b2fa]. (artifact: 9b89fdd3 user: drh)
2018-08-14
15:13 Fixed ticket [908f0014]: UPSERT does not work like PostgreSQL plus 3 other changes (artifact: d55756a6 user: drh)
11:06 Ticket [908f0014]: 6 changes (artifact: c781e55d user: drh)
11:01 New ticket [908f0014]. (artifact: 3f51aa1a user: drh)
2018-07-24
22:02 Fixed ticket [c694113e]: Unnecessary ABORT with unhelpful error message plus 5 other changes (artifact: 21658c4e user: drh)
20:57 New ticket [c694113e]. (artifact: b1a19bff user: drh)
2018-07-11
13:37 Fixed ticket [79cad5e4]: UPSERT results in a corrupt database plus 4 other changes (artifact: 2f1cb386 user: drh)
12:50 Ticket [79cad5e4]: 3 changes (artifact: 131ac5b2 user: drh)
12:12 Ticket [79cad5e4]: 6 changes (artifact: bea01e21 user: drh)
12:11 New ticket [79cad5e4]. (artifact: 151ec237 user: drh)
2018-06-11
18:07 Fixed ticket [c2432ef9]: Assertion fault due to column cache malfunction plus 5 other changes (artifact: fe1c1495 user: drh)
11:14 New ticket [c2432ef9]. (artifact: de9d04b2 user: drh)
2018-06-07
15:23 Fixed ticket [7be932df]: Adverse interaction between .stats and .eqp in the CLI plus 5 other changes (artifact: 07775835 user: drh)
15:11 New ticket [7be932df]. (artifact: facdb8d3 user: drh)
2018-05-23
17:53 Fixed ticket [d8dc2b3a]: Crash when the schema for sqlite_sequence is corrupt plus 5 other changes (artifact: de111d9d user: drh)
15:28 New ticket [d8dc2b3a]. (artifact: 82d3a7b3 user: drh)
2018-05-08
23:20 Fixed ticket [e63a34a0]: Incorrectly formatted output for the ".fullschema" command in the CLI plus 5 other changes (artifact: cbaa390e user: drh)
23:15 New ticket [e63a34a0]. (artifact: b316ee8e user: drh)
2018-04-26
15:50 Fixed ticket [d85fffd6]: VDBE program uses an expired value plus 3 other changes (artifact: 678425b1 user: drh)
15:07 Ticket [d85fffd6]: 6 changes (artifact: 9d7dfa45 user: drh)
12:45 New ticket [d85fffd6]. (artifact: 4af45294 user: drh)
2018-04-24
17:34 Fixed ticket [4ba5abf6]: Index on expression leads to an incorrect LEFT JOIN plus 5 other changes (artifact: f7d169fc user: drh)
14:42 Fixed ticket [7fa80496]: Incorrect result on a LEFT JOIN when using an index plus 5 other changes (artifact: d10434c3 user: drh)
14:30 New ticket [4ba5abf6] Index on expression leads to an incorrect LEFT JOIN. (artifact: e5a141f8 user: drh)
12:48 New ticket [7fa80496] Incorrect result on a LEFT JOIN when using an index. (artifact: 66d12dea user: drh)
2018-04-10
12:20 Fixed ticket [1e39b966]: LEFT JOIN strength reduction optimization causes an error. plus 5 other changes (artifact: f7116625 user: drh)
12:20 Fixed ticket [fac496b6]: Over-aggressive LEFT JOIN optimization on virtual tables plus 3 other changes (artifact: 57618283 user: drh)
12:05 New ticket [1e39b966] LEFT JOIN strength reduction optimization causes an error.. (artifact: 99d5851c user: drh)
2018-04-09
15:58 Fixed ticket [2b8aed9f]: Misbehavior in the FTS5 xBestIndex method plus 5 other changes (artifact: 89584454 user: drh)
14:20 New ticket [2b8aed9f]. (artifact: e5d67080 user: drh)
2018-04-06
12:55 Fixed ticket [093420fc]: Virtual Machine references an uninitialized register plus 5 other changes (artifact: 31842ae5 user: drh)
2018-04-05
11:47 New ticket [093420fc]. (artifact: 4524671d user: drh)
2018-04-03
14:37 Ticket [fac496b6] Over-aggressive LEFT JOIN optimization on virtual tables status still Open with 5 other changes (artifact: 2466fb91 user: drh)
13:38 Ticket [fac496b6]: 6 changes (artifact: eedbb46e user: drh)
12:48 New ticket [fac496b6]. (artifact: fd18820b user: drh)
2018-02-26
15:28 Fixed ticket [36fae083]: Inconsistent interpretation of truth plus 6 other changes (artifact: 9eea4013 user: drh)
15:14 New ticket [36fae083]. (artifact: a9d7468c user: drh)
2018-02-13
19:16 Fixed ticket [f484b65f]: Incorrect result from row-value comparison in WHERE clause plus 6 other changes (artifact: 79ae33f7 user: drh)
18:05 New ticket [f484b65f]. (artifact: e19d6906 user: drh)
16:35 Fixed ticket [d6ec09ec]: Assertion fault in FTS4 plus 5 other changes (artifact: 3f87a311 user: drh)
16:12 New ticket [d6ec09ec]. (artifact: e62a329a user: drh)
2018-02-01
16:17 Fixed ticket [34363494]: Index on expression goes corrupt from valid SQL plus 6 other changes (artifact: fb519404 user: drh)
00:08 New ticket [34363494]. (artifact: bc6f47b3 user: drh)
2018-01-27
13:56 Fixed ticket [ec32177c]: Incorrect result with complex OR-connected WHERE and STAT4 plus 3 other changes (artifact: 83c4e1e2 user: drh)
04:43 Ticket [ec32177c]: 6 changes (artifact: f5d59ef0 user: drh)
04:10 New ticket [ec32177c]. (artifact: 014b0310 user: drh)
2018-01-26
23:48 Fixed ticket [80177f0c]: Incorrect result when join condition uses a table-valued function plus 5 other changes (artifact: ca393f73 user: drh)
22:26 New ticket [80177f0c]. (artifact: 8e86e0cc user: drh)
2018-01-23
18:00 Fixed ticket [7310e2fb]: Valid row-value syntax is rejected plus 6 other changes (artifact: e1e0573a user: drh)
17:59 New ticket [7310e2fb]. (artifact: f3e9ec99 user: drh)
2018-01-16
13:50 Fixed ticket [47b2581a]: Infinite loop on UPDATE plus 5 other changes (artifact: ceefd4de user: drh)
12:54 New ticket [47b2581a]. (artifact: 0e79b53b user: drh)
2018-01-02
18:11 Fixed ticket [dc3f932f]: Assertion fault doing a REPLACE with index on an expression. plus 5 other changes (artifact: c50c85c7 user: drh)
17:40 New ticket [dc3f932f]. (artifact: efd28bca user: drh)
2017-12-23
12:34 Fixed ticket [3b445007]: Inconsistent column names plus 3 other changes (artifact: 549aa631 user: drh)
2017-12-22
19:36 Ticket [3b445007]: 6 changes (artifact: 19200663 user: drh)
19:28 New ticket [3b445007]. (artifact: 6ebc7575 user: drh)
2017-12-13
18:02 Fixed ticket [123c9ba3]: Incorrect result when an index is used for an ordered join plus 5 other changes (artifact: fa2161e1 user: drh)
16:33 New ticket [123c9ba3]. (artifact: da421d67 user: drh)
2017-11-26
00:49 Fixed ticket [d4beea16]: DELETE with a LIMIT does not work for WITHOUT ROWID tables plus 5 other changes (artifact: e11d4c75 user: drh)
2017-11-23
00:48 Fixed ticket [ef931875]: Incorrect result due to the skip-ahead-distinct optimization plus 3 other changes (artifact: 8331c214 user: drh)
00:16 Ticket [ef931875]: 6 changes (artifact: 0dfce830 user: drh)
2017-11-21
15:19 New ticket [ef931875]. (artifact: 00f210e1 user: drh)
2017-11-08
22:39 New ticket [d4beea16] DELETE with a LIMIT does not work for WITHOUT ROWID tables. (artifact: ae6f207a user: drh)
2017-11-06
12:04 Ticket [aa98619a] Assertion fault on an IN operator using a constant index status still Fixed with 3 other changes (artifact: 9ee09f8b user: dan)
12:01 Ticket [aa98619a]: 3 changes (artifact: a4182e93 user: dan)
2017-10-10
13:37 Fixed ticket [e651b134]: DROP TABLE fails for WITHOUT ROWID tables an SQLITE_OMIT_AUTOVACUUM plus 5 other changes (artifact: 814c1b73 user: drh)
13:36 New ticket [e651b134]. (artifact: b70e09fd user: drh)
2017-09-11
23:55 Fixed ticket [cfa2c908]: Assertion fault in STAT4 on a double-negation plus 5 other changes (artifact: 1f00b87e user: drh)
23:47 Fixed ticket [b899b604]: Segfault on correlated subquery on the RHS of an IN operator in the WHERE clause plus 5 other changes (artifact: b9905e14 user: drh)
2017-09-03
23:27 New ticket [b899b604]. (artifact: 95580e0c user: drh)
2017-08-28
11:13 Fixed ticket [02f0f4c5]: The ".dump" comman crashes following PRAGMA empty_result_callbacks=1 plus 5 other changes (artifact: c54498ab user: drh)
10:57 New ticket [02f0f4c5]. (artifact: db4451b8 user: drh)
2017-08-24
14:25 Closed ticket [88af8923]: plus 5 other changes (artifact: a7d394dc user: drh)
13:55 Fixed ticket [7486aa54]: Assertion fault caused by sqlite3_result_pointer() plus 5 other changes (artifact: 9747bf48 user: drh)
13:45 New ticket [7486aa54]. (artifact: ace65a0c user: drh)
2017-08-18
13:25 Fixed ticket [e20dd54a]: COLLATE sequence for ORDER/GROUP BY ignored when using an index-on-expression plus 3 other changes (artifact: 56c729e7 user: drh)
10:27 Ticket [e20dd54a]: 6 changes (artifact: ab63b0fa user: dan)
07:14 New ticket [e20dd54a]. (artifact: 752ae671 user: dan)
2017-08-17
14:48 Fixed ticket [be436a7f]: Use-after-free on schema change where RTREE is used inside of a trigger plus 5 other changes (artifact: f77fb5a0 user: drh)
02:25 New ticket [be436a7f]. (artifact: 580eefd3 user: drh)
2017-08-14
14:53 Fixed ticket [aa98619a]: Assertion fault on an IN operator using a constant index plus 5 other changes (artifact: a39886d0 user: drh)
14:44 Closed ticket [8897054d]: lsm1 does not overwrite values for duplicate keys plus 5 other changes (artifact: 58f8ad3c user: drh)
14:02 New ticket [8897054d]. (artifact: a4e8662c user: anonymous)
12:52 New ticket [aa98619a] Assertion fault on an IN operator using a constant index. (artifact: ce951f50 user: drh)