/ Timeline
Login

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

50 check-ins occurring around 89e099fbe5e13c33.

2018-11-09
23:41
Fix invalid use of unprotected sqlite3_value objects in the sqldiff utility, when using the --changeset option. check-in: a8d65214a5 user: drh tags: trunk
20:04
When a table is renamed using "ALTER TABLE RENAME TO", update any REFERENCES clauses that refer to the table, unless "PRAGMA legacy_alter_table" is true and "PRAGMA foreign_keys" is set to false (i.e. so that when "PRAGMA legacy_alter_table" is set behaviour is still compatible with versions 3.24 and earlier). check-in: ae9638e9c0 user: dan tags: trunk
18:44
Merge latest trunk changes with this branch. check-in: ae88f8e1ff user: dan tags: reuse-schema
14:17
Fix for ticket [787fa716be3a7f650cac] check-in: 531eca6104 user: drh tags: trunk
00:02
Disable the use of coroutines for subqueries within a query that is the RHS of an IN operator, as the IN operator might be evaluated more than once. Possible fix for [787fa716be3a7f65], unless we can come up with something better. Later: Counter-example found. Closed-Leaf check-in: 8d663bfaaa user: drh tags: tkt787fa716-deadend
2018-11-08
22:53
In the treeview.c module, break out the display of SrcList into a separate subroutine, so that it can be invoked while debugging. check-in: 8c74065f00 user: drh tags: trunk
17:32
Improved documentation for SQLITE_DBCONFIG_DEFENSIVE. Add a NEVER() macro on an unreachable branch. check-in: 9292d3351c user: drh tags: read-only-shadow
14:59
Add tests and a fix for program "changesetfuzz". check-in: 09b90db56c user: dan tags: changesetfuzz
2018-11-07
20:13
Merge latest trunk changes into this branch. check-in: 53cd91d005 user: dan tags: changesetfuzz
20:07
Fix minor issues in the changesetfuzz program. check-in: 5c7f024073 user: dan tags: changesetfuzz
17:52
Update the "changesetfuzz" program to work with patchsets as well as changesets. check-in: 75b00fbe88 user: dan tags: changesetfuzz
16:46
Performance improvement in subroutine that decides whether or not a table is read-only. check-in: 6e4968b005 user: drh tags: read-only-shadow
16:12
Merge the onefile permutation fix from trunk. check-in: e543bff87d user: drh tags: read-only-shadow
14:41
More test-case adjustments for defensive mode. check-in: 911e8a17a3 user: drh tags: read-only-shadow
14:39
Fix a problem with the handling of SQLITE_FCNTL_PRAGMA in the test_onefile.c demo. check-in: 13e21b7da8 user: dan tags: trunk
13:41
Merge the permutations fix from trunk. check-in: b753d849fe user: drh tags: read-only-shadow
11:56
Partially revert [3e1a2f661], as some test scripts require separate $presql and $dbconfig variables. check-in: cbf85284be user: dan tags: trunk
02:17
Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled. check-in: 3212733cb6 user: drh tags: read-only-shadow
2018-11-06
20:08
Update the changesetfuzz program to fuzz changeset schemas as well as data. check-in: 141a93c843 user: dan tags: changesetfuzz
19:26
Enable DEFENSIVE mode by default for tests. This requires lots of case of turning DEFENSIVE off in order to dodgy things to the database for testing purposes. No all of those cases are yet handled, so "make test" does not run to completion. check-in: a1d6c6712c user: drh tags: read-only-shadow
15:57
Turn on defensive mode for running test scripts. Does not yet work. check-in: 1c1d24edbb user: drh tags: read-only-shadow
14:03
Only allow shadow table to be written from within a recursive SQL call. Omit the SQLITE_PREPARE_SHADOW flag. Some tests are failing because the tests depend on being able to write to shadow tables. check-in: d890c65825 user: drh tags: read-only-shadow
13:37
Add enforcement of read-only on shadow tables. This does not currently work since some virtual tables are attempting to update shadow tables using sqlite3_exec(). check-in: f79b47c985 user: drh tags: read-only-shadow
2018-11-05
23:01
Initial code to make shadow tables read-only to ordinary SQL. The now xShadowName method is added to the sqlite3_module object and is used to identify potential shadow tables. The SQLITE_PREPARE_SHADOW argument to sqlite3_prepare_v3() is defined. It is designed to permit writing to shadow tables, but is currently an unused placeholder. check-in: 31942b3dd3 user: drh tags: read-only-shadow
20:37
Version 3.25.3 check-in: 89e099fbe5 user: drh tags: release, version-3.25.3, branch-3.25
20:37
Add preliminary version of "changesetfuzz" program. For fuzzing changeset data without creating corrupt changesets. check-in: 81ac8745fa user: dan tags: changesetfuzz
19:37
Add the SQLITE_DBCONFIG_DEFENSIVE flag. check-in: 11d98414ea user: drh tags: trunk
16:38
Eponymous virtual tables appear to exist in all schemas. This is an alternative and improved fix to the eponymous virtual table in trigger problem that was previously addressed by checkin [1fa74930ab56171e]. check-in: b8d35c4a7c user: drh tags: trunk
13:53
Merge recent trunk enhancements. check-in: 62acf7a09e user: drh tags: apple-osx
13:48
Disable the IS NOT NULL optimization when the IS NOT NULL operator is part of the ON clause of a LEFT JOIN. Fix for ticket [65eb38f6e46de8c75e188a17ec]. check-in: 8d09ce5d73 user: drh tags: branch-3.25
13:43
Add extra defenses against strategically corrupt databases to fts3/4. check-in: 940f2adc85 user: drh tags: branch-3.25
13:37
Increase the version number to 3.25.3. check-in: 1250ab8f22 user: drh tags: branch-3.25
13:35
Fix a assert() in the query planner that can arise when doing row-value operations on a PRIMARY KEY that contains duplicate columns. Ticket [1a84668dcfdebaf12415d]. check-in: 1309c84ad3 user: drh tags: branch-3.25
07:53
Disable the IS NOT NULL optimization when the IS NOT NULL operator is part of the ON clause of a LEFT JOIN. Fix for ticket [65eb38f6e46de8c75e188a17ec]. check-in: af39661e60 user: drh tags: trunk
2018-11-03
17:31
Correct the internal logic for SQLITE_DBCONFIG_DEFENSIVE. Closed-Leaf check-in: 7609434582 user: drh tags: dbconfig-defensive
16:51
Add extra defenses against strategically corrupt databases to fts3/4. check-in: d44318f590 user: dan tags: trunk
16:09
Add the SQLITE_DBCONFIG_DEFENSIVE flag. check-in: af3f29d493 user: drh tags: dbconfig-defensive
13:11
Fix a assert() in the query planner that can arise when doing row-value operations on a PRIMARY KEY that contains duplicate columns. Ticket [1a84668dcfdebaf12415d]. check-in: dcb8c73594 user: drh tags: trunk
2018-11-02
17:38
Enhance triggers so that they can use table-valued-functions that exist in schemas outside of the schema in which the trigger is defined. check-in: 1fa74930ab user: drh tags: trunk
2018-10-31
20:52
Deploy the sqlite3Strlen30NN() function (argument guaranteed to be non-NULL) for a small performance improvement. check-in: 4a6ad5190b user: drh tags: trunk
19:01
Add support for the SQLITE_PREPARE_NORMALIZED flag and the sqlite3_normalized_sql() when compiling with SQLITE_ENABLE_NORMALIZE. Also remove unnecessary whitespace from Makefiles. check-in: 790ea39a65 user: drh tags: trunk
18:24
Tweaks to the test_intarray documentation and tests. check-in: 7107f0dacf user: drh tags: trunk
01:26
Merge fixes from trunk, especially rebustness against corrupt database files. check-in: 4b370c74ae user: drh tags: apple-osx
01:12
Merge fuzz test cases computed by dbfuzz2. check-in: e0d30c1862 user: drh tags: trunk
01:04
Improved corrupt database detection in the relocatePage() routine of the b-tree module. check-in: d57873337a user: drh tags: trunk
2018-10-30
23:45
Add new fuzzer cases generated by dbfuzz2. Closed-Leaf check-in: 79fdad8b42 user: drh tags: dbfuzz2-cases
19:14
Update comments in sqlite3session.c to describe the format of "rebase blobs", as well as changesets and patchsets. check-in: bf93f7b56b user: dan tags: trunk
16:25
Split the SQLITE_WriteSchema flag in two flags, WriteSchema and SQLITE_NoSchemaError. Set only WriteSchema on a VACUUM to avoid problems when trying to vacuum a corrupt database. With this change, the size of the flags field on sqlite3 must grow from 32 to 64 bytes. check-in: 4f9878107a user: drh tags: trunk
15:31
Modify the CLI so that the --deserialize option is only available if it is compiled with SQLITE_ENABLE_DESERIALIZE. DESERIALIZE is now off by default for the main.mk makefile, but on for Makefile.in and Makefile.msc. check-in: 90b2a684f7 user: drh tags: trunk
15:20
Improvements to the -fsanitize=fuzzer based database file fuzzer. (Cherrypick from the rubust-against-damaged-db branch.) check-in: 3cc01a0eaf user: drh tags: trunk