SQLite

Timeline
Login

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

100 ticket changes occurring around 4a01880b62706c12.

2017-08-24
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)
2017-08-11
18:42 New ticket [88af8923] . (artifact: 180b8717 user: anonymous)
2017-08-01
19:53 Fixed ticket [cb91bf42]: Assertion fault following PRAGMA reverse_unordered_selects=ON plus 5 other changes (artifact: 1e861ce0 user: drh)
18:21 New ticket [cb91bf42]. (artifact: b9784104 user: drh)
2017-07-31
16:42 Fixed ticket [de3403bf]: Column name shift due to LEFT JOIN query flattening plus 3 other changes (artifact: 726bbd38 user: drh)
11:26 Fixed ticket [bc115541]: Assertion fault on a dodgy CREATE TABLE statement using WITHOUT ROWID plus 5 other changes (artifact: 3f6c11e5 user: drh)
2017-07-30
18:25 New ticket [bc115541]. (artifact: 23e3c07e user: drh)
2017-07-29
17:47 Ticket [de3403bf] Column name shift due to LEFT JOIN query flattening status still Open with 6 other changes (artifact: 84cc8ca4 user: drh)
03:26 New ticket [de3403bf]. (artifact: e6b7df69 user: drh)
2017-07-21
19:33 Fixed ticket [ce68383b]: Incorrect LEFT JOIN result with IS operator in WHERE clause and auto-index plus 5 other changes (artifact: 6637feea user: drh)
2017-07-18
16:57 New ticket [ce68383b]. (artifact: 4776331e user: drh)
2017-07-15
20:38 Fixed ticket [a4e06e75]: False-positive from "PRAGMA integrity_check" plus 6 other changes (artifact: d02faf27 user: drh)
19:32 New ticket [a4e06e75]. (artifact: 1cd21727 user: drh)
2017-06-27
23:36 Fixed ticket [b9f01010]: Violation of the Query Planner Stability Guarantee plus 3 other changes (artifact: 29856781 user: drh)
2017-06-23
19:38 Ticket [b9f01010]: 6 changes (artifact: ecf53365 user: drh)
19:21 New ticket [b9f01010]. (artifact: 81c613f2 user: drh)
2017-06-20
18:13 Fixed ticket [892fc34f]: Incorrect query result when a LEFT JOIN subquery is flattened plus 5 other changes (artifact: 879fcac8 user: drh)
16:15 New ticket [892fc34f]. (artifact: d28d6544 user: drh)
2017-06-13
03:55 New ticket [cfa2c908] Assertion fault in STAT4 on a double-negation. (artifact: bea44233 user: drh)
2017-06-08
13:10 Fixed ticket [fda22108]: Corruption due to REPLACE in an auto-vacuumed database plus 3 other changes (artifact: eee8ce59 user: drh)
11:08 Ticket [fda22108]: 6 changes (artifact: 7b1cb0c7 user: drh)
11:07 New ticket [fda22108]. (artifact: 548c43a8 user: drh)
2017-05-25
16:28 Fixed ticket [7fde638e]: Assertion fault on a LEFT JOIN plus 5 other changes (artifact: f6f681e5 user: drh)
2017-05-24
22:39 New ticket [7fde638e]. (artifact: dcc0914b user: drh)
2017-05-23
19:16 Fixed ticket [cad1ab4c]: Segfault due to LEFT JOIN flattening optimization plus 3 other changes (artifact: 83102567 user: drh)
15:18 Open ticket [cad1ab4c]. (artifact: f952f397 user: drh)
15:18 Ticket [cad1ab4c]: 3 changes (artifact: 49dcb66a user: drh)
12:35 Ticket [cad1ab4c]: 3 changes (artifact: 88096b0c user: drh)
01:29 Fixed ticket [cad1ab4c]. (artifact: b4ade83b user: drh)
01:17 New ticket [cad1ab4c]. (artifact: 6e17327e user: drh)
2017-05-01
18:35 Fixed ticket [f68dc596]: Database corruption on REPLACE with a mix of NULL and non-NULL rowids. plus 5 other changes (artifact: f8f6c4c1 user: drh)
18:09 New ticket [f68dc596]. (artifact: 784838a8 user: drh)
2017-04-24
14:57 Closed ticket [61fe9745]: Duplicate result using an IN operator in the WHERE clause plus 6 other changes (artifact: 3998d56c user: dan)
13:49 New ticket [61fe9745]. (artifact: dde67a53 user: drh)
2017-04-11
18:55 Fixed ticket [981329ad]: Stack overflow while parsing deeply nested JSON plus 5 other changes (artifact: 86a95386 user: drh)
18:09 New ticket [981329ad]. (artifact: 85802dae user: drh)
2017-04-10
12:25 Fixed ticket [6c9b5514]: JSON allows unescaped control characters in strings plus 5 other changes (artifact: a2343249 user: drh)
12:14 New ticket [6c9b5514]. (artifact: e6bb692a user: drh)
2017-04-08
18:18 Fixed ticket [b93be872]: JSON extension accepts invalid numeric values plus 5 other changes (artifact: 39c0f43a user: drh)
17:54 New ticket [b93be872]. (artifact: 72ad25bf user: drh)
2017-03-24
19:14 Fixed ticket [06796225]: Crash in recursive invocation of a trigger that uses an ephemeral table plus 3 other changes (artifact: 7a87396c user: drh)
15:55 Ticket [06796225]: 6 changes (artifact: c5faf531 user: drh)
15:45 New ticket [06796225]. (artifact: a9dc7f75 user: dan)
2017-03-02
23:41 Fixed ticket [6097cb92]: Broken 'start of day' modifier on date/time functions plus 5 other changes (artifact: 451609e4 user: drh)
23:20 New ticket [6097cb92]. (artifact: dc7e78fb user: drh)
2017-02-11
14:58 Fixed ticket [eb703ba7]: Incorrect result using index on expression with collating function plus 5 other changes (artifact: d0eb9fbf user: drh)
04:07 New ticket [eb703ba7]. (artifact: d008a3ff user: drh)
2017-01-25
19:04 Fixed ticket [e6e962d6]: sqlite3_blob_reopen() misbehavior on ALTER-ed table plus 5 other changes (artifact: 3850384c user: drh)
04:28 New ticket [e6e962d6]. (artifact: a6d71ce7 user: drh)
2017-01-16
18:10 Fixed ticket [7ffd1ca1]: Incorrect affinity when using automatic indexes plus 5 other changes (artifact: d60e4194 user: drh)
15:10 New ticket [7ffd1ca1]. (artifact: 9ce8b972 user: drh)
2017-01-10
17:46 Fixed ticket [25e335f8]: Incorrect result when ON clause refers to table to the right plus 4 other changes (artifact: 70ac38b2 user: drh)
17:19 Ticket [25e335f8]: 6 changes (artifact: b5f4cd32 user: drh)
17:15 New ticket [25e335f8]. (artifact: 464fffdc user: drh)
2017-01-05
17:38 Fixed ticket [190c2507]: Assertion fault on a query against a view plus 5 other changes (artifact: db3c58de user: drh)
16:34 New ticket [190c2507]. (artifact: 5c889138 user: drh)
14:23 Fixed ticket [30027b61]: DELETE trigger on WITHOUT ROWID table not fired for REPLACE op plus 4 other changes (artifact: 8389ee53 user: drh)
2017-01-04
21:26 Ticket [30027b61]: 6 changes (artifact: 53472fbe user: drh)
19:12 New ticket [30027b61]. (artifact: b5b5fd5d user: dan)
2017-01-03
13:37 Fixed ticket [8c9458e7]: row-value updates in triggers do not work. plus 5 other changes (artifact: 0395bbea user: drh)
2017-01-02
21:40 New ticket [8c9458e7]. (artifact: 2e02cb7e user: drh)
2016-12-01
23:37 Fixed ticket [2df0107b]: Incorrect result from LEFT JOIN with a subquery on the LHS plus 3 other changes (artifact: 546ccb21 user: drh)
19:34 Ticket [2df0107b]: 6 changes (artifact: a1238592 user: drh)
19:11 New ticket [2df0107b]. (artifact: 944f716f user: drh)
2016-11-24
00:00 Fixed ticket [1a684656]: Assertion fault on a conditional row-value expression plus 5 other changes (artifact: ddff0332 user: drh)
2016-11-23
23:59 Fixed ticket [da784137]: Query flattening causes bad byte-code for a vector IN operator plus 5 other changes (artifact: 10c82825 user: drh)
23:49 Fixed ticket [199df416]: Different answer with and without index on IN operator with type mismatch plus 3 other changes (artifact: d6505cbd user: drh)
18:36 New ticket [1a684656] Assertion fault on a conditional row-value expression. (artifact: 2564b3cd user: drh)
2016-11-17
05:51 New ticket [da784137] Query flattening causes bad byte-code for a vector IN operator. (artifact: ddc2e187 user: drh)
2016-11-11
03:40 Fixed ticket [2f1b168a]: Crash following syntax error on DETACH plus 5 other changes (artifact: 0a7d72a5 user: drh)
03:36 New ticket [2f1b168a]. (artifact: e12fe9da user: drh)
2016-10-27
01:08 Fixed ticket [fef4bb4b]: Incorrect result from a LEFT JOIN with a row-value constraint plus 5 other changes (artifact: 9eee2c5f user: drh)
00:27 New ticket [fef4bb4b]. (artifact: b2735a64 user: drh)
2016-10-26
16:05 Closed ticket [34a57914]: Incorrect results with OR terms in the ON clause of a LEFT JOIN plus 3 other changes (artifact: eecf570b user: dan)
16:05 Ticket [34a57914]: 6 changes (artifact: 0155188b user: drh)
15:39 New ticket [34a57914]. (artifact: 79f8ae17 user: dan)
2016-10-12
15:35 Fixed ticket [96c1454c]: Incorrect result with ORDER BY DESC and LIMIT (again) plus 5 other changes (artifact: a2a682f9 user: drh)
14:00 New ticket [96c1454c]. (artifact: e3b3158e user: drh)
2016-10-10
14:38 Closed ticket [4766f444]: ORDER BY handling with indexes on expressions plus 6 other changes (artifact: 498d1d7a user: dan)
14:20 New ticket [4766f444]. (artifact: 4860a299 user: dan)
14:18 Fixed ticket [4baa4649]: NULL handling for indexes on expressions plus 5 other changes (artifact: 415f43e7 user: drh)
13:05 New ticket [4baa4649]. (artifact: 976f36f6 user: drh)
2016-10-03
02:59 Fixed ticket [7b332808]: AUTOINCREMENT problem with the INSERT xfer optimization plus 5 other changes (artifact: 509f81f3 user: drh)
02:01 New ticket [7b332808]. (artifact: 5a826871 user: drh)
2016-09-20
22:04 Fixed ticket [1ec41379]: Integer multiple fails to overflow to floating-point plus 5 other changes (artifact: db310877 user: drh)
20:33 New ticket [1ec41379]. (artifact: 6af4ab88 user: drh)
2016-09-16
17:07 Fixed ticket [0eab1ac7]: O(N*N) behavior where it should be O(N) plus 3 other changes (artifact: 8da4f274 user: drh)
14:30 Ticket [0eab1ac7]: 6 changes (artifact: 9aab0ed9 user: drh)
13:57 New ticket [0eab1ac7]. (artifact: 62ca7f9b user: drh)
2016-09-07
01:56 Fixed ticket [0c4df461]: Incorrect result with ORDER BY DESC and LIMIT plus 5 other changes (artifact: 1f53b3e5 user: drh)