Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 most recent ticket changes
|
2019-04-19
| ||
| 18:23 | • Fixed ticket [f00d7b65]: ALTER TABLE corrupts the schema for tables that start with "sqlite" plus 5 other changes artifact: c58968e5 user: drh | |
| 16:26 | • New ticket [f00d7b65]. artifact: dacc8af2 user: drh | |
|
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 | |