Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around f766dff012af0ea3.
|
2022-04-29
| ||
| 17:45 | With TreeView, only show the table columns for a SrcItem if the data source is a subquery rather than a persistent table. (check-in: 7b4a0d0fa1 user: drh tags: trunk) | |
| 17:13 | Multiple enhancements to the TreeView output for SrcItem, cherrypicked from the right-join experimental branch. (check-in: 293afa8111 user: drh tags: trunk) | |
| 17:03 | Show the USING clause as part of the tree-view display of SrcItem. (check-in: 9cba3ce577 user: drh tags: right-join) | |
| 12:09 | Minor typo fix in a comment, for the benefit of broken IDE syntax highlighters. (check-in: 680ccecbc8 user: drh tags: trunk) | |
|
2022-04-28
| ||
| 18:33 | Fix problem with SQLITE_OMIT_VIRTUALTABLE builds. (check-in: a99ee612b9 user: dan tags: trunk) | |
| 18:17 | In treeview.c, show the columns of the table associated with each SrcItem. (check-in: 3aafccb5c3 user: drh tags: right-join) | |
| 17:35 | Tweaks to the name resolution on parenthesized joins. A small number of tests fail now due to extra columns appearing in the expansion of "*". (check-in: c86804917e user: drh tags: right-join) | |
| 12:52 | Merge trunk enhancements into the right-join branch. (check-in: 3fd9706bba user: drh tags: right-join) | |
|
2022-04-27
| ||
| 21:10 | The -DSQLITE_MXFILENAMESZ=N option for some non-negative integer value N prevents SQLite from ever creating a hole larger than N bytes in a named file for which a size hint has been issued. The exception code never runs, except for cases when the application deliberately corrupts the size hint. (Leaf check-in: 0c2da4ff64 user: drh tags: mkfileholesz) | |
| 18:38 | Fix a harmless typo in a comment. (check-in: e1f4a115df user: drh tags: trunk) | |
| 16:41 | When computing STAT1 values using ANALYZE, if a ratio comes out to be between 1.0 and 1.1, then round it down to 1 rather than the using the default rounding rule of changing it to 2. The reduces the estimation error for the case where a column value is very nearly, but not quite unique. (check-in: eb59c46a5a user: drh tags: trunk) | |
| 13:33 | Fix a test problem in rbubusy.test causing a crash under some circumstances. (check-in: bc5bbd9fa6 user: dan tags: trunk) | |
| 13:12 | Merge the version 3.38.3 fixes into the reuse-schema-3.8 subbranch. (check-in: 436d0a5837 user: drh tags: reuse-schema-3.38) | |
| 13:00 | Merge version 3.38.3 fixes onto the begin-concurrent-wal2-3.38 branch. (check-in: 5590f0a4e6 user: drh tags: begin-concurrent-wal2-3.38) | |
| 12:03 | Version 3.38.3 (check-in: 9547e2c38a user: drh tags: release, version-3.38.3, branch-3.38) | |
|
2022-04-26
| ||
| 20:58 | Modify utility function sqlite3SetString() so that it may be used safely on Parse.zErrMsg. Fuzzer test case "crash-1604e5d76c92574e21e437049dab9b672e06b767.txt". (check-in: b9c7d2c1bd user: drh tags: branch-3.38) | |
| 19:48 | Cherry-pick various minor fixes from trunk into branch-3.38. (check-in: fece097c70 user: drh tags: branch-3.38) | |
| 19:16 | Update corruptL.test so that it works with SQLITE_ENABLE_OVERSIZE_CELL_CHECK builds. (check-in: b1bec72043 user: dan tags: trunk) | |
|
2022-04-25
| ||
| 23:00 | Reverse the order of two tests to stop a harmless initialized value warning from MSAN - reported by OSSFuzz. (check-in: fb7e1a07a9 user: drh tags: branch-3.38) | |
| 21:31 | Fix a problem with using multiple SQLITE_SUBTYPE function as window functions in a single query. (check-in: 9caca6cb3e user: drh tags: branch-3.38) | |
| 21:22 | Increase the version number to 3.38.3. (check-in: b113afa224 user: drh tags: branch-3.38) | |
| 21:21 | Fix a problem with automatic indexes introduced by check-in [664b461bb5063d980] and reported by forum post 0d3200f4f3bcd3a3. (check-in: 4fbb9ffe72 user: drh tags: branch-3.38) | |
| 20:56 | Fix a problem with automatic indexes introduced by check-in [664b461bb5063d980] and reported by forum post 0d3200f4f3bcd3a3. (check-in: 134cfb18ff user: drh tags: trunk) | |
| 20:47 | Do not allow the push-down optimization on the right table of a RIGHT JOIN. (Closed-Leaf check-in: 05917bfa02 user: drh tags: autoindex-fix) | |
| 20:38 | The pushDownWhereTerms() routine should be using sqlite3ExprIsTableConstraint(), not sqlite3ExprIsTableConstant(). This fixes many problems, but still an error persists in join7.test. (check-in: 10bf0e6138 user: drh tags: autoindex-fix) | |
| 19:40 | Failed first attempt to fix a problem with automatic indexes introduced by check-in [664b461bb5063d980] and reported by forum post 0d3200f4f3bcd3a3. I thought that I had tested this prior to check-in and that it worked. But after checking it in, I find that there are many test failures. (check-in: 7ca3456c00 user: drh tags: autoindex-fix) | |
| 14:59 | Add a new optimizer disabling bit to disable just the UNION ALL branch of the query flattener. (check-in: c0f9ebab54 user: drh tags: trunk) | |
| 14:49 | Avoid unintended side-effects on Parse.nSelect in the sqlite3ViewGetColumnNames() routine. (check-in: 59789fe1e7 user: drh tags: trunk) | |
| 10:43 | Remove NEVER() on branches formerly thought to unreachable (see check-in [71272caff5874137]) in order to fix the first bug reported by forum post 28821db852. (check-in: bd6811d811 user: drh tags: trunk) | |
|
2022-04-24
| ||
| 20:00 | Get CLI conformed to revised doc for it, and take recent fixes. (check-in: 60e85c7e71 user: larrybr tags: cli_extension) | |
|
2022-04-23
| ||
| 19:26 | Merge enhancements and fixes from trunk into the right-join branch. (check-in: 2fb165cf8b user: drh tags: right-join) | |
| 19:21 | Prevent the ORDER BY LIMIT optimization from running if the innermost loop is a right-join, as doing so will get an incorrect answer. (check-in: 3aefc874d3 user: drh tags: trunk) | |
| 18:46 | In debug builds, add extra code to verify that there are no jumps that try to escape from the right-join body subroutine. (check-in: 45fe919266 user: drh tags: trunk) | |
| 18:34 | Fix false-positives in sqlite3VdbeNoJumpsOutsideSubrtn(). All tests pass now. (Closed-Leaf check-in: 1300d978d5 user: drh tags: right-join-subrtn-check) | |
| 18:04 | For debug builds, if the RIGHT JOIN body subroutine contains a jump that escapes the subroutine, then abort the prepared statement with a descriptive error and SQLITE_INTERNAL. This extra sanity check causes many tests to fail. (check-in: 2c5bb2bff2 user: drh tags: right-join-subrtn-check) | |
| 14:30 | Fix an operator typo - This indicates that the branch needs further investigation and verification. (check-in: f6ab67965b user: drh tags: right-join) | |
| 07:31 | Correctly resolve left and right USING columns of an outer join in a parenthesized subjoin. (check-in: ea91aba88c user: drh tags: right-join) | |
| 07:29 | Fix minor problems with the new join table name resolution logic. (Closed-Leaf check-in: 3a6b0db451 user: drh tags: right-join-colnames) | |
|
2022-04-22
| ||
| 23:18 | Add the ability to access the USING columns of the right or left tables of an OUTER JOIN even if the OUTER JOIN is in parentheses. Prototype code only. (check-in: c3a427575f user: drh tags: right-join-colnames) | |
| 19:52 | Merge the latest enhancements and fixes from trunk onto the right-join branch. (check-in: 7f8983345d user: drh tags: right-join) | |
| 18:07 | Make use of the "%!S" format when running ExplainSubquery. (check-in: 9425d79cb4 user: drh tags: trunk) | |
| 17:36 | Improve EXPLAIN QUERY PLAN output and comments on bytecode listings by distinguishing between "subquery" and "join" and using consistent names across EQP and bytecode. (check-in: a2d3ee9242 user: drh tags: trunk) | |
| 16:15 | Honor the MATERIALIZED keyword on a common table expression by not flattening the CTE into an outer query. (check-in: 8d631a6b9e user: drh tags: trunk) | |
| 15:18 | Add test cases to check the handling of SQLITE_BUSY in rbu. (check-in: 6fccc733c6 user: dan tags: trunk) | |
| 13:34 | Simplification of data structures in the wildcard expander for SF_NestedFrom queries. (check-in: f7c1826234 user: drh tags: trunk) | |
| 12:46 | Minor simplification to the result-set wildcard expander for SF_NestedFrom. (check-in: d942530a65 user: drh tags: right-join) | |
| 09:57 | Merge the latest trunk fixes into the right-join branch. (check-in: c74dc574c3 user: drh tags: right-join) | |
|
2022-04-21
| ||
| 23:34 | Previous fix to join8.test needs a return. (check-in: 7b4cd705a0 user: drh tags: trunk) | |
| 23:01 | Disable join8.test if the build lacks support for virtual tables. (check-in: 94e1916a2f user: drh tags: trunk) | |
| 19:38 | Add support for RIGHT and FULL JOIN. (check-in: f766dff012 user: drh tags: trunk) | |
| 19:25 | Fix harmless compiler warnings. (check-in: 2925566412 user: drh tags: right-join) | |
| 19:20 | Fix a harmless uninitialized variable warning in MSVC. (check-in: b870d2a2fa user: drh tags: trunk) | |
| 19:14 | Fix harmless compiler warnings in the CLI. (check-in: dfd2100bc4 user: drh tags: trunk) | |
| 14:48 | Make sure the code generator knows to invoke row-value subroutines which running the right-join post-processing loop. (check-in: fd328e52ae user: drh tags: right-join) | |
| 14:08 | Ensure correct fg.isNestedFrom values even on crazy parses. (check-in: e611e8e62c user: drh tags: right-join) | |
| 13:11 | Avoid materializing columns of SF_NestedFrom subqueries that are never used. Other code improvements manually imported from the right-join-paren branch. (check-in: cd8272fc2a user: drh tags: right-join) | |
| 12:11 | Further attempts to get name resolution to work correctly with parenthisized FROM clauses. Work-in-progress. Lots of crashes and wrong answers. (Closed-Leaf check-in: 6b326b3bcf user: drh tags: right-join-paren) | |
| 01:49 | Attempting to improve name resolution for parenthesized FROM clauses. Only partially working. (check-in: 959b718214 user: drh tags: right-join-paren) | |
|
2022-04-20
| ||
| 22:41 | For CLI, fix how columnar mode fills in empty portions of wrapped row outputs. (check-in: 77aed89192 user: larrybr tags: trunk) | |
| 21:58 | Try to avoid materializing unused columns when processing a parenthesized FROM clause. (check-in: 07906e3c4f user: drh tags: right-join-paren) | |
| 18:12 | Small correction to the new bUsed logic of sqlite3ProcessJoin(). (check-in: ba04142e09 user: drh tags: right-join) | |
| 16:54 | Merge window function fix from trunk. (check-in: b6b9e185f8 user: drh tags: right-join) | |
| 16:53 | Remove an unnecessary assignment operation. (check-in: ed46527aca user: drh tags: right-join) | |
| 16:42 | Fix a problem with using multiple SQLITE_SUBTYPE function as window functions in a single query. (check-in: 9430ead7ba user: dan tags: trunk) | |
| 16:26 | Comment fixes and improvements in sqlite3ProcessJoin(). (check-in: 1118655f4d user: drh tags: right-join) | |
| 15:07 | Improved tracking of nested SELECT objects used to implement parenthensized FROM terms. (check-in: 0da2232624 user: drh tags: right-join) | |
| 12:15 | Also show the ENAME_SPAN value in sqlite3TreeViewExprList(), if there is one. (check-in: c1d4286177 user: drh tags: right-join) | |
| 12:14 | Improved TreeView output for ExprList: Show the ENAME_TAB value, if there is one. (check-in: eb3f883b45 user: drh tags: right-join) | |
| 12:02 | Add a new comment to the body of lookupName(). No code changes. (check-in: 22fa9b9b45 user: drh tags: right-join) | |
|
2022-04-19
| ||
| 23:00 | Merge the ALTER TABLE fix from trunk. (check-in: d5ceaef3fc user: drh tags: right-join) | |
| 20:47 | Fix a problem in ALTER TABLE with handling "table.*" expressions within SELECT statements in triggers. (check-in: 24755fd065 user: dan tags: trunk) | |
| 19:51 | Improved comment on the JF_LTORJ constant definition. (check-in: e0744da95f user: drh tags: right-join) | |
| 18:23 | Fix a NULL-pointer dereference that can occur on an aggregate query that uses FULL JOIN. dbsqlfuzz 496a35dd4eefcd7935aaaeb0c69056bf49785d28. (check-in: 63b8f8aec2 user: drh tags: right-join) | |
| 15:56 | Mark an unreachable "just-in-case" branch as unreachable. (check-in: b966d52437 user: drh tags: right-join) | |
| 15:01 | Add 512 new join test cases derived from PostgreSQL output. (check-in: 78d58e461f user: drh tags: right-join) | |
| 09:39 | Remove unnecessary cases for the resolver. (check-in: 5bc9aa68e2 user: drh tags: right-join) | |
| 02:03 | Add the omitted "finish_test" to the end of joinA.test. (check-in: 0907505cc9 user: drh tags: right-join) | |
| 00:24 | New test cases for RIGHT and FULL JOIN. (check-in: 5c2f670e0f user: drh tags: right-join) | |
|
2022-04-18
| ||
| 23:20 | Fix the query flattener so that it does not flatten a RIGHT or FULL JOIN into any position of the outer query other than the first. (check-in: 837322aa95 user: drh tags: right-join) | |
| 22:51 | New test cases, including one that gets a different result than Postgres. (check-in: 49ea11a4a5 user: drh tags: right-join) | |
| 19:48 | Disable the unused EU4_EXPR mode for the IdList object. (check-in: 5bcf4aa3bf user: drh tags: right-join) | |
| 19:34 | Even more test cases. (check-in: 5f4310a104 user: drh tags: right-join) | |
| 19:28 | New test cases for parenthesized NATURAL FULL JOINs. (check-in: e34250efd3 user: drh tags: right-join) | |
| 18:01 | New test case demonstrating the ability to invoke OP_NullRow on a cursor that has never been opened. (check-in: d173edc242 user: drh tags: right-join) | |
| 16:23 | Merge the btree bug-fix from trunk. (check-in: a333c0b50c user: drh tags: right-join) | |
| 16:20 | Ensure that left-hand side WITHOUT ROWID tables are set to OP_NullRow prior to running the right-join loop. This fixes a problem introduced by the previous check-in. (check-in: aab7665ce6 user: drh tags: right-join) | |
| 16:10 | Fix problems with WHERE clauses that follow multiple FULL JOINs. This introduces some new faults in the tests, probably due to something unrelated. (check-in: 95b242d4c2 user: drh tags: right-join) | |
| 15:56 | Avoid an assert() failure in allocateSpace() triggered by a corrupt database. dbsqlfuzz f022eb0ce64d27808574d1dcde5cf7d002dabde8. (check-in: 2de7f8cc7f user: dan tags: trunk) | |
| 14:41 | Merge the latest fixes from trunk. (check-in: 1ba3b3ccf1 user: drh tags: right-join) | |
| 14:15 | Improved comment field in the bytecode generated for OP_Column and OP_Rowid. (check-in: 1b2c5cef95 user: drh tags: trunk) | |
| 13:57 | Improved comment field in the bytecode generated for OP_Column and OP_Rowid. (check-in: 009bbf8026 user: drh tags: right-join) | |
| 13:08 | New RIGHT JOIN test cases, one of which is currently failing. (check-in: 9168cbbedd user: drh tags: right-join) | |
| 11:22 | Change the row-value initialization subroutine call from within the right-join body subroutine from an issue to an optimization opportunity. (check-in: 829d49f27c user: drh tags: right-join) | |
| 10:26 | Do not allow an empty table bypass to jump outside of a right-join body subroutine. (check-in: 1549dcd235 user: drh tags: right-join) | |
| 10:09 | Fix the sqlite3SrcListAppendList() routine so that it correctly adds the JT_LTORJ attribute to the first SrcItem, if needed. (check-in: 07ed0dca31 user: drh tags: right-join) | |
| 09:59 | Leave sqlite3ProcessJoin() early if an OOM is encountered in the NATURAL to USING converter. This avoids NULL pointer dereferences further along in the code. (check-in: 0ccb224e13 user: drh tags: right-join) | |
| 00:57 | Fix to the coalesce() function generation in the resolver. (check-in: 584bd55e20 user: drh tags: right-join) | |
| 00:04 | When converting a NATURAL JOIN into a JOIN USING, make sure to insert the name correctly into the IdList even if it is a wierd quoted name. (check-in: e62156b696 user: drh tags: right-join) | |
|
2022-04-17
| ||
| 23:46 | Fix to the logic that computes coalesc() functions to resolve USING terms. (check-in: 20388548d8 user: drh tags: right-join) | |
| 22:58 | Deal with OP_Return bypass in the RIGHT JOIN subroutine by adding extra OP_Returns where needed. (check-in: 71abe5641f user: drh tags: right-join) | |