SQLite

Timeline
Login

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

100 ticket changes occurring around 68eac74874d06463.

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)
00:42 New ticket [0c4df461]. (artifact: 51389ac4 user: drh)
2016-09-03
15:24 Ticket [199df416] Different answer with and without index on IN operator with type mismatch status still Open with 6 other changes (artifact: 6a413497 user: drh)
14:19 New ticket [199df416]. (artifact: 21640ea6 user: drh)
2016-08-26
12:01 Fixed ticket [ef360601]: Incorrect affinity transformations on DELETE plus 5 other changes (artifact: 06aa3be5 user: drh)
05:17 New ticket [ef360601]. (artifact: 21b6b00b user: drh)
2016-07-26
04:24 Fixed ticket [a0bac8b3]: CREATE INDEX changes the answer plus 3 other changes (artifact: 17eb1530 user: drh)
04:21 Ticket [a0bac8b3]: 6 changes (artifact: af44096d user: drh)
03:31 New ticket [a0bac8b3]. (artifact: f4aacbb6 user: drh)
2016-07-14
19:13 Fixed ticket [f68bf685]: ALTER TABLE corrupts DESC indexes plus 5 other changes (artifact: 50bb45fa user: drh)
18:46 New ticket [f68bf685]. (artifact: 2db52790 user: drh)
2016-07-01
20:12 Fixed ticket [e8d439c7]: Crash on transitive WHERE constraint and undefined collation plus 6 other changes (artifact: b9baf11a user: drh)
20:08 New ticket [e8d439c7]. (artifact: 647e33df user: drh)
2016-05-06
16:49 Fixed ticket [16c9801c]: Segfault on DELETE with WHERE containing OR plus 3 other changes (artifact: 809d005f user: drh)
16:05 Ticket [16c9801c]: 3 changes (artifact: 387d6abf user: drh)
14:33 Ticket [16c9801c]: 3 changes (artifact: bbb174fc user: drh)
03:56 Ticket [16c9801c]: 6 changes (artifact: 35b41059 user: drh)
03:26 New ticket [16c9801c]. (artifact: 79eb5be6 user: drh)
2016-05-02
13:46 Fixed ticket [dc6ebeda]: Incorrect DELETE due to the one-pass optimization plus 6 other changes (artifact: d9f4aeb0 user: drh)
12:00 New ticket [dc6ebeda]. (artifact: 16a4e843 user: drh)
2016-04-25
02:20 Fixed ticket [f7f8c97e]: Valid query fails to compile due to WHERE clause optimization plus 5 other changes (artifact: c320a9dd user: drh)
01:43 New ticket [f7f8c97e]. (artifact: 1db949b0 user: drh)
2016-04-18
15:58 Fixed ticket [7d7525cb]: Compatibility break on INTEGER PRIMARY KEY columns. plus 5 other changes (artifact: 7d322fdd user: drh)
15:24 New ticket [7d7525cb]. (artifact: b61cd89a user: drh)
2016-04-09
17:20 Fixed ticket [a306e56f]: Failed DELETE with PRAGMA reverse_unordered_selects plus 5 other changes (artifact: dd06e22d user: drh)
16:31 New ticket [a306e56f]. (artifact: 66083a64 user: drh)
2016-04-07
21:14 Fixed ticket [7f7f8026]: Segfault following heavy SAVEPOINT usage plus 3 other changes (artifact: c9b6953f user: drh)
21:07 Ticket [7f7f8026]: 3 changes (artifact: 26ac4c61 user: drh)
20:54 Ticket [7f7f8026]: 6 changes (artifact: 282da264 user: drh)
18:31 New ticket [7f7f8026]. (artifact: af77e034 user: drh)
2016-03-09
15:09 Fixed ticket [5e3c8867]: Correlated subquery on the RHS of an IN operator plus 5 other changes (artifact: f54cb735 user: drh)
14:48 New ticket [5e3c8867]. (artifact: ada44cb0 user: drh)
2016-02-19
18:55 Ticket [dc9b1c91] One trigger may use auxdata belonging to another. status still Closed with 3 other changes (artifact: c1b47ba6 user: dan)
18:55 Closed ticket [dc9b1c91]. (artifact: 0395b295 user: dan)
18:55 Ticket [dc9b1c91]: 6 changes (artifact: 0bea5f1c user: dan)
17:22 New ticket [dc9b1c91]. (artifact: 018bf9a3 user: dan)
2016-02-09
14:12 Fixed ticket [d06a25c8]: Incorrect result from a UNION with an ORDER BY plus 6 other changes (artifact: 1ef35260 user: drh)
2016-02-08
22:22 New ticket [d06a25c8]. (artifact: 46852019 user: drh)
2016-02-04
10:28 Fixed ticket [ad2559db]: JSON does not properly escape control characters plus 5 other changes (artifact: 0134f388 user: drh)
10:14 New ticket [ad2559db]. (artifact: 9f98f001 user: drh)
2016-01-30
14:54 Fixed ticket [f45ac567]: Invalid JSON generated by json_group_array() plus 7 other changes (artifact: 627a0c62 user: drh)
13:56 New ticket [f45ac567]. (artifact: 7ebe8f73 user: drh)
2016-01-20
14:25 Fixed ticket [80369edd]: Incorrect case folding in the LIKE operator plus 5 other changes (artifact: db994bd6 user: drh)
14:07 New ticket [80369edd]. (artifact: b3016558 user: drh)
2016-01-13
17:50 Fixed ticket [cb3aa064]: Incorrect result from a subquery containing over-constrainted ORDER BY plus 3 other changes (artifact: bcde10d8 user: drh)
15:21 Ticket [cb3aa064]: 6 changes (artifact: 5d76babb user: drh)
15:00 New ticket [cb3aa064]. (artifact: ac020a73 user: drh)
2015-11-24
02:10 Fixed ticket [e5c6268d]: Assertion fault on DISTINCT query containing a correlated aggregate. plus 5 other changes (artifact: 16a157ae user: drh)
02:08 New ticket [e5c6268d]. (artifact: 0d68ffc0 user: drh)
2015-11-21
13:24 Fixed ticket [73eba7ba]: Table-valued function syntax allowed for ordinary tables and views plus 5 other changes (artifact: 189655c8 user: drh)
13:11 New ticket [73eba7ba]. (artifact: f2c7d781 user: drh)
2015-11-13
17:39 Fixed ticket [38a97a87]: Inaccurate int/float comparison results in corrupt index plus 5 other changes (artifact: 63470268 user: drh)
2015-11-06
00:36 New ticket [38a97a87]. (artifact: 98d1f3aa user: drh)
2015-11-01
21:19 Fixed ticket [ac661962]: Differing interpretation of historical schemas plus 5 other changes (artifact: 3ab30754 user: drh)
21:17 New ticket [ac661962]. (artifact: 8c71f535 user: drh)
2015-10-24
20:34 Ticket [8a2adec1] Problem creating automatic-indexes on sub-queries in the FROM clause of correlated scalar sub-queries status still Closed with 3 other changes (artifact: 831a2f9b user: dan)