Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins occurring around df1d6482f9e92daf.
|
2021-01-01
| ||
| 21:02 | Faster and smaller test to ensure that the sqlite_schema.sql field is always a CREATE statement of some kind. (check-in: 76de2bb04b user: drh tags: trunk) | |
| 20:04 | Change the unions of the Table.addColOffset field from characters to bytes. This makes the query that implements ALTER TABLE ADD COLUMN more complex and slightly slower, but also makes CREATE TABLE statement parsing faster by avoiding a call to sqlite3UtfCharLen(). Since, CREATE TABLE parsing is far more common than ALTER TABLE, this is a net win for performance. (check-in: 6f25f2529f user: drh tags: trunk) | |
| 19:17 | Use the column name hash to improve performance of column name collision detection while parsing CREATE TABLE statements. (check-in: d02820f035 user: drh tags: trunk) | |
| 18:32 | Modify the makefile rule for "startup" so that it always builds with -Os and -DSQLITE_THREADSAFE=0 and no other options, for consistency of performance. (check-in: 5ac939e0ad user: drh tags: trunk) | |
| 18:23 | Size reduction and performance increase in sqlite3Prepare(). (check-in: 41f45c8e89 user: drh tags: trunk) | |
| 17:01 | Small size reduction and performance improvement in sqlite3VdbeMakeReady() by linking the new prepared statement into the prepared statement list sooner rather than later. (check-in: 2996e800a0 user: drh tags: trunk) | |
| 16:43 | Streamline processing of the authenticator callback for the common case when there is no callback. (check-in: d3196685d9 user: drh tags: trunk) | |
| 15:13 | Add the "startup" test program designed to measure startup performance, and in particular schema parsing time. (check-in: 7b3b31efb0 user: drh tags: trunk) | |
| 01:44 | Do not attempt to take a pointer to the ceil() and floor() functions as those routines are intrinsics on some versions of MSVC. (check-in: e5d7209e11 user: drh tags: trunk) | |
|
2020-12-30
| ||
| 13:20 | New test case for the HAVING fix of check-in [f62f983b56623f0e]. (check-in: 45f46317ab user: drh tags: trunk) | |
| 13:10 | New test cases for cursor renumbering in the UNION ALL query flattener. (check-in: 270babf259 user: drh tags: trunk) | |
|
2020-12-29
| ||
| 16:48 | Add an ALWAYS on an always-true conditional in the cursor renumbering logic of the UNION ALL flattener. Edit: turns out this change is incorrect and the conditional is reachable after all. See the nearby trunk check-in for test cases. (Closed-Leaf check-in: 5774318e73 user: drh tags: mistake) | |
| 15:06 | Do not set the P3 parameter on OP_RowCell when copying an index btree, as P3 is not used in that case. (check-in: eef070a4aa user: drh tags: trunk) | |
|
2020-12-28
| ||
| 21:42 | Fix missing comma in ctime.c that would cause the ENABLE_MATH_FUNCTIONS output rw to merge with whatever row followed. Problem reported in forum post aacac97680. (check-in: 328bc4a01d user: drh tags: trunk) | |
|
2020-12-23
| ||
| 16:46 | Add the sqlite3session_memory_used() API to the sessions module. For querying the amount of heap memory currently being used by a session object. (check-in: 823f75c2e4 user: dan tags: trunk) | |
|
2020-12-22
| ||
| 20:35 | Fix SQLITE_OMIT_WINDOWFUNC builds by moving declaration of sqlite3ExpandSubquery out of "ifndef SQLITE_OMIT_WINDOWFUNC" block. (check-in: 9587fa8b29 user: dan tags: trunk) | |
| 19:57 | Fix a couple spelling typos in comments. (check-in: 907ddf8676 user: mistachkin tags: trunk) | |
| 16:23 | Fix a problem handling sub-queries with both a correlated WHERE clause and a "HAVING 0" clause where the parent query is itself an aggregate. The problem was apparently introduced by check-in [6e6b3729e0549de0] (check-in: f62f983b56 user: dan tags: trunk) | |
| 14:54 | Simplification to the aggregate-function analysis error detection logic at the end of sqlite3Select(). (check-in: 82884438e3 user: drh tags: trunk) | |
|
2020-12-21
| ||
| 19:50 | Fix problems with joining UNION ALL sub-queries against other sub-queries that contain LEFT JOIN. (check-in: d554f710a5 user: dan tags: trunk) | |
| 18:39 | Fix a problem when flattening joins between a UNION ALL sub-query and another sub-query that uses more than one window function. (check-in: ef9733fe1c user: dan tags: trunk) | |
| 14:51 | Enhance documentation to show that "ro" is the correct way to say "readonly" in the mode= query parameter. (check-in: 788b96851d user: drh tags: trunk) | |
| 12:14 | Add the --timer option to fuzzcheck. Get the --timeout option working in fuzzcheck when running dbsql tests. (check-in: 3b0c9b41a8 user: drh tags: trunk) | |
|
2020-12-20
| ||
| 14:51 | Always declare the sqlite3WhereTrace variable, even for non-debug builds. (check-in: 88d93ee380 user: drh tags: trunk) | |
|
2020-12-19
| ||
| 15:39 | Fix a broken assert() in fts5 that could be triggered by corrupt database records. (check-in: b79f59f9ad user: dan tags: trunk) | |
| 13:58 | Allow UNION ALL sub-queries to be flattened even if the parent query is a join. (check-in: df1d6482f9 user: drh tags: trunk) | |
|
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: 63c5cfb9ae 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: c510377b0b user: dan tags: union-all-flattener) | |
|
2020-12-17
| ||
| 17:17 | Fix a part of the header comment for flattenSubquery(). (check-in: dc0937ce9d user: dan tags: union-all-flattener) | |
| 16:48 | Add test cases and minor fixes to this branch. (check-in: 5d6dc29d5f user: dan tags: union-all-flattener) | |
| 15:17 | In the CLI, add the ".filectrl data_version" command. And put the various ".filectrl" subcommands in alphabetical order. (check-in: 3434452148 user: drh tags: trunk) | |
| 11:30 | Merge latest trunk changes into this branch. (check-in: 9f41f60405 user: dan tags: reuse-schema) | |
| 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: 2a6cd6833e 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: 85952e7117 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: 00e4bf74d3 user: dan tags: union-all-flattener) | |
| 14:20 | Remove an unnecessary and incorrect #ifdef. Fix harmless compiler warnings. (check-in: 31cd1bbfa5 user: drh tags: trunk) | |
| 13:20 | Fix a typo in the sqlite3_free_filename() documentation. (check-in: 7316ee19c5 user: drh tags: branch-3.34) | |
| 13:17 | Fix a typo in the sqlite3_free_filename() documentation. (check-in: 48301edc90 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: 4e2dd2a533 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: 94f81b5117 user: dan tags: trunk) | |
| 13:55 | Change an fts5 assert() that can be triggered by a corrupt database to an if() condition. (check-in: ea0a7f103a user: dan tags: trunk) | |
|
2020-12-14
| ||
| 16:50 | Merge the latest trunk enhancements into the begin-concurrent-pnu branch. (check-in: daf0465021 user: drh tags: begin-concurrent-pnu) | |
| 16:26 | Merge recent trunk enhancements into the begin-concurrent branch. (check-in: a1708e8457 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: 6b01a24daa user: drh tags: trunk) | |
| 15:25 | Fix an integer overflow problem in new VACUUM code. (check-in: 59b4367fd8 user: dan tags: trunk) | |
| 13:52 | Minor changes for test coverage. (Closed-Leaf check-in: e5a8fa50f4 user: drh tags: generalized-upsert) | |
|
2020-12-12
| ||
| 00:43 | More test cases. No new problems discovered. (check-in: f34dd67e2d user: drh tags: generalized-upsert) | |
| 00:28 | New test cases with corresponding bug fixes. (check-in: f22c21a94c 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: aadd67ddf2 user: drh tags: generalized-upsert) | |
| 19:01 | Fix an assert() broken by recent changes to vacuum. (check-in: dd058da85c user: dan tags: trunk) | |