/ Timeline
Login

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

100 descendants of [a596b7c6]

2016-11-09
20:14
Comment changes that attempt to better explain the behavior of the "seekResult" field on VdbeCursor objects and the seekResult parameter to sqlite3BtreeInsert() and the OPFLAG_USESEEKRESULT flag on insert opcodes. No changes to code. check-in: 345b46be user: drh tags: unpacked-IdxInsert
16:03
Fix a simple comment typo. No changes to code. check-in: 51d0aed8 user: drh tags: unpacked-IdxInsert
01:46
Fix typo in the CSV extension. check-in: b4889588 user: mistachkin tags: trunk
01:38
Make use of the unpacked key on the OP_IdxInsert on sorters with a LIMIT. check-in: 42db7cd2 user: drh tags: unpacked-IdxInsert
01:19
Fix a typo on the OP_IdxInsert documentation. No code changes. check-in: e4acd982 user: drh tags: unpacked-IdxInsert
01:07
Add a DISTINCT query to speedtest1.c. Also change INSERT OR REPLACE into just REPLACE. check-in: 754ee844 user: drh tags: trunk
00:57
Remove the "experimental" marking from the sqlite3_preupdate interfaces. But be sure all the interface definitions are within documentation. check-in: d6dd2ad3 user: drh tags: trunk
00:10
Enhance the OP_IdxInsert opcode to optionally accept unpacked key material. check-in: 89d958ab user: drh tags: unpacked-IdxInsert
2016-11-08
19:22
Avoid superfluous cursor seeks in "INSERT OR REPLACE" statements. check-in: bec5b6d4 user: dan tags: trunk
17:19
Avoid generating OP_TableLock unnecessary instructions on btrees that are not sharable. check-in: 8cb8516d user: drh tags: trunk
16:27
Fix the speedtest1.c test program so that it gives closing "%" wildcards on LIKE searches. check-in: c2f84f63 user: drh tags: trunk
00:30
Tweaks to speedtest1.c to better reflect mobile usage based on findings in the "Pocket Data" paper by Kennedy, Ajay, Challen, and Ziarek. check-in: b5733cae user: drh tags: trunk
2016-11-07
18:18
Fix OOM error reporting in the json1_group_object() SQL function. Remove an unreachable branch from the JSON1 logic. check-in: b5409849 user: drh tags: trunk
15:15
Replace some unreachable branches from the JSON1 extension with assert(). check-in: 145cd13e user: drh tags: trunk
13:37
Fix the JSON1 extension so that the JSON validator correctly rejects malformed backslash escapes within string literals. check-in: 7a635391 user: drh tags: trunk
2016-11-04
19:09
Merge recent trunk changes, including all the fixes that appeared in version 3.15.1. check-in: 0e5ffd91 user: drh tags: apple-osx
12:08
Version 3.15.1 check-in: 1136863c user: drh tags: release, version-3.15.1, branch-3.15
12:05
Avoid a crash that can occur after an obscure OOM in the built-in INSTR() function. check-in: b86b79c4 user: dan tags: trunk
12:03
Mark the ICU extension functions as deterministic. check-in: afbbb6c6 user: drh tags: trunk
11:23
Add an assert() to silence a coverity false-positive. check-in: 97354093 user: drh tags: trunk
07:25
Fix a test case in vacuum5.test so that it works with the in-memory journal permutation. check-in: 81c86401 user: dan tags: trunk
2016-11-03
21:35
Replace a couple more references to Tcl 8.5 in the Windows build tools. check-in: 1d0e43c5 user: mistachkin tags: trunk
19:27
Fix a test case in vacuum5.test so that it works with -DSQLITE_TEMP_STORE=2 and -DSQLITE_ENABLE_ATOMIC_WRITE.. check-in: 752e14d9 user: dan tags: branch-3.15
19:24
Fix a test case in vacuum5.test sot aht it works with -DSQLITE_ENABLE_ATOMIC_WRITE. check-in: 3ca80010 user: dan tags: trunk
19:01
Fix a test case in vacuum5.test so that it works with -DSQLITE_TEMP_STORE=2. check-in: f5dd95e2 user: dan tags: trunk
18:49
Add the SQLITE_FCNTL_WIN32_GET_HANDLE file control. check-in: 5221e3cc user: drh tags: branch-3.15
18:44
Increase the version number to 3.15.1. check-in: ccdcce46 user: drh tags: branch-3.15
18:38
Escape non-ASCII character from an ICU extension comment. check-in: ee16fedd user: drh tags: branch-3.15
18:36
Fix an issue that was causing the new database image to be assembled entirely in heap memory when VACUUMing a database, even if it should use a temp file. This could cause SQLITE_NOMEM errors when vacuuming very large databases on 32-bit systems. check-in: 3fae483f user: drh tags: branch-3.15
18:35
Make sure left-join markings are transferred to the virtual scalar subexpressions when decomposing a vector comparison in the ON clause of a LEFT JOIN. Fix for ticket [fef4bb4bd9185ec8f]. check-in: aba1e22b user: drh tags: branch-3.15
18:33
If all branches of an OR optimize scan that is the rhs of a LEFT JOIN use the same index, set the index cursor to return NULL values if there are no matches for a row on the lhs. Fix for ticket [34a579141b2c5ac] check-in: 54eeddec user: drh tags: branch-3.15
18:31
In the sessions module, avoid recording a change if an UPDATE statement overwrites a column with REAL affinity containing an integer value with the same value. check-in: 0fc4f0f4 user: drh tags: branch-3.15
18:30
Avoid using the "direct overflow read" optimization to read large blobs if the pager layer has a wal file open - even if the database header indicates that the db is not a wal database. check-in: 63cfe197 user: drh tags: branch-3.15
13:12
In the command-line shell, fix the .imposter command so that it works with indexes on expressions. Fix the ".mode quote" mode so that it works with ".headers ON". check-in: ba9873da user: drh tags: trunk
13:01
Add the ".imposter" command to the command-line shell. check-in: be3ec8fd user: drh tags: trunk
02:25
Fix an possible NULL pointer deference in the command-line shell that can occur when using imposter mode. check-in: ad08753a user: drh tags: trunk
2016-11-02
19:49
Adjust the MSVC makefile to use Tcl8.6 by default. check-in: def8f598 user: drh tags: trunk
14:50
Fix an issue that was causing the new database image to be assembled entirely in heap memory when VACUUMing a database, even if it should use a temp file. This could cause SQLITE_NOMEM errors when vacuuming very large databases on 32-bit systems. check-in: 30288453 user: dan tags: trunk
13:18
Fix a requirement mark. No changes to code. check-in: d18f61b7 user: drh tags: trunk
02:17
Use NOT NULL partial indexes when the query is constrained by a single LIKE or GLOB. check-in: 9b3a3b41 user: drh tags: trunk
2016-10-31
16:49
Add the SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE sqlite3_dbconfig() option - for disabling SQLite's default checkpoint-on-close behaviour. check-in: 6d142025 user: dan tags: trunk
16:16
Add the SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE sqlite3_dbconfig() option - for disabling SQLite's default checkpoint-on-close behaviour. Closed-Leaf check-in: 093d2fc2 user: dan tags: no-ckpt-on-close
2016-10-27
14:51
Remove the mutex from test_multiplex.c. check-in: 6374978e user: dan tags: trunk
01:02
Make sure left-join markings are transferred to the virtual scalar subexpressions when decomposing a vector comparison in the ON clause of a LEFT JOIN. Fix for ticket [fef4bb4bd9185ec8f]. check-in: 619f5cc7 user: drh tags: trunk
2016-10-26
18:41
Small size reduction and performance enhancement in whereScanInit(). check-in: c23f5ef3 user: drh tags: trunk
17:57
Small size reduction and performance improvement in whereScanNext(). check-in: d861ee17 user: drh tags: trunk
16:05
If all branches of an OR optimize scan that is the rhs of a LEFT JOIN use the same index, set the index cursor to return NULL values if there are no matches for a row on the lhs. Fix for ticket [34a579141b2c5ac] check-in: ec9dab80 user: dan tags: trunk
15:46
If all branches of an OR optimize scan that is the rhs of a LEFT JOIN use the same index, set the index cursor to return NULL values if there are no matches for a row on the lhs. Closed-Leaf check-in: e7b9bc67 user: dan tags: leftjoin-or-fix
13:58
Merge the SQLITE_ENABLE_URI_00_ERROR compile-time option. check-in: 86675ae0 user: drh tags: trunk
13:44
Add extra tests to check the result of including a %00 escape in a URI when ENABLE_URI_00_ERROR is defined. Closed-Leaf check-in: 1aaa06e3 user: dan tags: uri-00-error
12:58
Add an elapsed-time output for faststat1.c. check-in: 71167951 user: drh tags: est_count_pragma
12:15
Add compile time option SQLITE_ENABLE_URI_00_ERROR. If defined, any "%00" escape found in a URI is treated as an error. check-in: e8a9bfec user: dan tags: uri-00-error
2016-10-25
19:39
Simplifications to faststat1.c. Fix a bug in sqlite3MovetoProportional() for very large b-trees. check-in: f7f78147 user: drh tags: est_count_pragma
19:21
Further refinements to the faststat1.c utility. check-in: b051fd19 user: drh tags: est_count_pragma
18:28
Enhance faststat1.c to deal better with WITHOUT ROWID tables. check-in: 65444f2e user: drh tags: est_count_pragma
17:28
Merge recent trunk changes, and especially the PRAGMA index_info enhancement which is needed on this branch. check-in: c3570e46 user: drh tags: est_count_pragma
15:39
Enhance the "PRAGMA index_info" and "PRAGMA index_xinfo" statements so that they work on WITHOUT ROWID tables and provide information about the underlying index btree that implements the WITHOUT ROWID table. Leaf check-in: fe49fb03 user: drh tags: index-info-on-table
15:06
Add test case to demonstrate a "BEGIN EXCLUSIVE" command returning SQLITE_BUSY_SNAPSHOT. check-in: b1158564 user: dan tags: trunk
13:57
First attempt at a utility program to compute sqlite_stat1 without doing a full table scan. check-in: 7b83581a user: drh tags: est_count_pragma
2016-10-24
01:01
Performance optimization in moveToRoot(). Avoid repeated validity checking of the root page on each call. Once is enough. check-in: 98795c2d user: drh tags: trunk
2016-10-22
01:22
In the sessions module, avoid recording a change if an UPDATE statement overwrites a column with REAL affinity containing an integer value with the same value. check-in: 5f3e6028 user: drh tags: trunk
2016-10-21
21:21
In the sessions module, avoid recording a change if an UPDATE statement overwrites a column with REAL affinity containing an integer value with the same value. Closed-Leaf check-in: b861328a user: dan tags: sessions-fix
18:01
When reading from an index, the shared-cache lock must be on the corresponding table. check-in: 04fe12b5 user: drh tags: est_count_pragma
17:45
Merge updates from trunk, and especially the ".mode quote" enhancement to the shell. check-in: 0c8a5b88 user: drh tags: est_count_pragma
17:39
Add ".mode quote" to the command-line shell. check-in: c4f5fa78 user: drh tags: trunk
17:25
Add the btree_sample(INDEX,LOCATION,LIMIT) pragma. check-in: affc2ef5 user: drh tags: est_count_pragma
15:36
Fix problems in the est_count pragma for indexes and WITHOUT ROWID tables. check-in: c39fd9b8 user: drh tags: est_count_pragma
10:49
Avoid using the "direct overflow read" optimization to read large blobs if the pager layer has a wal file open - even if the database header indicates that the db is not a wal database. check-in: b54c15f1 user: dan tags: trunk
10:09
If SQLITE_DIRECT_OVERFLOW_READ is defined at compile time, add "DIRECT_OVERFLOW_READ" to the list of symbols returned by "PRAGMA compile_options". check-in: b7d9727b user: dan tags: trunk
2016-10-20
22:02
Experimental est_count pragma. check-in: 340822af user: drh tags: est_count_pragma
18:20
Add the ability for the PRAGMA statement to accept multiple arguments. Currently all arguments other than the first are ignored. Leaf check-in: fd81d8a4 user: drh tags: multi-arg-pragma
11:48
Add test case to incrblob4.test. No changes to code. check-in: fd9c6ff0 user: dan tags: trunk
2016-10-18
16:36
Minor simplification of the comparison opcodes. check-in: 56474ebc user: drh tags: trunk
15:29
Fix harmless uninitialized variable warnings in speedtest1.c. check-in: 2aa7a03b user: drh tags: trunk
14:35
Add the --repeat option to speedtest1.c and speed-check.sh. check-in: 6ca0e06b user: drh tags: trunk
2016-10-17
18:44
Escape non-ASCII character from an ICU extension comment. check-in: 5ec02ecf user: mistachkin tags: trunk
18:33
Corrections to a couple recently added 'filectrl.test' results. check-in: 3d89dc45 user: mistachkin tags: trunk
15:28
Changes to support interrupting a checkpoint using sqlite3_interrupt(). check-in: c88d36e2 user: dan tags: trunk
00:48
Small size reduction and performance increase in the string duplicator. check-in: cda998f0 user: drh tags: trunk
2016-10-15
18:37
Add documentation for the OP_SorterInsert opcode, formerly omitted by mistake. No changes to code. check-in: 16d88a90 user: drh tags: trunk
08:56
Add test case to hook.test. No changes to non-test code. check-in: 2674d779 user: dan tags: trunk
2016-10-14
21:27
Add the SQLITE_FCNTL_WIN32_GET_HANDLE file control. check-in: 16039be3 user: mistachkin tags: trunk
21:16
Bump the version number in anticipation of the next development cycle. check-in: aa6de9c4 user: drh tags: trunk
10:20
Version 3.15.0 check-in: 70787558 user: drh tags: trunk, release, version-3.15.0
2016-10-13
12:56
Take care to avoid integer overflow when doing the initial page cache allocation with an excessively large cache_size setting. check-in: 4d66ac98 user: drh tags: trunk
2016-10-12
18:55
Avoid reading the -1-th element of an array in the query planner. Fix to a bug introduced by check-in [8e2b25f9b8a7] from earlier today. Curiously, the problem only appeared on 32-bit systems. check-in: 443913d5 user: drh tags: trunk
18:26
Add to sqlite3_analyzer command-line options --version and --tclsh, and also the undocumented --debug option. check-in: e87d02d2 user: drh tags: trunk
15:15
New testcase() macros to ensure coverage of the ORDER BY LIMIT optimization code in where.c. check-in: 61f05269 user: drh tags: trunk
14:48
Fix a problem affecting queries that match the pattern (... WHERE ipk IN (....) ORDER BY ? LIMIT ?). Fix for [96c1454c]. check-in: 8e2b25f9 user: dan tags: trunk
2016-10-10
14:48
Remove a stray line from session4.test causing a memory leak. No changes to SQLite code. check-in: 6624c496 user: dan tags: trunk
14:34
When handling ORDER BY expressions, do not assume all values of an indexed expressions are distinct. Fix for [4766f444]. check-in: aebe429e user: dan tags: trunk
13:29
Make sure indexes on expressions skip over initial NULL values in the index. Fix for ticket [4baa464912129477f3c9] check-in: 71797ba4 user: drh tags: trunk
10:06
Fix a case in which the rtree module was ignoring an OOM while generating an error message. check-in: 788f86be user: dan tags: trunk
2016-10-08
16:10
Update test/trace3.test to account for the fact that casting a pointer to a 64-bit signed integer might produce a negative value. check-in: 010ec225 user: dan tags: trunk
13:34
Corrections to Lemon documentation. No SQLite changes. check-in: c568ae3e user: drh tags: trunk
11:55
Add missing "static" to internal function whereRangeVectorLen(). check-in: cbed3d75 user: dan tags: trunk
09:21
Updates to the tool/warnings.sh script to make it easier to use on OpenBSD. check-in: dbe2997f user: dan tags: trunk
2016-10-05
20:14
Fix some compiler warnings in fts5. check-in: b066637b user: dan tags: trunk
20:10
Fix harmless compiler warnings. check-in: 2dde3375 user: drh tags: trunk
15:04
Add a test case for the fix in [a596b7c6cc]. check-in: b2ef39b1 user: dan tags: trunk
15:02
Do not set MEM_Blob unless the appropriate fields of the Mem object have been correctly initialized. check-in: a596b7c6 user: drh tags: trunk