SQLite
Timeline
Not logged in

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

2015-08-29
19:41
[1da60c3d] Leaf: Enhance the json_extract() function so that if given multiple PATH arguments it will return a JSON array with all of the answers. Also update comments within the json1 extension to reflect stricter interpretation of JSON and PATH arguments. (user: drh, tags: trunk)
19:03
[2e8e239c] Link the json1 extension into the command-line shell by default. (user: drh, tags: trunk)
18:30
[daff4832] New test cases for the json1 extension. (user: drh, tags: trunk)
17:22
[752918de] Fix the build with -DSQLITE_OMIT_VIRTUALTABLE. (user: drh, tags: trunk)
16:02
[fd19ff02] Do not consider an empty string to be valid JSON. Add some additional JSON test cases. (user: drh, tags: trunk)
00:54
[3aa0855f] Change the json1.c module so that it throws an error if any of the JSON selector paths are malformed. (user: drh, tags: trunk)
2015-08-28
20:07
[dc9ce7b1] Back out the json_check() routine. Instead, throw an error if the input to a json function (other than json_valid()) is not valid JSON. (user: drh, tags: trunk)
16:41
[0fdc36fe] Fix compiler warnings in rbu code. (user: dan, tags: trunk)
16:18
[a84cf4f5] When searching the wal file for a frame, do not search that part that was already checkpointed when the transaction was opened. (user: dan, tags: trunk)
03:48
[64abb65d] Add the json_check() function, which returns its argument if the argument is well-formed JSON or which throws an error otherwise. (user: drh, tags: trunk)
03:33
[44f103d8] Enhance the json_insert(), json_replace(), and json_set() functions with the ability to add JSON instead of text if the argument is text and if the PATH begins with '$$' instead of just '$'. (user: drh, tags: trunk)
2015-08-27
23:18
[66f92a16] Fix the OR-optimization so that it always ignores subplans that do not use an index. (user: drh, tags: trunk)
2015-08-26
21:08
[cbc3c9a8] Reduce the size of the WhereScan object by 24 bytes while also clarifying its operation. (user: drh, tags: trunk)
14:01
[c2f3bbad] Evaluate expressions only once when the same expression is used in both the result set and in the ORDER BY clause. (user: drh, tags: trunk)
11:40
[58ba7363] Refactor With.a.zErr into With.a.zCteErr. No logic changes. (user: drh, tags: trunk)
11:34
[65a89187] Update the TreeView output for compound SELECT statements so that all entries are shown vertically aligned rather than each successive entry being indented. (user: drh, tags: trunk)
2015-08-25
19:42
[b3732a4e] Move sqlite3IndexColumnAffinity() inside of SQLITE_ENABLE_STAT3_OR_STAT4. (user: drh, tags: trunk)
19:20
[1ee089a7] Use the sqlite3IndexColumnAffinity() routine to quickly and correctly find the affinity of an index column. (user: drh, tags: trunk)
00:34
[8f1d9f1f] Fix a memory leak that might occur when compiling with SQLITE_OMIT_CHECK. (user: drh, tags: trunk)
2015-08-24
20:54
[bdaf6646] Remove some redundant code: Call sqlite3ResolveExprListNames() rather than calling sqlite3ResolveExprNames() in a loop - in two places. (user: drh, tags: trunk)
20:21
[bed42116] Enhances the parser so that it accepts arbitrary expressions for the arguments of an index, though the code generator still rejects everything other than simple column names. The sqlite3RestrictColumnListSyntax() routine is removed since that feature is now handled by the parser. (user: drh, tags: trunk)
17:42
[d794b34d] Enhance the CREATE VIEW syntax so that the names of columns of the view can be specified after the view name. (user: drh, tags: trunk)
17:18
[a1ae20cd] Enhancements to the batch build tool for MSVC. (user: mistachkin, tags: trunk)
15:39
[83cbc4d8] Disallow the use of COLLATE clauses and the ASC and DESC keywords within foreign key constraints and in the argument list to common table expressions. (user: drh, tags: trunk)
12:42
[196d66d3] Improvements to JSON string dequoting. (user: drh, tags: trunk)
02:32
[f0aba0e1] Fix corner-case problems in the type and atom columns of json_each() and json_tree(). (user: drh, tags: trunk)
2015-08-23
20:48
[518d6220] Fix a comment typo on sqlite3ExprAlloc(). No code changes. (user: drh, tags: trunk)
20:44
[cc520414] Fix minor glitches in the json1.c extension, mostly having to do with OOM behavior. (user: drh, tags: trunk)
02:42
[fc1b24f3] Fixes to json_each() and json_tree(). Improved json_parse() debugging output. (user: drh, tags: trunk)
2015-08-22
19:39
[380a9734] Add the json_valid() function to the json1.c extension. Fix various minor problems in the json1.c extension. (user: drh, tags: trunk)
03:05
[213a6c5c] Fix a couple instances of OOM handling in the json extension. (user: drh, tags: trunk)
01:32
[351bc22f] Do not apply the WHERE-clause pushdown optimization to terms that originate in the ON or USING clause of a LEFT JOIN. Fix for ticket [6df18e949d3676290]. (user: drh, tags: trunk)
2015-08-21
20:43
[178f9a35] Add extension functions for processing JSON. (user: drh, tags: trunk)
19:53
[da3c9df0] Add a missing #define for sqlite3_vsnprintf to sqlite3ext.h. (user: drh, tags: trunk)
17:39
[53b593fc] Reserve the SQLITE_IOERR_VNODE error code name. (user: drh, tags: trunk)
17:14
[552bc9cb] Fix a corner-case bug in table-valued functions. Update the generate_series() virtual table to increase the performance estimate penalty for being underspecified. (user: drh, tags: trunk)
12:37
[7b8d17dd] Fix typo in comment. No changes to code. (user: drh, tags: trunk)
2015-08-20
23:33
[64d13339] Compiler-warning fixes in the sqldiff.exe utility. (user: drh, tags: trunk)
23:28
[bc577fe6] Fix a couple C99-isms that cause compile errors on MSVC. (user: drh, tags: trunk)
23:21
[774e6a14] Fix corner-case memory management issues in table-valued functions. Change virtual table handling so that if xDestroy is missing the table is eponymous only even if xCreate is present. (user: drh, tags: trunk)
21:14
[b73ad305] Skip calling the virtual table xDestroy method when it is null. (user: mistachkin, tags: trunk)
20:21
[17eb7f18] Fix stray variable declaration for C89. (user: mistachkin, tags: trunk)
20:13
[a7acc787] Correctly handle empty function argument lists on table-valued functions. (user: drh, tags: trunk)
19:55
[9b718b06] Add support for table-valued functions in the FROM clause implemented as virtual tables. (user: drh, tags: trunk)
17:18
[fd13dd95] Make SQLITE_BUSY_SNAPSHOT and SQLITE_BUSY_RECOVERY retryable, just as a plain SQLITE_BUSY is. (user: drh, tags: trunk)
2015-08-19
12:45
[c573b0a1] Simplification to error handling in addModuleArgument() in the virtual table processing. (user: drh, tags: trunk)
08:34
[dec14a39] When updating a zipvfs database with RBU, set journal_mode=off to prevent the upper-level pager from creating a large temporary file. (user: dan, tags: trunk)
2015-08-18
19:09
[85994020] Add test file spellfix2.test, which should have been checked in some time ago. (user: dan, tags: trunk)
16:32
[02448a9f] Fix harmless compiler warning in FTS5. (user: mistachkin, tags: trunk)
2015-08-15
16:32
[f65a9b4a] Minor fix to the display of oversized KeyInfo structures in the P4 operand of Open opcodes in EXPLAIN output. (user: drh, tags: trunk)
2015-08-14
12:53
[5e06a9c1] Duplicate the output of releasetest.tcl into releasetest-out.txt (user: drh, tags: trunk)
2015-08-13
18:26
[851a875a] Add the sqlite3rbu_savestate() function to the rbu extension. To force rbu to save its state to disk without closing the sqlite3rbu* handle. (user: dan, tags: trunk)
11:46
[ee966af8] Avoid invoking system call unlink() directly from RBU code. Use the xDelete method of the default VFS instead. (user: dan, tags: trunk)
2015-08-12
15:36
[efb7c9c5] Minor optimization for fts5 API xInst(). (user: dan, tags: trunk)
12:11
[f7682435] Add the xPhraseFirst() and xPhraseNext() fts5 APIs, for faster iteration through a single phrases position list. Also optimize xInst() and xInstCount() a bit. (user: dan, tags: trunk)
2015-08-11
14:25
[61cb2fc6] Merge fixes from the fts5NoWarn branch. (user: dan, tags: trunk)
2015-08-08
23:30
[fd5608fb] Fix compiler warnings and remove unreachable code. (user: drh, tags: trunk)
15:13
[1d75a41b] Update RBU to avoid repreparing a statement immediately after it is prepared. (user: dan, tags: trunk)
2015-08-07
20:57
[06576590] Enhance the query planner so that it is able to use partial indexes that use AND-connected terms in the WHERE clause. (user: drh, tags: trunk)
20:06
[6d47b35a] Add a specially formatted comment to shell.c to make it easier for scripts to edit. No code changes. (user: dan, tags: trunk)
2015-08-06
12:54
[e596a6b6] increase the version number to 3.8.12 (user: drh, tags: trunk)
03:09
[483ebe89] Fix duplicate test numbering in the FTS5 matchinfo tests. (user: mistachkin, tags: trunk)
2015-08-05
19:35
[9e3aafe4] Add tests for the matchinfo-like test function. Fix problems found in test and fts5 code by doing so. (user: dan, tags: trunk)
15:29
[08888383] Update the spellfix virtual table extension so that an explicit "top = ?" constraint works even if there is also a "distance < ?" or "distance <= ?" constraint. (user: dan, tags: trunk)
08:01
[c9ff4ca4] Fix some problems in test code detected by cppcheck. (user: dan, tags: trunk)
07:43
[dffd358f] Remove all references to "docid" within fts5 source code and comments. Replace with "rowid". (user: dan, tags: trunk)
2015-08-04
20:29
[4f9520a9] Add new test file fts5_test_mi.c, containing an implementation of a function similar to FTS4 matchinfo() for FTS5. (user: dan, tags: trunk)
19:06
[783f78e3] Improve the usage comment on sqlite3_analyzer: show the available switches. (user: drh, tags: trunk)
15:29
[e3c6d4b6] Update the [showdb] program so that the database file is read directly (bypassing the SQLite VFS) only if the --raw option is specified. Otherwise, it is read using the default VFS. Also, the URI syntax may be used on the command line to specify the name of the database file to examine, so an alternative VFS may be requested using a URI parameter. (user: dan, tags: trunk)
14:18
[cd997770] In the sqlite3_analyzer.exe utility, show the depth of each btree and report the average fanout of indexes and WITHOUT ROWID tables. (user: drh, tags: trunk)
2015-08-03
13:44
[70b57daf] Allow a VIEW to reference undefined tables and functions when initially created. The error report is deferred until the VIEW is used. This allows views to be created before subviews and tables that the view references. (user: drh, tags: trunk)
2015-08-01
18:18
[34190449] Add extra tests for RBU and FTS3/4. (user: dan, tags: trunk)
2015-07-31
19:52
[e26ef165] Add support for "fossil deltas" to RBU and "sqldiff --rbu". (user: dan, tags: trunk)
18:59
[047d3475] Fix the sqlite3_stmt_busy() interface so that it always returns FALSE after the statement has returned SQLITE_DONE, even for ROLLBACK statements. Clarify the documentation. (user: drh, tags: trunk)
17:48
[54a771fe] Remove a duplicate "typedef struct Fts5Global Fts5Global;" from fts5_main.c (duplicate is in fts5Int.h). (user: dan, tags: trunk)
15:14
[fee7ad73] When building the VSIX package for UAP, omit the AppLocal suffix for the MSVC runtime library because it is no longer needed. (user: mistachkin, tags: trunk)
15:13
[93449e70] Fix a problem causing [sqldiff --rbu] to fail on tables for which all columns are part of the PRIMARY KEY. (user: dan, tags: trunk)
14:43
[c3c672af] Fix a bug in the fts5 porter tokenizer preventing it from passing xCreate() arguments through to its parent tokenizer. (user: dan, tags: trunk)
2015-07-30
20:26
[098bea26] Add the --rbu switch to the "sqldiff" utility. (user: dan, tags: trunk)
11:38
[287aa306] Allow RBU tables to be named "data[0-9]*_<target>" instead of strictly "data_<target>". Also update RBU so that it always processes data tables in order sorted by name. (user: dan, tags: trunk)
11:26
[8e818b89] Return an error message (instead of segfaulting) if test function fts5_expr() is invoked with no arguments. (user: dan, tags: trunk)
2015-07-29
22:38
[96559adb] Support building VSIX packages for UAP using Visual Studio 2015 and the Windows 10 SDK. (user: mistachkin, tags: trunk)
21:47
[f0075d73] Add SQLITE_DISABLE_INTRINSIC define to disable use of intrinsic functions (e.g. for certain older compilers and/or platforms). (user: mistachkin, tags: trunk)
20:24
[a0020c57] Fix the releasetest.tcl script so that it ignore cast overflow errors that recent versions of clang generate but which are unavoidable given the test input. (user: drh, tags: trunk)
20:00
[cf538e27] Version 3.8.11.1 (user: drh, tags: trunk, release, version-3.8.11.1)