/ Timeline
Login

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

200 most recent check-ins using file src/test_sqllog.c version 11e6ce7575

2020-02-19
15:39
Fix a potential NULL pointer dereference following OOM. Problem discovered by dbsqlfuzz. Test case in TH3. Leaf check-in: 5aeb5a2d29 user: drh tags: trunk
2020-02-18
23:58
Remove a NEVER() macro and add a test case to cause its argument to be true. check-in: ee034fe916 user: drh tags: trunk
19:49
Add the new sqlite3_create_filename() and sqlite3_free_filename() interfaces for use by Shims. Use these interfaces inside the multiplexor. check-in: 9469f36ac8 user: drh tags: trunk
2020-02-17
23:08
Convert invalid surrogates to 0xfffd when translating UTF. check-in: 7fab1393c2 user: drh tags: trunk
19:25
A better (smaller and faster) solution to ticket [4374860b29383380]. check-in: abc473fb8f user: drh tags: trunk
00:12
Take care when checking the table of a TK_COLUMN expression node to see if the table is a virtual table to first ensure that the Expr.y.pTab pointer is not null due to generated column optimizations. Ticket [4374860b29383380]. check-in: 9d0d4ab95d user: drh tags: trunk
2020-02-16
17:40
Avoid an infinite recursion on an illegal recursive definition of an fts5vocab table. check-in: 109ee07433 user: drh tags: trunk
2020-02-13
22:12
Fix problems in the constant propagation optimization that were introduced by check-in [1c3e5c20a9e6f501]. Fix for ticket [1dcb4d44964846ad] check-in: c9a8defcef user: drh tags: trunk
14:51
Disallow the skip-scan optimization in the absence of sqlite_stat1 data. check-in: e0c6b8bdb7 user: drh tags: trunk
13:45
Omit O_NOFOLLOW from the open() call when opening /dev/null, since /dev/null is a symlink on Solaris, we are told. check-in: 0c683c43a6 user: drh tags: trunk
11:46
Fix an incorrect assert() statement that was added yesterday. Tickets [41c1456a6e61c0e7] and [fb8c538a8f57ae2a]. check-in: abfb043ebb user: drh tags: trunk
2020-02-12
20:50
Increase the default upper bound on the number of parameters in a single SQL statement to 32766 (from 999). check-in: 2def75693a user: drh tags: trunk
11:57
When determining whether an == or IS constraint in a WHERE clause makes an ORDER BY term redundant, consider the collation sequence used by the == or IS comparison, not the collation sequence of the comparison expression itself. Possible fix for [fb8c538a8f]. check-in: 16aed5d0c6 user: dan tags: trunk
2020-02-10
19:37
Fix a typo in the in-tree begin-concurrent documentation Leaf check-in: b13dae1cb3 user: drh tags: begin-concurrent
19:24
Mark the sha1() extension function as SQLITE_DETERMINISTIC. check-in: 7d8dcfb95c user: drh tags: trunk
13:29
Fix the build for when SQLITE_VDBE_COVERAGE is used. check-in: 084381649e user: drh tags: trunk
2020-02-07
19:44
During byte-code generation, strive to avoid jumps that merely jump to the following instruction. check-in: bcf876e67e user: drh tags: trunk
01:12
Simplify the code by removing the unsupported and undocumented SQLITE_HAS_CODEC compile-time option check-in: 5a877221ce user: drh tags: trunk
2020-02-06
20:46
There is no need to keep track of the number of changed rows or of the last-insert-rowid while running VACUUM. check-in: a8a7c05b16 user: drh tags: trunk
15:38
Unroll the comparison loop inside keywordCode() for to avoid unnecessary comparisions and thus help that routine run faster. check-in: cec5f920f5 user: drh tags: trunk
13:57
Separate OP_IdxInsert and OP_SorterInsert into completely separate opcodes, helping each one to run a little faster. check-in: 447d71f086 user: drh tags: trunk
13:09
Remove dead code from the sqlite3_filename_database() function. check-in: 1b6185550f user: drh tags: trunk
11:08
Merge changes on 3.31 branch into reuse-schema. Leaf check-in: 6dbb8cb0e3 user: dan tags: reuse-schema-3.31
11:02
Fix a 4 byte OOB read in test_multiplex.c. Leaf check-in: 6279f69f0f user: dan tags: branch-3.31
10:55
Fix some fts3 problems found by usan. check-in: fb7ccf61be user: dan tags: trunk
2020-02-05
18:28
Small size reduction and performance improvement in the sqlite3VdbeMemFromBtree() interface used to pull content out of the b-tree and into an sqlite3_value object. check-in: ae6dd8d3e9 user: drh tags: trunk
2020-02-04
20:22
Merge latest trunk/wal2 changes, including the SQLITE_ENABLE_CORRUPT_PGNO patch, with this branch. Leaf check-in: 76668b5589 user: dan tags: begin-concurrent-pnu-wal2
20:11
Merge latest trunk changes into this branch. Leaf check-in: 6ad4d6b7ff user: dan tags: wal2
20:09
Merge latest trunk changes, including the SQLITE_ENABLE_CORRUPT_PGNO patch, into this branch. Leaf check-in: 23bc80cc86 user: dan tags: begin-concurrent-pnu
20:08
Merge latest trunk changes, including the SQLITE_ENABLE_CORRUPT_PGNO patch, into this branch. check-in: f253618ac6 user: dan tags: begin-concurrent
20:01
Enable more detailed log messages in SQLITE_ENABLE_CORRUPT_PGNO builds if database corruption is encountered. check-in: 57c36a293e user: dan tags: trunk
01:41
Extend the OP_Copy-coalesce optimization fix of check-in [b36126c1889e323c] so that it is also correctly disabled by the CASE operator. Ticket [9d3666754ac37d5a]. check-in: 29a969d6b1 user: drh tags: trunk
00:55
Fix a problem with the byte-code decompiler that was inserted by the enhancements at [4248980a356f659b] check-in: af63e95dcd user: drh tags: trunk
2020-02-03
19:56
Cosmetic change to the xfer-optimization to put the OP_RowData opcode closer to the corresponding OP_Insert opcode. This makes it slightly easier to read and understand the code. check-in: 0ea2dbfc90 user: drh tags: trunk
12:25
Increase the version number to 3.32.0. check-in: 8130bbb421 user: drh tags: trunk
2020-02-01
21:03
On an INSERT or UPDATE, perform affinity conversions on new data prior to running CHECK constraints. Ticket [86ba67afafded936]. check-in: 1d4f86201d user: drh tags: trunk
17:38
Fix the comment display for the OP_Function opcode. And at the same time, improve the comment generating logic to make use of the newer sqlite3_str_appendf() interface. check-in: 4248980a35 user: drh tags: trunk
14:29
Fix a problem in sqlite3CodecQueryParameters() that was introduced by the query parameter encoding changes for the 3.31.1 release. Leaf check-in: 1240ee4f6f user: drh tags: apple-osx
14:20
Merge the sqlite3CodecQueryParameters() fix into trunk. check-in: a812f53369 user: drh tags: trunk
13:30
Fix a problem in sqlite3CodecQueryParameters() that was introduced by the query parameter encoding changes for the 3.31.1 release. check-in: cc65ca5412 user: drh tags: branch-3.31
00:08
Merge version 3.31.1 check-in: d250d085fa user: numist tags: apple-osx
2020-01-31
14:52
Fix a minor typo in a comment in the btreeinfo extension. check-in: b5a66d10f4 user: drh tags: trunk
2020-01-29
15:03
Fix a problem with the processing of IN(...) constraints handled by virtual table implementations that do not set the "omit" flag when the virtual table column contains at least one NULL value. check-in: dcb4838757 user: dan tags: trunk
13:56
Add a test case for commit [ffd8bb93]. check-in: bcd5b37b8e user: dan tags: trunk
13:50
Remove a NEVER() that is in fact reachable. Test cases in dbsqlfuzz and TH3. check-in: ffd8bb9351 user: drh tags: trunk
13:10
Add new memory barriers during initialization. check-in: a9b2adc5d6 user: drh tags: trunk
12:37
Modify a couple of FTS test cases so that they work on big-endian platforms. check-in: b20503aaf5 user: drh tags: trunk
2020-01-28
20:27
Faster decoding of 32-bit variable-length integers in cases were we do not need to know the number of bytes in the encoding. check-in: 59a31b16b5 user: drh tags: trunk
20:09
Small performance improvement to the key-comparision routine for strings. check-in: 41454499a2 user: drh tags: trunk
18:09
Reinstate the optimization of converting "a IN (C)" into "a=C" but only if C is a constant. If the RHS is a table column, the complications of managing affinity and collations become too involved to mess with. check-in: 8ac26a23d7 user: drh tags: trunk
16:55
Fix a 4 byte OOB read in test_multiplex.c. check-in: 912148913c user: dan tags: trunk
15:02
Minor change for compatibility with the s390 architecture. check-in: 04885763c4 user: drh tags: trunk
2020-01-27
19:55
Version 3.31.1 check-in: 3bfa9cc97d user: drh tags: trunk, release, version-3.31.1
17:09
Update the version number to 3.31.1. check-in: 6fb9a8fb85 user: drh tags: trunk
14:40
Revise the layout of filenames in the Pager object so that it is unchanged from prior versions. It turns out that some important 3rd-party software does questionable pointer manipulations on those filenames that depend on that legacy layout. Technically, this is a misuse of SQLite by the 3rd-party software, but we want to avoid unnecessary breakage. check-in: 34ab760689 user: drh tags: trunk
2020-01-23
15:00
Fix typos in the sqlite3ext.h header file that prevent some newer APIs from being accessed from loadable extensions. check-in: 14331989fc user: drh tags: trunk
00:08
Fix variable declaration issue seen with MSVC. check-in: 8a6fe3066c user: mistachkin 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: 9f0f5d593a user: drh tags: trunk
21:18
Merge version 3.31.0 check-in: 9c3f46384d user: drh tags: begin-concurrent-pnu-wal2
21:12
Merge version 3.31.0 check-in: 3bb267deb1 user: drh tags: wal2
21:06
Merge version 3.31.0 check-in: e65e6c01d6 user: drh tags: begin-concurrent-pnu
20:56
Merge version 3.31.0 check-in: bbbc2881b9 user: drh tags: begin-concurrent
20:36
Merge version 3.31.0 check-in: 0eae87ad11 user: drh tags: apple-osx
20:02
Merge in version 3.31.0 Leaf check-in: f418afa1bf user: drh tags: reuse-schema
18:38
Version 3.31.0 check-in: f6affdd416 user: drh tags: trunk, release, version-3.31.0
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: c39e3c14a9 user: dan tags: begin-concurrent-report
16:31
Update test file exclusive.test so that it works with the "journaltest" permutation. check-in: 4daf94d833 user: dan tags: trunk
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: 934ee8bdb4 user: dan tags: trunk
15:01
Fix a case in fts3auto.test that fails for SQLITE_DISABLE_FTS4_DEFERRED builds. check-in: d241055ead 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: c7e29458a7 user: dan tags: trunk
13:40
Fix a problem in the userauth extension causing it to occasionally set "PRAGMA count_changes" (and some others) to true. check-in: 3a62f64222 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: 9265cb7f02 user: drh tags: trunk
01:45
Improvements to the autoconf TEA Makefile for MSVC. check-in: cffcf12f03 user: mistachkin tags: trunk
2020-01-20
15:32
Merge recent fixes from trunk. check-in: 9c920bbad3 user: drh tags: reuse-schema
14:42
In the fuzzcheck test program, reduce the default expression depth limit from 1000 to 500 to avoid stack-overflow problems when running stress tests using clang ASAN. check-in: 63d886f4ce user: drh tags: trunk
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: 4d46255096 user: drh tags: trunk
2020-01-18
23:52
Documentation improvements. check-in: 535afe1509 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: 1accfa8cf0 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: 8c8ce526ad user: drh tags: trunk
19:58
Fix a couple of test case issues on this branch. check-in: 9830a44bc6 user: dan tags: reuse-schema
19:46
Do not use memcpy() of zero bytes when initializing a pager. This avoids a warning. check-in: cca437788e user: drh tags: trunk
19:07
Disable a redundant test case that uses a very large stack, and hence is unable to run with -fsanitize=undefined,address. check-in: 3c63f68e12 user: drh tags: trunk
19:02
Fix harmless compiler warning seen with MSVC. check-in: cd0437ba5b 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: 7a4ec57985 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: fee945671a 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: a1be6ee018 user: drh tags: trunk
2020-01-17
23:27
Fix a typo in a comment. No code changes. check-in: 4363f69c3a user: drh tags: trunk
21:12
The compress() function should not be deterministic since the same input can have multiple possible compressed outputs. The uncompress() function, on the other hand, is deterministic. check-in: 84f314902c 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: 7584e4b649 user: drh tags: trunk
16:47
Improved rounding in the 'unixepoch' feature of the date and time functions. check-in: c9abf1bd2d user: drh tags: trunk
15:45
Update test script instrfault.test to account for the fact that bound blob values cast to text values are now intepreted using the text encoding of the database, instead of always as utf-8. check-in: 4d6cb28811 user: dan tags: trunk
15:33
More restrictions on changes to shadow tables when in defensive mode. Leaf check-in: b302b260ca 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: 3d13fbf248 user: drh tags: branch-3.28
14:56
Do not allow shadow tables to be dropped in defensive mode. check-in: ad1f760f16 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: be4269c624 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: cbcbb1e5a9 user: drh tags: branch-3.22
11:18
Fix a case in "fuzz.test" that could fail, as non-deterministic functions may no longer appear in CHECK constraints. check-in: a370871e21 user: dan tags: trunk
2020-01-16
17:53
New testcase() macros in select.c, for coverage of the change from two check-ins ago. check-in: 52206488f3 user: drh tags: trunk
16:32
Add the SQLITE_FCNTL_CKPT_DONE file-control for the use of custom VFSs. check-in: 3cc39e5069 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: 1bc783da63 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: f8801ffd94 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: 86b5e5a20e 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: af06f80a59 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: 1194a42add 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: 03b003c988 user: drh tags: trunk
14:26
Merge all recent enhancements and fixes from trunk. check-in: f783917800 user: drh tags: reuse-schema
14:21
Merge in the latest trunk changes via the begin-concurrent-pnu branch. check-in: 350627f3b1 user: drh tags: begin-concurrent-pnu-wal2
14:11
Merge recent enhancements and fixes from trunk. check-in: 35eae71a4d user: drh tags: wal2
13:48
Merge all recent enhancements and fixes from trunk. check-in: 110a081f12 user: drh tags: begin-concurrent-pnu
13:34
Merge fixes and enhancements from trunk into begin-concurrent. check-in: 95ba2f50fd user: drh tags: begin-concurrent
12:49
Merge all recent enhancements and fixes from trunk into the apple-osx branch. check-in: dadedf41c7 user: drh tags: apple-osx
2020-01-14
16:50
Fix the urifuncs.c extension (used for testing and debugging only) so that the sqlite3_filename_database() SQL function and its siblings correctly handle an invalid schema name passed in as the argument. check-in: 3d7434a9d8 user: drh tags: trunk
16:39
Remove an ALWAYS on a branch for improved database corruption detection in btree.c:freeSpace(). Test case found by dbsqlfuzz. check-in: 54bf048119 user: drh tags: trunk
16:33
Add the new noop_nd() debugging function to the noop.c extension. check-in: 72911fb1b0 user: drh tags: trunk
13:24
For the showdb utility program, more accurate detection of when the database is in autovacuum mode for the "pgidx" subcommand. check-in: 9ce2192b81 user: drh tags: trunk
13:13
Fix a minor typo on a comment in the CLI implementation. check-in: db4fb3503c user: drh tags: trunk
00:52
Improvements to sqlite3_open_v2() documentation. check-in: 4c4fd62a09 user: drh tags: trunk
2020-01-13
15:25
More documentation updates. No code changes. check-in: a684d4ef08 user: drh tags: trunk
13:33
Documentation updates. No changes to code. check-in: cc0e0aa3a7 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: 3e3c60d812 user: drh tags: trunk
22:25
Change the zipfile virtual table so that the xBestIndex method gives a reasonable cost estimate even if no filename is specified. The missing filename error continues to be raised in the xFilter method. Meanwhile, the more reasonable cost estimate avoids unnecessary wierdness in the query planner. check-in: 0e468aa6de user: drh tags: trunk
22:20
Remove an incorrect assert(). Fix for ticket [614b25314c766238] check-in: 6a999c5aa0 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: fd7bcc5352 user: drh tags: trunk
20:27
Minor changes for consistency between sqlite3_filename_wal() and sqlite3_filename_journal(). Closed-Leaf check-in: 9a70ff43a7 user: drh tags: enhanced-uri
16:08
Redesign for better legacy compatibility. Add the sqlite3_uri_key() interface. check-in: bcb43d11c4 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: 2ae77bd233 user: drh tags: enhanced-uri
01:05
Fix to the register validity tracking logic in debug builds. No impact on release builds. check-in: 0a500da6aa 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: 3d23a275ab user: drh tags: default-untrusted-schema
00:00
Documentation updates on newer APIs. No changes to code. check-in: 8845a8c22a user: drh tags: trunk
2020-01-09
23:07
Fix the fossildelta.c extension so that it will compile on mingw. check-in: 20237d5dc4 user: drh tags: trunk
20:44
Merge in the untrusted-schema enhancements. See [/doc/87aea3ab1cdda453/doc/trusted-schema.md|doc/trusted-schema.md] for details. check-in: 5720924cb0 user: drh tags: trunk
20:33
Only register the fts3_tokenizer() function using a single text encoding. check-in: 966964af10 user: drh tags: trunk
20:33
Fix a harmless compiler warning. check-in: edbf911fde 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: 83dc55679a user: dan tags: trunk
16:28
Fix a problem in the encoding display in the updated PRAGMA function_list. Closed-Leaf check-in: 318ff7720b user: drh tags: new-security-options
16:00
Fix minor typos in the trusted-schema.md document. check-in: 87aea3ab1c user: drh tags: new-security-options
15:18
Minor formatting changes in the trusted-schema.md document. check-in: 55553b5e5e user: drh tags: new-security-options
14:51
Design notes for the new-security-options branch. check-in: af7c1ed4f8 user: drh tags: new-security-options
13:08
Simplified error message for the unsafe use of a virtual table. check-in: d662129a60 user: drh tags: new-security-options
01:20
Fix a problem that restricted edgy functions in TEMP tables. New test cases added. check-in: 8878c40753 user: drh tags: new-security-options
2020-01-08
22:22
Block edgy functions used in DEFAULT constraints. check-in: da434dc149 user: drh tags: new-security-options
20:37
Performance improvements and test cases added. Allow "PRAGMA trusted_schema=ON" check-in: 30882ca80f 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: 1da802d54b user: drh tags: new-security-options
15:44
Provide the -innocuous option to the "db func" method in the TCL interface. check-in: 0138652b6c user: drh tags: new-security-options
15:43
Fix the rot13.c extension to be deterministic. Add the noop.c extension. check-in: a679122ca8 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: fe7472fd2a user: drh tags: new-security-options
13:08
Merge recent changes from trunk. check-in: 5962921fce 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: 1c76f1d8ec user: drh tags: trunk
11:36
Fix a minor formatting error in the display of BLOB values during VDBE tracing. check-in: 295442887a user: drh tags: trunk
10:57
Improvements to the documentation of sqlite3_create_collation(). check-in: fa866aec56 user: drh tags: trunk
04:36
Simplification of the logic in the constant-propagation optimization. check-in: 1c3e5c20a9 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: 6db1c3498f user: drh tags: trunk
00:39
Fix a misworded comment. No code changes. check-in: ee0bc7ede0 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: 4c21373c21 user: drh tags: new-security-options
18:10
Enforce SQLITE_VTABRISK restrictions. check-in: 3d87ff312e user: drh tags: new-security-options
18:10
Fix a performance regression caused by the previous check-in. check-in: d7d98d3dff user: drh tags: trunk
16:09
Invert the UNTRUSTED_SCHEMA setting to be TRUSTED_SCHEMA. check-in: f5fcf1fbc6 user: drh tags: new-security-options
15:44
Merge recent fixes from trunk. check-in: 5dfa33a09e user: drh tags: new-security-options
14:51
Provide the ability to tag an application-defined function as "testonly". Leaf check-in: e6f5c0e0ac user: drh tags: testonly-functions
13:32
Add an "|| CORRUPT_DB" term to an assert() statement inside of btree. check-in: 03c1d75ddc user: drh tags: trunk
09:06
Fix an instance of an undefined behaviour (a left-shift of a 64-bit unsigned integer by a value greater than 64) that could occur in fts3. check-in: e1f12978b5 user: dan 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: e1154c39ba user: drh tags: trunk
19:30
Merge enhancements from trunk. check-in: 9c50f6c28a 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: 69f6a7e42f 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: b3f2696705 user: drh tags: trunk
18:44
Move variable declaration to start-of-block for MSVC. check-in: 55c136ef61 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: d7126a9ced 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: 1409758f72 user: dan tags: trunk
15:25
Refactor names of flags for improved legibility. check-in: 411e8ec221 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: 46f8ef70fb 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: 65d7d39a85 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: 7a8d7ca726 user: drh tags: new-security-options
19:19
Merge all fixes and enhancements from trunk. check-in: b878c30f03 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: 5b246b47ae user: drh tags: trunk
19:12
Fix harmless compiler warnings. check-in: 8452fe0343 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: cfff5cb227 user: dan tags: trunk
18:33
Record when the OP_IfNotOpen branch is and is not taken. check-in: 182a898b14 user: drh tags: trunk
17:55
Remove another NEVER added by check-in [7b62555e285f32d3]. Dbsqlfuzz found another test case. check-in: 481f4956af user: drh tags: trunk
17:42
New test cases in test/in4.test require rtree, so disable those tests on builds that lack the rtree extension. check-in: b5900914f7 user: drh tags: trunk
16:55
Fix a problem where the loop for the RHS of a LEFT JOIN uses values from an IN() clause as the second or subsequent field of an index. check-in: 95ef68966c user: dan tags: trunk
15:37
Merge the latest fixes from trunk. check-in: 26ef709a47 user: drh tags: new-security-options
15:21
Fix a false-positive in the register validity tracking logic by moving the temporary register release call before the jump that uses that temporary register. check-in: 9da48a5ca6 user: drh tags: trunk
14:57
Improve a testcase in test/fuzzdata8.db to make it more resilient. check-in: 139aefe600 user: drh tags: trunk
14:50
Back out another NEVER added by check-in [7b62555e285f32d3] - the test case was already in test/fuzzdata3.db, but it only occurs if compiled without SQLITE_ENABLE_PREUPDATE_HOOK. check-in: 61f873b14c user: drh tags: trunk
14:00
Omit the omit flag from eq constraints on column "aggregate" of dbstat virtual tables. Fix for [727074e2]. check-in: 74ef6f2b6d user: dan tags: trunk
12:34
Restore a NEVER and an assert in btree that was removed by check-in [7b62555e285f32d3]. Dbsqlfuzz found test cases. check-in: 04a05c83f5 user: drh tags: trunk
01:43
Enhance PRAGMA function_list so that it shows all instances of each FuncDef, the number of arguments, the encoding, the type, and the flags. Use this capability to locate and fix incorrect function flags in the standard build. check-in: 9ca906d24a user: drh tags: new-security-options
2020-01-03
21:57
Invert the SQLITE_FUNC_SAFE bit to be SQLITE_FUNC_UNSAFE. The external bit is still SQLITE_INNOCUOUS. It gets inverted as the appdef function is registered. check-in: 1c266cb3be user: drh tags: new-security-options
20:57
When UNSAFE_IN_VIEW is disabled, only allow functions in views that are tagged with SQLITE_INNOCUOUS. check-in: 9ee79b254e user: drh tags: new-security-options
20:16
In fts3, avoid making a very large memory allocation if the merge-hint record is corrupt. check-in: 9add58fe96 user: dan tags: trunk
17:40
Add NEVER macros to error-detection branches that were made unreachable (as far as I can tell) by check-in [ceacc28b03580334]. check-in: 7b62555e28 user: drh tags: trunk
16:38
Improvement to check-in [7405e98225761180] so that missing or null filenames given to the zipfile extension throw an immediate error. check-in: 523e09bd22 user: drh tags: trunk
15:51
Improve a specific case of early database corruption dectecion in the b-tree layer. check-in: ceacc28b03 user: dan tags: trunk
15:22
Merge fixes from trunk. check-in: 002406df22 user: drh tags: new-security-options
14:34
Remove an over-zealous ALWAYS() macro and add a test case that shows that the conditional can sometimes be false. check-in: 536e9a9d1b user: drh tags: trunk
14:27
Fix a possible NULL pointer dereference caused by using a "VALUES(...)" as a component of a compound SELECT with non-integer ORDER BY clause terms. check-in: 9d79111642 user: dan tags: trunk
14:16
Fix the OP_Copy-coalesce optimization so that if the previous row happens to end with OP_Copy but is not a candidate for the optimization due to jumps, then the optimization is correctly bypassed. check-in: b36126c188 user: drh tags: trunk
13:55
Ensure that when a Select object is reset a new, empty, SrcList is allocated. check-in: 4889cbf898 user: dan tags: trunk
02:20
When generating the name of a view (or common table expression) because the SQL does not specify a name, avoid the names "true" and "false" which might be confused for the boolean literals of the same name, leading to an inconsistent abstract syntax tree. check-in: ff9492d3ff user: drh tags: trunk
00:28
Fix a problem in sqlite3TreeViewBareExprList() in which the routine was not interpreting the new ExprList format correctly. check-in: cd56872afb user: drh tags: trunk