SQLite

Timeline
Login

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

100 ticket changes occurring around ad15486022209205.

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)