Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins using file src/shell.c.in version e9f674ee
|
2020-12-18
| ||
| 18:04 | Fix for the previous fix in the case where a UNION ALL sub-query is joined against some other compound query. (Closed-Leaf check-in: 63c5cfb9 user: dan tags: union-all-flattener) | |
| 16:13 | When flattening UNION ALL subqueries into a join query, ensure that separate cursor numbers are used for each segment of the newly flattened query. (check-in: c510377b user: dan tags: union-all-flattener) | |
|
2020-12-17
| ||
| 17:17 | Fix a part of the header comment for flattenSubquery(). (check-in: dc0937ce user: dan tags: union-all-flattener) | |
| 16:48 | Add test cases and minor fixes to this branch. (check-in: 5d6dc29d user: dan tags: union-all-flattener) | |
| 11:24 | Fix a problem with sqlite3_expanded_sql() that could occur with statements that use both numbered (e.g. "?1") and unnumbered (i.e. "?") parameters. (check-in: 2a6cd683 user: dan tags: trunk) | |
|
2020-12-16
| ||
| 21:09 | Enhance the sqlite3BtreeTransferRow() routine so that it does more careful checks for corrupt database pages. (check-in: 85952e71 user: drh tags: trunk) | |
| 20:00 | Allow sub-queries that use UNION ALL to be flattened, even if the parent query is a join. Still some problems on this branch. (check-in: 00e4bf74 user: dan tags: union-all-flattener) | |
| 14:20 | Remove an unnecessary and incorrect #ifdef. Fix harmless compiler warnings. (check-in: 31cd1bbf user: drh tags: trunk) | |
| 13:17 | Fix a typo in the sqlite3_free_filename() documentation. (check-in: 48301edc user: drh tags: trunk) | |
|
2020-12-15
| ||
| 19:27 | Fix another integer overflow triggered by a corrupt database in recently modified vacuum code. (check-in: 4e2dd2a5 user: dan tags: trunk) | |
| 16:28 | When the -statstep option is passed to the "rbu" executable, print out memory stats right before exiting, as well as every -statstep steps. (check-in: 94f81b51 user: dan tags: trunk) | |
| 13:55 | Change an fts5 assert() that can be triggered by a corrupt database to an if() condition. (check-in: ea0a7f10 user: dan tags: trunk) | |
|
2020-12-14
| ||
| 16:50 | Merge the latest trunk enhancements into the begin-concurrent-pnu branch. (check-in: daf04650 user: drh tags: begin-concurrent-pnu) | |
| 16:26 | Merge recent trunk enhancements into the begin-concurrent branch. (check-in: a1708e84 user: drh tags: begin-concurrent) | |
| 15:39 | Enhance UPSERT so that it allows multiple ON CONFLICT clauses and does not require a conflict target for DO UPDATE. (check-in: 6b01a24d user: drh tags: trunk) | |
| 15:25 | Fix an integer overflow problem in new VACUUM code. (check-in: 59b4367f user: dan tags: trunk) | |
| 13:52 | Minor changes for test coverage. (Closed-Leaf check-in: e5a8fa50 user: drh tags: generalized-upsert) | |
|
2020-12-12
| ||
| 00:43 | More test cases. No new problems discovered. (check-in: f34dd67e user: drh tags: generalized-upsert) | |
| 00:28 | New test cases with corresponding bug fixes. (check-in: f22c21a9 user: drh tags: generalized-upsert) | |
|
2020-12-11
| ||
| 19:36 | Begin adding test cases. Fix one bug found so far. More are pending. (check-in: aadd67dd user: drh tags: generalized-upsert) | |
| 19:01 | Fix an assert() broken by recent changes to vacuum. (check-in: dd058da8 user: dan tags: trunk) | |
| 17:11 | Small performance tweaks. (check-in: 5321d60c user: drh tags: generalized-upsert) | |
| 16:49 | Bug fixes so that legacy tests pass. New tests for new functionality have not yet been added. (check-in: aa76790e user: drh tags: generalized-upsert) | |
| 16:03 | Add an "#ifndef SQLITE_AMALGAMATION" block around the typedef for u64 in shathree.c. (check-in: b411f29e user: dan tags: trunk) | |
| 14:34 | Fix the configure script on the autoconf distribution so that the --disable-threadsafe option works. See FreeBSD bug 244459. (check-in: e64ff2cc user: drh tags: trunk) | |
| 14:22 | Fix the expert extension so that it handles generated columns correctly. (check-in: c2ae7ba6 user: dan tags: trunk) | |
| 01:17 | Logic is in place to handle multiple ON CONFLICT clauses, but it does not work. Any use of ON CONFLICT will likely lead to memory faults. This is an incremental check-in to save my place. (check-in: 15514231 user: drh tags: generalized-upsert) | |
|
2020-12-10
| ||
| 20:31 | Use an iterator for the index loop in sqlite3GenerateConstraintChecks(). The idea is that this iterator can be enhanced to traverse the indexes in any order, as required by multi-index UPSERT. (check-in: 64a4a91e user: drh tags: generalized-upsert) | |
| 19:54 | Remove a redundant branch added by [56a54258560]. (check-in: b4d6f6d7 user: dan tags: trunk) | |
| 19:51 | Changes to avoid loading large records into memory within VACUUM. (check-in: 56a54258 user: dan tags: trunk) | |
| 19:20 | Fix minor issues with new code on this branch. (Closed-Leaf check-in: f7fa76d0 user: dan tags: vacuum-lomem) | |
| 18:07 | Merge trunk changes into this branch. (check-in: 7337eed6 user: dan tags: vacuum-lomem) | |
| 18:06 | Better integrate the changes on this branch with OP_Insert and OP_IdxInsert. (check-in: 101cef14 user: dan tags: vacuum-lomem) | |
| 13:49 | Add an optional function to the chsumvfs extension. When activated by the SQLITE_CKSUMVFS_INIT_FUNCNAME macro, this function will invoke the file-control that sets the number of reserved bytes to 8. This can be used to initialize a cksumvfs database file by programming languages that do not have access to the sqlite3_file_control() interface. (check-in: 01841fb4 user: drh tags: trunk) | |
| 12:49 | The DO UPDATE code generator searches for the correct ON CONFLICT clause to use. (check-in: a47e35ee user: drh tags: generalized-upsert) | |
|
2020-12-09
| ||
| 23:35 | Fix compilation issues with MSVC related to C99. (check-in: c0de6c1f user: mistachkin tags: trunk) | |
| 20:33 | Transfer large index or WITHOUT ROWID records between b-trees when vacuuming without loading them into memory. (check-in: dfd4ca68 user: dan tags: vacuum-lomem) | |
| 20:30 | For upsert, the constraint check code generator uses a copy of the index list for the target table, which can potentially be reordered. (check-in: 3194c00c user: drh tags: generalized-upsert) | |
| 16:49 | Add tests for a 'delete' command on a contentless table where values that weren't actually inserted are NULL. (check-in: 818c647c user: dan tags: trunk) | |
| 16:32 | Avoid loading large intkey rows when VACUUMing, even if the page-size is changing. (check-in: 0d2c3776 user: dan tags: vacuum-lomem) | |
| 13:11 | Improved comments in sqliteInt.h. No changes to code. (check-in: 8ccb8d1d user: drh tags: generalized-upsert) | |
| 01:34 | Initialize all terms in the ON CONFLICT clause stack. (check-in: 5e683fd1 user: drh tags: generalized-upsert) | |
|
2020-12-08
| ||
| 20:19 | Experimental changes to vacuum to avoid loading large records entirely into memory. Currently only works in limited cases only - for rowid tables when the page-size does not change. (check-in: c90e063c user: dan tags: vacuum-lomem) | |
| 14:29 | Enhance UPSERT parsing to allow multiple ON CONFLICT clauses. Only the very last clause may omit the conflict target, but the conflict target may now be omitted for the DO UPDATE resolution. (check-in: 2ca62f4c user: drh tags: generalized-upsert) | |
|
2020-12-07
| ||
| 23:14 | Fix a bad assert() in math1Func(). (check-in: 4b286129 user: drh tags: trunk) | |
| 21:19 | Fix to the --disable-math option to ./configure. (check-in: 99ff6418 user: drh tags: trunk) | |
| 21:13 | Many more math functions. Semantics follows PG wherever possible. (check-in: 6b93627b user: drh tags: trunk) | |
| 17:15 | Begin adding new SQL functions that depend on -lm: ceil(), ceiling(), floor(), ln(), log(), and log10() so far. More to follow. (check-in: 4db5f2f7 user: drh tags: trunk) | |
|
2020-12-04
| ||
| 17:05 | Fix harmless compiler warnings associated with the recent FTS5 enhancements. (check-in: 1db7c751 user: drh tags: trunk) | |
| 16:58 | Fix a bug in the ".eqp" command of the shell that was introduced by the recent sqlite3SelectTrace/SQLITE_TESTCTRL_TRACEFLAGS changes. (check-in: fd02dffc user: drh tags: trunk) | |