Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 descendants and 100 ancestors of [8c74065f]
|
2018-12-05
| ||
| 17:14 | Fix a problem causing "PRAGMA journal_mode" to report the wrong journal mode (wal instead of wal2) under some circumstances. check-in: 1d8d4f68 user: dan tags: wal2 | |
| 16:45 | Fixes for snapshots API on this branch. Also ensure that the snapshots API cannot be used with wal2 mode databases (for now anyhow). check-in: d8c2d55f user: dan tags: begin-concurrent-wal2 | |
| 16:31 | Fixes for snapshots API on this branch. Also ensure that the snapshots API cannot be used with wal2 mode databases (for now anyhow). check-in: 19c61ab7 user: dan tags: wal2 | |
| 13:49 | Merge enhancements from trunk, especially the sqlite3_normalized_sql() enhancement. check-in: 342c9538 user: drh tags: begin-concurrent-pnu | |
| 13:49 | Ensure that ALTER TABLE modifies table and column names embedded in WITH clauses that are part of views and triggers. check-in: f44bc7a8 user: dan tags: trunk | |
| 13:44 | Merge enhancements from trunk, especially the enhanced sqlite3_normalized_sql() interface. check-in: 47b73f6b user: drh tags: begin-concurrent | |
| 13:39 | Enhance the sqlite3_normalize_sql() interface so that it works even if the prepared statement was not initially compiled using SQLITE_PREPARE_NORMALIZED. Enhance the ".trace" command in the CLI so that it is able to access the full scope of functionality provided by sqlite3_trace_v2() and in particular so that it is able to show normalized SQL output using the newly enhanced sqlite3_normalize_sql() interface. check-in: 7da617e9 user: drh tags: trunk | |
|
2018-12-04
| ||
| 21:16 | When compiled with SQLITE_ENABLE_NORMALIZE, always have sqlite3_exec() enable the SQLITE_PREPARE_NORMALIZE flag. Leaf check-in: 28643d83 user: mistachkin tags: execWithNormalize | |
| 19:41 | First attempt at making features work together. Only the most minimal testing so far. check-in: fd707001 user: dan tags: begin-concurrent-wal2 | |
| 16:51 | Add the "index_usage" utility program. check-in: df954552 user: drh tags: trunk | |
| 14:33 | Performance improvement in sqlite3_step() by creating a new mTrace flag for the legacy xProfile pointer that is set by sqlite3_profile(). check-in: e28584e8 user: drh tags: trunk | |
| 13:51 | Fix a problem with SQLITE_ENABLE_EXPENSIVE_ASSERT builds on this branch. check-in: ddb4a6fb user: dan tags: begin-concurrent | |
| 13:51 | Small performance increase in sqlite3_step() for the common case where it returns SQLITE_ROW. check-in: 89344826 user: drh tags: trunk | |
| 01:18 | Attempt to make the parser a little faster by storing the ON and USING clause in a single OnUsing object. Leaf check-in: 6770ed08 user: drh tags: on-using-opt | |
|
2018-12-03
| ||
| 23:57 | Reduce the size of the parser tables generated by Lemon by splitting the yyRuleInfo structure into separate yyRuleInfoLhs and yyRuleInfoNRhs arrays. check-in: 70fe8ec2 user: drh tags: trunk | |
| 20:49 | Merge the wal2 and begin-concurrent code. Both features work, but not at the same time. check-in: b7281a1c user: dan tags: begin-concurrent-wal2 | |
| 20:38 | Minor change to wal.c on this branch to make it more similar to trunk. check-in: 6a7af3ea user: dan tags: begin-concurrent | |
| 19:29 | Cherrypick a couple of fixes from begin-concurrent-pnu into this branch. The differences between the two branches are now that this one does not have "PRAGMA noop_update" or the mutex-free PRNG. check-in: a56506b9 user: dan tags: begin-concurrent | |
| 18:24 | Merge in all changes for release 3.26.0. check-in: 85fd92c7 user: drh tags: begin-concurrent-pnu | |
| 18:15 | Bring up to date with version 3.26.0. check-in: f0ddb358 user: drh tags: begin-concurrent | |
| 18:13 | Increase a timeout in test file walprotocol2.test. To account for unix builds without HAVE_USLEEP. check-in: 480be916 user: dan tags: wal2 | |
| 17:40 | Remove the unused sqlite3Fts5UnicodeNCat() function. check-in: 7149dacf user: drh tags: trunk | |
| 16:14 | Add the "remove_diacritics=2" option to the unicode61 tokenizer in both FTS5 and FTS3/4. check-in: 06177f3f user: dan tags: trunk | |
| 14:58 | Update the autoconf makefile for MSVC. check-in: 675aba1f user: mistachkin tags: trunk | |
| 01:58 | Remove two lines of unnecessary code, for a very small performance increase and size decrease. check-in: 15824ccd user: drh tags: trunk | |
| 01:47 | Fix a parser bug in the use of parentheses around table-valued functions. check-in: 58a51123 user: drh tags: trunk | |
|
2018-12-02
| ||
| 01:15 | Omit a line of code that has no affect on the outcome. check-in: 5d933aa6 user: drh tags: trunk | |
|
2018-12-01
| ||
| 21:13 | Very slightly smaller and faster. check-in: 27798f17 user: drh tags: trunk | |
| 20:14 | Sync this branch with the latest trunk. check-in: 7a44fa5a user: dan tags: wal2 | |
| 12:34 | Version 3.26.0 check-in: bf8c1b2b user: drh tags: trunk, release, version-3.26.0 | |
|
2018-11-30
| ||
| 20:59 | Fix a typo in a comment. No changes to code. check-in: 23684cb8 user: drh tags: trunk | |
| 18:22 | Merge the pre-3.26.0 fixes from trunk. check-in: 2c76ce4f user: drh tags: apple-osx | |
| 16:26 | Merge the mutex-free PRNG change into this branch. check-in: 81e626f4 user: dan tags: begin-concurrent-pnu | |
|
2018-11-29
| ||
| 12:00 | Fix the name of the trig function approximation in geopoly. No functional changes to the code. check-in: 33576b12 user: drh tags: trunk | |
|
2018-11-28
| ||
| 19:23 | Fix a typo in a comment used to generate documentation. No changes to code. check-in: 62360cea user: drh tags: trunk | |
| 19:12 | Update incrvacuum.test so that it works with builds that do not support mmap(). check-in: 8eb62fd5 user: dan tags: trunk | |
| 11:49 | Update some test cases to account for SQLITE_OMIT_VIRTUAL_TABLE builds. check-in: b53a9a3d user: dan tags: trunk | |
| 11:09 | Follow-up to [0bf0fd242b93c3bd30]: only reset the pager when adding a new codec, not when overwriting an existing codec. Also, improve a comment in the pcache1 subsystem. check-in: 5c040fdb user: drh tags: trunk | |
| 08:24 | Changes to Makefile.in to allow testfixture to be built with SQLITE_USER_AUTHENTICATION. check-in: 7b510f59 user: dan tags: trunk | |
| 08:09 | Remove -DSQLITE_USER_AUTHENTICATION from the "Unlock-Notify" configuration. Create a dedicated "User-Auth" configuration for testing this feature. check-in: 8c41024f user: dan tags: trunk | |
| 08:02 | Fixes for SQLITE_OMIT_VIRTUAL_TABLE builds. check-in: 9bcdec85 user: dan tags: trunk | |
| 01:45 | Always enable SQLITE_ENABLE_DESERIALIZE for the MSVC makefile as this is necessary to get releasetest.tcl to work. check-in: d362dedb user: drh tags: trunk | |
|
2018-11-27
| ||
| 19:47 | Fix a failing assert() in sqlite3ResetAllSchemasOfConnection(). check-in: 0ea049f3 user: dan tags: trunk | |
| 17:02 | Improvements to two cases in pragma4.test. check-in: 3c893d9b user: drh tags: trunk | |
| 14:41 | Remove the sqlite3PagerUseWal() routine which was made obsolete by the [81629ba91475938b6ad] change. check-in: 4331b499 user: drh tags: trunk | |
| 14:34 | Add a simple test case for Lemon. Always include assert.h in the Lemon-generated parser. check-in: 9c9c46dc user: drh tags: trunk | |
| 14:03 | Fix to the error handling logic in the Lemon parser template. This does not affect SQLite since SQLite does not use that part of the Lemon parser template. check-in: c6dfc59e user: drh tags: trunk | |
| 09:57 | Add an "#ifndef SQLITE_DISABLE_FTS4_DEFERRED" block around function fts3EvalDeferredPhrase() in fts3 in order to silence a compiler warning. check-in: 6f4b0d04 user: dan tags: trunk | |
|
2018-11-26
| ||
| 23:35 | Merge recent enhancements from trunk. check-in: e8c20a88 user: drh tags: apple-osx | |
| 18:09 | Do not allow direct access to internal-use SQL functions such as sqlite_rename_column() and sqlite3_rename_table() except when the new SQLITE_TESTCTRL_INTERNAL_FUNCTIONS flag is set. check-in: 6e133054 user: drh tags: trunk | |
| 15:00 | Minor comment enhancement in alter.c. No changes to code. check-in: 12920bcb user: drh tags: trunk | |
| 07:34 | Merge latest begin-concurrent changes into this branch. check-in: 76608f75 user: dan tags: begin-concurrent-pnu | |
| 07:21 | Merge latest trunk changes into this branch. check-in: 28a615a2 user: dan tags: begin-concurrent | |
|
2018-11-24
| ||
| 20:44 | Fix a bug in the geopoly_ccw() function. Test cases in TH3. check-in: 773c5c1d user: drh tags: trunk | |
| 17:46 | Make the winTruncate() method of the windows VFS be a no-op if there are outstanding references to the memory-mapped pages. Otherwise, memory might be deleted out from under those references when the file is remapped during the truncate operation. check-in: ffce4aac user: drh tags: trunk | |
| 16:07 | Remove the unused mmapSizeActual field from the Windows sqlite3_file implementation. check-in: 0e7aa622 user: drh tags: trunk | |
|
2018-11-22
| ||
| 19:10 | Fix a problem reading from temp databases in SQLITE_DIRECT_OVERFLOW_READ builds. check-in: 81629ba9 user: dan tags: trunk | |
|
2018-11-21
| ||
| 14:27 | Improvements to the ossfuzz.c fuzz-testing module so that it works with -DSQLITE_OMIT_PROGRESS_CALLBACK and with -DSQLITE_OMIT_INIT. check-in: d343f7d6 user: drh tags: trunk | |
|
2018-11-20
| ||
| 18:09 | Fix problems in pragma.c causing some PRAGMA statements to test the wrong schema-cookie before proceeding, or to try to open cursors on the wrong database ("PRAGMA foreign_key_check" only). check-in: 6982f52f user: dan tags: trunk | |
| 16:02 | Consolidate the two sqlite3SchemaToIndex() routines. Leaf check-in: dfab7170 user: dan tags: reuse-schema1 | |
|
2018-11-19
| ||
| 20:41 | Fix a problem with virtual tables in shared schemas. check-in: 84be9220 user: dan tags: reuse-schema1 | |
|
2018-11-17
| ||
| 19:15 | Fix another name resolution problem occurring when two or more attached databases use the same Schema object. check-in: 5328f899 user: dan tags: reuse-schema1 | |
| 18:45 | Merge latest trunk changes into this branch. check-in: 9fdd1868 user: dan tags: reuse-schema1 | |
| 18:11 | Fix further problems with the feature on this branch. check-in: 6d7a7e5f user: dan tags: reuse-schema1 | |
| 14:59 | Fix the regexp used to recognize libdl errors on OS-X. check-in: 17400253 user: drh tags: trunk | |
| 14:26 | Fix harmless compiler warnings that appear with SQLITE_OMIT_EXPLAIN. check-in: 5fff00b0 user: drh tags: trunk | |
| 14:19 | Remove a C++-style comment. check-in: 645232f2 user: drh tags: trunk | |
| 13:08 | Fix a problem in test script e_fkey.test. check-in: acfd0a05 user: dan tags: trunk | |
|
2018-11-16
| ||
| 20:50 | Fix a test case so that it works on windows. check-in: 2d92d25f user: drh tags: trunk | |
| 20:18 | Add SQLITE_CONSTRAINT support to the xBestIndex methods on dbstat, sqlite_dbpage, and zipfile. check-in: 5cd24e55 user: drh tags: trunk | |
| 19:19 | Update the explain virtual table to make use of SQLITE_CONSTRAINT. check-in: b2d41ff7 user: drh tags: trunk | |
| 17:04 | Fix further REUSE_SCHEMA issues. check-in: 9780829a user: dan tags: reuse-schema1 | |
| 16:04 | Fix the JSON table-valued functions to make use of SQLITE_CONSTRAINT. check-in: 3f34f4f5 user: drh tags: trunk | |
| 15:41 | Add an assert() to the generate_series virtual table to verify assumptions about the design. check-in: cd13b499 user: drh tags: trunk | |
| 15:08 | Update the generate_series() table-valued function to make use of the new SQLITE_CONSTRAINT return from xBestIndex. check-in: 4372ad64 user: drh tags: trunk | |
| 14:36 | In order to avoid exporting a symbol, use a macro instead of a function to replace sqlite3_complete() in the shell code when SQLITE_OMIT_COMPLETE is defined. check-in: d584a0cb user: dan tags: trunk | |
| 13:56 | Enhance the xBestIndex interface of virtual table so that if the xBestIndex method returns SQLITE_CONSTRAINT then that particular combination of constraints is considered unusable and does not participate further in query planning. check-in: 684013ce user: drh tags: trunk | |
| 13:06 | Fix comments and make magic numbers into #defines in the fsdir implementation. check-in: c537c9c3 user: drh tags: trunk | |
| 08:36 | Fix a problem with virtual table "fsdir" and some join queries. check-in: 7fffcee0 user: dan tags: trunk | |
| 01:42 | Improvements to the CSV virtual table. check-in: 0406ecbb user: drh tags: trunk | |
|
2018-11-15
| ||
| 21:20 | Fix some problems with the feature on this branch. Many problems remain. check-in: 31b6aee7 user: dan tags: reuse-schema1 | |
| 19:12 | Fix typos in the previous check-in. check-in: 9b37bbf5 user: mistachkin tags: trunk | |
| 16:56 | Include geopoly in the compiler-warning script. check-in: 3d947e1e user: drh tags: trunk | |
| 13:51 | New fuzztest cases. check-in: e8316ba4 user: drh tags: trunk | |
|
2018-11-13
| ||
| 20:21 | Fix a potential buffer overread in the dbstat virtual table when processing a corrupt database file. check-in: a62e6b59 user: drh tags: trunk | |
| 19:51 | Turn on ASAN for the dbfuzz2 utility. Fix a buffer overread associated with sqlite3_deserialize(). check-in: 4e38f27b user: drh tags: trunk | |
|
2018-11-12
| ||
| 15:20 | New hyperlinks in comments used to generate documentation. No changes to code. check-in: f9755f81 user: drh tags: trunk | |
| 13:20 | Fix a use-after-free problem in the fts5vocab virtual table. check-in: ac69d169 user: dan tags: trunk | |
|
2018-11-10
| ||
| 20:07 | Merge the read-only shadow table and defensive mode enhancments from trunk. check-in: 977fc44e user: drh tags: apple-osx | |
| 18:23 | Add support for read-only shadow tables on virtual tables. Added the SQLITE_DEFAULT_DEFENSIVE compile-time option that can put SQLite in defensive mode by default. check-in: 9c685171 user: drh tags: trunk | |
| 17:37 | Add the "changesetfuzz" program. For fuzzing changeset blobs. check-in: 2bae0e7c user: dan tags: trunk | |
| 17:36 | Merge latest trunk changes. Closed-Leaf check-in: b6d549c9 user: dan tags: changesetfuzz | |
| 04:14 | Remove a NEVER() that is reachable after all. Reverts checkin [9292d3351c40339]. Closed-Leaf check-in: c5dc7fb8 user: drh tags: read-only-shadow | |
| 03:47 | Merge fixes from trunk. check-in: bf88efce user: drh tags: read-only-shadow | |
|
2018-11-09
| ||
| 23:45 | Merge fixes from trunk. check-in: e3e9b85e user: drh tags: apple-osx | |
| 23:41 | Fix invalid use of unprotected sqlite3_value objects in the sqldiff utility, when using the --changeset option. check-in: a8d65214 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: ae9638e9 user: dan tags: trunk | |
| 18:44 | Merge latest trunk changes with this branch. check-in: ae88f8e1 user: dan tags: reuse-schema | |
| 14:17 | Fix for ticket [787fa716be3a7f650cac] check-in: 531eca61 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: 8d663bfa 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: 8c74065f user: drh tags: trunk | |
|
2018-11-07
| ||
| 14:39 | Fix a problem with the handling of SQLITE_FCNTL_PRAGMA in the test_onefile.c demo. check-in: 13e21b7d user: dan tags: trunk | |
| 11:56 | Partially revert [3e1a2f661], as some test scripts require separate $presql and $dbconfig variables. check-in: cbf85284 user: dan tags: trunk | |
|
2018-11-05
| ||
| 19:37 | Add the SQLITE_DBCONFIG_DEFENSIVE flag. check-in: 11d98414 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: b8d35c4a user: drh tags: trunk | |
| 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: af39661e user: drh tags: trunk | |
|
2018-11-03
| ||
| 17:31 | Correct the internal logic for SQLITE_DBCONFIG_DEFENSIVE. Closed-Leaf check-in: 76094345 user: drh tags: dbconfig-defensive | |
| 16:51 | Add extra defenses against strategically corrupt databases to fts3/4. check-in: d44318f5 user: dan tags: trunk | |
| 16:09 | Add the SQLITE_DBCONFIG_DEFENSIVE flag. check-in: af3f29d4 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: dcb8c735 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: 1fa74930 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: 4a6ad519 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: 790ea39a user: drh tags: trunk | |
| 18:24 | Tweaks to the test_intarray documentation and tests. check-in: 7107f0da user: drh tags: trunk | |
| 01:12 | Merge fuzz test cases computed by dbfuzz2. check-in: e0d30c18 user: drh tags: trunk | |
| 01:04 | Improved corrupt database detection in the relocatePage() routine of the b-tree module. check-in: d5787333 user: drh tags: trunk | |
|
2018-10-30
| ||
| 23:45 | Add new fuzzer cases generated by dbfuzz2. Closed-Leaf check-in: 79fdad8b 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: bf93f7b5 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: 4f987810 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: 90b2a684 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: 3cc01a0e user: drh tags: trunk | |
| 14:36 | In the CLI, when opening a file that begins with the normal SQLite prefix, open the file as a normal database even if it has a ZIP for AppendVFS record at the end. check-in: 7989bbda user: drh tags: trunk | |
| 13:19 | Enable sqlite3_deserialize() in the CLI. The --deserialize option associated with opening a new database cause the database file to be read into memory and accessed using the sqlite3_deserialize() API. This simplifies running tests on a database without risk of modifying the file on disk. check-in: 5e0129ee user: drh tags: trunk | |
|
2018-10-29
| ||
| 21:01 | Fix a potential assertion fault that can occur while trying to DROP a table from a corrupted database file. check-in: 147a9429 user: drh tags: trunk | |
| 18:33 | Fix minor memory leak in the dbstat extension that can occur following an attempt to analyze a corrupt database file. check-in: cb874fd8 user: drh tags: trunk | |
| 17:53 | Add the sqlite3_normalized_sql() API. Closed-Leaf check-in: 592b66e8 user: mistachkin tags: normalized_sql | |
| 17:08 | In the sessions module, avoid collecting rebase data if the user has not requested it. check-in: de72a773 user: dan tags: trunk | |
| 16:07 | Harden the dbstat extension against corrupt database files. check-in: a0d47f25 user: drh tags: trunk | |
|
2018-10-27
| ||
| 21:06 | Improvements to the dbfuzz2.c test module. check-in: d60eff49 user: drh tags: trunk | |
| 16:02 | Add an entry in Makefile.in to build dbfuzz2 using clang-6.0 with -fsanitize=fuzzer,undefined. check-in: a4a083ed user: drh tags: trunk | |
| 00:47 | Initial code for a fuzzing tool on database file that works with the -fsanitize=fuzzer option of clang. check-in: 90d12094 user: drh tags: trunk | |
|
2018-10-26
| ||
| 17:05 | Add the sqlite3session_config() interface. For configuring global parameters belonging to the sessions module. check-in: 1e69f3ff user: dan tags: trunk | |
| 15:36 | Prevent an == constraint specified using the table-valued-function argument syntax from being used to optimize any scan not related to the virtual table for which it was specified as an argument. check-in: 4d46685f user: dan tags: trunk | |
|
2018-10-25
| ||
| 14:15 | In the WHERE-constraint propagation optimization, if there are duplicate constraint, make sure only one of them propagates. Proposed fix for ticket [cf5ed20fc8621b165]. check-in: 5d5b596f user: drh tags: trunk | |
|
2018-10-24
| ||
| 23:55 | Add the ENABLE_GEOPOLY case to the compile_options pragma. check-in: de940296 user: drh tags: trunk | |
|
2018-10-23
| ||
| 13:48 | Fix a problem with using window functions in compound (UNION, INTERSECT etc.) queries. check-in: 059ff53a user: dan tags: trunk | |
|
2018-10-20
| ||
| 13:48 | Add the sqlite3changeset_start_v2() - a new version of _start() that accepts a flags parameter - and a streaming equivalent to the sessions module. Also add the SQLITE_CHANGESETSTART_INVERT flag, used with start_v2() to invert a changeset while iterating through it. check-in: cbedcb9a user: dan tags: trunk | |
|
2018-10-18
| ||
| 15:17 | Take steps to avoid a potential integer overflow in sessionBufferGrow(). check-in: f7affa2e user: dan tags: trunk | |
| 14:59 | Add the SQLITE_CHANGESETAPPLY_INVERT flag to sessions. For inverting and applying a changeset in a single step. check-in: d4b6406e user: dan tags: trunk | |
|
2018-10-12
| ||
| 15:01 | Test case modifications to support SEE. check-in: 02b6f8f2 user: drh tags: trunk | |
|
2018-10-11
| ||
| 18:41 | Add the textkey and textrekey pragmas. check-in: f03164d4 user: drh tags: trunk | |
| 16:53 | Fix harmless compiler warnings in the CLI. check-in: 1916d291 user: drh tags: trunk | |
| 16:38 | Always reset the pager before changing the codec. check-in: 0bf0fd24 user: drh tags: trunk | |
| 13:51 | On the first connection to a WAL-mode database that was not cleanly shut down and contains a left-over -shm file, truncate the -shm file to 3 bytes instead of to 0 bytes. Avoiding a truncation to 0 means that system monitoring tools can better detect if a process illegitimately tries to truncate a -shm file. Such a rogue process might think it is being helpful by cleaning up old files, but there is a race condition that can cause damage to the database. check-in: 90cf32cd user: drh tags: trunk | |
| 10:37 | In the CLI, fix a file descriptor leak following OOM and a missing va_end() call. check-in: ec36d15a user: drh tags: trunk | |
| 02:39 | In the unix VFS, fix the heap shm allocator (used for unix-excl) so that it works even on systems where the page size is larger than 32KB. check-in: 7fbb083c user: drh tags: trunk | |
|
2018-10-10
| ||
| 18:56 | In the CLI, allow the SQLITE_HISTORY environment variable, if it exists, to specify an alternative file in which to store the shell edit history. check-in: 696e82f7 user: drh tags: trunk | |
|
2018-10-08
| ||
| 20:04 | Fix an issue with the new memstat.c extension. check-in: ce6e80b1 user: drh tags: trunk | |
| 18:55 | Replace the new geopoly_reverse() function with geopoly_ccw(). The geopoly_ccw() function only reverses the vertex order if doing so is necessary to get the correct right-hand winding rule on the polygon. check-in: 07506694 user: drh tags: trunk | |
| 12:58 | Add the geopoly_reverse() function to the GeoPoly extension. check-in: 690dd18a user: drh tags: trunk | |
|
2018-10-06
| ||
| 14:38 | Fix the ".help -all" option in the command-line shell. check-in: aac8f1df user: drh tags: trunk | |
| 13:46 | Add test cases and assert() statements to ensure that the authorizer is being called as expected from within ALTER TABLE. check-in: ff10d2c7 user: dan tags: trunk | |
|
2018-10-05
| ||
| 15:10 | Changes to geopoly to silience false-positive warnings coming out of clang. check-in: 11d9015f user: drh tags: trunk | |
|
2018-10-03
| ||
| 18:05 | Add an ALWAYS on an unreachable branch in the ALTER TABLE logic. check-in: ebcd4523 user: drh tags: trunk | |
| 11:13 | Change a type in shell.c.in from "int" to "sqlite3_int64" in order to avoid a compiler warning and possible integer overflow. check-in: bf0a6634 user: dan tags: trunk | |
|
2018-10-02
| ||
| 20:16 | Add an additional assert() verifying mutex invariants on the unixShmSystemLock() routine in the unix VFS. check-in: cb151106 user: drh tags: trunk | |
| 19:58 | Additional field name changes and commit fixes associated with shared-memory locking in the unix VFS, to improve maintainability. No logic changes. check-in: 9280774a user: drh tags: trunk | |
| 19:36 | Fix comments and refactor some names associated with shared-memory locking in the Unix VFS. No logical changes. check-in: 3e9f1635 user: drh tags: trunk | |
|
2018-10-01
| ||
| 21:41 | Add the "PRAGMA table_xinfo" command that works like table_info but also shows hidden columns in virtual tables and adds the "hidden" boolean column. check-in: defa0515 user: drh tags: trunk | |
| 21:36 | Test case for PRAGMA table_xinfo. Closed-Leaf check-in: 7694b9bc user: drh tags: pragma-table-vinfo | |
| 21:26 | Change the name of the pragma to PRAGMA table_xinfo. Improve the mkpragmatab.tcl script to reuse column names where appropriate. check-in: 2fdd0689 user: drh tags: pragma-table-vinfo | |
| 18:28 | Add the extra "hidden" column to the end of the PRAGMA table_vinfo output. check-in: cf1b7613 user: drh tags: pragma-table-vinfo | |
| 17:33 | Speed up xAccess() calls made on an RBU VFS when there are lots of open connections. check-in: 310b4b65 user: dan tags: trunk | |
| 17:15 | Bring the PRAGMA table_vinfo statement up to date with trunk. check-in: 6f606f99 user: drh tags: pragma-table-vinfo | |
| 13:54 | Fix a potential crash that can occur while reading an index from a corrupt database file. The corruption is a record-header-size that is larger than 0x7fffffff. Problem detected by OSSFuzz against GDAL and reported to us (with a suggested fix) by Even Rouault. The test case is in TH3. check-in: 8ac2cdda user: drh tags: trunk | |
| 07:04 | Fix a problem with ALTER TABLE commands when the schema features an INSTEAD of trigger that uses NEW.* or OLD.*. check-in: c52f457e user: dan tags: trunk | |
|
2018-09-29
| ||
| 19:38 | Add the PRAGMA table_vinfo command (with an extra "v" before "info") that works like PRAGMA table_info (without the "v") except that it also shows hidden columns on virtual tables. check-in: 8bcd1a59 user: drh tags: pragma-table-vinfo | |
|
2018-09-28
| ||
| 23:53 | Fix test cases so that they work with ICU. check-in: d04b2013 user: drh tags: trunk | |
| 20:46 | Have sqlite3changegroup_output_strm() call its output function more regularly. check-in: 8467c31a user: dan tags: trunk | |
| 18:51 | Fix a bug in the sqlite_memstat virtual table that was causing it to report the amount of memory used as zero bytes. check-in: 8a758a87 user: drh tags: trunk | |
| 14:01 | Add the geopoly_regular(X,Y,R,N) function to the geopoly extension. check-in: 4505bbae user: drh tags: trunk | |
| 13:18 | Make most geopoly functions pure. check-in: 944e167a user: drh tags: trunk | |
| 00:16 | Rig geopoly to use sqlite3AtoF() if it is available, as that routine is much faster than atof(). check-in: 470c6c07 user: drh tags: trunk | |
|
2018-09-27
| ||
| 23:57 | Small performance optimization in the JSON parser of Geopoly. check-in: fb520e71 user: drh tags: trunk | |
| 20:37 | Enhance the GeoPOLY extension so that it always stores its polygons in the binary format, which is faster and more compact. check-in: dc35f7b1 user: drh tags: trunk | |
| 20:20 | Ensure that the OP_VColumn opcode does set sqlite3_vtab_nochange() unless the OPFLAG_NOCHNG bit is set in P5. Fix for ticket [69d642332d25aa3b7315a6d385] check-in: 322ab1fc user: drh tags: trunk | |
| 17:33 | Another minor tweak to memstat.c so that it may be built against older versions of SQLite. check-in: 4c1fed60 user: dan tags: trunk | |
| 17:15 | Modify the memstat virtual table so that it works with SQLite version 3.9.2. check-in: 7171d8ae user: drh tags: trunk | |
| 17:03 | Add the sqlite_memstat extension - an eponymous virtual table that shows memory usages statistics for SQLite. check-in: 954ef61f user: drh tags: trunk | |
| 16:57 | Enhancements to sqlite_memstat: (1) Add an extra "schema" column to show the schema name for ZIPVFS stats. (2) Only show ZIPVFS stats to schema that use ZIPVFS (3) Put a NULL in unused columns of the output. Closed-Leaf check-in: 9351135b user: drh tags: memstat-vtab | |
| 15:45 | Add initial ZIPVFS support for the "main" database to the sqlite_memstat virtual table. check-in: 9cd27350 user: drh tags: memstat-vtab | |
| 15:21 | Initial prototype of a eponymous virtual table that accesses sqlite3_status64() and sqlite3_db_status(). check-in: 0b44e1f6 user: drh tags: memstat-vtab | |
| 12:14 | Disallow the use of window functions in the recursive part of a recursive CTE. Fix for ticket [e8275b415a2f03bee]. check-in: 7fc29944 user: dan tags: trunk | |
| 00:04 | Minor simplification: In OP_ParseSchema, read the p1 register once. check-in: bd250533 user: mistachkin tags: trunk | |
|
2018-09-26
| ||
| 18:02 | Further improvements to the ".help" command in the CLI. check-in: edc3d18e user: drh tags: trunk | |
| 16:53 | Begin revamping the ".help" command in the command-line shell so that it can accept an argument and will do a search for commands that match that argument. check-in: 209afb8d user: drh tags: trunk | |
| 16:05 | Tweak spellfix.c so that if SQLITE_SPELLFIX_5BYTE_MAPPINGS is defined at compile time the Transliteration structure has space for 5 byte (instead of 4 byte) mappings. check-in: cbaf5b6c user: dan tags: trunk | |
| 03:43 | Fix typos in the header comment for the sha1 and sha3 hash extensions in the ext/misc folder. check-in: 4ed9d83a user: drh tags: trunk | |
|
2018-09-25
| ||
| 13:51 | Fix a problem in releasetest.tcl causing configuration "Fast-One" to fail. check-in: 42e04fef user: dan tags: trunk | |
|
2018-09-24
| ||
| 15:39 | Slightly smaller and faster alternative to [507d892c3a40a0bacbd47] that fixes a problem with views that use window function as part of complex expressions. check-in: d7c816ae user: drh tags: trunk | |
| 14:51 | Fix a problem with views that use window functions as part of complex expressions. check-in: 507d892c user: dan tags: trunk | |
| 14:10 | Allow a writable virtual table to have a schema with an INTEGER PRIMARY KEY and WITHOUT ROWID. This fixes ticket [f25d5ceebe1d710ff61a571e395356869d8272ef]. Test case in TH3. check-in: 5a38d928 user: drh tags: trunk | |
| 12:37 | Use compile-time options SQLITE_QUERY_PLANNER_LIMIT and SQLITE_QUERY_PLANNER_LIMIT_INCR to control the value for WhereLoopBuilder.iPlanLimit, rather than embedding magic numbers in the code. check-in: 903e5018 user: drh tags: trunk | |
| 10:47 | Increase the initial value of WhereLoopBuilder.iPlanLimit to 20K. Issue a warning if the iPlanLimit reaches zero. check-in: 3dd35f51 user: drh tags: trunk | |
|
2018-09-23
| ||
| 02:01 | Fix a faulty assert() in the validation logic for the LEFT JOIN strength reduction optimization. Problem found by OSSFuzz. check-in: 2fd62fcc user: drh tags: trunk | |
|
2018-09-22
| ||
| 15:05 | Enhance WhereLoopBuilder.iPlanLimit to handle a case involving the OR optimization discovered overnight by OSSFuzz. check-in: 7b59930a user: drh tags: trunk | |
|
2018-09-21
| ||
| 23:41 | Fix harmless compiler warning when compiled with SQLITE_OMIT_AUTHORIZATION. check-in: 50f2fa19 user: mistachkin tags: trunk | |
| 19:06 | Comment typo fixed. No code changes. check-in: 7e68cdab user: drh tags: trunk | |
| 18:43 | Put a limit counter on the query planner that restricts the number of index+constraint options that can be considered for each table in a join. This prevents certain pathological queries from taking up too much time in the query planner. check-in: 8690b5a0 user: drh tags: trunk | |
| 13:07 | Optimization to the OP_MakeRecord opcode makes speed-check.sh run about 1.1 million cycles faster, and results in a slightly smaller library. check-in: d10e6362 user: drh tags: trunk | |
|
2018-09-20
| ||
| 20:43 | Minor code simplification. check-in: 22ae8a52 user: drh tags: trunk | |