/ Timeline
Login

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

100 most recent check-ins that include changes to files matching 'src/*'

2020-01-23
15:00
Fix typos in the sqlite3ext.h header file that prevent some newer APIs from being accessed from loadable extensions. Leaf check-in: 14331989 user: drh tags: trunk
2020-01-22
23:08
Fix a NEVER() macro that can be true if compiled with SQLITE_ENABLE_UNKNOWN_SQL_FUNCTION. Ticket [b985f0bd1636d9bc] check-in: 9f0f5d59 user: drh tags: trunk
21:18
Merge version 3.31.0 Leaf check-in: 9c3f4638 user: drh tags: begin-concurrent-pnu-wal2
21:12
Merge version 3.31.0 Leaf check-in: 3bb267de user: drh tags: wal2
21:06
Merge version 3.31.0 Leaf check-in: e65e6c01 user: drh tags: begin-concurrent-pnu
20:56
Merge version 3.31.0 Leaf check-in: bbbc2881 user: drh tags: begin-concurrent
20:36
Merge version 3.31.0 Leaf check-in: 0eae87ad user: drh tags: apple-osx
20:02
Merge in version 3.31.0 Leaf check-in: f418afa1 user: drh tags: reuse-schema
2020-01-21
21:01
Begin adding instrumentation to record and report on the set of key-ranges a concurrent transaction reads from the database. Leaf check-in: c39e3c14 user: dan tags: begin-concurrent-report
16:23
Fix a problem with using views in SQLITE_OMIT_VIRTUAL_TABLE builds. Also some test case fixes required for the same builds. check-in: 934ee8bd user: dan tags: trunk
14:42
Fix an assert() that could fail in SQLITE_MUTATION_TEST builds following an error in a query that uses CTEs. check-in: c7e29458 user: dan tags: trunk
12:29
Fix the series.c and spellfix.c extensions to use SQLITE_VTAB_INNOCUOUS correctly. Fix the documentation on sqlite3_vtab_config() to take into account SQLITE_VTAB_INNOCUOUS and SQLITE_VTAB_DIRECTONLY. check-in: 9265cb7f user: drh tags: trunk
2020-01-20
15:32
Merge recent fixes from trunk. check-in: 9c920bba user: drh tags: reuse-schema
2020-01-19
20:37
Enhancement to the CLI to allow the ".parameter init" command to work even if defensive mode is turned on. check-in: 4d462550 user: drh tags: trunk
2020-01-18
23:52
Documentation improvements. check-in: 535afe15 user: drh tags: trunk
22:20
In the TCL interface, add the ability to change the SQLITE_DBCONFIG_TRUSTED_SCHEMA setting using the "db config" method. check-in: 1accfa8c user: drh tags: trunk
21:34
Allow non-deterministic function in CHECK constraints. It turns out that PostgreSQL, MySQL, and SQLServer all allow this. We should be the the exception. Ticket [830277d9db6c3ba1] check-in: 8c8ce526 user: drh tags: trunk
19:46
Do not use memcpy() of zero bytes when initializing a pager. This avoids a warning. check-in: cca43778 user: drh tags: trunk
19:02
Fix harmless compiler warning seen with MSVC. check-in: cd0437ba user: mistachkin tags: trunk
18:59
Have this branch call sqlite3LockAndPrepare() instead of sqlite3Prepare() when parsing SQL for new schema objects in order to ensure that schemas are released as soon as possible. check-in: 7a4ec579 user: dan tags: reuse-schema
14:50
Add extra front margin to the fake empty filename returned by sqlite3PagerFilename() for an in-memory or TEMP database. check-in: fee94567 user: drh tags: trunk
13:53
Fix the VDBE so that it correctly handles the sequence of operations OP_OpenEphemeral, OP_OpenDup, OP_OpenEphemeral, and OP_OpenDup in that order on the same cursor. check-in: a1be6ee0 user: drh tags: trunk
2020-01-17
23:27
Fix a typo in a comment. No code changes. check-in: 4363f69c user: drh tags: trunk
19:14
Fix #ifdefs so it compiles cleanly with all SQLITE_OMIT compile-time options. Update compile-time option testing. check-in: 7584e4b6 user: drh tags: trunk
16:47
Improved rounding in the 'unixepoch' feature of the date and time functions. check-in: c9abf1bd user: drh tags: trunk
15:33
More restrictions on changes to shadow tables when in defensive mode. Leaf check-in: b302b260 user: drh tags: branch-3.28
15:24
Validate the type, name, and tbl_name fields of the sqlite_master table when loading the schema, unless writable_schema is engaged. check-in: 3d13fbf2 user: drh tags: branch-3.28
14:56
Do not allow shadow tables to be dropped in defensive mode. check-in: ad1f760f user: drh tags: branch-3.28
14:30
Import the 3.31.0-beta FTS3/4 code directly into the 3.28 branch, thus providing 3.28 with all the latest 3.31 fixes. FTS3 has not been enhanced to use any core functionality that was not already available in 3.23, so no modifications were made to FTS3 sources for this import. check-in: be4269c6 user: drh tags: branch-3.28
14:18
Import all FTS3/4 enhancements and fixes that exist on the latest trunk (3.31.0-beta) that do not require extensive change to the SQLite core into the 3.22 branch. Basically, the 3.31.0 FTS3 sources are copied into 3.22.0, with minor changes to work around core enhancements that are not available in 3.22.0. Leaf check-in: cbcbb1e5 user: drh tags: branch-3.22
2020-01-16
17:53
New testcase() macros in select.c, for coverage of the change from two check-ins ago. check-in: 52206488 user: drh tags: trunk
16:32
Add the SQLITE_FCNTL_CKPT_DONE file-control for the use of custom VFSs. check-in: 3cc39e50 user: dan tags: trunk
16:12
Do not allow the constant-propagation optimization to apple to ON/USING clause terms as it does not help and it might cause downstream problems. check-in: 1bc783da user: drh tags: trunk
13:02
Very small performance improvement by ensuring that the argument to sqlite3VdbeFreeCursor() is non-NULL. Hold for the next sprint. Leaf check-in: f8801ffd user: drh tags: close-cursor-faster
12:25
Fix an SQL syntax error in the comment on the omit-left-join optimization. No changes to code. check-in: 86b5e5a2 user: drh tags: trunk
11:51
Clean up the definitions of the TERM_ constants in the code generator. Formatting only - no logic changes. check-in: af06f80a user: drh tags: trunk
2020-01-15
17:18
Fix the assert_schema_state_ok() routine so that it correctly ignores ATTACH-ed database that failed to open due to an error. check-in: 1194a42a user: drh tags: reuse-schema
16:20
Do not allow the "PRAGMA encoding" statement to change the database encoding if TEMP content exists, or content in any other attached database. Formerly, encoding changes were allowed if just the main database file was empty. Ticket [a08879a4a476eea9]. check-in: 03b003c9 user: drh tags: trunk
14:26
Merge all recent enhancements and fixes from trunk. check-in: f7839178 user: drh tags: reuse-schema
14:21
Merge in the latest trunk changes via the begin-concurrent-pnu branch. check-in: 350627f3 user: drh tags: begin-concurrent-pnu-wal2
14:11
Merge recent enhancements and fixes from trunk. check-in: 35eae71a user: drh tags: wal2
13:48
Merge all recent enhancements and fixes from trunk. check-in: 110a081f user: drh tags: begin-concurrent-pnu
13:34
Merge fixes and enhancements from trunk into begin-concurrent. check-in: 95ba2f50 user: drh tags: begin-concurrent
12:49
Merge all recent enhancements and fixes from trunk into the apple-osx branch. check-in: dadedf41 user: drh tags: apple-osx
2020-01-14
16:39
Remove an ALWAYS on a branch for improved database corruption detection in btree.c:freeSpace(). Test case found by dbsqlfuzz. check-in: 54bf0481 user: drh tags: trunk
13:13
Fix a minor typo on a comment in the CLI implementation. check-in: db4fb350 user: drh tags: trunk
00:52
Improvements to sqlite3_open_v2() documentation. check-in: 4c4fd62a user: drh tags: trunk
2020-01-13
15:25
More documentation updates. No code changes. check-in: a684d4ef user: drh tags: trunk
13:33
Documentation updates. No changes to code. check-in: cc0e0aa3 user: drh tags: trunk
2020-01-12
22:38
Better than removing the incorrect assert() is to change it into a testcase() together with a comment indicating where an appropriate test case can be found, and the ticket that provoked the change. Ticket [614b25314c766238] check-in: 3e3c60d8 user: drh tags: trunk
22:20
Remove an incorrect assert(). Fix for ticket [614b25314c766238] check-in: 6a999c5a user: drh tags: trunk
2020-01-11
21:08
New apis: sqlite3_filename_database(), sqlite3_filename_journal(), and sqlite3_filename_wal(). Also sqlite3_uri_key(). And the other sqlite3_uri functions now work using the journal or wal filename in addition to the database file. And the sqlite3_db_filename() result is guaranteed to work as an argument to the sqlite3_uri functions. check-in: fd7bcc53 user: drh tags: trunk
20:27
Minor changes for consistency between sqlite3_filename_wal() and sqlite3_filename_journal(). Closed-Leaf check-in: 9a70ff43 user: drh tags: enhanced-uri
16:08
Redesign for better legacy compatibility. Add the sqlite3_uri_key() interface. check-in: bcb43d11 user: drh tags: enhanced-uri
2020-01-10
18:05
Rearchitect the way in which filenames are stored in the Pager object so that the sqlite3_uri_parameter() interface will work from journal and WAL filenames too. This check-in implements the central idea, and compile and runs somewhat, but crashes on an extended test. check-in: 2ae77bd2 user: drh tags: enhanced-uri
01:05
Fix to the register validity tracking logic in debug builds. No impact on release builds. check-in: 0a500da6 user: drh tags: trunk
00:20
Begin making changes to turn off trusted schema in command-line tools that open SQLite databases. There are a lot of these, and a lot of places to change, which makes me wonder if trusted schema should be off by default. Leaf check-in: 3d23a275 user: drh tags: default-untrusted-schema
00:00
Documentation updates on newer APIs. No changes to code. check-in: 8845a8c2 user: drh tags: trunk
2020-01-09
20:44
Merge in the untrusted-schema enhancements. See doc/trusted-schema.md for details. check-in: 5720924c user: drh tags: trunk
20:33
Fix a harmless compiler warning. check-in: edbf911f user: drh tags: trunk
20:11
Fix an assert() in window.c that could fail with some obscure SELECT statements that use window functions. Ticket [678ecf429f8d1a5f] check-in: 83dc5567 user: dan tags: trunk
16:28
Fix a problem in the encoding display in the updated PRAGMA function_list. Closed-Leaf check-in: 318ff772 user: drh tags: new-security-options
13:08
Simplified error message for the unsafe use of a virtual table. check-in: d662129a user: drh tags: new-security-options
01:20
Fix a problem that restricted edgy functions in TEMP tables. New test cases added. check-in: 8878c407 user: drh tags: new-security-options
2020-01-08
22:22
Block edgy functions used in DEFAULT constraints. check-in: da434dc1 user: drh tags: new-security-options
20:37
Performance improvements and test cases added. Allow "PRAGMA trusted_schema=ON" check-in: 30882ca8 user: drh tags: new-security-options
17:28
Check for whether or not it is safe to use non-innocuous functions as the function is being coded, not when its name is resolved. check-in: 1da802d5 user: drh tags: new-security-options
15:44
Provide the -innocuous option to the "db func" method in the TCL interface. check-in: 0138652b user: drh tags: new-security-options
14:39
In the TreeView debugging output, show a "DDL" mark on SrcList and Expr nodes that derive from a non-TEMP schema. check-in: fe7472fd user: drh tags: new-security-options
13:08
Merge recent changes from trunk. check-in: 5962921f user: drh tags: new-security-options
12:17
When doing a test-to-double conversion on a BLOB with an odd number of bytes and assuming a UTF16 encoding, ignore the last byte. Ticket [9eda2697f5cc1aba]. check-in: 1c76f1d8 user: drh tags: trunk
11:36
Fix a minor formatting error in the display of BLOB values during VDBE tracing. check-in: 29544288 user: drh tags: trunk
10:57
Improvements to the documentation of sqlite3_create_collation(). check-in: fa866aec user: drh tags: trunk
04:36
Simplification of the logic in the constant-propagation optimization. check-in: 1c3e5c20 user: drh tags: trunk
01:43
Fix the constant propagation optimization so that it does not try to propagate constant expressions that have affinity. Ticket [82ac75ba0093e5dc] check-in: 6db1c349 user: drh tags: trunk
00:39
Fix a misworded comment. No code changes. check-in: ee0bc7ed user: drh tags: trunk
2020-01-07
19:45
Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set the risk rank for many virtual tables. check-in: 4c21373c user: drh tags: new-security-options
18:10
Enforce SQLITE_VTABRISK restrictions. check-in: 3d87ff31 user: drh tags: new-security-options
18:10
Fix a performance regression caused by the previous check-in. check-in: d7d98d3d user: drh tags: trunk
16:09
Invert the UNTRUSTED_SCHEMA setting to be TRUSTED_SCHEMA. check-in: f5fcf1fb user: drh tags: new-security-options
15:44
Merge recent fixes from trunk. check-in: 5dfa33a0 user: drh tags: new-security-options
14:51
Provide the ability to tag an application-defined function as "testonly". Leaf check-in: e6f5c0e0 user: drh tags: testonly-functions
13:32
Add an "|| CORRUPT_DB" term to an assert() statement inside of btree. check-in: 03c1d75d user: drh tags: trunk
2020-01-06
20:48
In the typeof() optimization in OP_Column, expand the size of the bogus buffer provided for data so that it is big enough to cover the increased number of bytes displayed during register tracing from check-in [54553bf16fabd72d]. This is the correct fix for ticket [bbd55a97e66ff50d], though the earlier one does not hurt and is useful to retain. check-in: e1154c39 user: drh tags: trunk
19:30
Merge enhancements from trunk. check-in: 9c50f6c2 user: drh tags: new-security-options
19:23
Rewrite the (debugging use only) sqlite3VdbeMemPrettyPrint() function to use the safer StrAccum interface rather than writing directly into a static string buffer. Perhaps this will address ticket [bbd55a97e66ff50d], which we are unable to reproduce. check-in: 69f6a7e4 user: drh tags: trunk
18:59
Backout change [4d0b9109f7a5312d4e1] because the conditional it added is no longer reachable due to check-in [1409758f72c0206c]. check-in: b3f26967 user: drh tags: trunk
18:44
Move variable declaration to start-of-block for MSVC. check-in: 55c136ef user: mistachkin tags: trunk
17:33
Do not attempt to use the skip-scan optimization if prior terms of the index are already used for non-equality constraints. Ticket [304017f5f04a0035] check-in: d7126a9c user: drh tags: trunk
17:06
Ensure the SF_Aggregate flag on a SELECT statement is set if a DISTINCT is transformed to a GROUP BY. Ticket [9c944882]. check-in: 1409758f user: dan tags: trunk
15:25
Refactor names of flags for improved legibility. check-in: 411e8ec2 user: drh tags: new-security-options
2020-01-05
21:53
Remove a NEVER in btree due to a new test case from dbsqlfuzz. check-in: 46f8ef70 user: drh tags: trunk
2020-01-04
20:58
Refactor the names of the new controls for restricting what actions the schema can take behind the application's back. check-in: 65d7d39a user: drh tags: new-security-options
19:58
Enhance PRAGMA function_list to show internal functions if the direct use of internal functions is enabled via the SQLITE_TESTCTRL_INTERNAL_FUNCTIONS test control. check-in: 7a8d7ca7 user: drh tags: new-security-options
19:19
Merge all fixes and enhancements from trunk. check-in: b878c30f user: drh tags: new-security-options
19:14
Fix DBSTAT so that it returns no rows, rather than an error when the WHERE clause is "schema=NULL". check-in: 5b246b47 user: drh tags: trunk
19:12
Fix harmless compiler warnings. check-in: 8452fe03 user: drh tags: trunk
18:38
Omit the omit flat from eq constraints on column "name" of dbstat virtual tables. Fix for [74a4c386]. check-in: cfff5cb2 user: dan tags: trunk
18:33
Record when the OP_IfNotOpen branch is and is not taken. check-in: 182a898b user: drh tags: trunk
17:55
Remove another NEVER added by check-in [7b62555e285f32d3]. Dbsqlfuzz found another test case. check-in: 481f4956 user: drh tags: trunk