SQLite
Timeline
Not logged in

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

2017-03-29
18:03
[4a01880b] Leaf: Avoid unnecessary blob handle invalidation when changes are made to an unrelated table. (user: drh, tags: trunk)
17:06
[06c2b685] Slightly smaller and faster implementation of pcache1InitBulk(). (user: drh, tags: trunk)
16:55
[d336858d] Fix some tests in malloc5.test to account for the sqlite3_release_memory() change in the previous commit. (user: dan, tags: trunk)
15:18
[5d902b7f] Fix the sqlite3_release_memory() interface so that it works even if SQLITE_DEFAULT_PCACHE_INITSZ is non-zero. (user: drh, tags: trunk)
2017-03-25
19:16
[8469fc0d] Add the new sqlite3_set_last_insert_rowid() interface to the extension loader thunk. (user: drh, tags: trunk)
18:31
[55df410b] Do not run tests for ".dump --preserve-rowids" when testing SQLITE_OMIT_VIRTUALTABLE builds. (user: dan, tags: trunk)
18:15
[bd5bbe4e] Disable the new --preserve-rowids option on the CLI ".dump" command if compiled with SQLITE_OMIT_VIRTUALTABLE. (user: drh, tags: trunk)
18:03
[833ab321] Make the default value for SQLITE_DEFAULT_SYNCHRONOUS a simple integer literal, so that it does not show up goofy in the output of "PRAGMA compile_options;". (user: drh, tags: trunk)
12:08
[32be9c3f] Fix two harmless compiler warnings. (user: drh, tags: trunk)
2017-03-24
19:45
[c2c3dd84] Fix a harmless compiler warning in the JSON1 extension. (user: drh, tags: trunk)
18:38
[8194dd28] Previous check-in was not correct. This is a better fix for the OP_Once problem of ticket [06796225f59c057cd120f1]. (user: drh, tags: trunk)
17:59
[25560145] Fix the OP_Once opcode so that it works correctly for recursive triggers. Ticket [06796225f59c057cd120f1]. (user: drh, tags: trunk)
13:31
[c5441d2d] Add the RFC-7396 Appendix A test cases for json_patch(). (user: drh, tags: trunk)
12:35
[9d535041] Fix an error in the new json_patch() routine discovered by Ralf Junker. (user: drh, tags: trunk)
2017-03-23
23:44
[47608848] Add the json_patch() SQL function to the JSON1 extension. (user: drh, tags: trunk)
19:51
[bf28a55d] Improvement to the amalgamation configure.ac file contributed by Bob Friesenhahn. (user: drh, tags: trunk)
17:22
[e1d06a57] Do not run test file autoanalyze1.test if OMIT_VIRTUALTABLE is defined. (user: dan, tags: trunk)
17:03
[9f2e04d3] Remove an invalid assert() statement failing when VACUUMing a database that contains an index on a column explicitly declared "COLLATE BINARY". (user: dan, tags: trunk)
2017-03-22
12:51
[a7868297] Fix harmless compiler warnings in the shell. (user: drh, tags: trunk)
2017-03-21
20:17
[055b36f1] New simplified memory initialization for MacOS. (user: drh, tags: trunk)
18:56
[ad741976] Fix an incorrect assert in the ANALYZE logic for STAT4 on WITHOUT ROWID tables. (user: drh, tags: trunk)
17:19
[ee9588e8] Add short script ext/fts3/tool/fts3cov.sh. To help measure test-coverage of fts3 source code. (user: dan, tags: trunk)
10:45
[9f680bc7] Do not run sync2.test as part of the "inmemory_journal" permutation. (user: dan, tags: trunk)
2017-03-20
22:58
[0dd18ec8] Add the --native-malloc option to fuzzcheck. Fix ossfuzz.c and fuzzcheck.c so that they both deallocate the temp_store_directory before closing. (user: drh, tags: trunk)
20:42
[021e8874] Fix the fuzzcheck program so that it can create new databases again. (user: drh, tags: trunk)
19:35
[49b93d97] Avoid passing NULL as the second argument to memcpy() in fts3. (user: dan, tags: trunk)
19:26
[a144875f] Avoid a technically undefined right-shift of a signed value in rtree.c. (user: dan, tags: trunk)
18:53
[16a8e84f] Fix some problems in fts3 found by address-sanitizer. (user: dan, tags: trunk)
16:34
[ef3a7c87] Avoid the possibility of signed integer overflow with oversized precisions in %d conversions in the printf() implementation. (user: drh, tags: trunk)
16:06
[285005a9] Do not run sync2.test as part of the "journaltest" permutation, as it uses "PRAGMA synchronous = off". (user: dan, tags: trunk)
15:29
[673a7b67] Ensure that a "--" prefix is added to sqlite3_trace_v2() output for nested SQL statements. (user: drh, tags: trunk)
15:11
[ecb9321e] Only run sync2.test on unix, as it depends on instrumentation in os_unix.c. (user: dan, tags: trunk)
14:44
[8822eb5d] Fix the check.test script so that it works on Windows. (user: drh, tags: trunk)
13:03
[2aa22509] Documentation fix: SQLITE_SOURCE_ID is a now a SHA3-256 hash. (user: drh, tags: trunk)
2017-03-18
13:59
[4e6a03d9] Only do the specialized MacOS single-core zone_malloc initialization if compiled with the SQLITE_MIGHT_BE_SINGLE_CORE flag. This avoids a (harmless) warning about OSAtomicCompareAndSwapPtrBarrier() being deprecated. (user: drh, tags: trunk)
2017-03-17
23:08
[f4cf8635] Fix an error in the newly revised documentation for SQLITE_LIMIT_VDBE_OP. No changes to code. (user: drh, tags: trunk)
22:51
[f74899ed] Set a reasonable limit on the number of opcodes in a prepared statement for ossfuzz.c. This should prevent timeouts in OSS-Fuzz when it generates totally unreasonable queries. (user: drh, tags: trunk)
22:50
[ef591461] Begin enforcing the SQLITE_LIMIT_VDBE_OP. The documentation warned that this day might come. (user: drh, tags: trunk)
14:59
[626bdca9] Add the --show-errors and --show-max-delay command-line options to the ossshell test program. (user: drh, tags: trunk)
14:15
[36f5602e] Fix the Makefile.in so that it builds the ossshell test program correctly. (user: drh, tags: trunk)
13:59
[f336fba7] Fix a buffer overread in debugging routine sqlite3VdbeMemPrettyPrint(). Problem discovered by OSS-Fuzz. (user: dan, tags: trunk)
03:21
[019dd3d5] Fix a problem in the enhanced PRAGMA integrity_check where it verifies CHECK constraints: Do not be confused by the reuse of the Table.pCheck field by VIEWs with named columns. Problem discovered by OSS-Fuzz. (user: drh, tags: trunk)
2017-03-16
18:55
[5c604479] If the user has not set it explicitly, set the "PRAGMA synchronous" setting to SQLITE_DEFAULT_SYNCHRONOUS when a database connection changes from wal to rollback journal mode. (user: dan, tags: trunk)
14:28
[6d85eb57] Simplified OOM detection in the instr() SQL function. (user: drh, tags: trunk)
13:30
[e3d48716] Fix an uninitialized variable reference in the text generator for "PRAGMA vdbe_trace=ON" output. Problem discovered by OSS-Fuzz. (user: drh, tags: trunk)
13:14
[eb7680a1] Fix a problem in the "showdb" utility that prevents it from correctly decoding cells with no content beyond the record header. (user: drh, tags: trunk)
12:11
[6e59e903] Fix a crash that could follow an OOM condition in the instr() SQL function. Problem discovered by OSS-Fuzz. (user: dan, tags: trunk)
2017-03-15
20:27
[029bc5d2] Updates to README files under the ext/ hierarchy. No changes to code. (user: drh, tags: trunk)
19:11
[b1b1aa8b] Add the "Obtaining The Code" subsection in the top-level README.md file. No changes to code. (user: drh, tags: trunk)
14:20
[37f766db] Mention the ".selftest" command in the ".help" output of the CLI. (user: drh, tags: trunk)
14:04
[bcf6bb08] Make "PRAGMA temp.synchronous=N" a no-op to ensure that the TEMP schema always has synchronous=OFF. This fixes an issue discovered by OSS-Fuzz. (user: drh, tags: trunk)
13:47
[84f2e3d5] Improved header comment on the shathree.c extension. No changes to code. (user: drh, tags: trunk)
2017-03-14
15:27
[1e4b9e7c] Updates to the MSVC makefiles. (user: mistachkin, tags: trunk)
2017-03-13
22:10
[2b9980a2] Add the dbdump.c extension that implements functionality similar to the ".dump" command of the CLI, though in a separate library. (user: drh, tags: trunk)
18:24
[68f6dc7a] In the output of the ".dump" command in the CLI, quote newline and carriage-return characters using the char() function, so that they do not get eaten by end-of-line processing logic in the OS or in other command-line utilities and/or libraries. (user: drh, tags: trunk)
17:37
[9034cf7e] Fix the sqlite3TreeViewSelect() routine so that it works with a null pointer to the Select object. (user: drh, tags: trunk)
14:30
[c6dda3f7] Fix a segfault that could occur following an OOM error in the flattenSubquery() routine. (user: dan, tags: trunk)
13:45
[f3b6959c] In the OSSFuzz test module, invoke the progress handler much more frequently so that timeouts are detected punctually even if the test script is running opcodes that individually take a long time (for example, an OP_Function opcode that invokes "randomblob(1.5e6)"). (user: drh, tags: trunk)
2017-03-12
20:28
[5ec655e8] Fix a possible NULL pointer dereference in following an OOM error in sqlite3ExprIsInteger(). Problem found by OSS-Fuzz. (user: drh, tags: trunk)
19:39
[18bf6aca] Remove an obsolete assert() in the IN operator code generation. (user: drh, tags: trunk)
2017-03-11
13:02
[3299a261] Make sure the translateColumnToCopy() routine in the query planner does not try to access an array that failed to be fully allocated due to a prior OOM. This fixes an issue discovered by OSSFuzz. (user: drh, tags: trunk)
00:46
[7359fcac] Increase the number of significant digits in floating point literals on ".dump" output from the shell. (user: drh, tags: trunk)
2017-03-10
18:36
[b5bf2957] Remove the rbu_round_trip.tcl script. It is now part of project "test-dbs". (user: dan, tags: trunk)
17:03
[f8560c60] Fix an error in the SQLITE_MAX_MEMORY implementation resulting from a bad merge. Update the OSSFuzz interface so that it times out after running the byte-code engine for 10 seconds. (user: drh, tags: trunk)
16:22
[eabd4ef4] Add the -DSQLITE_MAX_MEMORY=N compile-time option. The default is no limit. (user: drh, tags: trunk)
14:36
[118f5c05] Enhance the ".stats" dot-command in the CLI to use sqlite3_status64() instead of sqlite3_status(). (user: drh, tags: trunk)
01:05
[b044b152] Improvements to ".selftest --init". Tests are number in increments of 10 starting with 100. The tests are generated inside a SAVEPOINT. Errors are reported during test generation. Tests can be appended to existing tests. Add a test case to verify the schema. (user: drh, tags: trunk)
2017-03-09
22:00
[f4fcd46f] Remove the test/dbselftest.c program. In its place, add the ".selftest" command to the CLI. The new CLI version is .selftest is slightly different in that it uses SHA3 hashing instead of SHA1, so the new is subtly incompatible with the old. (user: drh, tags: trunk)
18:13
[6c627e50] Fix the ".dump" command to correctly extract tail data from corrupt WITHOUT ROWID tables. (user: drh, tags: trunk)
13:50
[50eec5d9] Begin moving separate boolean variables in the ShellState object of the CLI into the shellFlgs bitmask. (user: drh, tags: trunk)
2017-03-08
18:06
[2ea300fb] Make sure the database connection is open prior to running the ".sha3sum" command. (user: drh, tags: trunk)
17:56
[30f87883] In the ".sha3sum" command, if there is a LIKE pattern, show the hashes for each table separately. Without a LIKE pattern, show a single hash over the entire database. (user: drh, tags: trunk)
16:10
[fc663799] Add the ".sha3sum" command to the CLI - used to compute a cryptographic hash of the content of a database file or of individual tables with in that file. (user: drh, tags: trunk)
15:03
[54ef7abd] Improved comments explaining the sha3_query() format. Fix a performance #ifdef error in the sha3 implementation. (user: drh, tags: trunk)
13:50
[f7ca9193] Add the shathree.c extension for implementing SHA3() and SHA3_QUERY() SQL functions. (user: drh, tags: trunk)
12:25
[de65f907] In the CLI, avoid unnecessary identifier quoting in the ".dump" output. Also add new ".dump" test cases. (user: drh, tags: trunk)
11:44
[c60aee24] Add the --preserve-rowids option to the ".dump" command in the CLI. (user: drh, tags: trunk)
2017-03-07
20:03
[961e79da] Add test script ext/rbu/rbu_round_trip.tcl. Uses "dbselftest" to test that "rbu" and "sqldiff" work together. (user: dan, tags: trunk)
14:38
[2cb71583] Performance optimization in the tokenizer/parser loop. (user: drh, tags: trunk)
12:18
[01cd9fb1] Minor comment typo fixes. No changes to code. (user: drh, tags: trunk)
03:40
[e0a3d39f] More size and speed improvements in the expression name resolver. (user: drh, tags: trunk)
03:25
[1a3554e1] Small size reduction and performance increase in the name resolver routine for expressions. (user: drh, tags: trunk)
2017-03-06
23:51
[73019a8b] Make the default MASK argument for "PRAGMA optimize" be 0xfffe, to allow for future expansion of up to 14 new default-on optimizations. (user: drh, tags: trunk)
20:44
[ec529bf1] Fix a typo in a comment. No changes to code. (user: drh, tags: trunk)
17:33
[137aeb2b] Add an initial implementation of the "PRAGMA optimize" command. (user: drh, tags: trunk)
2017-03-03
21:51
[45797fee] If a reprepare is needed after binding to a variable with a number larger than 32, set only the high-order bit of the Vdbe.expmask rather than setting all bits. This could potentially result in fewer false-positive reprepares. (user: drh, tags: trunk)
21:36
[4a04c48a] Remove an redundant function call from the date/time function implementation. (user: drh, tags: trunk)
20:43
[8831f439] Fix another corner-case for the 'start of ...' modifier in the date/time functions. Related to ticket [6097cb92745327a1]. (user: drh, tags: trunk)
20:02
[5d0455fe] Fix a case introduced by [4cd2a967] where a corrupt database could cause a buffer overwrite. (user: dan, tags: trunk)
16:51
[915a9a28] Before beginning an incremental checkpoint in RBU, sync the directory containing the target database file. This ensures that the new directory entry created by renaming the *-oal file to *-wal is synced to disk. (user: dan, tags: trunk)
2017-03-02
23:40
[081dbcfb] Fix a bug in the 'start of ...' date/time modifiers when they follow a julian day number. Fix for ticket [6097cb92745327a1]. (user: drh, tags: trunk)
16:56
[4012bb3a] Fix another RBU case similar to the previous. This one for systems where the sector-size is larger than the page-size. (user: dan, tags: trunk)
14:51
[edee6a80] When saving the state of an RBU update in the incremental-checkpoint phase, sync the database file. Otherwise, if a power failure occurs and the RBU update resumed following system recovery, the database may become corrupt. (user: dan, tags: trunk)
13:13
[29f54b89] Make sure the Vdbe.expmask value is set correctly in sqlite3VdbeSwap(). This fixes a problem introduced by [a8fd7052]. (user: drh, tags: trunk)
2017-03-01
11:30
[ac760db0] Fix a use-after-free problem in the shell tool code that could occur if an SQL statement were executed after an ".open" command with invalid options. (user: dan, tags: trunk)
2017-02-27
17:16
[23a8917e] Make PATH handling more robust in the batch tools for MSVC. (user: mistachkin, tags: trunk)
17:06
[2b210d69] Improve performance of fts5 writes by writing the "averages" record once at the end of each transaction instead of every time the table is updated. (user: dan, tags: trunk)
16:15
[952a3906] Add an sqlite3_set_last_insert_rowid() method. Use it to work around fts4 and fts5 modifying the last-insert-rowid unintuitively from within commit processing. (user: dan, tags: trunk)
12:23
[660f9569] Remove references to special handling in virtual table methods from the documentation for sqlite3_last_insert_rowid(). (user: dan, tags: trunk)
2017-02-25
20:57
[ffd61fb4] Add an 'extern "C"' block to header file sqlite3userauth.h. (user: dan, tags: trunk)
17:47
[4cd2a967] Optimize defragmentPage() in the case where the page contains either one or two free-blocks and a small number of fragmented bytes. (user: dan, tags: trunk)
2017-02-23
16:30
[a8fd7052] Save a few bytes and a few cycles by setting Vdbe.expmask to zero for statements prepared using legacy interface sqlite3_prepare(). (user: dan, tags: trunk)
2017-02-22
19:41
[d6afd98d] Move a branch condition in analyze.c inside an #ifdef SQLITE_ENABLE_STAT4 block. (user: dan, tags: trunk)
19:27
[737a8244] Improve the performance of ANALYZE when SQLITE_ENABLE_STAT4 is defined. (user: dan, tags: trunk)
18:53
[aa02bd3c] Improvements to PRAGMA integrity_check. Verify CHECK constraints. Verify NOT NULL constraints even on table that lack indexes. Verify CHECK and NOT NULL constraints with PRAGMA quick_check. (user: drh, tags: trunk)
2017-02-21
21:24
[80adc0cb] In sqlite3VdbeHalt(), return as soon as possible if Vdbe.magic!=VDBE_MAGIC_RUN. This makes sqlite3_reset() slightly faster in some cases. (user: dan, tags: trunk)
17:52
[e400909f] Fix an FTS5 problem that could cause a crash when certain queries were interrupted using sqlite3_interrupt(). (user: dan, tags: trunk)
15:27
[3c3228ed] Very small enhancement to dispatch speed for SQL functions. (user: drh, tags: trunk)
2017-02-20
23:32
[1589db01] Correct a harmless typo in the previous check-in. (user: mistachkin, tags: trunk)
19:13
[96b6a98e] Avoid unsigned integer overflows for SQLITE_WIN32_HEAP_INIT_SIZE when the Win32 heap subsystem is used with very large values of SQLITE_DEFAULT_CACHE_SIZE and/or SQLITE_DEFAULT_PAGE_SIZE. (user: mistachkin, tags: trunk)
14:30
[0d8a868a] Small grammar simplification. (user: drh, tags: trunk)
2017-02-18
13:47
[49181427] Add the SQLITE_BUG_COMPATIBLE_20160819 compile-time option to omit the error message when an unrecognized argument is provided to the VACUUM command. (user: drh, tags: trunk)
2017-02-17
23:52
[8cc9d74c] Fix the #endif location for an #ifndef SQLITE_UNTESTABLE macro in the command-line shell. (user: drh, tags: trunk)
02:04
[218b2bbb] Fix a test case that was made to fail by the LIKE optimization enhancement in check-in [158290c0ab] but which went unnoticed because test builds were running with ICU enabled and ICU disables the LIKE optimization. (user: drh, tags: trunk)
01:43
[8a03be1d] Enable the ".wheretrace" and ".selecttrace" extensions in the command-line shell when compiled on Windows using DEBUG=3 or higher. Fix a harmless warning in the shell that comes up when compiled this way. (user: drh, tags: trunk)
2017-02-16
20:52
[9fc5cd50] Change the name of WhereInfo.pDistinctSet to pResultSet, since it is now used for more than just DISTINCT processing. (user: drh, tags: trunk)
17:18
[ff5e733c] Change two MallocZero() calls into MallocRaw() to avoid unnecessary memset(). (user: drh, tags: trunk)
16:26
[bb8e2642] Fix a comment on a field of the ExprList object. No changes to code. (user: drh, tags: trunk)
15:57
[7e14044c] Increase Table.tabFlags from 8 to 32 bits. (user: drh, tags: trunk)
15:06
[6bd82b95] Remove two redundant initializations from the virtual table logic. (user: drh, tags: trunk)
14:48
[6affb1c8] Always use the IsVirtual() macro to determine if a Table object is a virtual table. Slightly smaller and faster code. (user: drh, tags: trunk)
2017-02-15
22:36
[58797e9b] Query planner optimization to detect empty tables in a join early and bail out without doing excess work. (user: drh, tags: trunk)
18:30
[830b9235] Minor enhancement to mutex tracing on Win32. (user: mistachkin, tags: trunk)
15:09
[810d2932] Remove the CLANG_VERSION macro, since we have learned that version numbers in clang are "marketing" and are inconsistent and unreliable. Builds using clang will still use the GCC_VERSION macro since clang works hard to be gcc compatible. (user: drh, tags: trunk)
04:16
[ee1e6896] Further reforms to Tcl_*Alloc() usage. (user: mistachkin, tags: trunk)
01:39
[1d267757] In the blob test code, avoid crashing on low-memory systems by using Tcl_AttemptAlloc(). (user: mistachkin, tags: trunk)
2017-02-14
21:47
[ca4f1e49] Clarification of the help text for the command-line shell. (user: drh, tags: trunk)
20:00
[54836270] Enable the SQLITE_ENABLE_NULL_TRIM option for WITHOUT ROWID tables. (user: drh, tags: trunk)
16:30
[e4731fd6] More realistic lengths of string values in speedtest1 with --testset orm. (user: drh, tags: trunk)
15:58
[58b2f911] Fix a testcase number on the ORM testset of speedtest1. (user: drh, tags: trunk)
15:57
[1836adc1] Add the new "--testset orm" to the speedtest1 utility. (user: drh, tags: trunk)