SQLite
Timeline
Not logged in

200 most recent timeline items related to "trunk"

2017-04-26
20:45
[64ecf7c7] Leaf: Experimental implementation of pessimistic page-level locking based on rollback mode. (user: dan, tags: server-edition)
17:21
[2d0b6431] Leaf: Add new test file cachespill.test. (user: dan, tags: trunk)
14:34
[63d9ca5c] Replace <fts5.h> with "fts5.h" in test file fts5_test_tok.c. (user: dan, tags: trunk)
04:32
[304689f8] Fix a subtle bug in Lemon discovered and reported on the mailing list by Kelvin Sherlock, who also suggested the correct fix. (user: drh, tags: trunk)
2017-04-24
16:14
[031feebc] Leaf: Bring in all the latest enhancements from trunk. (user: drh, tags: apple-osx)
14:16
[1c1b0862] 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]. (user: dan, tags: trunk)
2017-04-22
00:20
[e39769f4] Fix an assertion fault found by OSSFuzz. (user: drh, tags: trunk)
2017-04-21
17:03
[bdc50d8d] Remove a NEVER macro for a condition that may be true as of [a47efb7c]. Problem reported by OSSFuzz. (user: dan, tags: trunk)
16:04
[840042cb] Fix an FTS5 bug that could cause a prefix-query without a prefix-index on a database that contains delete-markers to return extra, non-matching, rows. (user: dan, tags: trunk)
2017-04-20
17:35
[b1533bc4] Merge latest trunk changes into this branch. (user: dan, tags: schemalint)
2017-04-19
13:25
[6b21d0fd] Further improvements to coverage of fts3 module. (user: dan, tags: trunk)
07:33
[ea8a0d2c] Further modifications and test cases to improve test coverage of fts3. (user: dan, tags: trunk)
2017-04-18
13:50
[dc2a4802] Use sqlite3_table_column_metadata() instead of a SELECT statement to check for the existence of a %_stat table in fts3. This leads to smaller and easier to test code. (user: dan, tags: trunk)
11:20
[41c27bc0] Improved optimizations of views as the right operand of a LEFT JOIN. (user: drh, tags: trunk)
05:49
[e47fdb49] Refactor the fts3ColumnMethod() function so that all branches can be covered. (user: dan, tags: trunk)
2017-04-17
23:23
[56845256] Defer checking for null in the comparison operators, since that is an uncommon case. (user: drh, tags: trunk)
20:50
[e698db19] Do not allow a Mem object to be both NULL and some other type at the same time. (user: drh, tags: trunk)
18:42
[69f51f83] Consolidate two branches of code in the "PRAGMA foreign_key_check" implementation. (user: dan, tags: trunk)
18:02
[690870bd] Fix a problem in "PRAGMA foreign_key_check" in handling a WITHOUT ROWID child table with an INTEGER PRIMARY KEY parent key. Also, if an FK violation is detected in a WITHOUT ROWID child table, do not try to read and return the rowid. The second column returned by "PRAGMA foreign_key_check" in this case (WITHOUT ROWID child table) is now always set to NULL. (user: dan, tags: trunk)
16:07
[352413ee] Further improvements to test coverage in fts3. (user: dan, tags: trunk)
13:38
[1a08a836] Improve coverage of code in fts3. (user: dan, tags: trunk)
13:18
[f508aff8] Fix the ".column" output mode in the command-line shell so that it correctly counts and formats multi-byte UTF characters. (user: drh, tags: trunk)
2017-04-16
22:41
[90015df3] In the showwal command-line tool, for unix builds, if the auxiliary argument is of the form "Ntruncate" where "N" is a frame number, then truncate the WAL file after the N-th frame. (user: drh, tags: trunk)
22:08
[d7b9813c] Add the anycollseq.c loadable extension in etc/misc (user: drh, tags: trunk)
2017-04-15
15:47
[2d0c458e] Merge latest trunk changes into this branch. (user: dan, tags: schemalint)
11:53
[89f9e436] In the skip-ahead-distinct optimization, fix a bug in the logic that determines when to invoke the optimization based on sqlite_stat1 statistics. (user: drh, tags: trunk)
2017-04-14
22:41
[e50fd489] Closed-Leaf: Fix to the decision logic for when to use the skip-ahead-distinct optimization. (user: drh, tags: skip-ahead-distinct)
19:46
[d78355c8] Remove end-of-line whitespace from lemon.c. (user: drh, tags: trunk)
19:44
[a5379905] Fix some left-over K&R-C constructs in lemon.c. No changes to the core. (user: drh, tags: trunk)
19:03
[3a5860d8] Closed-Leaf: Add the TK_IF_NULL_ROW opcode to deal with non-NULL result columns in the result set of a view or subquery on the RHS of a LEFT JOIN that gets flattened. (user: drh, tags: left-join-view)
17:30
[f489b5bb] When doing a DISTINCT query using an index, try to use the index to skip ahead to the next distinct element, rather than doing a full scan of the index. (This is the "skip-ahead-distinct" optimization.) (user: drh, tags: trunk)
17:18
[1838a59c] An initial attempt to optimize VIEWs that occur as the right operand of a LEFT JOIN. This particular check-in does not work correctly because it does not deal with the case of columns in the VIEW that return non-NULL even when all columns in the table of the VIEW are NULL because of the LEFT JOIN. (user: drh, tags: left-join-view)
14:50
[6bf67376] Make USE_FULLWARN=1 the default for MSVC and fix harmless compiler warnings. (user: mistachkin, tags: trunk)
14:02
[5159cb8f] Enhance the sqlite3TreeView() display for Expr objects so that it shows the iRightJoinTable value for Expr nodes that have the EP_FromJoin property. (user: drh, tags: trunk)
12:39
[e651074b] Simplify the interface to the subst() routines that are part of the query flattener by collecting common parameters into the SubstContext object and passing around a pointer to that object. (user: drh, tags: trunk)
12:27
[f956f6ae] Remove an incorrect ALWAYS(). (user: drh, tags: trunk)
00:45
[1aa0ea8d] Fix a couple of unreachable branches. (user: drh, tags: skip-ahead-distinct)
2017-04-13
16:19
[5fcd840c] Update this branch with latest changes from trunk. (user: dan, tags: schemalint)
15:51
[59c70108] Reinstate the SQLITE_API qualifier on the sqlite3_delete_database() method in test_delete.c. Accidentally removed by the previous commit. (user: dan, tags: trunk)
15:36
[fa9bb7b7] Update the code in test_delete.c to use the "win32" VFS if SQLITE_OS_WIN is defined. (user: dan, tags: trunk)
09:45
[6f54ffd1] Allow a user column name to be used on the LHS of a MATCH operator in FTS5. (user: dan, tags: trunk)
01:19
[132339a1] Forward port the skip-ahead-distinct branch which was abandoned for some reason that I do not recall. This port should have been achived by a merge of trunk into the previous head of skip-ahead-distinct, but that did not work. So I had to manually "rebase" the changes. (user: drh, tags: skip-ahead-distinct)
00:12
[8e7b6118] Fix a regression caused by the fix for ticket [6c9b5514077fed34551f98e64c09a1] - control characters allowed in JSON. (user: drh, tags: trunk)
2017-04-12
17:50
[c847543f] Update fts5 to support "<colset> : ( <expr> )" for column filtering, as well as "<colset> : NEAR(...)" and "<colset> : <phrase>". (user: dan, tags: trunk)
17:38
[f2643315] Improved \n and \r escapes in the ext/misc/dbdump.c utility function. The implementation of dbdump.c now matches the implementation in the CLI. (user: drh, tags: trunk)
2017-04-11
20:48
[7aae5c0f] Avoid updating unaffected indexes on a table as part of an UPDATE that requires foreign key processing in some cases. (user: dan, tags: trunk)
19:58
[477bea9e] Closed-Leaf: Avoid updating unaffected indexes on a table as part of an UPDATE that requires foreign key processing in some cases. (user: dan, tags: fkey-optimization)
19:00
[0f66a093] Update this branch with latest trunk changes. (user: dan, tags: schemalint)
18:55
[1f68c184] Limit the depth of recursion for valid JSON in the JSON1 extension in order to avoid using excess stack space in the recursive descent parser. Fix for ticket [981329adeef51011052667a9]. (user: drh, tags: trunk)
18:06
[76cd611d] Smaller and faster implementation of exprMightBeIndexed(). (user: drh, tags: trunk)
16:44
[4143650c] Very slight smaller and faster sqlite3SelectNew() (user: drh, tags: trunk)
12:20
[0f3eb61f] Add an ALWAYS() around an unreachable condition in sqlite3VdbeMemGrow(). (user: drh, tags: trunk)
11:52
[d6bb7c42] Fix a segfault that could occur if an indexed expression was used in a comparison operation within the result-set of a SELECT statement. (user: dan, tags: trunk)
01:30
[a47efb7c] When using an index on an expression, try to use the columns of the index rather than pulling columns from the table and reevaluating the expression. (user: drh, tags: trunk)
01:01
[c59eaf2b] Closed-Leaf: Improved comments. Fix a problem when an indexed expression is used in an ORDER BY clause. (user: drh, tags: covering-index-on-expr)
2017-04-10
23:42
[8978465f] Merge changes from trunk. (user: drh, tags: covering-index-on-expr)
20:51
[e052436d] Smaller and faster vdbeFreeOpArray() (user: drh, tags: trunk)
20:27
[efd1702a] Slightly smaller and faster sqlite3VdbeMemGrow(). (user: drh, tags: trunk)
12:31
[6ee12221] Add a new JSON test case to verify that all control characters are escaped in the json_quote() function. (user: drh, tags: trunk)
12:25
[475d8f82] Change the JSON extension so that it disallows control characters inside of strings. Fix for ticket [6c9b5514077fed34551f98e64c09a10dc2fc8e16]. (user: drh, tags: trunk)
2017-04-09
19:23
[19dd753f] Do not expose the name of the internal Mem object in the public interface defined by sqlite3.h. (user: drh, tags: trunk)
2017-04-08
19:00
[e051e8f2] Merge latest trunk with this branch. (user: dan, tags: schemalint)
18:24
[c23ef5e2] Merge all recent changes from trunk. (user: drh, tags: apple-osx)
18:18
[204e72f0] Disallow leading zeros on numeric constants in JSON. Fix for ticket [b93be8729a895a528e2] (user: drh, tags: trunk)
14:11
[b9a8c2b9] Expand on the comment above OP_Destroy to explain why it throws an error if there are any active reader VMs. (user: dan, tags: trunk)
13:52
[fa4416ad] Have the rtree module close any open blob-handle within the xSavepoint method. This prevents such an open blob handle from interfering with DROP TABLE operations. (user: dan, tags: trunk)
13:42
[78c1e903] Fix the quoting mechanism for ".dump" so that it is not applied for the ".mode quote" output. (user: drh, tags: trunk)
09:12
[a921ada8] Have fts5 close any open blob-handle when a new savepoint is opened. This ensures that fts5 does not prevent DROP TABLE statements (which always open a savepoint) from succeeding. (user: dan, tags: trunk)
01:09
[1cdae2db] Make sure the RTree sqlite3_blob handle is reset prior to renaming the table. (user: drh, tags: trunk)
00:55
[a6ce57ee] Fix the ".dump" command so that it works with ".headers on". Also fix the display of ".mode insert" with ".headers on". (user: drh, tags: trunk)
00:25
[dd16439e] Merge the latest trunk changes. (user: drh, tags: apple-osx)
2017-04-07
20:20
[73073529] Use replace() instead of char() to quote newline and return characters in strings in the output of .dump, to avoid excess expression complexity. (user: drh, tags: trunk)
19:41
[a52ef2ad] Proof of concept for the ability to use the expression columns in an index on expressions in place of equivalent expressions in the result set or in the WHERE clause. This check-in compiles but is mostly untested. (user: drh, tags: covering-index-on-expr)
11:45
[4c2b5729] Closed-Leaf: Use replace() instead of char() to quote newline and return characters in strings in the output of .dump, to avoid excess expression complexity. (user: drh, tags: shell-fix)
2017-04-06
14:56
[48826b22] Fix the ".lint fkey" shell command for cases where the child key is also an INTEGER PRIMARY KEY. (user: dan, tags: trunk)
12:06
[327eff25] Fix the ".lint fkey" shell tool command so that it works for foreign keys that refer implicitly to primary key columns with non-BINARY default collation sequences. (user: dan, tags: trunk)
2017-04-05
13:44
[c5f1a2b6] Remove a confusing and pointless sentence from the documentation for the sqlite3_interrupt() interface. (user: drh, tags: trunk)
12:39
[ad90e8bb] Split off sqlite3DbFreeNN() from sqlite3DbFree() and use it in cases where we know that the argument to be freed is never NULL. (user: drh, tags: trunk)
11:57
[9e6c9391] Save a few bytes and a few CPU cycles in sqlite3ExprListDelete() routine. (user: drh, tags: trunk)
11:49
[a1cf4476] Remove a conditional made unreachable by the previous ExprList enhancement. (user: drh, tags: trunk)
11:32
[2b6560ad] Combine the ExprList_item objects and the ExprList wrapper into a single memory allocation, for improved performance and reduced footprint. (user: drh, tags: trunk)
10:54
[71ed35cc] Attempt to remove bash-isms from configure.ac. Use -O0 with --enable-debug. (user: drh, tags: trunk)
2017-04-04
19:58
[e5bb7db5] Fix a problem causing "PRAGMA integrity_check" to disable the xfer optimization for subsequent VACUUM operations on tables with one or more CHECK constraints. This could result in VACUUM producing slightly larger database files. (user: dan, tags: trunk)
2017-04-03
14:07
[5c11f430] Avoid an unnecessary call to sqlite3WhereGetMask() inside of whereShortCut(). (user: drh, tags: trunk)
13:59
[658f08ce] Do not attempt to run sync2.test with SQLITE_DISABLE_DIRSYNC builds. (user: dan, tags: trunk)
13:33
[86897c24] Force a schema load prior to "PRAGMA optimize". (user: drh, tags: trunk)
13:17
[777b43e6] Fix typos in the documentation for OP_Column. (user: drh, tags: trunk)
12:04
[84fa069c] Slightly smaller and faster implementation for vdbeSorterCompareInt(). (user: drh, tags: trunk)
2017-04-01
20:44
[e6e36b28] Remove an unnecessary setting of the Mem.enc field for the output of the OP_Record opcode, for a performance improvement and size reduction. (user: drh, tags: trunk)
20:14
[c45cd3b9] Minor performance enhancements to the OP_Affinity opcode. (user: drh, tags: trunk)
19:45
[fcd2acdd] Remove an unnecessary clearing of the Vdbe.iCurrentTime value. (user: drh, tags: trunk)
11:59
[8698df60] Faster implementation for sqlite3VdbeIntValue() and sqlite3VdbeRealValue(). (user: drh, tags: trunk)
11:40
[1c0d82e0] Remove unused fields from the BtCursor object. (user: drh, tags: trunk)
00:20
[2452f061] Save a 78 bytes of code space and a million CPU cycles in speedtest1 by storing the cell index for the leaf page in the BtCursor object in its own field (BtCursor.ix), rather than as an entry in the BtCursor.aiIdx array. (user: drh, tags: trunk)
2017-03-31
11:20
[cb721d0b] Merge latest trunk into this branch. (user: dan, tags: schemalint)
2017-03-30
17:13
[c8000e94] Declare the Lemon-generated parser object as itself. (Duh) (user: drh, tags: trunk)
16:51
[9e550ccc] Increase the version number for the next development cycle. (user: drh, tags: trunk)
16:37
[1279de0b] Ensure that the stack space used to hold the Lemon-generated parser object is always 8-byte aligned. (user: drh, tags: trunk)
2017-03-29
23:22
[a6891942] When compiling with MSVC, disable extra SELECT/WHERE tracing for dynamically built shells. (user: mistachkin, tags: trunk)
18:03
[4a01880b] 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-28
18:48
[424a0d38] Leaf: Version 3.18.0 (user: drh, tags: release, branch-3.18, version-3.18.0)
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)
15:09
[fd5676fe] Merge all recent enhancements from trunk. (user: drh, tags: begin-concurrent)
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)
20:33
[04d41004] Closed-Leaf: Change the name of the json_merge_patch() function to just json_patch(). (user: drh, tags: json_mergepatch)
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
21:24
[a2674440] Initial implementation of the json_mergepatch(A,B) SQL function. (user: drh, tags: json_mergepatch)
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)
18:54
[df39adea] Closed-Leaf: Fix a typo causing the build to fail if SQLITE_DEFAULT_SYNCHRONOUS==SQLITE_DEFAULT_WAL_SYNCHRONOUS. (user: dan, tags: default-synchronous-fix)
18:14
[78030c0f] 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: default-synchronous-fix)
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)
22:02
[59241a50] Closed-Leaf: Add dbdump.exe to the MSVC makefile. (user: drh, tags: dbdump)
19:26
[74c5ace4] Infrastructure for an extension C-library to implement sqlite3_db_dump() and a corresponding "dbdump" command-line utility - both of which do the same work as the ".dump" command of the CLI. (user: drh, tags: dbdump)
18:31
[3d04b2cd] Merge all recent changes from trunk. (user: drh, tags: apple-osx)
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)
01:56
[8b2954dd] Closed-Leaf: The output of the ".dump" command in the CLI quotes newline and carriage-return characters using "char(10)" and "char(13)". (user: drh, tags: string-quoting-dump)
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)
15:55
[77dfe2ab] Closed-Leaf: Add the SQLITE_MAX_MEMORY compile-time option that provides a hard upper bound on the amount of memory that SQLite will use, per process. (user: drh, tags: max-memory-option)
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)
16:32
[5dc82a15] Closed-Leaf: Add the --recovery-mode option to the CLI ".dump" command. This involves enhancing the "PRAGMA reverse_unordered_selects" command to accept a "TOGGLE" option. Recovery mode used to be always on. Now it is opt-in. Not sure this is the correct approach. Also not sure if TOGGLE is a good feature to have on boolean PRAGMA statements. (user: drh, tags: dump-recovery)
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
23:29
[aacac906] Leaf: Refactor the output logic in the CLI. Not sure we want to go this way. Just saving the work for historical reference, or in case I decide to come back to it. (user: drh, tags: shell-print-refactor)
18:37
[9b439173] Merge recent enhancements from trunk, including the --preserve-rowids option to .dump and the .sha3sum commands of the CLI. (user: drh, tags: apple-osx)
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)
20:00
[1650c3f4] Merge all pending 3.18 enhancements from trunk. (user: drh, tags: apple-osx)
17:33
[137aeb2b] Add an initial implementation of the "PRAGMA optimize" command. (user: drh, tags: trunk)
11:39
[5f7fc79a] Closed-Leaf: Merge updates from trunk. (user: drh, tags: auto-analyze)