Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins occurring around e3794997c34f03db.
|
2021-07-29
| ||
| 18:34 | Enhance the wal.c source file with an ASCII-art schematic of the -shm file header. (check-in: a6c160e08a user: drh tags: trunk) | |
| 17:31 | Improvements to asserts to enforce magic numbers in the wal-index format. Also improve automatic configure and make builds on legacy PPC iBooks. (check-in: 87b8d47889 user: drh tags: trunk) | |
| 17:23 | Complete warning-free build on old PPC iBook. (Closed-Leaf check-in: ef2a085039 user: drh tags: wal-asserts) | |
| 17:01 | Fix an error in one of the assert() statements added by [23b08fe9db24a953]. (check-in: ad24334bc0 user: drh tags: wal-asserts) | |
| 16:49 | Minor tweaks to various TCL build scripts so that they work even for TCL 8.4, which is obsolete, but is also all that is available for some legacy platforms. (check-in: 2269ce64f7 user: drh tags: wal-asserts) | |
| 16:48 | Improve comments and add new assert() statements in WAL to help document how everything works. (check-in: 23b08fe9db user: drh tags: wal-asserts) | |
| 14:27 | Merge the latest enhancements from trunk. (Leaf check-in: 8498d7727c user: drh tags: win-blocking-locks) | |
| 00:33 | Remove ALWAYS() macros that can be true if the internal test function implies_nonnull_row() is used in the result set of a query and contains comparison operator against a computed column. dbsqlfuzz 4c34db5bff6247f33ee49e341a1f3018e72be0a0. (check-in: 4d1dbfa35c user: drh tags: trunk) | |
|
2021-07-28
| ||
| 18:13 | Add test case to ensure that sessions works with DELETE statements that use the truncate optimization (i.e. a DELETE without a WHERE clause). (check-in: a2fc531177 user: dan tags: trunk) | |
| 02:04 | Fix a harmless uninitialized variable read that occurs after an error associated with a subquery that uses DISTINCT. Found by a fuzzer. (check-in: e9719f975f user: drh tags: trunk) | |
| 01:22 | Reduce the scope of a variable in order to fix a harmless compiler warning that occurs under -DSQLITE_OMIT_AUTOMATIC_INDEX. (check-in: 36d5dbbe13 user: drh tags: trunk) | |
|
2021-07-26
| ||
| 19:49 | Remove sqldiff --visible-controls option, make it always happen. Add test cases for controls made visible (check-in: ff74c0cc4c user: larrybr tags: trunk) | |
| 18:28 | Give sqldiff --visible-controls option to deal with non-graphic text content robustly across platforms (check-in: 68d2373f5d user: larrybr tags: trunk) | |
| 01:35 | Manual merge of new .connection shell command (check-in: 0d41f7f93c user: larrybr tags: cli_extension) | |
|
2021-07-23
| ||
| 19:26 | Merge the ".connection" CLI enhancement from trunk. (check-in: d317d44fbb user: drh tags: win-blocking-locks) | |
| 18:43 | Enhance the CLI with the ".connection" command that can switch between up to five different database connections. Used for manual testing of multiple database connections in the same process. (check-in: 54eaf076c0 user: drh tags: trunk) | |
| 14:53 | Merge recent enhancements on trunk into the win-blocking-locks branch. (check-in: 9ecad2f8c6 user: drh tags: win-blocking-locks) | |
|
2021-07-22
| ||
| 21:11 | Set the checkSchema flag if a CREATE TABLE parse fails because the table already exists, to ensure that the table was not previously deleted by some other connection. (check-in: 91bcb96215 user: drh tags: trunk) | |
| 18:22 | Fix ALTER TABLE DROP COLUMN so that it generates valid bytecode even when operating on a corrupt database and using PRAGMA writable_schema=ON. dbsqlfuzz 5f09e7bcc78b4954d06bf9f2400d7715f48d1fef (check-in: b65f4f7639 user: drh tags: trunk) | |
| 16:07 | One of the optimizations of check-in [de9c86c9e4cdb34f] does not work for terms originating in the ON/USING clause, as demonstrated by forum post 6cf3bb457c3f4685. This check-in disables that optimization for ON/USING terms. Also improve the TreeView display for the resulting "true"/"false" nodes to show that they originate from the ON/USING clause. Add a testcase() to the other optimization to show that it can still be used for ON/USING terms. (check-in: 1f67960440 user: drh tags: trunk) | |
| 10:44 | Fix a problem in the new os_unix.c code. Refine the threadtest3 test case some. (Leaf check-in: 2039d447b7 user: dan tags: unix-timed-wait-exp) | |
|
2021-07-21
| ||
| 15:42 | Improved robustness of cursor renumbering in the UNION ALL flattener when operating on vector assignments of an UPDATE FROM. dbsqlfuzz 417d2b053b9b3c9edaf22dd515564f06999e029c (check-in: 60695359dc user: drh tags: trunk) | |
|
2021-07-20
| ||
| 21:02 | Add in-process blocking locks to os_win.c using a similar technique. (check-in: b67c157fd8 user: dan tags: unix-timed-wait-exp) | |
| 17:23 | Merge changes from the win-blocking-locks branch into this one. (check-in: 85fd18d7a2 user: dan tags: unix-timed-wait-exp) | |
| 16:07 | Run a "PRAGMA quick_check", if necessary, on the modified table after an ALTER TABLE ADD COLUMN to verify that added NOT NULL or CHECK constraints are satisfied by existing rows. Abort the ADD COLUMN if not. Forum post c04814903d6ec4f7. (check-in: e3794997c3 user: drh tags: trunk) | |
| 14:57 | Avoid a malfunction that could occur if the same correlated column reference appears in both the GROUP BY and the HAVING clause of a sub-select. dbsqlfuzz a779227f721a834df95f4f42d0c31550a1f8b8a2. (check-in: 1e35cc6d5c user: dan tags: trunk) | |
| 08:23 | Fix issues in the new ADD COLUMN constraint checking. Add preliminary test cases. (Closed-Leaf check-in: 48434ad3fa user: drh tags: add-column-constraint-check) | |
| 07:35 | Demonstration code to show how NOT NULL and CHECK constraints can be verified after an ALTER TABLE ADD COLUMN. (check-in: 039f540373 user: drh tags: add-column-constraint-check) | |
| 02:02 | It does not work to deserialized into TEMP, so do not allow it. The sqlite3_deserialize() routine now returns SQLITE_ERROR if you try. (check-in: 18068cc606 user: drh tags: trunk) | |
| 00:18 | Fix compilation of 'threadtest3' for some older versions of MSVC. (check-in: b5ede6a688 user: mistachkin tags: trunk) | |
|
2021-07-19
| ||
| 20:52 | More precision in comparing integers and floating point values while processing the integer primary key for OP_SeekGE and similar. Forum post 2bdb86a068. (check-in: f9c6426de3 user: drh tags: trunk) | |
| 20:34 | Revise the testthread3.walthread6 test case to better demonstrate the advantages of blocking locks. (check-in: 952b4cae49 user: dan tags: unix-timed-wait-exp) | |
| 17:06 | Merge trunk with this branch. (check-in: 853c621bb2 user: dan tags: unix-timed-wait-exp) | |
| 16:49 | Updates so that "threadtest3[.exe]" can be built for windows with MSVC. (check-in: 4ce585fb07 user: dan tags: trunk) | |
| 14:00 | In defensive mode, allow statements that write to shadow tables to be prepared from with virtual-table xSync() calls. (check-in: c8601d83fb user: dan tags: trunk) | |
| 03:38 | Fix minor spacing issues in the MSVC makefile. (check-in: d78c272b39 user: mistachkin tags: trunk) | |
| 03:37 | Minor enhancements to new OSTRACE messages. (check-in: 3249a6a38d user: mistachkin tags: win-blocking-locks) | |
|
2021-07-16
| ||
| 22:43 | Try to omit the ORDER BY clause in subqueries if doing so does not change the result in any way. See Forum post 2d76f2bcf65d256a for details and history. (check-in: 85ddaf1b59 user: drh tags: trunk) | |
| 20:16 | Minor comment improvements. (Closed-Leaf check-in: 6854b5919b user: drh tags: omit-subquery-order-by) | |
| 18:30 | Experiment with having SQLITE_ENABLE_SETLK_TIMEOUT builds on unix use a condition variable to wait for wal locks held by other threads. (check-in: 4a9f5ce79d user: dan tags: unix-timed-wait-exp) | |
| 17:11 | De-typo sqlite3_expanded_sql() doc (check-in: 56b0f5418d user: larrybr tags: trunk) | |
| 17:04 | Modify the generate_series() table-valued functions so that its first argument (the START value) is required. Throw an error if that argument is not supplied. In this was the series.c loadable extension can be used as a demonstration of how to code an xBestIndex function to require certain parameters. Compile with -DZERO_ARGUMENT_GENERATE_SERIES to obtain the legacy behavior. (check-in: 459d85a289 user: drh tags: trunk) | |
| 15:30 | Fix the "main.mk" makefile so that "series.c" is a dependency of "shell.c". (check-in: ff95991791 user: drh tags: trunk) | |
| 01:19 | Get the "omit ORDER BY in FROM-clause subqueries" optimization working for the core test cases. (check-in: e31c588865 user: drh tags: omit-subquery-order-by) | |
|
2021-07-15
| ||
| 23:34 | By default, do not emit #line directives in the amalgamation. (check-in: bacfa93677 user: mistachkin tags: trunk) | |
| 23:12 | Initial work on blocking locks for the Win32 VFS. Various other small enhancements. (check-in: 584c24252a user: mistachkin tags: win-blocking-locks) | |
| 19:29 | Attempt to omit ORDER BY clauses from FROM-clause subqueries if those ORDER BY clauses do not affect the output. See forum thread 2d76f2bcf65d256a for discussion. This can help the query flattener in some cases, resulting in faster query plans. The current implemention does not always work. (check-in: ef97c3e7c3 user: drh tags: omit-subquery-order-by) | |
| 16:39 | Change references to the schema table in sqlite3_analyzer to the new SQLITE_SCHEMA name. (check-in: 3beb77d6a7 user: drh tags: trunk) | |
|
2021-07-14
| ||
| 21:18 | Fix a use-after-free error in ioerr.test caused by an error in test code. (check-in: 1594056aab user: dan tags: trunk) | |
| 19:35 | Enhance the Windows VFS to recognize SQLITE_FCNTL_LOCK_TIMEOUT and make the value set there available to the winLockFile() function. (check-in: 954b5d6129 user: drh tags: win-blocking-locks) | |