SQLite
Timeline
Not logged in

77 timeline items tagged with "trunk" occurring on or after release.

2015-04-18
04:45
[691cc201] Leaf: Disregard leading zeros when converting strings to 32-bit integers. (user: drh, tags: trunk)
00:22
[eabde339] Fix an incorrect assert() in the sqlite3_trace() logic. (user: drh, tags: trunk)
2015-04-17
20:51
[284c1623] Fix a problem affecting some fts3 UPDATE and DELETE statements on order=DESC tables. (user: dan, tags: trunk)
19:41
[b67bb16c] In the expression-tree comparison routine, do not compiler Expr.iColumn and Expr.iTable for TK_STRING expressions. (user: drh, tags: trunk)
18:52
[6c39ef73] Always resolve symbols in all ORDER BY clauses of a compound-SELECT, even illegal ORDER BY clauses. (user: drh, tags: trunk)
18:22
[3f3b0f68] Remove unnecessary parser error count increments. Let the sqlite3ErrorMsg() take care of doing that. (user: drh, tags: trunk)
16:12
[ad67a67c] Remove an ALWAYS() that turns out to be false when there is a semantic error on a compound SELECT. (user: drh, tags: trunk)
15:58
[7aeade9a] Ensure that semantic SQL errors are always reported back up to the syntax parser. Also: Improve the defense against invalid PRAGMA synchronous settings. (user: drh, tags: trunk)
15:16
[620d19c3] Fix a faulty assert() in sqlite3SelectNew(). (user: drh, tags: trunk)
14:30
[db8d9af4] Add the tool/fuzzershell.c utility program. (user: drh, tags: trunk)
12:16
[b355ca3a] Fix the header comment on the sqldiff utility program. No code changes. (user: drh, tags: trunk)
2015-04-16
23:04
[cd6598f4] Restrict the scope of a local-use function in the parser. (user: drh, tags: trunk)
21:57
[e94b2ef2] Use a heap rather than a bitmap for cell coverage and overlap testing on btree pages in PRAGMA integrity_check. (user: drh, tags: trunk)
20:27
[8f391dff] Fix a couple of unreachable branches. (user: drh, tags: trunk)
20:10
[55d10baf] Fix a boundry-value condition in the phrase poslist extractor of FTS3/4. (user: drh, tags: trunk)
18:11
[d04d354d] Make sure all cursors are closed when returning from a VDBE subprogram that implements a foreign-key construct. (user: drh, tags: trunk)
17:31
[647495cf] Fix the VDBE so that it always uses the original opcode for profiling and debugging even after the pOp pointer has been updated due to a jump. (user: drh, tags: trunk)
16:22
[10715b05] Fix a faulty assert() in the compound-SELECT code generator. (user: drh, tags: trunk)
16:04
[e0a88176] Silently ignore requests to change the PRAGMA synchronous setting to an illegal integer value, rather than raising an assertion. (user: drh, tags: trunk)
15:47
[928f973c] Make sure errors in coding triggers are propagated back up to the parser. (user: drh, tags: trunk)
15:05
[dd96211e] Add the --backslash option to the command-line shell for testing purposes. (user: drh, tags: trunk)
14:33
[9d336be1] Fix a faulty assert() in the compound select code generator. (user: drh, tags: trunk)
14:13
[ec5a493a] Improvements to the way VALUES clauses are parsed. (user: drh, tags: trunk)
12:12
[7c0deed2] Fix the corruptC.test module due to a change in error message text. (user: drh, tags: trunk)
08:54
[5b3de939] Fix a problem in test file e_reindex.test. (user: dan, tags: trunk)
07:19
[b51028ed] Ensure the sqlite3Select() routine always returns non-zero if an error has occurred. (user: dan, tags: trunk)
00:26
[d3c00d61] When parsing the schema, ignore any SQL that does not begin with "CREATE". (user: drh, tags: trunk)
2015-04-15
19:25
[e018f4bf] Fix a potential one-byte buffer overread in the command-line shell. (user: drh, tags: trunk)
17:26
[f71053cf] Prevent the fetchPayload() routine from reporting a cell size that extends off the end of the page on a pathologically corrupted database file. (user: drh, tags: trunk)
15:29
[61d72e17] Enhance the showdb utility program so that it can read the last partial page of a truncated database file. (user: drh, tags: trunk)
14:52
[b8768f12] Add the --msvc command-line option to the releasetest.tcl script. This is only a partial merge from the winTest branch as the OS_TRACE changes are omitted. (user: drh, tags: trunk)
09:16
[bd06eeb8] Remove an incorrect assert() statement from sqlite3Fts3Dequote(). (user: dan, tags: trunk)
08:37
[fa0956ed] Remove a branch that became unreachable due to one of the earlier check-ins today. (user: drh, tags: trunk)
08:20
[eafd0a1e] Fix a problem causing an assert() to fail if a snippet containing 0 tokens was requested from fts3. (user: dan, tags: trunk)
07:57
[3576973f] Fix the error message generator for illegal token errors so that it does not leak memory if it immediately follows another erroneous SQL statement. (user: drh, tags: trunk)
07:34
[eeb4bd06] Remove an incorrect ALWAYS() from the automatic index generator. (user: drh, tags: trunk)
07:19
[0e087c01] Remove an incorrect ALWAYS() from the table_info pragma. (user: drh, tags: trunk)
07:10
[14784c31] Change the multiSelectOrderBy() routine to return non-zero if there has been any prior error. (user: drh, tags: trunk)
06:45
[c72324ef] Fix a faulty assert() statement in the name resolver associated with the optimization that converts compound selects with ORDER BY COLLATE into subqueries. (user: drh, tags: trunk)
05:57
[9e1f837b] Correctly handle COLLATE operators applied to COLLATE operators in an ORDER BY clause. (user: drh, tags: trunk)
05:38
[998cfdb8] Fix a faulty assert() in the sqlite3StrAccumAppend() routine. (user: drh, tags: trunk)
05:31
[a0b6e2fe] Correctly deal with an unknown collating sequence on an indexed DISTINCT query. (user: drh, tags: trunk)
05:20
[7c27310b] When adding the implied "LIMIT 1" to the end of a scalar subquery, make sure that subquery is not a VALUES-only query as such queries cannot deal with LIMIT clauses. (user: drh, tags: trunk)
04:51
[d7211b68] When doing the (dubious) conversion of double-quoted identifier into string literal for MySQL compatibility, be sure to also clear the iTable value from the Expr entry to avoid an assert. (user: drh, tags: trunk)
04:20
[38727425] Add a test case for what was formerly thought to be an unreachable condition: when the LHS of an OR operator contains an error and the RHS contains an IN operator. (user: drh, tags: trunk)
04:10
[a084690b] An oversize hex literal can cause a parsing error while generating code for constants that are factored out of the main body of the VDBE program. So allow for that case. (user: drh, tags: trunk)
2015-04-14
19:01
[88b22761] Add the --summary option to the sqldiff command-line tool. (user: drh, tags: trunk)
15:14
[b549cbce] Update API documentation to identify many functions as methods on objects. No changes to code. (user: drh, tags: trunk)
2015-04-13
23:05
[211411d0] Add #ifdef magic for HAVE_GETHOSTUUID so that the build will hopefully now work on more verions of MacOS with SQLITE_ENABLE_LOCKING_STYLE turned on. (user: drh, tags: trunk)
22:26
[661db19b] On a DETACH statement, keep all schemas intact except fo the one that is being detached, and thus avoid unnecessary schema reparsing. (user: drh, tags: trunk)
21:39
[d2f10c41] Omit the "pc" or "program counter" variable from the VDBE loop for 0.6% performance increase. (user: drh, tags: trunk)
19:14
[e29c7f2c] Remove the out2-prerelease VDBE opcode property and its associated code, for a 0.5% performance improvement. (user: drh, tags: trunk)
17:43
[bc33af86] Add a comment to wal.c to explain why a race condition is safe. (user: dan, tags: trunk)
14:44
[d06669d9] Remove a faulty assert() from the btree balancing logic. (user: drh, tags: trunk)
14:08
[ce6eaac1] Test that if the definition of a collation sequence is changed and VACUUM run, the new database contains records sorted in the (new) correct order. (user: dan, tags: trunk)
14:03
[65ace4b0] Remove an unreachable branch from the VACUUM logic. (user: drh, tags: trunk)
12:45
[f666ef06] Remove an unreachable branch from the vdbeSorterCompareInt() routine. (user: drh, tags: trunk)
2015-04-12
21:28
[bd2cfa1d] Update the version number to 3.8.10 because of the new sort optimizations from check-in [79326d6eec]. (user: drh, tags: trunk)
17:35
[9a453f52] Fix a problem with a stale Select.pWith pointer when a CTE is used together with a compound query and an ORDER BY clause. (user: drh, tags: trunk)
01:22
[e527d96a] Avoid problems when a query has a GROUP BY and an ORDER BY but no FROM clause. (user: drh, tags: trunk)
2015-04-11
20:44
[79326d6e] Optimizations for VACUUM, CREATE INDEX and some cases of ORDER BY. (user: dan, tags: trunk)
20:20
[acca97ef] Fix a problem with sorting large amounts of partially ordered data. (user: dan, tags: trunk)
13:49
[f9a3a839] Add the --changeset option to the sqldiff utility program, for generating a sessions changeset file instead of an SQL diff. (user: drh, tags: trunk)
11:53
[da49700c] Update tests in whereD.test to account for the change in the previous commit. (user: dan, tags: trunk)
11:44
[e3b1f625] Do not assume an index contains unique entries unless it is declared UNIQUE and NOT NULL is specified for all columns. Fix for [7b4fee9f6c]. (user: dan, tags: trunk)
02:08
[9e139afd] Detect and report oversized records constructed from multiple zeroblobs. (user: drh, tags: trunk)
2015-04-10
21:16
[40c417a7] Minor build enhancements for MSVC. (user: mistachkin, tags: trunk)
16:05
[860e4f8a] In sqlite3_declare_vtab(), avoid accessing the database structure until after the "api-armour" safety-check has completed and the db mutex has been obtained. (user: dan, tags: trunk)
12:04
[ed3cbaab] Fix foreign key CASCADE for cases where the parent key is an INTEGER PRIMARY KEY and the parent table contains other columns named "rowid", "_rowid_", and "oid". (user: drh, tags: trunk)
07:55
[0a72726d] Do not allow virtual table constructors to be called recursively. (user: dan, tags: trunk)
2015-04-09
19:39
[ee53b460] Fix incorrect column names in UPDATE statements generated by the sqldiff utility. (user: drh, tags: trunk)
18:14
[5063f907] Add the --primarykey option to the sqldiff tool, which causes it to use the schema-defined PRIMARY KEY. (user: drh, tags: trunk)
16:30
[83b342a4] Remove two pointless assert() statements. This should silence harmless compiler warnings reported at https://bugzilla.mozilla.org/show_bug.cgi?id=1152845 (user: drh, tags: trunk)
13:40
[32ab2bb9] Fix comment typos in the sqldiff.c utility program. (user: drh, tags: trunk)
13:34
[88da5bf5] Add the "sqldiff" utility program. (user: drh, tags: trunk)
11:24
[79861adb] Remove a variable initializion to silence a harmless compiler warning. (user: drh, tags: trunk)
2015-04-08
12:16
[8a8ffc86] Version 3.8.9 (user: drh, tags: trunk, release, version-3.8.9)