SQLite
Timeline
Not logged in

50 most recent timeline items

2015-05-24
10:18
[4f0bba42] Leaf: Detect database corruption in the modifyPagePointer() routine and abort. (user: drh, tags: trunk)
2015-05-23
19:53
[7bbf9b3c] Instead of early detection of corruption in balance_nonroot, simply ignore the error, as it is harmless and exceedingly uncommon. (user: drh, tags: trunk)
19:29
[ee6dc991] Earlier detection of a specific kind of corruption in the balance_nonroot() routine. (user: drh, tags: trunk)
15:43
[5165de54] Leaf: Avoid making redundant copies of position-lists within the fts5 code. (user: dan, tags: fts5)
02:44
[e446d9ce] Minor documentation improvements. No changes to code. (user: drh, tags: trunk)
2015-05-22
23:51
[519054bb] Leaf: Merge bug fixes from trunk. (user: drh, tags: sessions)
23:50
[c404fcac] Improved error messages in fuzzershell when unable to open the database. (user: drh, tags: trunk)
23:45
[745deab8] Fix a bug in fuzzershell caused by an uninitialized local variable. (user: drh, tags: trunk)
23:39
[89f0bbfd] Fix another bad assert() in btree - one that can be false on a corrupt database file. (user: drh, tags: trunk)
23:26
[cdc0ca6f] Merge enhancements from trunk, including the new sqlite3_value_dup() API and the addition of the apSqlParam field in the sqlite3_rtree_query_info object of R-Tree. (user: drh, tags: sessions)
23:20 • Edit [b9e45596d823a665|b9e45596]: Marked "Closed". Edit check-in comment. (user: drh)
23:17
[10cc44f5] Fix incorrect validation of the size of the BLOB returned by a geometry function on the RHS of a MATCH operator in RTree. The old code worked for 64-bit systems (by chance) but fails on 32-bit. (user: drh, tags: trunk)
21:12
[c1814242] Add the sqlite3_value_dup() and sqlite3_value_free() interfaces. Use these interfaces to enhance R-Tree to add the sqlite3_rtree_query_info.apSqlParam field. (user: drh, tags: trunk)
21:04
[f332ffc3] Closed-Leaf: Make sure sqlite3_value_dup() works correctly even for sqlite3_value objects that are marked SQLITE_STATIC. (user: drh, tags: value-dup)
19:55
[95edcf50] Fix minor issues with the sqlite3_value_dup() interface. (user: drh, tags: value-dup)
18:40
[9605d008] Update with fixes and enhancements from trunk. (user: drh, tags: value-dup)
17:29
[b9727e6b] The SRT_Table type for the SelectDest object is now just an SRT_EphemTab for which the ephemeral table has already been allocated. (user: drh, tags: trunk)
16:08
[b9fb9519] Have r-tree prefer to use the constraint "col MATCH ?" over "rowid = ?". (user: dan, tags: trunk)
13:09
[799817bf] Fix two faulty assert statements discovered by fuzzing. (user: drh, tags: trunk)
12:37
[a6eb2a39] Fix an assert in btree.c that can be false when using a corrupted database file. (user: drh, tags: trunk)
11:38
[c6d5512f] Add the --database option to the fuzzershell test program. (user: drh, tags: trunk)
07:44
[065ab83a] Increase test coverage of fts5_vocab.c. (user: dan, tags: fts5)
06:08
[fea8a4db] Improve test coverage of fts5_unicode2.c. (user: dan, tags: fts5)
2015-05-21
20:26
[b9e45596] Closed-Leaf: Have r-tree prefer to use the constraint "col MATCH ?" over "rowid = ?". drh added later: All changes on this branch have been cherrypicked to trunk and will be merged into sessions from trunk. So this branch can close. (user: dan, tags: sessions-value-dup)
17:24
[b3bb660a] Leaf: Prevent a virtual table from being destroyed while it is in use. Also: replace Vdbe.inVtabMethod with sqlite3.nVDestroy. Simplify the EXPLAIN output for P4.pVtab to only show the sqlite3_vtab pointer. Cherrypick of [cbeb9a1aed8c]. (user: dan, tags: branch-3.8.6)
17:21
[31b13eb5] Avoid ever writing before the start of an allocated buffer in the DIRECT_OVERFLOW_READ code. Fix for [e3a290961a6]. Cherrypick of [c3c15d20c691]. (user: dan, tags: branch-3.8.6)
02:24
[000197cc] Leaf: Silently ignore any attempt to add a prefix index for prefixes zero bytes in size to an fts3/4 table. Or any prefix index size so large that it overflows a 32-bit signed integer. Cherrypick [ad4b19d2ac0889a] (user: drh, tags: branch-3.7.11)
02:20
[9e3f64a4] Ensure that tables names are dequoted exactly once by the trigger logic. Cherrypick [59e92bd9521f1e8] and [9d887b92f8086961e]. (user: drh, tags: branch-3.7.11)
02:07
[09784f37] When parsing the schema, ignore any SQL that does not begin with "CREATE". Cherrypick of [d3c00d61581c] with additional changes. (user: drh, tags: branch-3.7.11)
01:04
[0f0694e4] Do not allow virtual table constructors to be called recursively. Cherrypick [0a72726da21581ab] (user: drh, tags: branch-3.7.11)
00:50
[a71e2a72] Add the ".open" command to the command-line shell. Cherrypick from [21eccb919441]. (user: drh, tags: branch-3.7.11)
2015-05-20
22:01
[2007391c] Add the sqlite3_value_dup() and sqlite3_value_free() interfaces and use those to add the sqlite3_rtree_query_info.apSqlParam field to the query callback in R-Tree. (user: drh, tags: sessions-value-dup)
21:28
[a7ee40c4] Add the sqlite3_value_dup() and sqlite3_value_free() interfaces. Use these interfaces to enhance R-Tree to add the sqlite3_rtree_query_info.apSqlParam field. (user: drh, tags: value-dup)
20:50
[80633682] Fix a problem in test file e_reindex.test. Cherrypick of [5b3de9390f2f]. (user: dan, tags: branch-3.8.6)
20:34
[7d7d633c] Fix a problem causing the fts3 integrity-check to fail if run inside a transaction. Cherrypick of [3b925189a75e]. (user: dan, tags: branch-3.8.6)
20:30
[bd357739] Ensure that tables names are dequoted exactly once by the trigger and FK logic. Cherrypick of [59e92bd9521f] and [9d887b92f808]. (user: dan, tags: branch-3.8.6)
20:27
[3cd2b772] Fix an obscure problem with "INSERT INTO tbl(cols) SELECT" statements where the SELECT is a compound with an ORDER BY and "cols" is a strict subset of tbl's columns. Cherrypick of [718d5d0eab04]. (user: dan, tags: branch-3.8.6)
20:24
[7f3943fb] Fix a potential NULL pointer deference on a corrupt database schema. Cherrypick of [dc61b292d8ea]. (user: dan, tags: branch-3.8.6)
20:21
[2c649cdf] Fix a bug caused by cherrypicking from a branch that assumes sqlite3_stricmp() can handle NULL arguments. (user: dan, tags: branch-3.8.6)
19:57
[0da229b8] When parsing the schema, ignore any SQL that does not begin with "CREATE". Cherrypick of [d3c00d61581c]. (user: dan, tags: branch-3.8.6)
19:53
[4a08f6b8] Detect and report oversized records constructed from multiple zeroblobs. Cherrypick of [9e139afd9211]. (user: dan, tags: branch-3.8.6)
19:50
[023a29ba] Do not allow virtual table constructors to be called recursively. Cherrypick of [0a72726da215] (user: dan, tags: branch-3.8.6)
19:48
[b330c7ff] Avoid signed integer overflow when converting oversized in-line integer widths and precisions in printf(). Cherrypick of [c494171f77dc], [5ce4e7d7651e], [95625ef3adc3] and [8e4ac2ce2441]. (user: dan, tags: branch-3.8.6)
19:44
[4125477e] Ensure that comparison operators do not mess up the MEM_Dyn flag on registers when reverting affinity changes. Cherrypick of [02e3c88fbf6a]. (user: dan, tags: branch-3.8.6)
19:34
[fc1a4f29] Fix a problem causing collation sequence names to be dequoted multiple times under some circumstances. Cherrypick of [eddc05e7bb31]. (user: dan, tags: branch-3.8.6)
19:32
[ff7be4db] Silently ignore any attempt to add a prefix index for prefixes zero bytes in size to an fts3/4 table. Or any prefix index size so large that it overflows a 32-bit signed integer. Cherrypick of [ad4b19d2ac0889a2]. (user: dan, tags: branch-3.8.6)
18:17
[2ef4f3a5] Leaf: Version 3.8.10.2 (user: drh, tags: release, branch-3.8.10, version-3.8.10.2)
17:36
[6a0cf3ce] Fix the initialization logic in CREATE TABLE AS so that the correct affinities are applied to all values being inserted into the new table, even if the RHS is a compound SELECT. Fix for ticket [f2ad7de056ab1dc9200]. (user: drh, tags: trunk)
17:36 • Fixed ticket [f2ad7de0]: Corrupt table created by CREATE TABLE AS followed by compound SELECT plus 3 other changes (user: drh)
17:25
[0e45e8f1] Closed-Leaf: Add a test case to verify that CREATE TABLE AS does not store INT values in TEXT columns. Ticket [f2ad7de056ab1dc92]. (user: drh, tags: create-table-as-type-fix)