Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 check-ins occurring around 9547e2c38a.
|
2022-05-12
| ||
| 11:01 | Fix the ".echo" command of the CLI so that it shows the results of input lines immediately, before invoking sqlite3_prepare(). (check-in: cf7fdabdba user: drh tags: trunk) | |
|
2022-05-11
| ||
| 20:29 | Zap stray --help output from intermediate version. (Closed-Leaf check-in: deb7372b18 user: larrybr tags: echo-sql) | |
| 19:59 | Change .echo on effect so that SQL is echoed before prepare. This slightly alters echoed output when multiple SQL statements are submitted at once. Also sync with trunk. (check-in: c1eff632c4 user: larrybr tags: echo-sql) | |
| 17:57 | The unix interface now resolves all symbolic links in filenames before actually using those filenames. (check-in: d55273e36e user: drh tags: trunk) | |
| 17:45 | Use osReadlink() in os_unix.c, not readlink() directly. (Closed-Leaf check-in: c3da4c1611 user: drh tags: resolve-symlinks) | |
| 16:46 | For the unix VFS, rewrite the xFullPathname method so that it automatically resolves all symbolic links, rendering a canonical pathname that contains no symlinks. (check-in: 40c9273d0e user: drh tags: resolve-symlinks) | |
| 03:42 | Fix .import leak in CLI and add shell leak testing to debug builds and the Tcl test suite. (check-in: df842ebc79 user: larrybr tags: trunk) | |
| 03:29 | Sync w/ trunk (Closed-Leaf check-in: 1284225b0a user: larrybr tags: import-leak-plug) | |
|
2022-05-10
| ||
| 23:28 | Fix a bug in the sqlite3WhereMalloc() routines that were added by chekc-in [f237e1d8cc41b937]. The bug was detected by dbsqlfuzz test case 4c5e3e89bc251d28378be88233f531b84ec66901. (check-in: 764b71267e user: drh tags: trunk) | |
| 22:32 | Make tester.tcl work on more Windows Tcl installations. And sync w/ trunk. (check-in: d25fbdf877 user: larrybr tags: import-leak-plug) | |
| 18:43 | New requirement marks. (check-in: e8479e56c6 user: drh tags: trunk) | |
| 18:18 | Fix a stale requirement mark. (check-in: fcda7fb1f1 user: drh tags: trunk) | |
| 17:42 | Fix a stale requirement mark. (check-in: 3eda4030f7 user: drh tags: echo-sql) | |
| 15:55 | Fix a harmless UBSAN warning. (check-in: 8f9355028b user: drh tags: trunk) | |
| 14:57 | Sync w/ trunk (check-in: b7285f92bb user: larrybr tags: echo-sql) | |
| 14:55 | For CLI, add ".echo sql" dot-command. (check-in: 35cef458ca user: larrybr tags: echo-sql) | |
| 13:06 | Merge all recent trunk changes into the reuse-schema branch. (check-in: 9f6d6e6135 user: drh tags: reuse-schema) | |
| 12:45 | Merge the latest trunk enhancements into theh begin-concurrent-pnu-wal2 branch. (check-in: d28af1f8a5 user: drh tags: begin-concurrent-pnu-wal2) | |
| 12:39 | Merge recent trunk enhancements into the wal2 branch. (check-in: 33d77fea40 user: drh tags: wal2) | |
| 12:24 | Merge the latest trunk enhancements into the begin-concurrent-report branch. Had to restore the sqlite3VdbeSerialPut() routine that was removed in check-in [6f4d6f212a3558c2] when it was inlined because that routine is used again in a different place by this branch. (check-in: e6b5224d71 user: drh tags: begin-concurrent-report) | |
| 12:00 | Merge recent trunk enhancements into the begin-concurrent branch. (check-in: f65bd76760 user: drh tags: begin-concurrent) | |
| 06:04 | Sync w/trunk (check-in: 536691ed0f user: larrybr tags: import-leak-plug) | |
| 01:11 | Cause most shell tests to be run under Tcl suite valgrind config. (check-in: cd085b36ff user: larrybr tags: import-leak-plug) | |
| 00:24 | Simplified "hidden" and "no-expand" handling in the *-expander. (check-in: c6c3115f3a user: drh tags: trunk) | |
|
2022-05-09
| ||
| 21:57 | Update this branch with latest changes from trunk, and the fts5 fix for "BEGIN CCONCURRENT" transactions. (check-in: c013544116 user: dan tags: begin-concurrent-report-wal2) | |
| 18:33 | Create new branch named "echo-sql" (check-in: 042f2935c9 user: larrybr tags: echo-sql) | |
| 17:55 | Minor STAT4 test case change due to the ANALYZE enhancement of [eb59c46a5aed69bc|check-in eb59c46a5aed69bc]. (check-in: 8ce2fecb58 user: drh tags: trunk) | |
| 16:29 | Add ALWAYS() on two unreachable branches in the * expander. (check-in: 387c852375 user: drh tags: trunk) | |
| 14:22 | Ensure that fts5 closes the read-only blob handle used to read the fts index at the end of each xUpdate operation. This doesn't matter for stock SQLite, as the handle will be closed in the subsequent xRollback or xSync call, but prevents "BEGIN CONCURRENT" transactions from being committed on this branch. (check-in: 093b60846c user: dan tags: begin-concurrent-pnu-wal2) | |
| 12:59 | Simplify a branch in the "*" expansion logic. New test case for an INSTEAD OF trigger on a RIGHT and FULL outer join. (check-in: d2717348f4 user: drh tags: trunk) | |
| 12:29 | Simplify .import leak plug and arrange for CLI to be run under valgrind. (check-in: 0d3e238019 user: larrybr tags: import-leak-plug) | |
|
2022-05-07
| ||
| 03:53 | Stop a memory leak in .import, and add leak complaint to CLI debug builds. (check-in: f5f09368b3 user: larrybr tags: import-leak-plug) | |
| 02:21 | Create new branch named "import-leak-plug" (check-in: 4a4cecab23 user: larrybr tags: import-leak-plug) | |
|
2022-05-06
| ||
| 22:29 | Perserve the requested reserved-bytes size for the database file when doing a VACUUM. (check-in: dac6d87c71 user: drh tags: trunk) | |
| 17:06 | Merge the 3.38.5 fix into the 3.38 subbranch of reuse-schema. (Leaf check-in: bfccca2ba3 user: drh tags: reuse-schema-3.38) | |
| 16:52 | Merge the 3.38.5 fix into the begin-concurrent-wal2 subbranch for 3.38. (Leaf check-in: 0586b3e963 user: drh tags: begin-concurrent-wal2-3.38) | |
| 15:25 | Version 3.38.5 (Leaf check-in: 78d9c993d4 user: drh tags: release, branch-3.38, version-3.38.5) | |
| 01:02 | Prevent an infinite loop on SQLITE_ERROR_RETRY when trying to modify a corrupt schema while PRAGMA writeable_schema=ON is active. dbsqlfuzz ded83609f475cc989c7339d45efb5151c1495501 (check-in: 7fcdb760a4 user: drh tags: branch-3.38) | |
| 00:43 | Prevent an infinite loop on SQLITE_ERROR_RETRY when trying to modify a corrupt schema while PRAGMA writeable_schema=ON is active. dbsqlfuzz ded83609f475cc989c7339d45efb5151c1495501 (check-in: 217b33234d user: drh tags: trunk) | |
|
2022-05-05
| ||
| 10:04 | Update the version number to 3.38.5 (check-in: bf73b57f70 user: drh tags: branch-3.38) | |
| 10:03 | Backout check-in [9fb20a21feb8f697] which was incorrect. (check-in: 66f65b322a user: drh tags: branch-3.38) | |
| 10:02 | Backout check-in [9fb20a21feb8f697] which was incorrect. (check-in: 99225618a8 user: drh tags: trunk) | |
| 03:49 | Cause CLI to use ExportHandler interface for its query output, and implement built-in subclasses of it, all in preparation for supporting implementations by shell extensions. (a WIP) (check-in: 9b37e0be1a user: larrybr tags: cli_extension) | |
|
2022-05-04
| ||
| 18:43 | Improvements for name resolution for parenthsized joins. (check-in: 006b2d9c52 user: drh tags: trunk) | |
| 17:43 | New test cases for RIGHT and FULL JOIN, focusing on cases that make use of Bloom filters, and a bug fix related to when ON-clause constraints are applied. (check-in: 67510354e6 user: drh tags: trunk) | |
| 17:30 | Code EP_InnerJoin constraints at the same time that EP_FromJoin constraints are coded. (Closed-Leaf check-in: b57033d2af user: drh tags: joinD) | |
| 16:46 | Merge version-3.38.4 into the reuse-schema-3.38 subbranch. (check-in: d5b0fd8434 user: drh tags: reuse-schema-3.38) | |
| 16:36 | Merge the version 3.38.4 fixes into the begin-concurrent-wal2-3.38 branch. (check-in: 8473718d19 user: drh tags: begin-concurrent-wal2-3.38) | |
| 15:45 | Version 3.38.4 (check-in: d402f49871 user: drh tags: release, version-3.38.4, branch-3.38) | |
| 14:46 | Merge ON-clause constraint usage fix from trunk into the joinD branch. (check-in: 0a20d4a859 user: drh tags: joinD) | |
| 14:45 | Fix ON-clause constraint usage for FULL and RIGHT JOINs. (check-in: 544268a723 user: drh tags: trunk) | |
| 11:49 | New test cases using various join types and Bloom filters. Two cases differ from PG and need to be resolved. (check-in: befa8cbc06 user: drh tags: joinD) | |
| 03:48 | Fix CLI use of wrong allocator for free(). (check-in: 4f83c442c9 user: larrybr tags: branch-3.38) | |
| 03:45 | Fix CLI use of wrong allocator for free(). (check-in: 9fb20a21fe user: larrybr tags: trunk) | |
| 02:01 | In the query planner, do not let tables commute across any outer join. (check-in: 8cee538823 user: drh tags: trunk) | |
|
2022-05-03
| ||
| 21:58 | Typos cleared from README.md (check-in: be3a1879c8 user: larrybr tags: trunk) | |
| 19:51 | Fix multi-byte column name rendition on .import and display of NULL in columnar modes. (check-in: f863aabe9d user: larrybr tags: branch-3.38) | |
| 16:26 | Merge Bloom filter bug fix from trunk into the right-join branch. (Closed-Leaf check-in: 72131ad1bd user: drh tags: right-join) | |
| 16:18 | Fix a typo in a comment. (check-in: c19c3c4869 user: drh tags: right-join) | |
| 14:26 | Increase the version number to 3.38.4. (check-in: def971a0e9 user: drh tags: branch-3.38) | |
| 14:25 | Fix the Bloom filter pull-down optimization so that it jumps to the correct place if it encounters a NULL key. Fix for the bug described by forum thread 2482b32700384a0f. (check-in: 3dc9fc2f2d user: drh tags: branch-3.38) | |
| 14:01 | Fix the Bloom filter pull-down optimization so that it jumps to the correct place if it encounters a NULL key. Fix for the bug described by forum thread 2482b32700384a0f. (check-in: 6eda9b1a77 user: drh tags: trunk) | |
| 12:11 | Add assert()s to show that jumps always land an an instruction that is between 1 and Vdbe.nOp-1. Had these assert()s been in place before, they would have caused an assertion fault for the byte-code error reported by forum post 2482b32700. (check-in: 8f8a58feb7 user: drh tags: trunk) | |
|
2022-05-02
| ||
| 20:49 | Organize the various flag bits of the ExprList_item object into a substructure so that the whole lot can be copied all at once. Faster and smaller code. (check-in: 5341d4bbe9 user: drh tags: right-join) | |
| 20:14 | Merge trunk fixes into the right-join branch. (check-in: e01f4c05c2 user: drh tags: right-join) | |
| 20:04 | Improved comments. (check-in: 158b80bed6 user: drh tags: right-join) | |
| 19:59 | Name resolution and "*" wildcard expansion for parenthesized FROM clauses seems to work the same as PG. The code is chaos, however, and needs some cleanup. (check-in: 6f9c0b07aa user: drh tags: right-join) | |
| 15:47 | Remove a testcase() macro taht was made obsolete by [a8da85c57e07721d]. (check-in: 053cf45eca user: drh tags: trunk) | |
| 15:31 | Document (in comments) that the SQLITE_FlttnUnionAll bit has a specific value needed by TH3. (check-in: bcaa4a4474 user: drh tags: trunk) | |
| 15:23 | Fix a harmless compiler warning in sqlite3TreeViewWinFunc() (a routine that does not even appear in release builds). (check-in: daff607003 user: drh tags: trunk) | |
| 15:10 | Merge the latest trunk fixes and enhancements into the right-join branch. (check-in: afbcf075c1 user: drh tags: right-join) | |
| 14:32 | Improvement on check-in [a193749730d6cfba] so that the subroutine call to the IN operator right-hand side generator from the RIGHT JOIN no-match logic does not generate unreachable byte code. (check-in: cc458317bd user: drh tags: trunk) | |
| 11:24 | Bring the comments on sqlite3FindInIndex() into closer alignment with what that routine actually does. (check-in: 40f3274745 user: drh tags: trunk) | |
|
2022-05-01
| ||
| 14:26 | Remove FILE* from shell extension interface. (check-in: 27ff5ce517 user: larrybr tags: cli_extension) | |
| 04:55 | Get sqlite3x.exe and extensions tested with MSVC build. (check-in: d2b16c29fc user: larrybr tags: cli_extension) | |
|
2022-04-30
| ||
| 19:55 | Defensive code in sqlite3TreeViewWindow() to fix a compiler warning. (check-in: b250c218b4 user: drh tags: trunk) | |
| 18:40 | Simplified fix to the problem with subroutine reuse in the RIGHT JOIN no-match logic for a subquery on the right-hand side of an IN operator. The code still needs simplification. (check-in: a193749730 user: drh tags: trunk) | |
| 17:22 | Fix another problem with subroutine reuse in the RIGHT JOIN no-match code for the subquery on the right-hand side of an IN operator. The current code works for all known cases, but seems unnecessarily complex and in need of simplification. Later: The fuzzer finds memory leaks with this version. (Closed-Leaf check-in: ad32da8045 user: drh tags: not-working) | |
| 12:55 | Preserve the COLLATE operator on an index on an expression when resolving the use of that expression into a reference to the index. See forum thread 7efabf4b03328e57 for details. (check-in: ef72f9e289 user: drh tags: branch-3.38) | |
| 12:35 | Preserve the COLLATE operator on an index on an expression when resolving the use of that expression into a reference to the index. See forum thread 7efabf4b03328e57 for details. (check-in: a8da85c57e user: drh tags: trunk) | |
| 00:06 | Further improvements to codeEqualityTerm() for cases when an IN operator with a right-hand side subquery is used as a constraint that needs to be processed by the RIGHT JOIN non-matched logic. (check-in: bb2798be3f user: drh tags: trunk) | |
| 00:05 | Enhance the TreeView debugging output for Expr with opcode TK_IN so as to show the RHS table and the subroutine address. (check-in: aec1e4cd59 user: drh tags: trunk) | |
|
2022-04-29
| ||
| 21:38 | For Tcl extension, get Tk option into MSVC build. (check-in: c3494fa757 user: larrybr tags: cli_extension) | |
| 19:00 | Enhance the codeEqualityTerm() routine inside the code generator so that it is able to reuse an IN operator that has an invariant subquery on its right-hand side while coding the non-matched loop of a RIGHT JOIN. dbsqlfuzz 19f1102a70cf966ab249de56d944fc20dbebcfcf (check-in: 56dd306546 user: drh tags: trunk) | |
| 18:36 | Get MSVC build going for sqlite3x.exe and extensions. And sync w/trunk. (check-in: cd5e57e0fe user: larrybr tags: cli_extension) | |
| 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) | |
| 21:03 | Get docs caught up with the .shxload change. (check-in: e21964480f user: larrybr tags: cli_extension) | |
| 20:30 | Change OP_Return such that if P3 is 1, the Return is a no-op when the P1 register contains a NULL. (check-in: c90602328a user: drh tags: right-join) | |
| 19:22 | Move shell extension load functionality into its own .shxload command for usage and code simplicity. (check-in: e2c8c88b4b user: larrybr tags: cli_extension) | |
| 18:46 | Further improvements to USING() processing for RIGHT and FULL JOINs. All currently known issues are now resolved. Performace is improved. (check-in: 9fd3f22e22 user: drh tags: right-join) | |
| 00:48 | For sqlite3x, rudimentary testing in place as make target shellxtest . More to come. (check-in: b73928befb user: larrybr tags: cli_extension) | |
|
2022-04-16
| ||
| 23:38 | New test cases, one of which is failing, indicating a bug that needs fixing. (check-in: bd5fd68435 user: drh tags: right-join) | |
| 22:57 | Fix the USING to ON translation so that it works correctly for a sequence of two or more joins where one of the joins to the right-hand side of the list is a RIGHT or FULL JOIN. (check-in: 9ffc2b2319 user: drh tags: right-join) | |
| 19:13 | Since the query planner is unable to cope with a LEFT JOIN on the left-hand side of a RIGHT JOIN, detect that situation early and raise a parsing error. This is a temporary measure that needs to be fixed. (check-in: 6d5d6e0403 user: drh tags: right-join) | |
| 18:33 | Additional SELECT trace logic: Show the tree after result-set wildcard expansion but before name resolution. (check-in: a7babf7541 user: drh tags: right-join) | |
| 17:53 | Make shell auto-column work with lots of columns when log() is missing. (check-in: 82366436ef user: larrybr tags: trunk) | |
| 15:46 | Fix a problem with "ON DELETE RESTRICT" and "ON UPDATE RESTRICT" foreign keys in attached databases scanning child tables in the wrong schema. (check-in: 04d5b637f0 user: dan tags: trunk) | |
| 13:55 | New test cases. One of the new test cases shows a flaw in the base design of RIGHT JOIN. (check-in: 4c3ce6475a user: drh tags: right-join) | |
| 12:40 | RIGHT JOIN USING now appears to work the same as PG-14. Legacy tests pass. (check-in: 5bfb862419 user: drh tags: right-join) | |
|
2022-04-15
| ||
| 21:21 | Get sqlite3x and extensions testing from Makefile setup, and some of wapptest changes done to run same. (a WIP) (check-in: d238fcf4be user: larrybr tags: cli_extension) | |
| 19:53 | Revamp the USING clause processing so that it works (mostly) with RIGHT and FULL JOIN. (check-in: 719c8d920b user: drh tags: right-join) | |