SQLite
Timeline
Not logged in

200 most recent check-ins using file src/func.c version 9d52522c

2017-10-11
20:10
[58e42cfd] Change some internal details to bring this branch closer to the code on trunk. (user: dan, tags: schemalint)
2017-08-18
19:28
[605907e7] Leaf: Version 3.19.4 (user: drh, tags: release, branch-3.19, version-3.19.4)
2017-07-31
13:22
[2dd0c77d] Use batch atomic writes when running on a recent F2FS filesystem, if compiled with SQLITE_ENABLE_BATCH_ATOMIC_WRITE. (user: drh, tags: branch-3.19)
13:11
[499942b3] Move the generation of output column names earlier, to right after name resolution and before query transformations such as flattening. This prevents the names from getting mangled by query transformations, and obviates hacks in the query flattener that attempt to work around the name mangling. The resulting code is smaller and faster and gives more consistent output. This is a fix for ticket [de3403bf5ae5f72ed] and a cherry-pick of check-in [09834279aeca3bda] (user: drh, tags: branch-3.19)
12:19
[322a2ede] Correctly handle an "INTEGER PRIMARY KEY UNIQUE" column in a WITHOUT ROWID table. This is a fix for ticket [bc115541132dad136], cherry-picked from check-in [5216bfb73f1a49bdd8] (user: drh, tags: branch-3.19)
12:07
[b77f297d] Increase the version number to 3.19.4 (user: drh, tags: branch-3.19)
12:04
[4be4265d] Leaf: Merge further enhancements to the batch-atomic-write subsystem. (user: drh, tags: batch-atomic-write-3.19)
2017-07-28
02:02
[def55027] Backport of all batch-atomic-write changes through check-in [67bad7fb9b] (user: drh, tags: batch-atomic-write-3.19)
2017-07-27
00:27
[24c9cd46] Do now allow the geometry object in the right operand of a MATCH operator in the RTREE extension to be inpersonated by a BLOB literal. (user: drh, tags: branch-3.19)
2017-07-21
07:56
[8201f4e1] Leaf: Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This changes is a cherry-pick of [f0f49224] via [69906880cee] and is ultimately inspired by check-in [72de49f2]. (user: drh, tags: branch-3.18)
2017-07-07
22:39
[6b618b18] Fix test cases in wal2.test due to the fact that Darwin checks to see if the SHM file is writable before attempting to open in read/write. (user: drh, tags: apple-osx)
20:33
[d9d92781] Avoid even trying to open a SHM file read/write in WAL mode if we know that the file is read-only. This avoids scare security log messages. (user: drh, tags: apple-osx)
16:12
[a3a9a2e1] Have this branch maintain an in-memory hash-table of old pages for read-only MVCC clients. There is no way to access it yet. (user: dan, tags: server-process-edition)
2017-07-06
13:23
[06269257] Avoid unnecessary upper-to-lower case conversion for function names when registering the built-in functions. (user: drh, tags: trunk)
03:06
[55ecd303] Small size reduction in findCollSeqEntry(). (user: drh, tags: trunk)
02:49
[503ba172] Avoid unnecessary calls to sqlite3GetCollSeq() for a small performance gain. (user: drh, tags: trunk)
01:28
[4da663d9] Slightly more compact implementation of the byte-code generator for the COMMIT and ROLLBACK commands. (user: drh, tags: trunk)
01:02
[7b2623f1] Small performance increase in sqlite3SrcListAppend(). (user: drh, tags: trunk)
2017-07-05
23:33
[f762f1ef] Make the hash table implementation a little smaller and faster. (user: drh, tags: trunk)
18:48
[b6b14ab6] Have fts3 virtual table cursors free internal resources when they reach EOF, instead of waiting until the xClose method is called. (user: dan, tags: trunk)
14:29
[2bce64c8] Fix a problem in lsmtest causing one test to fail for multi-threaded LSM connections. (user: dan, tags: trunk)
2017-07-04
19:34
[d1ba2002] Add the count-of-view optimization when compiled using SQLITE_COUNTOFVIEW_OPTIMIZATION. (user: drh, tags: trunk)
19:23
[ca757c86] Fix further OOM handling cases in LSM. (user: dan, tags: trunk)
17:25
[989a5c17] Fix a couple of problems in handling OOM conditions within LSM. (user: dan, tags: trunk)
12:50
[268a40f4] Fix a problem in the lempar.c Lemon template for YYSTACKDEPTH<=0 introduced by check-in [36e54cd8b1fb37] (user: drh, tags: trunk)
2017-07-03
21:09
[9bd3be92] Fix compiler warnings in LSM1, especially in the test logic. (user: drh, tags: trunk)
20:19
[b2c24879] Fix a bug in lsm queries on levels undergoing incremental an merge that contain range-delete markers. (user: dan, tags: trunk)
17:37
[9111ac69] Attempt to improve documentation on sqlite3_column_ and sqlite3_value_ interfaces. (user: drh, tags: trunk)
09:00
[e34eafd4] Add more tests for LSM log file recovery. Fix a problem in recovering log files that contain range deletes. (user: dan, tags: trunk)
2017-07-01
20:59
[dd55af30] Fix a memory management problem in lsm log recovery code. (user: dan, tags: trunk)
15:21
[66de6f4a] Enhance the RTree module to detect node truncation early and report an error. (user: drh, tags: trunk)
2017-06-30
23:46
[a99fa94d] Update the carray() and remember() extension functions so that they user the new sqlite3_value_pointer() interface. (user: drh, tags: bind-pointer)
23:09
[d9f4a831] Add APIs for binding pointers that can be used by app-defined functions. (user: drh, tags: bind-pointer)
20:11
[0db20efe] Improved documentation for sqlite3_value_type(). (user: drh, tags: trunk)
19:22
[d076d58f] Add some assert() statements in the Win32 interface for lsm1. (user: mistachkin, tags: trunk)
18:12
[0ef777d7] Fix some minor typos in lsm1. (user: mistachkin, tags: trunk)
11:44
[bacfe8cb] Avoid constantly freeing and reallocing small internal buffers associated with LSM cursors. Instead, allow them to persist for the lifetime of the cursor if they are LSM_SEGMENTPTR_FREE_THRESHOLD (default 1024) bytes or smaller. This change is based on research by Martijn Blaauw. (user: dan, tags: trunk)
2017-06-29
21:33
[5e3f9ea5] In the command-line shell, add the -quote option to start up in quote mode. Enhance the ".mode" command so that it reports the current output mode if given no arguments. (user: drh, tags: trunk)
21:11
[7782c04e] Remove the ".explain" command from the ".help" output of the command-line shell, though keep the implementation around for backwards compatibility. (user: drh, tags: trunk)
20:31
[a26e17ee] Some simple tests for the STMT virtual table. (user: drh, tags: trunk)
20:23
[3ed6877f] Avoid reading or writing the 32 locking bytes at the end of the first meta-page of an LSM database. (user: dan, tags: trunk)
20:13
[2b5df3e8] Closed-Leaf: Avoid reading or writing the 32 locking bytes at the end of the first meta-page of an LSM database. (user: dan, tags: lsm-metapage-fix)
19:08
[38ec4141] Fix issues in the POSIX and Win32 interfaces for lsm1. (user: mistachkin, tags: trunk)
17:27
[284707a7] Edit comments in sqlite.h.in used for generating documentation, to improve the description of the new sqlite3_prepare_v3() interfaces, and other miscellaneous cleanup. No changes to executable code. (user: drh, tags: trunk)
16:51
[cae64769] More updates to the Win32 interface for lsm1. (user: mistachkin, tags: trunk)
15:57
[1b4facb1] Correct typo in the Win32 interface for lsm1. (user: mistachkin, tags: trunk)
15:24
[03977248] Add interfaces sqlite3_prepare_v3() and sqlite3_prepare16_v3() with the extra prepFlags argument. Add the SQLITE_PREPARE_PERSISTENT option as one bit in that argument. Use the new option in FTS3, FTS5, and RTREE. (user: drh, tags: trunk)
15:13
[4df6e247] Further corrections to the Win32 interface for lsm1. (user: mistachkin, tags: trunk)
14:33
[adfdb801] Rename the "stmts" virtual table to just "stmt" without the final "s". (user: drh, tags: trunk)
14:17
[ebbd98e9] A couple fixes for the Win32 interface for lsm1. (user: mistachkin, tags: trunk)
13:41
[60c62829] Add the stmts virtual table to testfixture builds. Add new compile-time options SQLITE_ENABLE_QPSG and SQLITE_ENABLE_STMTSVTAB to ctime.c (user: drh, tags: trunk)
13:35
[b7794cc5] Compilation fix for lsm1 using MSVC. (user: mistachkin, tags: trunk)
13:19
[824e8327] Add the LSM1 extension. (user: drh, tags: trunk)
13:13
[88976ae3] Add the "stmts" virtual table to the amalgamation, activated when compiled using -DSQLITE_ENABLE_STMTSVTAB. Add the SQLITE_STMTSTATUS_REPREPARE and SQLITE_STMTSTATUS_RUN statistics outputs from sqlite3_stmt_status() and add corresponding columns to the stmts virtual table. Change the numeric value of SQLITE_STMTSTATUS_MEMUSED to get it out of the way of counter values. (user: drh, tags: trunk)
12:59
[c322bfa2] The query planner examines the values of bound parameters to help determine if a partial index is usable. Reprepares may happen if the bindings change. This behavior is disabled by the QPSG setting. (user: drh, tags: trunk)
12:54
[680cc064] Closed-Leaf: Implement xUnlink, xShmMap, and xShmUnmap for lsm1 on Win32. (user: mistachkin, tags: lsm-vtab)
12:49
[b0b0c8f8] Closed-Leaf: Add the SQLITE_STMTSTATUS_REPREPARE and SQLITE_STMTSTATUS_RUN options to sqlite3_stmt_status(). Use this for two new columns in the stmts virtual table. (user: drh, tags: stmts-vtab)
01:23
[25acd965] Closed-Leaf: Fix the exprCompareVariable() routine so that it works for non-UTF8 text. (user: drh, tags: partial-index-variables)
00:20
[93c9aa7d] Implement xRemap for lsm1 on Win32. Also, zero file handle when closing it. (user: mistachkin, tags: lsm-vtab)
2017-06-28
21:47
[b959c629] Alternative implementation of exprCompareVariable(). (user: drh, tags: partial-index-variables)
21:36
[9112117d] Implement xLock and xTestLock for lsm1 on Win32. (user: mistachkin, tags: lsm-vtab)
20:21
[58a0aab8] Merge tserver fixes with this branch. (user: dan, tags: server-process-edition)
20:12
[093b9108] Leaf: Fix bugs in test program tserver.c. (user: dan, tags: server-edition)
18:25
[a934dd14] Make the query planners use of partial indexes based on bound variables responsive to the SQLITE_DBCONFIG_ENABLE_QPSG setting. (user: drh, tags: partial-index-variables)
18:07
[8f63c586] Merge the in the latest enhancements from trunk. (user: drh, tags: partial-index-variables)
17:29
[942c3ef8] Closed-Leaf: Instead of the new sqlite3_prepare_v3() interface, provide the SQLITE_DBCONFIG_PREPARE_FLAGS interface which sets the flags on the single next call to sqlite3_prepare_v2() or its cousins. (user: drh, tags: dbconfig-prepare-flags)
15:56
[62b8269b] Closed-Leaf: Incorporate recent trunk changes. (user: drh, tags: prepare_v3)
15:47
[0ff057d8] Build the "stmts" virtual table into the amalgamation. It is active only when compiled using SQLITE_ENABLE_STMTSVTAB. That option is supplied to the command-line shell. (user: drh, tags: stmts-vtab)
15:17
[f02a5459] Fix harmless compiler warnings in the CSV extension. (user: drh, tags: trunk)
15:01
[36e54cd8] Faster parser stack overflow detection. (user: drh, tags: trunk)
14:26
[cc4810b2] Minor tweak to the SQL grammar to make the parser tables a few bytes smaller. (user: drh, tags: trunk)
13:47
[b362f0d8] In the lemon-generated parser, store the number of symbols on the RHS of each rule as a negative number and add it to the stack pointer, rather than storing the value as a positive and subtracting it. This makes the parser faster. (user: drh, tags: trunk)
11:56
[c46d94a8] In the lemon-generated parser, automatically promote SHIFTREDUCE actions on nonterminal systems to pure REDUCE actions, for a performance enhancement. (user: drh, tags: trunk)
01:21
[6480916c] Simplify error handling logic in sqlite3_exec() to save about 40 bytes. (user: drh, tags: trunk)
01:12
[bfc4e7f3] Minor code simplification in the ALTER TABLE logic. (user: drh, tags: trunk)
00:55
[29d6ceb3] Avoid an unnecessary call to sqlite3XPrintf() in the code generator, for a performance improvement. (user: drh, tags: trunk)
2017-06-27
23:36
[b82efd2a] Add SQLITE_DBCONFIG_ENABLE_QPSG that forces the query planner stability guarantee. This is the fix for ticket [b9f010107724c] (user: drh, tags: trunk)
22:33
[d0f6973d] Improve a local variable name. (user: mistachkin, tags: lsm-vtab)
22:27
[7e669d9b] Initial work on porting lsmtest to Win32. (user: mistachkin, tags: lsm-vtab)
20:23
[dfa9a4d5] Support clients within a single process only. (user: dan, tags: server-process-edition)
18:15
[dbe9c8aa] Implement xFullpath for lsm1 on Win32. (user: mistachkin, tags: lsm-vtab)
16:48
[2b095406] Merge latest trunk changes with this branch. (user: dan, tags: apple-osx)
16:39
[87b38166] Fix a virtual table problem that can occur when the vtab is on the RHS of a LEFT JOIN and there is a MATCH constraint in the ON clause, or when the vtab is in a sub-query that is the RHS of a LEFT JOIN and there is a MATCH constraint in the WHERE clause of the sub-query. (user: dan, tags: trunk)
06:28
[e1cf8a78] Minor corrections to the previous check-in. (user: mistachkin, tags: lsm-vtab)
05:59
[2017636e] Work in progress porting lsm1 to Win32. (user: mistachkin, tags: lsm-vtab)
2017-06-26
21:08
[18f0616e] Add the -withoutnulls option to the "db eval" method in the TCL interface. (user: drh, tags: trunk)
18:42
[7c15d762] The ".import" command of the shell, and the csv virtual table extension both ignore a single UTF-8 BOM at the beginning of their input. (user: drh, tags: trunk)
16:13
[cbe441b2] Closed-Leaf: Add the "-unsetnull 1" option to the "sqlite3" command in the TCL interface. (user: drh, tags: unsetnull-option)
14:46
[ebcfa73e] Closed-Leaf: Make sure sqlite3VdbeSetVarmask() is never invoked when QPSG is enabled. (user: drh, tags: enable-QPSG)
13:57
[7076e828] Add the SQLITE_DBCONFIG_ENABLE_QPSG option to activate the query planner stability guarantee. This involves refactoring the sqlite3.flags bitvector to carve out a free bit to use. (user: drh, tags: enable-QPSG)
11:46
[ca8a7e99] Remove an invalid assert() from lsm test code. (user: dan, tags: lsm-vtab)
08:24
[461ced77] Fix another problem with multi-threaded mode in the LSM test code. (user: dan, tags: lsm-vtab)
07:31
[d7015475] Update a test case to reflect the fact that the lsm blocksize is configured in KiB. And defaults to 1024, not 2048. (user: dan, tags: lsm-vtab)
06:53
[23f16382] Fix some compiler warnings in lsm_file.c. (user: dan, tags: lsm-vtab)
2017-06-24
19:21
[c8186874] Disable shell tests for the .schema command if virtual tables are not available. (user: drh, tags: trunk)
18:10
[7b59c353] Consider the values bound to SQL variables when determining whether or not a partial index may be used. (user: dan, tags: partial-index-variables)
16:35
[c2ea6293] Make sure the config.h header is included by ctime.c, if that header exists. (user: drh, tags: trunk)
16:03
[f0ec36d4] Query planner tuning: When deciding between two plans with the same cost, bias the selection toward the one that does not use the sorter. (user: drh, tags: trunk)
13:31
[0583b84a] Make sure enough memory is allocated for pathological quoting cases when computing a quoted table name in the command-line shell. (user: drh, tags: trunk)
2017-06-23
21:05
[53b14a38] Merge all recent trunk enhancements into the apple-osx branch. (user: drh, tags: apple-osx)
15:47
[712267c9] When generating individual loops for each ORed term of an OR scan, move any constant WHERE expressions outside of the loop, as is done for top-level loops. (user: dan, tags: trunk)
2017-06-22
16:51
[e4a022be] Closed-Leaf: When generating individual loops for each ORed term of an OR scan, move any constant WHERE expressions outside of the loop, as is done for top-level loops. (user: dan, tags: or-optimization)
2017-06-21
01:36
[118f7bb3] Enable pragma virtual tables for the integrity_check, quick_check, and foreign_key_check pragmas. (user: drh, tags: trunk)
2017-06-20
19:20
[d8568aac] Ensure that test tool "tserver" finalizes all statements before attempting to close a database handle. (user: dan, tags: server-edition)
18:19
[94e420ec] Rename the azCompileOpt global constant to avoid a harmless compiler warning about a name conflict with a local variable. (user: drh, tags: trunk)
17:43
[48346268] Ensure that the query planner knows that any column of a flattened LEFT JOIN can be NULL even if that column is labeled with "NOT NULL". Fix for ticket [892fc34f173e99d8]. (user: dan, tags: trunk)
2017-06-19
11:44
[f1682f0f] Closed-Leaf: Experimental "PRAGMA secure_delete=FAST" pragma. The intent is to overwrite deleted content with zeros without increasing the amount of disk I/O. (user: drh, tags: fast-secure-delete)
2017-06-17
19:06
[c21628e9] Leaf: Avoid adding an artifical "LIMIT 1" on scalar subqueries that do not need it. This seems like a pointless optimization as it makes minimal run-time difference but does increase code complexity. Parked on a branch for historical reference. (user: drh, tags: subquery-limit-opt)
18:49
[f3db02f4] Fix a missing comma in the previous check-in. (user: drh, tags: trunk)
17:55
[9a443397] Rework the code in ctime.c a bit to report on more compile time options. And to only output configuration options passed in to SQLite, not the default values of #define symbols set automatically. Also generate the large array in ctime.c using new script tool/mkctime.tcl, instead of entering it manually. (user: dan, tags: trunk)
17:29
[95141c64] Closed-Leaf: Ensure that the value of the THREADSAFE symbol is always included when reporting compile time options, even if it was not explicitly configured. (user: dan, tags: ctime-refactor)
16:39
[603838fc] Add extra test cases for sqlite3changeset_apply() and ALTER TABLE ADD COLUMN. (user: dan, tags: trunk)
09:59
[036ebf72] Version 3.18.2 (user: drh, tags: release, branch-3.18, version-3.18.2)
00:39
[e1b71029] When building an ephemeral table of integers, do not assume that the table does not already contain N if the insert cursor points to N-1. Fix for ticket [61fe9745]. Also increase the version number to 3.18.2. This is the release candidate. (user: drh, tags: branch-3.18)
2017-06-16
19:51
[bc1951d6] Rework the code in ctime.c a bit to report on more compile time options. And to only output configuration options passed in to SQLite, not the default values of #define symbols set automatically. Also generate the large array in ctime.c using new script tool/mkctime.tcl, instead of entering it manually. (user: dan, tags: ctime-refactor)
18:31
[3944a32e] Minor refactoring change to clarify how ATTACH works. No functional changes. (user: drh, tags: trunk)
13:43
[11693849] Prevent pagesize changes on VACUUM in encrypted databases even when running the VACUUM on an attached database. (user: drh, tags: trunk)
13:41
[77bb4623] Version 3.18.1 (user: drh, tags: release, branch-3.18, version-3.18.1)
12:15
[20e5ffb1] An unintentional fork was created due to a typo when creating branch-3.18. This check-in resolves the fork and is the 3.18.1 release candidate. (user: drh, tags: branch-3.18)
2017-06-15
16:56
[254617a1] Move the "shell_add_schema()" SQL function used by the ".schema" command of the command-line shell to a different spot in the shell.c source file so that it is not in the middle of an unrelated module. (user: drh, tags: trunk)
16:45
[ca1ff707] Fix typo and improve the wording of the description of "Metadata" in the output of the sqlite3_analyzer tool. (user: drh, tags: trunk)
15:06
[60105c22] Merge the latest changes from trunk. (user: drh, tags: lsm-vtab)
13:07
[9afd7a2f] Fix harmless compiler warnings in the shell.c file (user: drh, tags: trunk)
12:50
[c7f778b7] Improvements to the ".tables" command in the command-line shell so that it shows the name of all schemas if the name is anything other than "main". (user: drh, tags: trunk)
12:21
[48e08628] In the command-line shell, enhance the ".schema" command show that it shows the schema for ATTACH-ed databases in addition to "main". (user: drh, tags: trunk)
07:47
[4be2eba8] Increase the version number to 3.18.1. (user: drh, tags: branch-3.18)
00:52
[43ad41ef] Enhance the sqlite3_analyzer.exe utility so that it computes and shows the number of bytes of metadata on btree pages and per table and index entry. (user: drh, tags: trunk)
2017-06-13
16:52
[c433672d] Fix sqlite3rbu_close() so that the pzErrmsg parameter may be passed NULL. (user: dan, tags: trunk)
04:31
[35b34bdf] Fix the processing of double-negatives in WHERE clause constraints with STAT4. Ticket [cfa2c908f2182] (user: drh, tags: trunk)
2017-06-12
23:44
[30c50f0e] Ensure pointer map entries are always added when a row that does use overflow pages replaces one that does not in an auto-vacuum database. Fix for [fda22108]. (user: drh, tags: branch-3.18)
2017-06-11
20:17
[0bbdaf28] Fix an off-by-one error that messes up the display of loop codes in the ".wheretrace" debugging output for queries with more than 62 candidate loops when SQLITE_ENABLE_WHERETRACE is on. (user: drh, tags: trunk)
19:51
[87aceb41] When reusing a materialized view, make sure the estimated number of output rows is correctly initialized to avoid confusing the query planner. (user: drh, tags: trunk)
19:40
[8f92b7a6] Fix the sessiondiff test module so that it does not run if the session extension is not enabled. (user: drh, tags: trunk)
18:26
[a2f77285] Fix a potential null-pointer deference following OOM introduced by check-in [e39795d7] (unreleased). (user: drh, tags: trunk)
2017-06-10
17:23
[79544fc2] Remove sqlite3_log() and abort() calls added to this branch to debug the pointer-map problem ([fda22108]). (user: dan, tags: begin-concurrent)
2017-06-09
15:14
[3fd050c3] Merge enhancements and fixes from trunk. (user: drh, tags: prepare_v3)
11:43
[2881ab1e] Update the documentation to make it clear that the table name parameter to sqlite3_table_column_metadata() may not be NULL. (user: drh, tags: trunk)
02:27
[3168e2c9] Adjust the implementation of the ".selftest" feature of the shell to avoid using the deprecated sqlite3_get_table() interface. (user: drh, tags: trunk)
2017-06-08
16:23
[8e311a6d] Update the recent auto-vacuum fix so that it works for the in-memory pointer-map structure used by this branch. (user: dan, tags: begin-concurrent)
16:10
[e2d38d51] Merge 3.19.3 changes with this branch. (user: dan, tags: begin-concurrent)
15:54
[0f59bb94] Merge changes for version 3.19.0 with this branch. (user: dan, tags: begin-concurrent)
14:41
[93f32dd2] Merge the auto_vacuum bug fix and all other changes from the 3.19.3 release. (user: drh, tags: apple-osx)
14:35
[343e5599] Add a testcase() to confirm that an OOM on sqlite3DbStrNDup() is handled correctly in trigger.c. (user: drh, tags: trunk)
14:26
[0ee482a1] Version 3.19.3 (user: drh, tags: release, branch-3.19, version-3.19.3)
11:32
[97b5c4a5] Fix an issue with OPT_FEATURE_FLAGS in configure.ac. (user: drh, tags: branch-3.19)
11:27
[903fff53] Increase the version number to 3.19.3. (user: drh, tags: branch-3.19)
11:26
[9478106c] Ensure pointer map entries are always added when a row that does use overflow pages replaces one that does not in an auto-vacuum database. Fix for [fda22108]. (user: drh, tags: branch-3.19)
11:14
[b30dfba8] Ensure pointer map entries are always added when a row that does use overflow pages replaces one that does not in an auto-vacuum database. Fix for [fda22108]. (user: dan, tags: trunk)
2017-06-07
22:32
[e39795d7] In SQLITE_DEBUG mode, attempt to log the page number of the database that contained the problem when SQLITE_CORRUPT errors are seen. (user: drh, tags: trunk)
19:46
[61853bc1] Fix another lsmtest build problem. Add the "-trans BOOLEAN" option to "lsmtest speed2". (user: dan, tags: lsm-vtab)
16:25
[f8bbb608] Merge in trunk enhancements. (user: drh, tags: prepare_v3)
15:55
[05b4fc43] Add too/tserver.c - the implementation of a simple multi-threaded server designed for interactive testing of concurrency between connections used by different threads of the same process. (user: dan, tags: server-edition)
10:55
[c81f260c] Leaf: Cause the ANALYZE command to build sqlite_stat1 table entries for empty tables with the assumption that such tables really contain 10 elements. This gives better query plans for tables that are truely empty, but is likely to cause problems in legacy systems, so the change is kept off trunk. Some TCL tests fail on this check-in due to the new stat1 entries. (user: drh, tags: analyze-empty-tables)
2017-06-06
18:20
[234ede26] Add the SQLITE_DEFAULT_ROWEST compile-time option for changing the estimated number of rows in tables that lack sqlite_stat1 entries. (user: drh, tags: trunk)
16:14
[501238b9] Fix a threading problem in lsm test code. (user: dan, tags: lsm-vtab)
2017-06-05
19:20
[9eea3670] Fix a subtle bug in the remember UDF of the kvtest.exe utility program. (user: drh, tags: trunk)
16:33
[73c70590] Fix a bug in test_fs.c that occurs when the first component of a path contains a GLOB or LIKE escape character. (user: dan, tags: trunk)
13:28
[f3c25df4] For the kvtest utility, add the --vacuum option to "kvtest stat" and also run PRAGMA integrity_check with "kvtest stat". (user: drh, tags: trunk)
12:29
[ed0842c1] Fix the column width deduction logic in the command-line shell to account for multi-byte utf8 characters. (user: drh, tags: trunk)
10:31
[ead29f9c] Omit some of the fstree tests in vtabH if the PWD contains LIKE wildcards. (user: drh, tags: trunk)
2017-06-03
20:09
[65182ce0] Initialize a variable to zero to prevent an (incorrect) compiler warning of it potentially being uninitialized. (user: drh, tags: trunk)
19:16
[c4089ffb] Fix the SQLITE_PTR_TO_INT macro so that works on recent versions of LLVM on Macs. (user: drh, tags: trunk)
18:27
[dd7e043f] Remove unused header file from kvtest. (user: drh, tags: trunk)
17:24
[f568f666] In kvtest, add the ability to work with a hierarchy of files on disk, in addition to having all files in the same directory. (user: drh, tags: trunk)
15:17
[5828633c] Add the --nocheckpoint and --multitrans options to kvtest. (user: drh, tags: trunk)
2017-06-02
23:44
[1d23294d] Merge all recent trunk enhancements. (user: drh, tags: lsm-vtab)
23:32
[7fdc78a6] Add the --fsync flag to kvtest, and document the --nosync flag. (user: drh, tags: trunk)
19:31
[fc73e7d2] Work toward enhancing kvtest to measure write performance. (user: drh, tags: trunk)
15:44
[ab33d299] Change the name of the OP_Seek opcode into OP_DeferredSeek for better clarity of function. No functional code changes. (user: drh, tags: trunk)
13:16
[d637feb4] Fix a typo in the header comment of the "series.c" virtual table extension. (user: drh, tags: trunk)
09:31
[f131677d] Extend even further the logging designed to find problems in the pointer-map structure. Call abort() to dump a core as soon as such a problem is seen. (user: dan, tags: begin-concurrent)
2017-06-01
01:53
[4c2458c1] Add a comment to the Lemon documentation regarding the security of the lemon.exe command-line tool. (user: drh, tags: trunk)
00:54
[4a25c588] Add interfaces sqlite3_prepare_v3() and sqlite3_prepare16_v3() with the extra prepFlags argument. Add the SQLITE_PREPARE_PERSISTENT option as one bit in that argument. (user: drh, tags: prepare_v3)
2017-05-31
17:30
[c26cf978] Add the SQLITE_STMTSTATUS_MEMUSED opcode to sqlite3_stmt_status() for finding the heap memory usage by a single prepared statement. (user: drh, tags: trunk)
17:06
[f7e3e2bc] Generate extra log messages in response to irregularites in the pointer-map used by "BEGIN CONCURRENT" transactions. (user: dan, tags: begin-concurrent)
16:21
[b57d5104] Closed-Leaf: Add the SQLITE_STMTSTATUS_MEMUSED option for sqlite3_stmt_status() that reports the amount of heap memory used for a single prepared statement. (user: drh, tags: stmtstatus-memused)
16:09
[cb4c5c66] Add the experimental "stmts" virtual table for introspection of prepared statements. (user: drh, tags: trunk)
13:45
[df785943] Avoid allocating excess memory to the KeyInfo objects. (user: drh, tags: trunk)
13:27
[7d58836b] Remove a completely unnecessary memset() from the INSERT code generator. (user: drh, tags: trunk)
11:24
[8885b446] Very small performance increase in sqlite3VdbeSetNumCols(). (user: drh, tags: trunk)
03:20
[326e63d7] Reorder fields in the PgHdr object for a performance increase. (user: drh, tags: trunk)
02:58
[de28e651] Avoid unnecessary memory zeroing during expression list allocation. (user: drh, tags: trunk)
00:49
[af8c0fed] Size and performance optimizations to sqlite3ResolveExprNames(). (user: drh, tags: trunk)
2017-05-30
18:34
[e972a386] Change sqlite3BtreeNext() and sqlite3BtreePrevious() so that they return SQLITE_DONE if they have already reached the end (or beginning) of the table. This gives a performance increase and size reduction. (user: drh, tags: trunk)
18:14
[69ae6889] Omit a test of codepoint 0x202F (non-break narrow space) from the fts3 ICU tests. Different versions of ICU apparently handle this obscure codepoint slightly differently. (user: dan, tags: trunk)
2017-05-29
22:44
[9a3e3b34] More efficient error handling and reset in the binding mechanism. (user: drh, tags: trunk)
19:23
[9ad846e5] Instead of a root page number, log the object (table or index) name if a page level locking conflict is detected. (user: dan, tags: begin-concurrent)
17:59
[dd61c736] Omit unnecessary fstat() calls for determining the database file size, resulting in smaller and faster code. (user: drh, tags: trunk)
17:43
[43ce3bd3] Fix an issue with OPT_FEATURE_FLAGS in configure.ac. (user: drh, tags: trunk)
16:45
[6c3476b5] Closed-Leaf: Avoid unnecessary fstat() calls to determine the database size when transitioning into a read transaction on a rollback-mode database. (user: drh, tags: io-opt)
14:57
[c733a1de] Avoid unnecessary calls to fstat() to determine the database file size. (user: drh, tags: io-opt)
14:30
[cb29b838] Fix a typo in a comment. No code changes. (user: drh, tags: trunk)
14:27
[92618492] Enhance the log messages emitted when a page conflict is detected. (user: dan, tags: begin-concurrent)
14:26
[6854a34e] Optimizations to the Walker object and its methods to make the code a little smaller and to help it run a little faster. (user: drh, tags: trunk)
13:09
[43c9ae37] Correctly initialize the iSelectId of FROM clause terms that are a self join of a reused materialized subquery. Without this, the EXPLAIN QUERY PLAN output for the query will identify the subquery using the uninitialized (and arbitrary) iSelectId. (user: drh, tags: trunk)
03:48
[7cc940a9] Improve shell help text for the '.open' command. (user: mistachkin, tags: trunk)
2017-05-27
22:42
[542dc4c5] Smaller and faster vdbeSorterCompareText(). (user: drh, tags: trunk)
18:05
[214d238a] Leaf: Add debugging functions btreePageOriginFile() and btreePageOriginOffset(). (user: dan, tags: btree-debug)
2017-05-26
18:18
[a7e0e7a4] Adjust the bitvec related sqlite3_log messages added by [9527089b]. (user: dan, tags: begin-concurrent)
16:51
[9df01957] Add extra test cases for deferred page allocation. (user: dan, tags: begin-concurrent)