SQLite

Timeline
Login

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

100 ticket changes occurring around e388fe8be878c80e.

2010-07-29
10:08 Fixed ticket [c43940c49b]: sqlite3_profile gives milliseconds (was nanoseconds in earlier releases) plus 1 other change (artifact: 057fea7330 user: drh)
04:58 Ticket [c43940c49b]: 3 changes (artifact: 5ea7d43a0f user: rogerb)
04:54 New ticket [c43940c49b]. (artifact: 5ad542d17f user: rogerb)
01:55 Fixed ticket [ce7c133ea6]: Foreign key constraint fails when it should succeed. plus 1 other change (artifact: b3a12114ca user: drh)
01:55 Ticket [ce7c133ea6]: 4 changes (artifact: 6fb11fefa6 user: drh)
2010-07-28
20:57 New ticket [ce7c133ea6]. (artifact: 4202cdf359 user: drh)
02:53 Fixed ticket [8011086c85]: Query planner creates unnecessary and expensive automatic index plus 2 other changes (artifact: b5dd6bce40 user: drh)
00:33 New ticket [8011086c85]. (artifact: 333f2a707d user: drh)
2010-07-22
17:50 Fixed ticket [4711020446]: should use collate nocase index even if column isn't declared nocase plus 1 other change (artifact: b9e1ea8ef7 user: drh)
12:34 Fixed ticket [e090183531]: like should use index when pattern has no wildcard plus 1 other change (artifact: e78b5e5681 user: drh)
06:11 Ticket [5e0423b058] xAccess behaviour is not documented, changed in Windows 3.7.0 status still Open with 3 other changes (artifact: 6365a76ded user: rogerb)
05:46 New ticket [5e0423b058]. (artifact: a9b24d321c user: rogerb)
2010-07-21
22:22 Ticket [e090183531] like should use index when pattern has no wildcard status still Open with 3 other changes (artifact: 7a237684b4 user: drh)
22:21 Ticket [4711020446] should use collate nocase index even if column isn't declared nocase status still Open with 3 other changes (artifact: 92b593d292 user: drh)
22:06 New ticket [4711020446]. (artifact: 8e7db3c957 user: aswift)
22:01 New ticket [e090183531] like should use index when pattern has no wildcard. (artifact: 5484eb7b10 user: aswift)
2010-07-19
05:27 New ticket [f817a45752] CantOpen doesn't include name of file that can't be opened. (artifact: 57c188aa57 user: rogerb)
05:00 Closed ticket [30349e0f68]: Yet more FTS3 symbols need to be made private plus 3 other changes (artifact: d0851a8e05 user: rogerb)
2010-07-14
18:24 Fixed ticket [80e031a00f]: Result of IN should never be NULL if the RHS is empty plus 2 other changes (artifact: db6292423d user: drh)
15:48 New ticket [80e031a00f]. (artifact: 9ad817855e user: drh)
2010-06-26
19:03 Closed ticket [d11f09d36e]: Cache corruption caused by ROLLBACK with synchronous=NORMAL plus 1 other change (artifact: ea8ae4aa43 user: dan)
16:30 Ticket [d11f09d36e]: 1 change (artifact: 16a03c7557 user: dan)
16:17 Ticket [d11f09d36e]: 3 changes (artifact: 1f6fb18eb7 user: dan)
15:40 New ticket [d11f09d36e]. (artifact: 4fd136eab8 user: dan)
2010-06-17
13:22 Ticket [fc62af4523] Executing "PRAGMA journal_mode" may delete journal file while it is in use. status still Open with 1 other change (artifact: 068d606ebb user: drh)
10:45 Ticket [fc62af4523]: 1 change (artifact: deedf4616a user: dan)
10:44 Ticket [fc62af4523]: 1 change (artifact: 5f28458129 user: dan)
09:52 Ticket [fc62af4523]: 4 changes (artifact: c98b414755 user: dan)
09:37 New ticket [fc62af4523]. (artifact: f0c7acf8ea user: dan)
2010-06-09
16:16 Fixed ticket [f973c7ac31]: Incorrect affinity for indexed range constraint plus 2 other changes (artifact: 9b2cbacd90 user: drh)
15:20 New ticket [f973c7ac31]. (artifact: def6ef2209 user: drh)
2010-05-14
19:24 Fixed ticket [dd08e5a988]: Foreign key constraint fails to prevent consistency error. plus 2 other changes (artifact: d0c360fce3 user: drh)
18:20 New ticket [dd08e5a988]. (artifact: 9f47adfdd6 user: drh)
2010-05-13
23:00 Ticket [51914f6acd] nRef and owner should be #ifdef SQLITE_DEBUG status still Fixed with 1 other change (artifact: 2aeade5666 user: rogerb)
20:19 Fixed ticket [51914f6acd]. (artifact: 0e16051dfe user: drh)
2010-05-12
23:41 New ticket [51914f6acd]. (artifact: 5fe8ccfeb5 user: rogerb)
17:53 Ticket [c25aab7e7e] The ".import" command does not parse CSV correctly. status still Open with 2 other changes (artifact: 3d07a0d47a user: anonymous)
12:12 New ticket [26ff0c82d1] Incorrect result when using unnamed "?" bindings. (artifact: 3e0dd9c8b5 user: drh)
2010-04-30
21:03 Fixed ticket [3dbdcdb14e]: Assertion fault using indices with redundant columns plus 2 other changes (artifact: 7ab2adf41d user: drh)
20:35 New ticket [3dbdcdb14e]. (artifact: ced410c432 user: drh)
06:00 Closed ticket [c39ff61c43]: Erroneous FK constraint failure when reusing statement plus 2 other changes (artifact: 07e0b1880e user: dan)
2010-04-29
22:55 Add attachment fk_bug.c to ticket [c39ff61c43] (artifact: ea5803991b user: dan)
22:53 New ticket [c39ff61c43] Erroneous FK constraint failure when reusing statement. (artifact: 0e827cdafb user: dan)
2010-04-22
12:08 Closed ticket [bb1977f6e9]: Concatenation can create very invalid strings plus 2 other changes (artifact: 5349395933 user: drh)
2010-04-19
17:38 Ticket [bb1977f6e9]: 3 changes (artifact: 7095de75ef user: rogerb)
16:58 New ticket [bb1977f6e9]. (artifact: a6915b38a9 user: rogerb)
2010-04-15
23:26 Fixed ticket [02a8e81d44]: LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly plus 2 other changes (artifact: 052b48efab user: drh)
14:43 Ticket [02a8e81d44]: 3 changes (artifact: c271e30545 user: drh)
14:28 New ticket [02a8e81d44]. (artifact: 5b18826a94 user: dan)
2010-04-09
19:20 New ticket [9d68c88313] Database corruption following OOM fault. (artifact: e44fcd7e72 user: drh)
2010-04-05
06:35 New ticket [30349e0f68] Yet more FTS3 symbols need to be made private. (artifact: bc1fcc3bb6 user: rogerb)
2010-04-03
23:57 Verified ticket [775b39dd3c]: Poor query planning with virtual tables, joins and ORDER BY. plus 6 other changes (artifact: 136d8ef9fc user: anonymous)
23:49 Ticket [775b39dd3c]: 1 change (artifact: 58ca3c1451 user: anonymous)
2010-03-31
15:11 Ticket [883034dcb5] Column cache problem with aggregate queries status still Closed with 1 other change (artifact: 2602409665 user: dan)
15:10 Closed ticket [883034dcb5]. (artifact: f4abbf8f3c user: dan)
14:49 New ticket [883034dcb5]. (artifact: 739f88197f user: dan)
11:57 Fixed ticket [e063139eb3]: Download .zip excludes shell but .tar includes it plus 1 other change (artifact: e50018de6d user: drh)
10:35 Ticket [e063139eb3]: 2 changes (artifact: c4e414cdbb user: anonymous)
2010-03-30
13:43 Closed ticket [f3162063fd]: Crash compiling "INSERT INTO tbl DEFAULT VALUES" if tbl has BEFORE or INSTEAD OF triggers. plus 1 other change (artifact: 2eb0c08326 user: dan)
12:34 Ticket [f3162063fd]: 3 changes (artifact: 978e7e12f2 user: drh)
11:59 New ticket [f3162063fd]. (artifact: 4f5b53a558 user: dan)
2010-03-27
16:52 Ticket [7d96113ff0] SQLite fails to build when TCL isn't installed status still Fixed with 1 other change (artifact: cf173fb30b user: anonymous)
09:11 Ticket [775b39dd3c] Poor query planning with virtual tables, joins and ORDER BY. status still Open with 3 other changes (artifact: 88fa634239 user: dan)
09:09 New ticket [775b39dd3c]. (artifact: f936d94af3 user: dan)
2010-03-26
01:54 Ticket [cbd054fa6b] "out of memory" in ANALYZE with SQLITE_ENABLE_STAT2 status still Open with 3 other changes (artifact: ef5f324c9c user: shane)
01:05 New ticket [cbd054fa6b]. (artifact: 7eb8c2fa3b user: shane)
2010-03-25
04:43 Ticket [13137dccf3] FTS3 and last_insert_rowid() status still Open with 3 other changes (artifact: f80f3de508 user: dan)
2010-03-24
15:38 New ticket [9861b74ab9] Fts3 offsets() function may report SQLITE_CORRUPT with empty string.. (artifact: 0888a21a26 user: dan)
2010-03-22
17:47 Closed ticket [015d3820f2]: Missing call to xSync() following rollback. (artifact: 67e76ed664 user: dan)
17:46 Ticket [015d3820f2]: 2 changes (artifact: f7fe6d805c user: dan)
17:45 New ticket [015d3820f2]. (artifact: 27d0f9153a user: dan)
2010-03-19
19:11 Closed ticket [dd3ba6063a]: rtree module does not support last_insert_rowid() plus 2 other changes (artifact: c88f050744 user: dan)
18:58 New ticket [dd3ba6063a]. (artifact: b8192d22e7 user: dan)
2010-03-18
16:35 Fixed ticket [b1552d0fa7]: Symbols not declared private that should be plus 2 other changes (artifact: a96079dd9c user: drh)
2010-03-16
08:40 New ticket [b1552d0fa7]. (artifact: e6f8cfab18 user: rogerb)
2010-03-15
20:53 Fixed ticket [170872f1c3]: Unmatched double-quote causes problems for FTS3 plus 2 other changes (artifact: ac003677b1 user: drh)
19:28 Fixed ticket [42d45a693e]: Spurious log message from FTS3 plus 2 other changes (artifact: 83956ad4df user: drh)
2010-03-12
23:30 New ticket [170872f1c3] Unmatched double-quote causes problems for FTS3. (artifact: 84e2594f43 user: drh)
23:27 New ticket [42d45a693e] Spurious log message from FTS3. (artifact: 3d6049ee63 user: drh)
2010-03-05
13:23 New ticket [aa92c76cd4] Problem with GROUP BY and the distinction between real and integer values. (artifact: 14f2f1f348 user: dan)
2010-03-04
18:00 Closed ticket [9abd6aa831]: buffer overread in sqlite3_printf functions. plus 2 other changes (artifact: 911370593c user: dan)
17:47 New ticket [9abd6aa831]. (artifact: 41b75b039f user: dan)
2010-02-27
12:30 Ticket [ebdbadade5] LEFT JOIN incorrect when ON clause does not reference right table. status still Fixed with 1 other change (artifact: 7017709a6b user: drh)
2010-02-25
04:16 Fixed ticket [ebdbadade5]. (artifact: 89d8406eaa user: drh)
2010-02-24
22:36 Ticket [ebdbadade5]: 3 changes (artifact: 2267692434 user: drh)
22:35 New ticket [ebdbadade5]. (artifact: e3450baa28 user: drh)
19:55 Ticket [2e047cbefa] select DISTINCT performance could be better status still Open with 4 other changes (artifact: 8a75f8251b user: anonymous)
15:11 Fixed ticket [d2f02d37f5]: Assertion fault on UPDATE involving two virtual tables. plus 1 other change (artifact: fe19816b76 user: drh)
14:03 Ticket [d2f02d37f5]: 3 changes (artifact: 150a3df0c3 user: drh)
13:52 New ticket [d2f02d37f5]. (artifact: 29a566c9c2 user: drh)
2010-02-22
23:19 Fixed ticket [da1151f97d]: Assertion fault on VACUUM in an auto_vacuumed database. plus 2 other changes (artifact: dd36168aad user: drh)
22:57 New ticket [da1151f97d]. (artifact: e9ecc159f4 user: drh)
2010-02-16
11:00 Fixed ticket [e9a9fde1f4]: rtree module malfunctions if db page-size is changed plus 1 other change (artifact: 16ae4f5ce9 user: dan)
10:46 Ticket [e9a9fde1f4]: 3 changes (artifact: 5dc651f7a7 user: dan)
10:46 New ticket [e9a9fde1f4]. (artifact: 5c5e964df2 user: dan)
2010-02-15
18:05 Fixed ticket [13336e9c3c]: ALTER TABLE RENAME fails to update foreign key references plus 2 other changes (artifact: 3686318514 user: drh)
17:47 New ticket [13336e9c3c]. (artifact: 91486f00ee user: drh)
16:55 Fixed ticket [985771e116]: CREATE TRIGGER confused by TEMP/MAIN table name overlap plus 2 other changes (artifact: 239613c656 user: drh)
16:37 New ticket [985771e116]. (artifact: cecc6bdc3d user: drh)
2010-02-02
20:53 Closed ticket [8905af11a0]: NOT NULL interferes with ON CONFLICT REPLACE plus 2 other changes (artifact: e1bcfd4d59 user: drh)