SQLite

Timeline
Login

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

100 ticket changes occurring around eddfb2b4062f8a8b.

2010-10-06
17:06 New ticket [38cb5df3] LIMIT ignored on compound query with subqueries. (artifact: 08decf09 user: drh)
2010-09-30
17:34 Fixed ticket [3998683a]: Some valid floating-point literals are not recognized. plus 2 other changes (artifact: b314a828 user: drh)
16:26 New ticket [3998683a]. (artifact: 7d4b5cce user: drh)
14:48 Fixed ticket [8454a207]: ALTER TABLE ADD COLUMN with negative DEFAULT value plus 2 other changes (artifact: 788cfd73 user: drh)
12:56 New ticket [8454a207]. (artifact: 90b2b3d0 user: drh)
2010-09-28
07:21 Fixed ticket [b351d95f]: Bug in "INSERT INTO ... SELECT" statements that use CASE plus 3 other changes (artifact: a657e414 user: drh)
2010-09-27
13:41 New ticket [b351d95f]. (artifact: d9aed8f7 user: dan)
2010-09-18
19:37 Fixed ticket [313723c3]: Database corruption following an I/O error on xShmLock plus 2 other changes (artifact: 5dd6eebc user: drh)
19:34 New ticket [313723c3]. (artifact: e8022d69 user: drh)
2010-08-23
17:08 Fixed ticket [5e10420e]: Free-list corruption in incremental-vacuum mode plus 5 other changes (artifact: cfdf952b user: drh)
15:35 New ticket [5e10420e]. (artifact: 9ae88290 user: drh)
2010-08-13
16:50 Closed ticket [e4b8a2ba]: Problem with DISTINCT in sub-queries in a FROM clause. plus 3 other changes (artifact: 20f7d054 user: dan)
16:19 New ticket [e4b8a2ba]. (artifact: f77237ee user: dan)
2010-08-05
03:24 Fixed ticket [13f033c8]: Performance regression plus 2 other changes (artifact: c1ac8278 user: drh)
2010-08-04
18:43 New ticket [13f033c8]. (artifact: 07edd854 user: drh)
11:40 Ticket [51ae9cad] Database corruption by alternating writes from 3.7.0 and 3.6.23 status still Fixed with 1 other change (artifact: 19099f9f user: dan)
11:39 Fixed ticket [51ae9cad]. (artifact: 26a33213 user: dan)
11:39 Ticket [51ae9cad]: 3 changes (artifact: 93da284a user: dan)
11:30 New ticket [51ae9cad]. (artifact: 254d411d user: drh)
2010-08-03
13:09 Fixed ticket [c38baa3d]: REPLACE on a CHECK constraint does not work as advertised plus 2 other changes (artifact: 0f5aa05f user: drh)
12:59 New ticket [c38baa3d]. (artifact: 564db3d9 user: drh)
2010-08-01
22:25 Fixed ticket [168d0f71]: Segfault while reading database with a corrupt index plus 3 other changes (artifact: 184435bf user: drh)
22:25 New ticket [168d0f71]. (artifact: 04fbf617 user: drh)
2010-07-31
20:55 Fixed ticket [ce7c133e]: Foreign key constraint fails when it should succeed. (artifact: 7b3f9b14 user: drh)
06:57 Ticket [ce7c133e]: 1 change (artifact: 09391839 user: anonymous)
06:49 Ticket [ce7c133e]: 1 change (artifact: c23a1b20 user: anonymous)
06:43 Open ticket [ce7c133e]. (artifact: 822455e9 user: anonymous)
2010-07-30
11:37 Fixed ticket [f3e5abed]: Problems retrying COMMIT after SQLITE_BUSY on multi-file transaction plus 2 other changes (artifact: d07c2800 user: drh)
2010-07-29
19:02 Add attachment tkt-f3e5abed55.test to ticket [f3e5abed] (artifact: aee9538c user: dan)
18:59 New ticket [f3e5abed] Problems retrying COMMIT after SQLITE_BUSY on multi-file transaction. (artifact: fd92e3d4 user: dan)
10:08 Fixed ticket [c43940c4]: sqlite3_profile gives milliseconds (was nanoseconds in earlier releases) plus 1 other change (artifact: 057fea73 user: drh)
04:58 Ticket [c43940c4]: 3 changes (artifact: 5ea7d43a user: rogerb)
04:54 New ticket [c43940c4]. (artifact: 5ad542d1 user: rogerb)
01:55 Fixed ticket [ce7c133e]: Foreign key constraint fails when it should succeed. plus 1 other change (artifact: b3a12114 user: drh)
01:55 Ticket [ce7c133e]: 4 changes (artifact: 6fb11fef user: drh)
2010-07-28
20:57 New ticket [ce7c133e]. (artifact: 4202cdf3 user: drh)
02:53 Fixed ticket [8011086c]: Query planner creates unnecessary and expensive automatic index plus 2 other changes (artifact: b5dd6bce user: drh)
00:33 New ticket [8011086c]. (artifact: 333f2a70 user: drh)
2010-07-22
17:50 Fixed ticket [47110204]: should use collate nocase index even if column isn't declared nocase plus 1 other change (artifact: b9e1ea8e user: drh)
12:34 Fixed ticket [e0901835]: like should use index when pattern has no wildcard plus 1 other change (artifact: e78b5e56 user: drh)
06:11 Ticket [5e0423b0] xAccess behaviour is not documented, changed in Windows 3.7.0 status still Open with 3 other changes (artifact: 6365a76d user: rogerb)
05:46 New ticket [5e0423b0]. (artifact: a9b24d32 user: rogerb)
2010-07-21
22:22 Ticket [e0901835] like should use index when pattern has no wildcard status still Open with 3 other changes (artifact: 7a237684 user: drh)
22:21 Ticket [47110204] should use collate nocase index even if column isn't declared nocase status still Open with 3 other changes (artifact: 92b593d2 user: drh)
22:06 New ticket [47110204]. (artifact: 8e7db3c9 user: aswift)
22:01 New ticket [e0901835] like should use index when pattern has no wildcard. (artifact: 5484eb7b user: aswift)
2010-07-19
05:27 New ticket [f817a457] CantOpen doesn't include name of file that can't be opened. (artifact: 57c188aa user: rogerb)
05:00 Closed ticket [30349e0f]: Yet more FTS3 symbols need to be made private plus 3 other changes (artifact: d0851a8e user: rogerb)
2010-07-14
18:24 Fixed ticket [80e031a0]: Result of IN should never be NULL if the RHS is empty plus 2 other changes (artifact: db629242 user: drh)
15:48 New ticket [80e031a0]. (artifact: 9ad81785 user: drh)
2010-06-26
19:03 Closed ticket [d11f09d3]: Cache corruption caused by ROLLBACK with synchronous=NORMAL plus 1 other change (artifact: ea8ae4aa user: dan)
16:30 Ticket [d11f09d3]: 1 change (artifact: 16a03c75 user: dan)
16:17 Ticket [d11f09d3]: 3 changes (artifact: 1f6fb18e user: dan)
15:40 New ticket [d11f09d3]. (artifact: 4fd136ea user: dan)
2010-06-17
13:22 Ticket [fc62af45] Executing "PRAGMA journal_mode" may delete journal file while it is in use. status still Open with 1 other change (artifact: 068d606e user: drh)
10:45 Ticket [fc62af45]: 1 change (artifact: deedf461 user: dan)
10:44 Ticket [fc62af45]: 1 change (artifact: 5f284581 user: dan)
09:52 Ticket [fc62af45]: 4 changes (artifact: c98b4147 user: dan)
09:37 New ticket [fc62af45]. (artifact: f0c7acf8 user: dan)
2010-06-09
16:16 Fixed ticket [f973c7ac]: Incorrect affinity for indexed range constraint plus 2 other changes (artifact: 9b2cbacd user: drh)
15:20 New ticket [f973c7ac]. (artifact: def6ef22 user: drh)
2010-05-14
19:24 Fixed ticket [dd08e5a9]: Foreign key constraint fails to prevent consistency error. plus 2 other changes (artifact: d0c360fc user: drh)
18:20 New ticket [dd08e5a9]. (artifact: 9f47adfd user: drh)
2010-05-13
23:00 Ticket [51914f6a] nRef and owner should be #ifdef SQLITE_DEBUG status still Fixed with 1 other change (artifact: 2aeade56 user: rogerb)
20:19 Fixed ticket [51914f6a]. (artifact: 0e16051d user: drh)
2010-05-12
23:41 New ticket [51914f6a]. (artifact: 5fe8ccfe user: rogerb)
17:53 Ticket [c25aab7e] The ".import" command does not parse CSV correctly. status still Open with 2 other changes (artifact: 3d07a0d4 user: anonymous)
12:12 New ticket [26ff0c82] Incorrect result when using unnamed "?" bindings. (artifact: 3e0dd9c8 user: drh)
2010-04-30
21:03 Fixed ticket [3dbdcdb1]: Assertion fault using indices with redundant columns plus 2 other changes (artifact: 7ab2adf4 user: drh)
20:35 New ticket [3dbdcdb1]. (artifact: ced410c4 user: drh)
06:00 Closed ticket [c39ff61c]: Erroneous FK constraint failure when reusing statement plus 2 other changes (artifact: 07e0b188 user: dan)
2010-04-29
22:55 Add attachment fk_bug.c to ticket [c39ff61c] (artifact: ea580399 user: dan)
22:53 New ticket [c39ff61c] Erroneous FK constraint failure when reusing statement. (artifact: 0e827cda user: dan)
2010-04-22
12:08 Closed ticket [bb1977f6]: Concatenation can create very invalid strings plus 2 other changes (artifact: 53493959 user: drh)
2010-04-19
17:38 Ticket [bb1977f6]: 3 changes (artifact: 7095de75 user: rogerb)
16:58 New ticket [bb1977f6]. (artifact: a6915b38 user: rogerb)
2010-04-15
23:26 Fixed ticket [02a8e81d]: LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly plus 2 other changes (artifact: 052b48ef user: drh)
14:43 Ticket [02a8e81d]: 3 changes (artifact: c271e305 user: drh)
14:28 New ticket [02a8e81d]. (artifact: 5b18826a user: dan)
2010-04-09
19:20 New ticket [9d68c883] Database corruption following OOM fault. (artifact: e44fcd7e user: drh)
2010-04-05
06:35 New ticket [30349e0f] Yet more FTS3 symbols need to be made private. (artifact: bc1fcc3b user: rogerb)
2010-04-03
23:57 Verified ticket [775b39dd]: Poor query planning with virtual tables, joins and ORDER BY. plus 6 other changes (artifact: 136d8ef9 user: anonymous)
23:49 Ticket [775b39dd]: 1 change (artifact: 58ca3c14 user: anonymous)
2010-03-31
15:11 Ticket [883034dc] Column cache problem with aggregate queries status still Closed with 1 other change (artifact: 26024096 user: dan)
15:10 Closed ticket [883034dc]. (artifact: f4abbf8f user: dan)
14:49 New ticket [883034dc]. (artifact: 739f8819 user: dan)
11:57 Fixed ticket [e063139e]: Download .zip excludes shell but .tar includes it plus 1 other change (artifact: e50018de user: drh)
10:35 Ticket [e063139e]: 2 changes (artifact: c4e414cd user: anonymous)
2010-03-30
13:43 Closed ticket [f3162063]: Crash compiling "INSERT INTO tbl DEFAULT VALUES" if tbl has BEFORE or INSTEAD OF triggers. plus 1 other change (artifact: 2eb0c083 user: dan)
12:34 Ticket [f3162063]: 3 changes (artifact: 978e7e12 user: drh)
11:59 New ticket [f3162063]. (artifact: 4f5b53a5 user: dan)
2010-03-27
16:52 Ticket [7d96113f] SQLite fails to build when TCL isn't installed status still Fixed with 1 other change (artifact: cf173fb3 user: anonymous)
09:11 Ticket [775b39dd] Poor query planning with virtual tables, joins and ORDER BY. status still Open with 3 other changes (artifact: 88fa6342 user: dan)
09:09 New ticket [775b39dd]. (artifact: f936d94a user: dan)
2010-03-26
01:54 Ticket [cbd054fa] "out of memory" in ANALYZE with SQLITE_ENABLE_STAT2 status still Open with 3 other changes (artifact: ef5f324c user: shane)
01:05 New ticket [cbd054fa]. (artifact: 7eb8c2fa user: shane)
2010-03-25
04:43 Ticket [13137dcc] FTS3 and last_insert_rowid() status still Open with 3 other changes (artifact: f80f3de5 user: dan)
2010-03-24
15:38 New ticket [9861b74a] Fts3 offsets() function may report SQLITE_CORRUPT with empty string.. (artifact: 0888a21a user: dan)
2010-03-22
17:47 Closed ticket [015d3820]: Missing call to xSync() following rollback. (artifact: 67e76ed6 user: dan)
17:46 Ticket [015d3820]: 2 changes (artifact: f7fe6d80 user: dan)