SQLite

Timeline
Login

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

100 ticket changes occurring around 213c61cb82d4ee51.

2018-01-27
04:43 Ticket [ec32177c99] Incorrect result with complex OR-connected WHERE and STAT4 status still Open with 6 other 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)