SQLite

Timeline
Login

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

100 ticket changes occurring around c490bfb150c66763.

2016-05-06
03:26 New ticket [16c9801c] Assertion fault on DELETE. (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)
16:27 New ticket [873cae2b]. (artifact: bdeb3094 user: drh)
2015-05-20
17:36 Fixed ticket [f2ad7de0]: Corrupt table created by CREATE TABLE AS followed by compound SELECT plus 3 other changes (artifact: 81fc82f6 user: drh)
15:52 Ticket [f2ad7de0]: 6 changes (artifact: 8126358c user: drh)
14:04 New ticket [f2ad7de0]. (artifact: 86aa4e22 user: drh)
2015-05-19
20:34 Ticket [34cd55d6] Database corruption following INSERT with a TRIGGER that does an affinity change status still Fixed with 3 other changes (artifact: c195566c user: drh)
19:55 Fixed ticket [34cd55d6]. (artifact: 4d04bea3 user: drh)
19:08 New ticket [34cd55d6]. (artifact: 208465f3 user: drh)
2015-04-11
11:45 Closed ticket [7b4fee9f]: Expressions like (a IS NULL AND b = ?) optimized by a UNIQUE index matching a single row only plus 6 other changes (artifact: 51edb7d0 user: dan)
11:06 New ticket [7b4fee9f]. (artifact: a72fb3c9 user: dan)
2015-03-07
13:57 Fixed ticket [05f43be8]: Incorrect use of index with LIKE operators when the LHS is a blob plus 5 other changes (artifact: c140b281 user: drh)
2015-03-06
13:14 New ticket [05f43be8]. (artifact: 9a374a0d user: drh)
2015-02-24
20:21 Fixed ticket [2326c258]: Incorrect result when a LEFT JOIN provides the qualifying constraint for a partial index plus 3 other changes (artifact: 28d4d42e user: drh)
18:13 Ticket [2326c258]: 7 changes (artifact: 6c8344ce user: drh)
15:30 New ticket [2326c258]. (artifact: f6a379b6 user: drh)
2015-02-17
02:06 Fixed ticket [1c69be2d]: Incorrect GROUP BY when input and output columns have the same name plus 3 other changes (artifact: c35d9445 user: drh)
2015-02-09
18:28 Fixed ticket [ca0d20b6]: COLLATE operator masked by function calls plus 5 other changes (artifact: 9d7a17c8 user: drh)
18:28 Fixed ticket [2f7170d7]: "misuse of aggregate" error if aggregate column from FROM subquery is used in correlated subquery plus 5 other changes (artifact: 871a8aa9 user: drh)
15:16 New ticket [ca0d20b6] COLLATE operator masked by function calls. (artifact: 616fce0c user: drh)
07:51 New ticket [2f7170d7] "misuse of aggregate" error if aggregate column from FROM subquery is used in correlated subquery. (artifact: 8dbaf78f user: dan)
2015-01-22
12:01 Fixed ticket [32b63d54]: Fuzzer induced crash plus 5 other changes (artifact: d1840485 user: drh)
11:41 New ticket [32b63d54]. (artifact: c108a800 user: drh)
2015-01-20
18:11 Fixed ticket [f97c4637]: Incorrect ordering with ORDER BY and LIMIT plus 4 other changes (artifact: ac59934a user: drh)
2015-01-19
15:40 Ticket [f97c4637]: 6 changes (artifact: 0c9d51df user: drh)
15:31 New ticket [f97c4637]. (artifact: fc35a8b2 user: drh)
2015-01-09
01:27 Fixed ticket [a59ae93e]: Crashes due to fuzzed input plus 5 other changes (artifact: 2907380e user: drh)
00:43 New ticket [a59ae93e]. (artifact: 30acea0d user: drh)
2014-12-05
14:44 Fixed ticket [e4a18565]: Stale KeyInfo object used in shared-cache mode plus 5 other changes (artifact: 002412e9 user: drh)
04:45 New ticket [e4a18565]. (artifact: 45f4b5d2 user: drh)
2014-12-04
21:54 Fixed ticket [c5ea8056]: Inverted sort order when using DISTINCT and a descending index plus 5 other changes (artifact: af5ba544 user: drh)
21:29 New ticket [c5ea8056]. (artifact: 9fb2d923 user: drh)
16:35 Fixed ticket [6f2222d5]: Incorrect output on a LEFT JOIN plus 6 other changes (artifact: 63d1ebb2 user: drh)
15:40 New ticket [6f2222d5]. (artifact: 897deb67 user: drh)
2014-11-14
18:02 Fixed ticket [db872294]: Incorrect result when RHS of IN operator contains DISTINCT and LIMIT plus 5 other changes (artifact: 44893f76 user: drh)
15:25 New ticket [db872294]. (artifact: b959ab7a user: drh)
2014-11-05
15:57 Fixed ticket [094d39a4]: Assertion fault on CREATE TABLE ... AS SELECT ... plus 3 other changes (artifact: 3503a857 user: drh)
15:45 Ticket [43107840] Assertion fault on UPDATE status still Fixed with 3 other changes (artifact: 22c19255 user: drh)
15:44 Ticket [094d39a4] Assertion fault on CREATE TABLE ... AS SELECT ... status still Open with 6 other changes (artifact: e881c36f user: drh)
14:53 New ticket [094d39a4]. (artifact: b5f433e5 user: drh)
2014-10-29
00:58 Fixed ticket [43107840]: Assertion fault on UPDATE plus 5 other changes (artifact: 224c3ec2 user: drh)
00:27 New ticket [43107840]. (artifact: 0c3cdaf3 user: drh)
2014-10-11
02:12 Fixed ticket [ba7cbfae]: Wrong output order when a DESC index and GROUP BY and ORDER BY. plus 5 other changes (artifact: 7542bf31 user: drh)
2014-10-10
19:58 New ticket [ba7cbfae]. (artifact: 8a70e91f user: drh)
2014-10-02
21:52 Fixed ticket [8c32a33a]: Segfault on a syntax error involving the IS operator plus 5 other changes (artifact: ee9b9ce6 user: drh)