/ Timeline
Login

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

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

2019-02-18
18:16
Ensure that creating temp schema items does not cause an OPEN_SHARABLE_SCHEMA connection to load all schemas into memory. Leaf check-in: 88cbf54e user: dan tags: reuse-schema
12:16
Fix an assert() that might not be true if the %_segdir table of FTS3 contains corrupt entries. Leaf check-in: a6509ca3 user: drh tags: trunk
2019-02-16
17:27
Add support for chaining of WINDOW definitions. Leaf check-in: c155125f user: dan tags: window-functions
2019-02-15
19:36
Enhance the virtual table in test_schemapool.c so that it can be used to check that SHARED_SCHEMA connections are not allocating and freeing schemas when they should not be. check-in: cb236cb9 user: dan tags: reuse-schema
19:00
Fix a problem with eponymous virtual tables and SHARED_SCHEMA databases. Also, after preparing statements that require all database schemas (REINDEX, ANALYZE, CREATE, DROP and some PRAGMA statements), do not allow the database connection to return more than one schema to each schema-pool. check-in: ecf6251e user: dan tags: reuse-schema
2019-02-14
21:04
Fix SQLITE_DBSTATUS_SCHEMA_USED so that it works with SQLITE_OPEN_SHARED_SCHEMA connections. check-in: d43b3c05 user: dan tags: reuse-schema
18:38
Change the name of the SQLITE_OPEN_REUSE_SCHEMA flag to SQLITE_OPEN_SHARED_SCHEMA. check-in: 7257fcc8 user: dan tags: reuse-schema
15:56
Merge latest trunk into this branch. check-in: 577d1638 user: dan tags: reuse-schema
15:47
Add missing comments and fix other code issues in the new functions in callback.c. check-in: 441cabb6 user: dan tags: reuse-schema
15:27
Improved oversized cell detection when updating ptrmap pages in balance_nonroot(). check-in: aa61435a user: drh tags: trunk
2019-02-13
19:17
Fix for sqlite3_table_column_metadata() on REUSE_SCHEMA databases. check-in: 53220ad7 user: dan tags: reuse-schema
18:29
Avoid crashing after parsing a corrupt schema with a REUSE_SCHEMA connection. check-in: b102148e user: dan tags: reuse-schema
15:51
Fix a problem with the incrblob API and reusable schemas. check-in: 34f0f96f user: dan tags: reuse-schema
08:40
Fix a problem with OPEN_REUSE_SCHEMA connections reloading the temp schema. check-in: 7c2ec2d4 user: dan tags: reuse-schema
2019-02-12
20:58
Add tests for creating temp schema objects with SQLITE_OPEN_REUSE_SCHEMA connections. check-in: 8c07b609 user: dan tags: reuse-schema
19:20
Share schemas between databases attached to the same database handle. check-in: ea611d7c user: dan tags: reuse-schema
01:28
New test cases in test/fuzzdata8.db. check-in: ab2356f5 user: drh tags: trunk
01:04
Defer computing the number of bytes of free space on a btree page until that value is actually needed. check-in: 177f5f40 user: drh tags: trunk
2019-02-11
20:13
Merge latest trunk changes into this branch. check-in: dbedd81b user: dan tags: reuse-schema
19:34
Add eponymous virtual table "schemapool". For inspecting the current contents of the schema-pool. check-in: 2ebeb747 user: dan tags: reuse-schema
17:22
Fix test cases. Avoid unnecessary tests for MemPage.nFree less than zero. check-in: 480a5090 user: drh tags: deferred-free-space
11:34
Build and test fixes for SQLITE_OMIT_WINDOWFUNC builds. check-in: 8824115a user: dan tags: trunk
2019-02-09
19:23
Change a few assert() statements in fts3 that might fail if the database is corrupt. check-in: db74a56a user: dan tags: trunk
17:47
Fix virtual table support for SQLITE_OPEN_REUSABLE_SCHEMA connections. check-in: 3ca8856a user: dan tags: reuse-schema
2019-02-08
19:30
Add test cases and fix problems on this branch. check-in: 2b2e9f81 user: dan tags: reuse-schema
14:59
Merge the fix for ticket [4e8e4857d32d401f], so that this branch now contains release 3.27.1 plus the extra patch to preserve ROWID values on VACUUM. Leaf check-in: 0cdae60e user: drh tags: apple-osx
12:46
Cherrypick the fix for ticket [4e8e4857d32d401f] from trunk. check-in: d5d944d7 user: drh tags: branch-3.27
04:15
Do not do the optimization that attempts to pull expression values from an index on that expression when processing a multi-index OR (see check-in [a47efb7c8520a0111]) because the expression transformations that are applied become invalid when the processing moves off of the current index and on to the next index. Fix for ticket [4e8e4857d32d401f]. check-in: 440a7cda user: drh tags: trunk
2019-02-07
19:28
Pull in the change that causes VACUUM to preserve rowid values. check-in: c9af2f71 user: drh tags: apple-osx
19:07
Change VACUUM so that it preserves ROWID values. check-in: 49e5d11d user: drh tags: trunk
18:49
Merge the offical 3.27.0 release. check-in: 62829164 user: drh tags: apple-osx
00:17
In the fuzzcheck test program, make sure the isspace() and related routines are not given values outside the range of -1 to 255. check-in: f2983287 user: drh tags: trunk
2019-02-06
19:42
Avoid attempting to delete a file while it is still open in walfault2.test. check-in: 9d54a63d user: dan tags: trunk
18:08
Update test file dbfuzz001.test so that it works with SQLITE_ENABLE_OVERSIZE_CELL_CHECK builds. check-in: 4371a0c4 user: dan tags: trunk
15:23
Add -DSQLITE_ENABLE_DESERIALIZE to the default testing configuration in test/releasetest.tcl. check-in: 433d6ef6 user: dan tags: trunk
13:48
Do not attempt to test the shell ".trace" command in SQLITE_OMIT_TRACE builds. check-in: 3839e909 user: dan tags: trunk
00:55
If the query flattener detects an error, cause the SELECT code generator to abort immediately. check-in: 3d3b142f user: drh tags: trunk
2019-02-05
19:51
Merge latest trunk into this branch. check-in: c089cc4f user: dan tags: reuse-schema
19:15
Fix memory leaks on this branch. check-in: e9c5e189 user: dan tags: reuse-schema
16:53
Update the tester.tcl --malloctrace option so that it uses eu-addr2line instead of addr2line. check-in: 79c07387 user: dan tags: trunk
14:36
The IS NOT NULL operator does not imply that the operand is never NULL. Fix for ticket [5948e09b8c415bc45da5cf] check-in: d840e9bb user: drh tags: trunk
08:55
Update test file "resetdb.test" so that it works with the "prepare" permutation. check-in: 95d33812 user: dan tags: trunk
2019-02-04
21:02
Fix a problem with reloading the schema on this branch. check-in: 5dfbef83 user: dan tags: reuse-schema
19:50
Add the -memtrace option to dbfuzz2. check-in: 67fecbc7 user: drh tags: trunk
19:45
Enhance dbfuzz2 so that with the -v option it shows the return code and error message for any failing SQL statements. check-in: 3a127ef9 user: drh tags: trunk
16:42
Do not run shmlock.test as part of the inmemory_journal permutation. check-in: d3fea69c user: dan tags: trunk
16:36
Update the test/fuzzdata8.db database with new interesting cases from dbsqlfuzz. check-in: e467e4c8 user: drh tags: trunk
2019-02-03
07:46
Fix an assertion failure in fts3 triggered by a corrupt database. check-in: 560ebd42 user: dan tags: trunk
2019-02-02
21:02
Try new approach ensuring that each Schema object is only used by one connection/database at any one time. check-in: 9e8e5f52 user: dan tags: reuse-schema
18:24
New testcase added to test/fuzzdata8.db. check-in: 2f5c1925 user: drh tags: trunk
2019-02-01
14:54
New test cases added to test/fuzzdata8.db. check-in: e5924939 user: drh tags: trunk
2019-01-30
19:50
Change the error message slightly for when two or more indexes have the same rootpage. check-in: 916c52da user: drh tags: trunk
19:12
When parsing the schema, check for duplicate index root page numbers before adding the index to the schema hash table. check-in: 6b360bc0 user: dan tags: trunk
18:47
Add test case for the previous commit. check-in: 197edb23 user: dan tags: trunk
2019-01-29
19:17
Merge enhancements from trunk. check-in: 31efcc37 user: drh tags: apple-osx
16:47
Load all the latest dbsqlfuzz finds into test/fuzzdata8.db. check-in: e744d2dd user: drh tags: trunk
16:41
More robust handling of corrupt database file in the rebalance operation of the btree logic. check-in: 97704cb7 user: drh tags: trunk
02:37
Set a low limit on the length of strings and blobs in the OSSFuzz module, in an effort to avoid timeouts when the fuzzer does things like "randomblob(1e12)". check-in: 119d1609 user: drh tags: trunk
2019-01-28
19:06
Fix the query planner so that it is able to use an index on a CAST expression. check-in: 2c886f3d user: drh tags: trunk
18:08
Make indexes on CAST(...) expressions work. check-in: 3ef711d9 user: dan tags: index-on-cast
16:50
Fix a buffer overread in fts3 that could occur when accessing a corrupt database. check-in: a9faf903 user: dan tags: trunk
13:27
Do not assume that text parameters passed to fts4aux queries do not contain embedded nul characters. check-in: df04859a user: dan tags: trunk
11:54
Add a new test case to fuzzdata8.db. check-in: ce8e279a user: drh tags: trunk
2019-01-27
02:45
New test cases form dbsqlfuzz check-in: 9cf8ebd1 user: drh tags: trunk
01:11
Update fuzzcheck so that with the --load-dbsql options it screens its inputs to ensure that they are valid dbsqlfuzz cases. Add new dbsqlfuzz finds to the test/fuzzdata8.db database. check-in: 004f7d9b user: drh tags: trunk
2019-01-26
21:05
Fix a broken assert() in fts3. Also some test script issues causing failures with builds that do not support fts3. check-in: d59567dd user: dan tags: trunk
20:41
Fix another typo in fts3_common.tcl causing test failures in builds that do not support fts3. Closed-Leaf check-in: 773b5986 user: dan tags: rollback-abort
20:35
Fix a typo in fts3corrupt4.test causing it to fail if the build does not support fts3. check-in: 50163034 user: dan tags: rollback-abort
19:09
Fix a broken assert() in fts3. check-in: b8dd2d67 user: dan tags: rollback-abort
18:10
If a write statement fails with OE_Abort, but there is no statement journal, roll the entire transaction back instead. check-in: 75a8ed7a user: dan tags: rollback-abort
16:34
Roll back the transaction if a write statement fails with OE_Abort but there is no open statement transaction. check-in: d536be69 user: dan tags: rollback-abort
2019-01-25
20:09
Do not accidently truncate zeroblob values when doing an arithmetic operation. Fix for ticket [bb4bdb9f7f654b0bb9f34cfba]. check-in: 13f6942e user: drh tags: trunk
17:51
Fix harmless compiler warnings in fuzzcheck check-in: a8253966 user: drh tags: trunk
17:26
Fix a segfault that could follow an OOM when querying a table that has one or more columns with default values "true" or "false". check-in: 202f9919 user: dan tags: trunk
14:48
Add an assert_fts3_nc() macro to fts3 - for assert() conditions that are only true when it is guaranteed that the fts3 database is not corrupt. check-in: 3498908c user: dan tags: trunk
14:23
Extend fuzzcheck so that it can process dbsqlfuzz cases. Add a collection of interesting dbsqlfuzz cases to the standard test suite. check-in: e2991a7e user: drh tags: trunk
13:42
Fix a couple of assert() statments in btree.c that could fail with corrupt databases. check-in: 5eb5e828 user: dan tags: trunk
13:03
In fuzzcheck, activate vdbe_debug for dbsqlfuzz cases when using the -vvvvv verbosity level or above. check-in: 2e6f7c2a user: drh tags: dbsqlfuzz-in-fuzzcheck
04:43
Improved automatic detection of dbsqlfuzz cases in fuzzcheck. check-in: 1ef24e89 user: drh tags: dbsqlfuzz-in-fuzzcheck
04:00
Add the ability to process dbsqlfuzz cases in fuzzcheck and add an initial set of interesting dbsqlfuzz cases. check-in: fb9074ff user: drh tags: dbsqlfuzz-in-fuzzcheck
2019-01-24
17:41
Fix a buffer overread in fts3 that could occur in a prefix query on a corrupted database. check-in: d0d56893 user: dan tags: trunk
16:27
Fix a problem with running ALTER TABLE on a schema that contains expressions of the type "col IN ()" (empty set on RHS of IN operator). check-in: 2d9cd067 user: dan tags: trunk
15:16
Fix a potential problem with "INSERT INTO ... SELECT * FROM" (or VACUUM) statements on a corrupted database. check-in: db4b4c2c user: dan tags: trunk
13:36
Use memmove() instead of memcpy() in a place where buffers might overlap if the database file is badly corrupted, to prevent warnings from ASAN and valgrind. check-in: 65ad6c55 user: drh tags: trunk
2019-01-23
20:31
Fix an assert() in vdbemem.c that could fire if the database was corrupt. check-in: a70958cd user: dan tags: trunk
19:50
Fix a problem with renaming a table within a schema that contains a composite query that uses a column alias as an ORDER BY term. check-in: 2ca6b8f8 user: dan tags: trunk
16:59
Fix problems with sub-selects in WINDOW definitions. Also rename-column operations when the column being renamed appears in a WINDOW definition that is part of a VIEW or TRIGGER. check-in: 0387cb3a user: dan tags: trunk
2019-01-22
20:18
Do not run shmlock.test as part of the journaltest permutation. check-in: 5b7d0c78 user: dan tags: trunk
16:11
Update dbfuzz2 to set a maximum database size of 100MiB by default, but with the new --max-db-size N option to change that limit. check-in: 21d6bb78 user: drh tags: trunk
16:06
Enhancements to deserialize: (1) Add the SQLITE_FCNTL_SIZE_LIMIT file control to set a maximum size for an in-memory database, defaulting to SQLITE_MEMDB_DEFAULT_MAXSIZE or 1GiB. (2) Honor the SQLITE_DESERIALIZE_READONLY flag. (3) Enhance the TCL interface to support -maxsize N and -readonly BOOLEAN. (4) Add the --maxsize option to the ".open" command and on the command-line for the CLI. check-in: 30f08d58 user: drh tags: trunk
13:45
Make sure cursors are opened on all indexes for an UPDATE OR REPLACE regardless of whether or not the indexes are partial or contain columns that might need to be updated. check-in: e148cdad user: drh tags: trunk
12:21
Fix another segfault caused by a corrupt fts3 database. check-in: ba3b8412 user: dan tags: trunk
2019-01-21
17:57
Avoid deferencing a freed pointer following an OOM or SQLITE_CORRUPT error in the fts3 xDestroy method. check-in: 505ed9a4 user: dan tags: trunk
16:12
Remove a faulty assert() from fts3. check-in: 6c33a303 user: dan tags: trunk
14:49
Minor fix the fallocate.test module change from [7cd56cad5efead5] check-in: 94fb7a47 user: drh tags: trunk
13:47
Add the --max-data and --max-as options to dbfuzz2. Also cause dbfuzz2 to show its maximum RSS size upon exit in standalone mode with the -v option. check-in: 7ce93e82 user: drh tags: trunk
2019-01-20
00:03
Add the --max-stack option to dbfuzz2. check-in: c11ae4fe user: drh tags: trunk
2019-01-19
15:27
Remove a broken assert() triggered by a "PRAGMA max_page_count = N" invocation, where N is larger than the number of pages in the database image, but smaller than the number of pages in the database file. check-in: 7cd56cad user: dan tags: trunk
14:07
Fix a problem with using ALTER TABLE to rename a table or column when the database schema contains a trigger or view that itself contains an expression "<column> AND 0". check-in: 908ff7ff user: dan tags: trunk
2019-01-18
21:03
Fix an infinite loop caused by a corrupt database in fts3. Also an undefined left-shift in fts5. check-in: 55c5d72a user: dan tags: trunk