/ Timeline
Login

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

100 descendants and 100 ancestors of [43ad41ef]

2017-07-06
01:02
Small performance increase in sqlite3SrcListAppend(). check-in: 7b2623f1 user: drh tags: trunk
2017-07-05
23:33
Make the hash table implementation a little smaller and faster. check-in: f762f1ef user: drh tags: trunk
18:48
Have fts3 virtual table cursors free internal resources when they reach EOF, instead of waiting until the xClose method is called. check-in: b6b14ab6 user: dan tags: trunk
14:29
Fix a problem in lsmtest causing one test to fail for multi-threaded LSM connections. check-in: 2bce64c8 user: dan tags: trunk
2017-07-04
19:34
Add the count-of-view optimization when compiled using SQLITE_COUNTOFVIEW_OPTIMIZATION. check-in: d1ba2002 user: drh tags: trunk
19:23
Fix further OOM handling cases in LSM. check-in: ca757c86 user: dan tags: trunk
17:25
Fix a couple of problems in handling OOM conditions within LSM. check-in: 989a5c17 user: dan tags: trunk
12:50
Fix a problem in the lempar.c Lemon template for YYSTACKDEPTH<=0 introduced by check-in [36e54cd8b1fb37] check-in: 268a40f4 user: drh tags: trunk
2017-07-03
21:09
Fix compiler warnings in LSM1, especially in the test logic. check-in: 9bd3be92 user: drh tags: trunk
20:19
Fix a bug in lsm queries on levels undergoing incremental an merge that contain range-delete markers. check-in: b2c24879 user: dan tags: trunk
17:37
Attempt to improve documentation on sqlite3_column_ and sqlite3_value_ interfaces. check-in: 9111ac69 user: drh tags: trunk
09:00
Add more tests for LSM log file recovery. Fix a problem in recovering log files that contain range deletes. check-in: e34eafd4 user: dan tags: trunk
2017-07-01
20:59
Fix a memory management problem in lsm log recovery code. check-in: dd55af30 user: dan tags: trunk
15:21
Enhance the RTree module to detect node truncation early and report an error. check-in: 66de6f4a user: drh tags: trunk
2017-06-30
23:46
Update the carray() and remember() extension functions so that they user the new sqlite3_value_pointer() interface. check-in: a99fa94d user: drh tags: bind-pointer
23:09
Add APIs for binding pointers that can be used by app-defined functions. check-in: d9f4a831 user: drh tags: bind-pointer
20:11
Improved documentation for sqlite3_value_type(). check-in: 0db20efe user: drh tags: trunk
19:22
Add some assert() statements in the Win32 interface for lsm1. check-in: d076d58f user: mistachkin tags: trunk
18:12
Fix some minor typos in lsm1. check-in: 0ef777d7 user: mistachkin tags: trunk
11:44
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. check-in: bacfe8cb user: dan tags: trunk
2017-06-29
21:33
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. check-in: 5e3f9ea5 user: drh tags: trunk
21:11
Remove the ".explain" command from the ".help" output of the command-line shell, though keep the implementation around for backwards compatibility. check-in: 7782c04e user: drh tags: trunk
20:31
Some simple tests for the STMT virtual table. check-in: a26e17ee user: drh tags: trunk
20:23
Avoid reading or writing the 32 locking bytes at the end of the first meta-page of an LSM database. check-in: 3ed6877f user: dan tags: trunk
20:13
Avoid reading or writing the 32 locking bytes at the end of the first meta-page of an LSM database. Closed-Leaf check-in: 2b5df3e8 user: dan tags: lsm-metapage-fix
19:08
Fix issues in the POSIX and Win32 interfaces for lsm1. check-in: 38ec4141 user: mistachkin tags: trunk
17:27
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. check-in: 284707a7 user: drh tags: trunk
16:51
More updates to the Win32 interface for lsm1. check-in: cae64769 user: mistachkin tags: trunk
15:57
Correct typo in the Win32 interface for lsm1. check-in: 1b4facb1 user: mistachkin tags: trunk
15:24
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. check-in: 03977248 user: drh tags: trunk
15:13
Further corrections to the Win32 interface for lsm1. check-in: 4df6e247 user: mistachkin tags: trunk
14:33
Rename the "stmts" virtual table to just "stmt" without the final "s". check-in: adfdb801 user: drh tags: trunk
14:17
A couple fixes for the Win32 interface for lsm1. check-in: ebbd98e9 user: mistachkin tags: trunk
13:41
Add the stmts virtual table to testfixture builds. Add new compile-time options SQLITE_ENABLE_QPSG and SQLITE_ENABLE_STMTSVTAB to ctime.c check-in: 60c62829 user: drh tags: trunk
13:35
Compilation fix for lsm1 using MSVC. check-in: b7794cc5 user: mistachkin tags: trunk
13:19
Add the LSM1 extension. check-in: 824e8327 user: drh tags: trunk
13:13
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. check-in: 88976ae3 user: drh tags: trunk
12:59
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. check-in: c322bfa2 user: drh tags: trunk
12:54
Implement xUnlink, xShmMap, and xShmUnmap for lsm1 on Win32. Closed-Leaf check-in: 680cc064 user: mistachkin tags: lsm-vtab
12:49
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. Closed-Leaf check-in: b0b0c8f8 user: drh tags: stmts-vtab
01:23
Fix the exprCompareVariable() routine so that it works for non-UTF8 text. Closed-Leaf check-in: 25acd965 user: drh tags: partial-index-variables
00:20
Implement xRemap for lsm1 on Win32. Also, zero file handle when closing it. check-in: 93c9aa7d user: mistachkin tags: lsm-vtab
2017-06-28
21:47
Alternative implementation of exprCompareVariable(). check-in: b959c629 user: drh tags: partial-index-variables
21:36
Implement xLock and xTestLock for lsm1 on Win32. check-in: 9112117d user: mistachkin tags: lsm-vtab
18:25
Make the query planners use of partial indexes based on bound variables responsive to the SQLITE_DBCONFIG_ENABLE_QPSG setting. check-in: a934dd14 user: drh tags: partial-index-variables
18:07
Merge the in the latest enhancements from trunk. check-in: 8f63c586 user: drh tags: partial-index-variables
17:29
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. Closed-Leaf check-in: 942c3ef8 user: drh tags: dbconfig-prepare-flags
15:56
Incorporate recent trunk changes. Closed-Leaf check-in: 62b8269b user: drh tags: prepare_v3
15:47
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. check-in: 0ff057d8 user: drh tags: stmts-vtab
15:17
Fix harmless compiler warnings in the CSV extension. check-in: f02a5459 user: drh tags: trunk
15:01
Faster parser stack overflow detection. check-in: 36e54cd8 user: drh tags: trunk
14:26
Minor tweak to the SQL grammar to make the parser tables a few bytes smaller. check-in: cc4810b2 user: drh tags: trunk
13:47
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. check-in: b362f0d8 user: drh tags: trunk
11:56
In the lemon-generated parser, automatically promote SHIFTREDUCE actions on nonterminal systems to pure REDUCE actions, for a performance enhancement. check-in: c46d94a8 user: drh tags: trunk
01:21
Simplify error handling logic in sqlite3_exec() to save about 40 bytes. check-in: 6480916c user: drh tags: trunk
01:12
Minor code simplification in the ALTER TABLE logic. check-in: bfc4e7f3 user: drh tags: trunk
00:55
Avoid an unnecessary call to sqlite3XPrintf() in the code generator, for a performance improvement. check-in: 29d6ceb3 user: drh tags: trunk
2017-06-27
23:36
Add SQLITE_DBCONFIG_ENABLE_QPSG that forces the query planner stability guarantee. This is the fix for ticket [b9f010107724c] check-in: b82efd2a user: drh tags: trunk
22:33
Improve a local variable name. check-in: d0f6973d user: mistachkin tags: lsm-vtab
22:27
Initial work on porting lsmtest to Win32. check-in: 7e669d9b user: mistachkin tags: lsm-vtab
18:15
Implement xFullpath for lsm1 on Win32. check-in: dbe9c8aa user: mistachkin tags: lsm-vtab
16:48
Merge latest trunk changes with this branch. check-in: 2b095406 user: dan tags: apple-osx
16:39
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. check-in: 87b38166 user: dan tags: trunk
06:28
Minor corrections to the previous check-in. check-in: e1cf8a78 user: mistachkin tags: lsm-vtab
05:59
Work in progress porting lsm1 to Win32. check-in: 2017636e user: mistachkin tags: lsm-vtab
2017-06-26
21:08
Add the -withoutnulls option to the "db eval" method in the TCL interface. check-in: 18f0616e user: drh tags: trunk
18:42
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. check-in: 7c15d762 user: drh tags: trunk
16:13
Add the "-unsetnull 1" option to the "sqlite3" command in the TCL interface. Closed-Leaf check-in: cbe441b2 user: drh tags: unsetnull-option
14:46
Make sure sqlite3VdbeSetVarmask() is never invoked when QPSG is enabled. Closed-Leaf check-in: ebcfa73e user: drh tags: enable-QPSG
13:57
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. check-in: 7076e828 user: drh tags: enable-QPSG
11:46
Remove an invalid assert() from lsm test code. check-in: ca8a7e99 user: dan tags: lsm-vtab
08:24
Fix another problem with multi-threaded mode in the LSM test code. check-in: 461ced77 user: dan tags: lsm-vtab
07:31
Update a test case to reflect the fact that the lsm blocksize is configured in KiB. And defaults to 1024, not 2048. check-in: d7015475 user: dan tags: lsm-vtab
06:53
Fix some compiler warnings in lsm_file.c. check-in: 23f16382 user: dan tags: lsm-vtab
2017-06-24
19:21
Disable shell tests for the .schema command if virtual tables are not available. check-in: c8186874 user: drh tags: trunk
18:10
Consider the values bound to SQL variables when determining whether or not a partial index may be used. check-in: 7b59c353 user: dan tags: partial-index-variables
16:35
Make sure the config.h header is included by ctime.c, if that header exists. check-in: c2ea6293 user: drh tags: trunk
16:03
Query planner tuning: When deciding between two plans with the same cost, bias the selection toward the one that does not use the sorter. check-in: f0ec36d4 user: drh tags: trunk
13:31
Make sure enough memory is allocated for pathological quoting cases when computing a quoted table name in the command-line shell. check-in: 0583b84a user: drh tags: trunk
2017-06-23
21:05
Merge all recent trunk enhancements into the apple-osx branch. check-in: 53b14a38 user: drh tags: apple-osx
15:47
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. check-in: 712267c9 user: dan tags: trunk
2017-06-22
16:51
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. Closed-Leaf check-in: e4a022be user: dan tags: or-optimization
2017-06-21
01:36
Enable pragma virtual tables for the integrity_check, quick_check, and foreign_key_check pragmas. check-in: 118f7bb3 user: drh tags: trunk
2017-06-20
18:19
Rename the azCompileOpt global constant to avoid a harmless compiler warning about a name conflict with a local variable. check-in: 94e420ec user: drh tags: trunk
17:43
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]. check-in: 48346268 user: dan tags: trunk
2017-06-19
11:44
Experimental "PRAGMA secure_delete=FAST" pragma. The intent is to overwrite deleted content with zeros without increasing the amount of disk I/O. Closed-Leaf check-in: f1682f0f user: drh tags: fast-secure-delete
2017-06-17
19:06
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. Leaf check-in: c21628e9 user: drh tags: subquery-limit-opt
18:49
Fix a missing comma in the previous check-in. check-in: f3db02f4 user: drh tags: trunk
17:55
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. check-in: 9a443397 user: dan tags: trunk
17:29
Ensure that the value of the THREADSAFE symbol is always included when reporting compile time options, even if it was not explicitly configured. Closed-Leaf check-in: 95141c64 user: dan tags: ctime-refactor
16:39
Add extra test cases for sqlite3changeset_apply() and ALTER TABLE ADD COLUMN. check-in: 603838fc user: dan tags: trunk
2017-06-16
19:51
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. check-in: bc1951d6 user: dan tags: ctime-refactor
18:31
Minor refactoring change to clarify how ATTACH works. No functional changes. check-in: 3944a32e user: drh tags: trunk
13:43
Prevent pagesize changes on VACUUM in encrypted databases even when running the VACUUM on an attached database. check-in: 11693849 user: drh tags: trunk
2017-06-15
16:56
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. check-in: 254617a1 user: drh tags: trunk
16:45
Fix typo and improve the wording of the description of "Metadata" in the output of the sqlite3_analyzer tool. check-in: ca1ff707 user: drh tags: trunk
15:06
Merge the latest changes from trunk. check-in: 60105c22 user: drh tags: lsm-vtab
13:07
Fix harmless compiler warnings in the shell.c file check-in: 9afd7a2f user: drh tags: trunk
12:50
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". check-in: c7f778b7 user: drh tags: trunk
12:21
In the command-line shell, enhance the ".schema" command show that it shows the schema for ATTACH-ed databases in addition to "main". check-in: 48e08628 user: drh tags: trunk
00:52
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. check-in: 43ad41ef user: drh tags: trunk
2017-06-13
16:52
Fix sqlite3rbu_close() so that the pzErrmsg parameter may be passed NULL. check-in: c433672d user: dan tags: trunk
04:31
Fix the processing of double-negatives in WHERE clause constraints with STAT4. Ticket [cfa2c908f2182] check-in: 35b34bdf user: drh tags: trunk
2017-06-11
20:17
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. check-in: 0bbdaf28 user: drh tags: trunk
19:51
When reusing a materialized view, make sure the estimated number of output rows is correctly initialized to avoid confusing the query planner. check-in: 87aceb41 user: drh tags: trunk
19:40
Fix the sessiondiff test module so that it does not run if the session extension is not enabled. check-in: 8f92b7a6 user: drh tags: trunk
18:26
Fix a potential null-pointer deference following OOM introduced by check-in [e39795d7] (unreleased). check-in: a2f77285 user: drh tags: trunk
2017-06-09
11:43
Update the documentation to make it clear that the table name parameter to sqlite3_table_column_metadata() may not be NULL. check-in: 2881ab1e user: drh tags: trunk
02:27
Adjust the implementation of the ".selftest" feature of the shell to avoid using the deprecated sqlite3_get_table() interface. check-in: 3168e2c9 user: drh tags: trunk
2017-06-08
14:35
Add a testcase() to confirm that an OOM on sqlite3DbStrNDup() is handled correctly in trigger.c. check-in: 343e5599 user: drh tags: trunk
11:14
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]. check-in: b30dfba8 user: dan tags: trunk
2017-06-07
22:32
In SQLITE_DEBUG mode, attempt to log the page number of the database that contained the problem when SQLITE_CORRUPT errors are seen. check-in: e39795d7 user: drh tags: trunk
2017-06-06
18:20
Add the SQLITE_DEFAULT_ROWEST compile-time option for changing the estimated number of rows in tables that lack sqlite_stat1 entries. check-in: 234ede26 user: drh tags: trunk
2017-06-05
19:20
Fix a subtle bug in the remember UDF of the kvtest.exe utility program. check-in: 9eea3670 user: drh tags: trunk
16:33
Fix a bug in test_fs.c that occurs when the first component of a path contains a GLOB or LIKE escape character. check-in: 73c70590 user: dan tags: trunk
13:28
For the kvtest utility, add the --vacuum option to "kvtest stat" and also run PRAGMA integrity_check with "kvtest stat". check-in: f3c25df4 user: drh tags: trunk
12:29
Fix the column width deduction logic in the command-line shell to account for multi-byte utf8 characters. check-in: ed0842c1 user: drh tags: trunk
10:31
Omit some of the fstree tests in vtabH if the PWD contains LIKE wildcards. check-in: ead29f9c user: drh tags: trunk
2017-06-03
20:09
Initialize a variable to zero to prevent an (incorrect) compiler warning of it potentially being uninitialized. check-in: 65182ce0 user: drh tags: trunk
19:16
Fix the SQLITE_PTR_TO_INT macro so that works on recent versions of LLVM on Macs. check-in: c4089ffb user: drh tags: trunk
18:27
Remove unused header file from kvtest. check-in: dd7e043f user: drh tags: trunk
17:24
In kvtest, add the ability to work with a hierarchy of files on disk, in addition to having all files in the same directory. check-in: f568f666 user: drh tags: trunk
15:17
Add the --nocheckpoint and --multitrans options to kvtest. check-in: 5828633c user: drh tags: trunk
2017-06-02
23:32
Add the --fsync flag to kvtest, and document the --nosync flag. check-in: 7fdc78a6 user: drh tags: trunk
19:31
Work toward enhancing kvtest to measure write performance. check-in: fc73e7d2 user: drh tags: trunk
15:44
Change the name of the OP_Seek opcode into OP_DeferredSeek for better clarity of function. No functional code changes. check-in: ab33d299 user: drh tags: trunk
13:16
Fix a typo in the header comment of the "series.c" virtual table extension. check-in: d637feb4 user: drh tags: trunk
2017-06-01
01:53
Add a comment to the Lemon documentation regarding the security of the lemon.exe command-line tool. check-in: 4c2458c1 user: drh tags: trunk
2017-05-31
17:30
Add the SQLITE_STMTSTATUS_MEMUSED opcode to sqlite3_stmt_status() for finding the heap memory usage by a single prepared statement. check-in: c26cf978 user: drh tags: trunk
16:21
Add the SQLITE_STMTSTATUS_MEMUSED option for sqlite3_stmt_status() that reports the amount of heap memory used for a single prepared statement. Closed-Leaf check-in: b57d5104 user: drh tags: stmtstatus-memused
16:09
Add the experimental "stmts" virtual table for introspection of prepared statements. check-in: cb4c5c66 user: drh tags: trunk
13:45
Avoid allocating excess memory to the KeyInfo objects. check-in: df785943 user: drh tags: trunk
13:27
Remove a completely unnecessary memset() from the INSERT code generator. check-in: 7d58836b user: drh tags: trunk
11:24
Very small performance increase in sqlite3VdbeSetNumCols(). check-in: 8885b446 user: drh tags: trunk
03:20
Reorder fields in the PgHdr object for a performance increase. check-in: 326e63d7 user: drh tags: trunk
02:58
Avoid unnecessary memory zeroing during expression list allocation. check-in: de28e651 user: drh tags: trunk
00:49
Size and performance optimizations to sqlite3ResolveExprNames(). check-in: af8c0fed user: drh tags: trunk
2017-05-30
18:34
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. check-in: e972a386 user: drh tags: trunk
18:14
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. check-in: 69ae6889 user: dan tags: trunk
2017-05-29
22:44
More efficient error handling and reset in the binding mechanism. check-in: 9a3e3b34 user: drh tags: trunk
17:59
Omit unnecessary fstat() calls for determining the database file size, resulting in smaller and faster code. check-in: dd61c736 user: drh tags: trunk
17:43
Fix an issue with OPT_FEATURE_FLAGS in configure.ac. check-in: 43ce3bd3 user: drh tags: trunk
16:45
Avoid unnecessary fstat() calls to determine the database size when transitioning into a read transaction on a rollback-mode database. Closed-Leaf check-in: 6c3476b5 user: drh tags: io-opt
14:57
Avoid unnecessary calls to fstat() to determine the database file size. check-in: c733a1de user: drh tags: io-opt
14:30
Fix a typo in a comment. No code changes. check-in: cb29b838 user: drh tags: trunk
14:26
Optimizations to the Walker object and its methods to make the code a little smaller and to help it run a little faster. check-in: 6854a34e user: drh tags: trunk
13:09
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. check-in: 43c9ae37 user: drh tags: trunk
03:48
Improve shell help text for the '.open' command. check-in: 7cc940a9 user: mistachkin tags: trunk
2017-05-27
22:42
Smaller and faster vdbeSorterCompareText(). check-in: 542dc4c5 user: drh tags: trunk
2017-05-25
21:35
Small performance increase and size decrease in the btreeInitPage() routine. check-in: 6f415833 user: drh tags: trunk
17:27
Merge the LEFT JOIN query flattener fixes from 3.19.2. check-in: 6513e4a1 user: drh tags: trunk
16:50
Version 3.19.2 check-in: edb4e819 user: drh tags: release, branch-3.19, version-3.19.2
11:39
The SQLITE_EXTRA_IFNULLROW compile-time option causes OP_IfNullRow opcodes to be issued for references to the right-hand side table of *any* flattened join, not just LEFT JOINs. This puts extra stress on the OP_IfNUllRow opcodes for testing purposes. check-in: 1a074c8a user: drh tags: branch-3.19
00:28
The TK_IF_NULL_ROW expression node must be treated as a variable that references the table Expr.iTable. Proposed fix for ticket [7fde638e94287d2c]. check-in: b30a364a user: drh tags: branch-3.19
00:12
Increase the version number to 3.19.2 since ticket [7fde638e94287d2] is going to necessitate another patch release. check-in: c315727a user: drh tags: branch-3.19
00:08
The TK_IF_NULL_ROW expression node must be treated as a variable that references the table Expr.iTable. Proposed fix for ticket [7fde638e94287d2c]. check-in: 77fc2301 user: drh tags: trunk
2017-05-24
15:32
Fix harmless compiler warnings in FTS5. check-in: 57a60e95 user: mistachkin tags: trunk
13:08
Version 3.19.1 check-in: f6d7b988 user: drh tags: release, branch-3.19, version-3.19.1
04:18
Fix a problem in STAT4 equality estimation for multi-column indexes introduced by check-in [3e0590dee0e68cc1599]. check-in: cfb0d9e0 user: drh tags: trunk
2017-05-23
20:00
Remove the msvc.h header file from the autoconf tarball. check-in: 84996aef user: drh tags: trunk
19:35
Do not use strcpy() in the (obsolete) amatch extension. In releasetest.tcl, run Apple tests using -Os instead of -O1 check-in: 4440e420 user: drh tags: trunk
15:33
Disable the LEFT JOIN flattening optimization for aggregate queries, as it does not currently work. Further fix for ticket [cad1ab4cb7b0fc344]. check-in: 05ada741 user: drh tags: branch-3.19
15:21
Disable the LEFT JOIN flattening optimization for aggregate queries, as it does not currently work. Further fix for ticket [cad1ab4cb7b0fc344]. check-in: 44b21e35 user: drh tags: trunk
12:44
Ensure that the expression rewriter inside the query flattener decends into the substructure of the TK_IF_NULL_ROW operator. This is a continuation of the fix for ticket [cad1ab4cb7b0fc344]. check-in: 28d2902d user: drh tags: branch-3.19
12:36
Ensure that the expression rewriter inside the query flattener decends into the substructure of the TK_IF_NULL_ROW operator. This is a continuation of the fix for ticket [cad1ab4cb7b0fc344]. check-in: 941d8142 user: drh tags: trunk
01:35
Change the version number to 3.19.1. check-in: 16656b8f user: drh tags: branch-3.19
01:30
Remove a surplus semicolon, which was harmless on gcc and clang but caused compile-time errors on msvc. This only comes up using the encryption extension. check-in: 4510d55d user: drh tags: branch-3.19
01:29
When flattening a query, make sure iTable attribute of TK_IF_NULL_ROW operators (that result from a prior flattening of a LEFT JOIN) are updated correctly. Fix for ticket [cad1ab4cb7b0fc344]. check-in: 919d36e6 user: drh tags: branch-3.19
01:21
When flattening a query, make sure iTable attribute of TK_IF_NULL_ROW operators (that result from a prior flattening of a LEFT JOIN) are updated correctly. Fix for ticket [cad1ab4cb7b0fc344]. check-in: 92c17850 user: drh tags: trunk
00:32
Remove a surplus semicolon, which was harmless on gcc and clang but caused compile-time errors on msvc. This only comes up using the encryption extension. check-in: 987a2b55 user: drh tags: trunk
2017-05-22
18:09
Fix incompatibilities between the "sqldiff --changeset" command and the sessions module. Specifically, allow sessions to process changesets containing tables with zero operations on them and have sqldiff output the expected output for tables with multi-column primary keys. check-in: 0bb23c48 user: dan tags: trunk
18:00
Add the ".cd" command to the command-line shell. check-in: 5fe28e15 user: drh tags: trunk
17:39
Increase the version number to 3.20 for the next release cycle. check-in: ab471f61 user: drh tags: trunk
14:04
Merge the last-minute 3.19.0 changes into trunk. check-in: e6ba2a93 user: drh tags: trunk
13:58
Version 3.19.0 check-in: 28a94eb2 user: drh tags: release, branch-3.19, version-3.19.0
13:06
Include the "msvc.h" header file in the amalgamation tarball. check-in: 3dd6fe53 user: drh tags: branch-3.19
08:04
Fix a case where NULL was being passed to memcmp() following an OOM. This is probably not a real problem, as the number-of-bytes parameter was passed 0 in this case, but it was causing a santizer complaint. check-in: 3ea2bad2 user: dan tags: trunk
00:45
When planning a query using sorting, resolve ties in the solver by selecting loop plans with the smaller unsorted cost. check-in: f261678c user: drh tags: trunk
2017-05-19
23:04
Prevent a possible NULL pointer dereference in the OP_Found opcode that can follow an OOM error. Problem found by OSS-Fuzz. check-in: 50ad60de user: drh tags: branch-3.19
22:51
Prevent a possible NULL pointer dereference in the OP_Found opcode that can follow an OOM error. Problem found by OSS-Fuzz. check-in: c2de178f user: drh tags: trunk
20:55
Improved comments on one routine in the query planner. Improved diagnostic output for ".wheretrace". No production code changes. check-in: 946b87a5 user: drh tags: trunk
20:47
Fix a documentation typo. No changes to code. check-in: 68942a4f user: drh tags: trunk
20:46
Branch for the 3.19 release. check-in: f2b829ec user: drh tags: branch-3.19
12:32
Fix some problems in fts5 code detected by -fsanitize=undefined. check-in: 35f72104 user: dan tags: trunk
2017-05-18
18:17
Fix a documentation typo. No changes to code. Closed-Leaf check-in: cfa4aa20 user: drh tags: doc-type
2017-05-16
09:49
Update the tool/warnings.sh script to automatically use the right options on OpenBSD. check-in: 7940bff3 user: dan tags: trunk
2017-05-15
15:12
Fix the build so that it works again with SQLITE_OMIT_SUBQUERY. check-in: bb0d9281 user: drh tags: trunk
15:05
Improvements to the omittest.tcl script. check-in: 0f05d7e9 user: drh tags: trunk
2017-05-12
14:05
Make sure the 'sqlite3changegroup_*' functions are included in the SQLITE_APICALL handling. check-in: a123cb93 user: mistachkin tags: trunk
2017-05-11
19:09
Add another test case for the new authorizer functionality. check-in: 339df63f user: dan tags: trunk
18:42
Enhance the json_extract() function to reuse parses of the same JSON when the function appears multiple times in the same query. check-in: 3ba9e7ab user: drh tags: trunk
18:14
Do not save the state of an fts5 merge operation mid-way through an input term, even if no previous entry for that term has caused any output. Doing so may corrupt the FTS index. check-in: 9a2de4f0 user: dan tags: trunk
16:49
Cache the JSON parse used by json_extract(). Closed-Leaf check-in: 44ca6c2c user: drh tags: auxdata-cache
15:20
Negative N values in sqlite3_get_auxdata() and sqlite3_set_auxdata() can be used to access an auxiliary data cache over all functions in a single prepared statement. check-in: ff530675 user: drh tags: auxdata-cache
13:43
New requirements marks and documentation for the authorizer. check-in: 3980ea09 user: drh tags: trunk
12:27
Improvements to the sqlite3_set_authorizer() documentation. check-in: 47629b19 user: drh tags: trunk
12:05
Change the SQLITE_READ authorization call for unreferenced tables to use an empty string for the column name, as this is less likely to impact legacy authorization callbacks that assume column names are always non-NULL. check-in: 4139953a user: drh tags: trunk
2017-05-10
19:42
Rename fields of the internal AuxData object to make them unique and easier to search for. check-in: 2be9850c user: drh tags: trunk
16:33
Improved documentation for the SQLITE_READ authorizer callback. No code changes. check-in: 92c5ea70 user: drh tags: trunk
16:12
Invoke the SQLITE_READ authorizer callback with a NULL column name for any table referenced by a query but from when no columns are extracted. check-in: 92ab1f72 user: drh tags: trunk
13:36
Fix a couple of test scripts so that they work with -DSQLITE_DISABLE_FTS4_DEFERRED builds. check-in: 30018d31 user: dan tags: trunk