Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 descendants and 50 ancestors of 06177f3f114b5d80
|
2018-12-10
| ||
| 01:48 | Add support for the VACUUM INTO command. (check-in: 77f150b8b4 user: drh tags: trunk) | |
| 00:41 | Fix the shell1.test test for the new format of the .backup command. (Closed-Leaf check-in: 9748d7995b user: drh tags: vacuum-into) | |
| 00:40 | Merge fixes from trunk. (check-in: ab1e58fac9 user: drh tags: vacuum-into) | |
|
2018-12-09
| ||
| 18:55 | New test case for ticket [1d958d90596593a77420e59]. (check-in: b7bf3c9832 user: drh tags: trunk) | |
|
2018-12-08
| ||
| 20:30 | Do not use a partial index as a table scan in an IN operator. Fix for ticket [1d958d90596593a77420e59]. (check-in: 15bc915dd7 user: drh tags: trunk) | |
| 01:09 | Add the --async option to the ".backup" command in the CLI. (check-in: 7b6a605b18 user: drh tags: vacuum-into) | |
| 00:43 | Allow the INTO clause of VACUUM to be a text-valued expression. (check-in: af172b53b4 user: drh tags: vacuum-into) | |
|
2018-12-07
| ||
| 23:48 | Do not allow VACUUM INTO into a file that already exists. (check-in: 92f70e0fa3 user: drh tags: vacuum-into) | |
| 20:40 | Merge the VACUUM simplification from trunk. (check-in: 93d92a0a5d user: drh tags: vacuum-into) | |
| 20:26 | Remove a line of code from VACUUM that is no longer needed, due to the change that allows ATTACH to run within a transaction. (check-in: a92c398fc5 user: drh tags: trunk) | |
| 17:28 | Prototype implementation for the VACUUM INTO command. (check-in: 036e3320a4 user: drh tags: vacuum-into) | |
| 16:32 | Fix the sqlite3_normalized_sql() interface so that it renders double-quoted string literals as "?". (check-in: 0d8e150434 user: drh tags: trunk) | |
| 03:01 | Fix dbfuzz2.c so that it works with -DSQLITE_OMIT_INIT (check-in: 9ad796a882 user: drh tags: trunk) | |
| 01:56 | Fix the sqlite3ExprDup() function so that it correctly duplicates the Window object list on a Select that contains window functions. Fix for ticket [f09fcd17810f65f717]. (check-in: db5ed2268e user: drh tags: trunk) | |
|
2018-12-06
| ||
| 22:12 | Performance improvement: Avoid using sqlite3WalkerSelectExpr() and sqlite3WalkerSelectFrom() twice, so that the compiler will in-line their implementation. (Closed-Leaf check-in: 2b9258b8b0 user: drh tags: ticket-f09fcd17810f) | |
| 22:04 | Fix the sqlite3ExprDup() routine so that it makes complete duplications of subqueries containing window functions. (check-in: 940174543e user: drh tags: ticket-f09fcd17810f) | |
| 20:26 | Add the mutexfree-shmlock experiment to the begin-concurrent-pnu branch. (check-in: 3aead209b4 user: dan tags: begin-concurrent-pnu-mutexfree-shmlock) | |
| 20:18 | Experimental changes to (optionally) allow double-quoted strings to be checked against known identifiers. (Leaf check-in: 73a6b8c1b9 user: mistachkin tags: normalize_v4) | |
| 19:56 | New test case that still hits an assertion fault, just to prove that the previous checkin merely made the problem more obscure and did not completely fix it. (check-in: a9a3b53264 user: drh tags: ticket-f09fcd17810f) | |
| 19:15 | Simplify the query flattener so that it does not duplicate the WHERE clause of subquery that is being incorporated into the outer query - copies it directly. This is more efficient. And it also fixes the specific test case show for ticket [f09fcd17810f65f71789525] but it does not resolve the more general problem that sqlite3ExprDup() does not correctly duplicate expressions that contain subqueries with window functions. (check-in: f1b18d44ff user: drh tags: ticket-f09fcd17810f) | |
| 18:58 | Experiment with using an atomic CPU primitive instead of a mutex for intra-process locking with the unix-excl VFS. (check-in: 8f4cb9dd33 user: dan tags: mutexfree-shmlock) | |
| 17:06 | When masking bits off of sqlite3.flags, make sure the mask is 64 bits in size so as not to accidentally mask of high-order bits. (check-in: 53d3b169d8 user: drh tags: trunk) | |
| 16:50 | When saving off the value of sqlite3.flags, take care to preserve all 64 bits. (check-in: 9c6dbcfab5 user: drh tags: trunk) | |
| 16:11 | Issue a warning whenever a double-quoted string literal is used. (check-in: ac9ad50430 user: drh tags: trunk) | |
| 03:59 | Invoking the sqlite3_trace() or sqlite3_trace_v2() interfaces cancels any sqlite3_profile() that is running. (check-in: ec63d3506b user: drh tags: trunk) | |
| 03:13 | Merge fixes from trunk. (check-in: f2083ee410 user: drh tags: begin-concurrent-pnu) | |
| 02:08 | Merge bug fixes from trunk. (check-in: 1e13aaa29f user: drh tags: begin-concurrent) | |
| 02:01 | Remove the unused pColHash field from the Table object. (check-in: 3a2c047989 user: drh tags: trunk) | |
| 01:53 | Fix a potential NULL pointer dereference that can occur in ALTER TABLE following an OOM. Test case in TH3. (check-in: ea50815bf8 user: drh tags: trunk) | |
| 01:08 | Fix a missing mutex in the sqlite3_normalized_sql() interface when it is called on a prepared statement that did not previously have a computed normalization of the input SQL. (check-in: 1a1a59c6c5 user: drh tags: trunk) | |
| 00:08 | Merge ALTER TABLE and sqlite3_normalized_sql() bug fixes from trunk. (check-in: 3793e5d5d6 user: drh tags: begin-concurrent-pnu) | |
| 00:05 | Merge ALTER TABLE and sqlite3_normalized_sql() fixes from trunk. (check-in: acf10b3f8d user: drh tags: begin-concurrent) | |
|
2018-12-05
| ||
| 23:56 | Get rid of the hash table used to track IN operators in the sqlite3_normalized_sql() implementation. Use simple integer variables instead. (check-in: 272dc74fd0 user: drh tags: trunk) | |
| 23:45 | The sqlite3_normalized_sql() interface should not be transforming quoted identifier names into wildcards. Fix this, and at the same time simplify the code substantially. (check-in: e8540377ec user: drh tags: trunk) | |
| 23:25 | Bungled checkin. Ignore. (Closed-Leaf check-in: 9b6e9a6e45 user: drh tags: mistake) | |
| 21:55 | Fix an imbalanced lock problem in sqlite3Normalize() introduced by the simplification in [94ea6379178e3ff6a]. (check-in: f69624373e user: drh tags: trunk) | |
| 19:42 | Increase the version number to 3.27.0 for the next development cycle. (check-in: 8f8d682825 user: drh tags: trunk) | |
| 18:28 | Merge enhancements and the ALTER TABLE bug fix from trunk. (check-in: edfc2acfcd user: drh tags: apple-osx) | |
| 17:48 | Simplifications to the sqlite3_normalized_sql() implementation. (check-in: 94ea637917 user: drh tags: trunk) | |
| 13:49 | Merge enhancements from trunk, especially the sqlite3_normalized_sql() enhancement. (check-in: 342c9538d9 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: f44bc7a8b3 user: dan tags: trunk) | |
| 13:44 | Merge enhancements from trunk, especially the enhanced sqlite3_normalized_sql() interface. (check-in: 47b73f6bfe 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: 7da617e97e 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: 28643d837d user: mistachkin tags: execWithNormalize) | |
| 16:51 | Add the "index_usage" utility program. (check-in: df95455213 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: e28584e8bc user: drh tags: trunk) | |
| 13:51 | Small performance increase in sqlite3_step() for the common case where it returns SQLITE_ROW. (check-in: 8934482652 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: 6770ed0873 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: 70fe8ec2ae user: drh tags: trunk) | |
| 17:40 | Remove the unused sqlite3Fts5UnicodeNCat() function. (check-in: 7149dacf1d user: drh tags: trunk) | |
| 16:14 | Add the "remove_diacritics=2" option to the unicode61 tokenizer in both FTS5 and FTS3/4. (check-in: 06177f3f11 user: dan tags: trunk) | |
| 14:58 | Update the autoconf makefile for MSVC. (check-in: 675aba1f8b user: mistachkin tags: trunk) | |
| 01:58 | Remove two lines of unnecessary code, for a very small performance increase and size decrease. (check-in: 15824ccda0 user: drh tags: trunk) | |
| 01:47 | Fix a parser bug in the use of parentheses around table-valued functions. (check-in: 58a51123d1 user: drh tags: trunk) | |
|
2018-12-02
| ||
| 01:15 | Omit a line of code that has no affect on the outcome. (check-in: 5d933aa659 user: drh tags: trunk) | |
|
2018-12-01
| ||
| 21:13 | Very slightly smaller and faster. (check-in: 27798f17f5 user: drh tags: trunk) | |
| 12:34 | Version 3.26.0 (check-in: bf8c1b2b7a 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: 23684cb841 user: drh tags: trunk) | |
|
2018-11-29
| ||
| 12:00 | Fix the name of the trig function approximation in geopoly. No functional changes to the code. (check-in: 33576b12b4 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: 62360ceae9 user: drh tags: trunk) | |
| 19:12 | Update incrvacuum.test so that it works with builds that do not support mmap(). (check-in: 8eb62fd5fa user: dan tags: trunk) | |
| 11:49 | Update some test cases to account for SQLITE_OMIT_VIRTUAL_TABLE builds. (check-in: b53a9a3dc6 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: 5c040fdb01 user: drh tags: trunk) | |
| 08:24 | Changes to Makefile.in to allow testfixture to be built with SQLITE_USER_AUTHENTICATION. (check-in: 7b510f59fd 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: 8c41024fbb user: dan tags: trunk) | |
| 08:02 | Fixes for SQLITE_OMIT_VIRTUAL_TABLE builds. (check-in: 9bcdec85e2 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: d362dedba3 user: drh tags: trunk) | |
|
2018-11-27
| ||
| 19:47 | Fix a failing assert() in sqlite3ResetAllSchemasOfConnection(). (check-in: 0ea049f342 user: dan tags: trunk) | |
| 17:02 | Improvements to two cases in pragma4.test. (check-in: 3c893d9bcc user: drh tags: trunk) | |
| 14:41 | Remove the sqlite3PagerUseWal() routine which was made obsolete by the [81629ba91475938b6ad] change. (check-in: 4331b4990c user: drh tags: trunk) | |
| 14:34 | Add a simple test case for Lemon. Always include assert.h in the Lemon-generated parser. (check-in: 9c9c46dcbe 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: c6dfc59eb1 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: 6f4b0d0494 user: dan tags: trunk) | |
|
2018-11-26
| ||
| 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: 6e1330545e user: drh tags: trunk) | |
| 15:00 | Minor comment enhancement in alter.c. No changes to code. (check-in: 12920bcb99 user: drh tags: trunk) | |
|
2018-11-24
| ||
| 20:44 | Fix a bug in the geopoly_ccw() function. Test cases in TH3. (check-in: 773c5c1d9c 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: ffce4aac18 user: drh tags: trunk) | |
| 16:07 | Remove the unused mmapSizeActual field from the Windows sqlite3_file implementation. (check-in: 0e7aa62227 user: drh tags: trunk) | |
|
2018-11-23
| ||
| 13:21 | 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. (Leaf check-in: 8576ccb479 user: drh tags: branch-3.25) | |
|
2018-11-22
| ||
| 19:10 | Fix a problem reading from temp databases in SQLITE_DIRECT_OVERFLOW_READ builds. (check-in: 81629ba914 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: d343f7d6b0 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: 6982f52f57 user: dan tags: trunk) | |
|
2018-11-17
| ||
| 14:59 | Fix the regexp used to recognize libdl errors on OS-X. (check-in: 1740025307 user: drh tags: trunk) | |
| 14:26 | Fix harmless compiler warnings that appear with SQLITE_OMIT_EXPLAIN. (check-in: 5fff00b0d5 user: drh tags: trunk) | |
| 14:19 | Remove a C++-style comment. (check-in: 645232f2b9 user: drh tags: trunk) | |
| 13:08 | Fix a problem in test script e_fkey.test. (check-in: acfd0a05a8 user: dan tags: trunk) | |
|
2018-11-16
| ||
| 20:50 | Fix a test case so that it works on windows. (check-in: 2d92d25fae user: drh tags: trunk) | |
| 20:18 | Add SQLITE_CONSTRAINT support to the xBestIndex methods on dbstat, sqlite_dbpage, and zipfile. (check-in: 5cd24e552b user: drh tags: trunk) | |
| 19:19 | Update the explain virtual table to make use of SQLITE_CONSTRAINT. (check-in: b2d41ff702 user: drh tags: trunk) | |
| 16:04 | Fix the JSON table-valued functions to make use of SQLITE_CONSTRAINT. (check-in: 3f34f4f561 user: drh tags: trunk) | |
| 15:41 | Add an assert() to the generate_series virtual table to verify assumptions about the design. (check-in: cd13b499a2 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: 4372ad644d 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: d584a0cb51 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: 684013cef6 user: drh tags: trunk) | |
| 13:06 | Fix comments and make magic numbers into #defines in the fsdir implementation. (check-in: c537c9c363 user: drh tags: trunk) | |
| 08:36 | Fix a problem with virtual table "fsdir" and some join queries. (check-in: 7fffcee0fc user: dan tags: trunk) | |
| 01:42 | Improvements to the CSV virtual table. (check-in: 0406ecbbe7 user: drh tags: trunk) | |
|
2018-11-15
| ||
| 19:12 | Fix typos in the previous check-in. (check-in: 9b37bbf5f3 user: mistachkin tags: trunk) | |
| 16:56 | Include geopoly in the compiler-warning script. (check-in: 3d947e1ec0 user: drh tags: trunk) | |
| 13:51 | New fuzztest cases. (check-in: e8316ba47f 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: a62e6b593b user: drh tags: trunk) | |