SQLite

Timeline
Login

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

100 ticket changes occurring around 31ac8dbae4d5d3d5.

2019-03-15
16:28 Closed ticket [596d059a]: Committing a transaction with a failed ALTER TABLE may subtly corrupt schema plus 4 other changes (artifact: ffd8a4ff user: dan)
16:28 Ticket [596d059a]: 3 changes (artifact: 1a66d00d user: dan)
16:27 Ticket [596d059a]: 6 changes (artifact: 75efc5ac user: dan)
15:43 New ticket [596d059a]. (artifact: 0acc8b25 user: dan)
2019-02-23
00:21 Fixed ticket [df46dfb6]: Assertion fault in self-join with a IN constraint plus 3 other changes (artifact: 8e1fc5b8 user: drh)
2019-02-22
21:35 Fixed ticket [4feb3159]: Crash due to misuse of window functions. plus 5 other changes (artifact: 17c4d9a5 user: drh)
21:35 Open ticket [df46dfb6]: Assertion fault in self-join with a IN constraint plus 4 other changes (artifact: 0bf6d95b user: drh)
18:44 New ticket [4feb3159] Crash due to misuse of window functions.. (artifact: a24c0ec0 user: drh)
2019-02-20
12:59 Fixed ticket [df46dfb6]: Assertion fault in self-join with a IN constraint plus 6 other changes (artifact: 784f2606 user: drh)
01:39 New ticket [df46dfb6]. (artifact: 967c921b user: drh)
2019-02-08
04:20 Fixed ticket [4e8e4857]: Crash on query using an OR term in the WHERE clause plus 6 other changes (artifact: f29e381b user: drh)
03:01 New ticket [4e8e4857]. (artifact: 006561ff user: drh)
2019-02-05
14:36 Fixed ticket [5948e09b]: Incorrect result from LEFT JOIN plus 5 other changes (artifact: 5851ddcf user: drh)
13:55 New ticket [5948e09b]. (artifact: 5400ddb5 user: drh)
2019-01-25
20:09 Fixed ticket [bb4bdb9f]: Zeroblob truncated by an index on an expression plus 6 other changes (artifact: a2fbfd41 user: drh)
20:01 New ticket [bb4bdb9f]. (artifact: f81a0799 user: drh)
2019-01-09
02:04 Fixed ticket [bc8d94f0]: RENAME COLUMN fails on tables with redundant UNIQUE constraints plus 6 other changes (artifact: 95951a2b user: drh)
01:51 New ticket [bc8d94f0]. (artifact: 0894c0ac user: drh)
2019-01-01
18:03 Fixed ticket [d0866b26]: Window function in correlated subquery causes assertion fault plus 4 other changes (artifact: c01f9c32 user: drh)
13:02 Open ticket [d0866b26]. (artifact: 55b13ed5 user: drh)
2018-12-31
18:09 Fixed ticket [d0866b26]. (artifact: 0daee225 user: drh)
09:14 New ticket [d0866b26]. (artifact: 8d3fa507 user: dan)
2018-12-26
15:17 Closed ticket [43ddc85a]: ALTER TABLE fails when there is an INSTEAD-OF trigger on a VIEW plus 7 other changes (artifact: fac61f27 user: drh)
2018-12-22
01:13 Fixed ticket [e6f1f2e3]: REPLACE can insert a default NULL into a NOT NULL column plus 5 other changes (artifact: 84675e85 user: drh)
00:10 New ticket [e6f1f2e3]. (artifact: 317b6a4e user: drh)
2018-12-20
17:33 Closed ticket [50d2a6c2]: 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: b81d0560 user: dan)
17:30 New ticket [50d2a6c2]. (artifact: 065d8026 user: dan)
2018-12-14
11:17 Fixed ticket [d96eba87]: Incorrect results for OR query where both OR terms are different indexed expressions plus 3 other changes (artifact: 8279f197 user: drh)
11:00 Ticket [d96eba87]: 7 changes (artifact: 5f232414 user: drh)
07:53 New ticket [d96eba87]. (artifact: 180077be user: dan)
2018-12-08
20:30 Fixed ticket [1d958d90]: Incorrect result with NOT IN operator and partial index plus 5 other changes (artifact: 06dc40aa user: drh)
13:06 New ticket [1d958d90]. (artifact: 17e6b575 user: drh)
2018-12-07
01:56 Fixed ticket [f09fcd17]: Assertion fault when window functions are used. plus 5 other changes (artifact: d07f783f user: drh)
2018-12-06
17:17 New ticket [f09fcd17]. (artifact: f0910878 user: drh)
2018-11-09
14:18 Fixed ticket [787fa716]: Assertion fault when multi-use subquery implemented by co-routine plus 3 other changes (artifact: f1d68076 user: drh)
13:39 Ticket [787fa716]: 4 changes (artifact: 23c14e4a user: drh)
2018-11-08
22:03 Ticket [787fa716]: 3 changes (artifact: 0d3537a7 user: drh)
20:52 Ticket [787fa716]: 3 changes (artifact: 29699fe9 user: drh)
20:49 Ticket [787fa716]: 3 changes (artifact: 838f5f42 user: drh)
19:27 Ticket [787fa716]: 6 changes (artifact: 7da230dd user: drh)
15:06 New ticket [787fa716]. (artifact: 03d10343 user: drh)
2018-11-05
13:42 Fixed ticket [1a84668d]: Assertion fault due to malformed PRIMARY KEY plus 5 other changes (artifact: 4912034c user: drh)
08:09 Fixed ticket [65eb38f6]: Incorrect answer on LEFT JOIN when STAT4 is enabled plus 6 other changes (artifact: 88c47ba1 user: drh)
07:34 New ticket [65eb38f6]. (artifact: cf10feff user: drh)
2018-11-03
12:36 New ticket [1a84668d] Assertion fault due to malformed PRIMARY KEY. (artifact: 25fe2f85 user: drh)
2018-10-25
15:17 Fixed ticket [cf5ed20f]: Incorrect join result with duplicate WHERE clause constraint plus 5 other changes (artifact: a7a056a8 user: drh)
11:39 New ticket [cf5ed20f]. (artifact: 419091de user: drh)
2018-10-03
23:10 New ticket [31c6e64f] ALTER TABLE fails if a trigger references a non-existant table.. (artifact: d457452a user: drh)
15:34 New ticket [e8b67424] Query planner chooses an inefficient algorithm.. (artifact: 8b272a1b user: drh)
2018-10-02
16:45 New ticket [43ddc85a] ALTER TABLE fails when there is an INSTEAD-OF trigger of a VIEW. (artifact: c07d43a2 user: drh)
2018-09-27
20:20 Fixed ticket [69d64233]: The typeof() and length() functions fail in some virtual tables. plus 5 other changes (artifact: 8d26e66a user: drh)
20:04 New ticket [69d64233]. (artifact: 43a256c6 user: drh)
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)