SQLite

Timeline
Login

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

100 ticket changes occurring around 9e14aa14cff7ebf7.

2016-12-01
19:11 New ticket [2df0107b] Incorrect result from LEFT JOIN with a subquery on the LHS. (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)
20:34 Closed ticket [8a2adec1]. (artifact: 5529b5aa user: dan)
19:32 New ticket [8a2adec1]. (artifact: 13db9a52 user: dan)
2015-10-16
15:16 Fixed ticket [57eec374]: JSON1 accepts form-feed (char(12)) as a white-space character plus 5 other changes (artifact: c50665fe user: drh)
15:00 New ticket [57eec374]. (artifact: b6d5677b user: drh)
2015-10-06
17:27 Fixed ticket [b65cb2c8]: Incorrect LIMIT on a UNION ALL query plus 5 other changes (artifact: 3cd675c6 user: drh)
13:26 New ticket [b65cb2c8]. (artifact: b4cd8e8a user: drh)
2015-09-30
14:06 Fixed ticket [1b266395]: INSERT OR REPLACE with a foreign key constraint leads to assertion fault plus 3 other changes (artifact: b42dc371 user: drh)
12:36 Ticket [1b266395]: 6 changes (artifact: f0a3eedd user: drh)
12:10 New ticket [1b266395]. (artifact: 7f88fd96 user: drh)
2015-09-09
13:28 Fixed ticket [acd12990]: CREATE TABLE AS fails with a false report of database corruption plus 5 other changes (artifact: b2d6502f user: drh)
12:34 New ticket [acd12990]. (artifact: 16828871 user: drh)
2015-08-22
01:32 Fixed ticket [c2a19d81]: Incorrect LEFT JOIN when FROM clause contains nested subqueries plus 5 other changes (artifact: 05ca3244 user: drh)
2015-08-21
23:25 New ticket [c2a19d81]. (artifact: 7b645a97 user: drh)
2015-07-23
16:41 Fixed ticket [8fd39115]: assertion fault on WITHOUT ROWID query using the OR optimization plus 7 other changes (artifact: 4bd51eb9 user: drh)
14:27 New ticket [8fd39115]. (artifact: d63541a5 user: drh)
2015-06-18
14:33 Fixed ticket [5f60b11f]: likely() function in the ON clause of a LEFT JOIN results in incorrect result plus 5 other changes (artifact: f317e943 user: drh)
14:31 New ticket [5f60b11f]. (artifact: dd11c3b0 user: drh)
2015-06-16
16:39 Fixed ticket [873cae2b]: Schema corruption after aborted CREATE TABLE AS plus 5 other changes (artifact: 8c915fd4 user: drh)