Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around 78d9c993d4.
|
2022-05-14
| ||
| 17:40 | Improved debugging comment generation for the OP_Column opcode. (check-in: 3e073bfddf user: drh tags: trunk) | |
| 15:59 | Improvements to the decision of when to check ON constraints for an inner join that is an operand to a RIGHT JOIN. Fix for issue identify by forum post c06b10ad7e. (check-in: 9d17233c7d user: drh tags: trunk) | |
|
2022-05-13
| ||
| 23:01 | Change an unreachable branch into an assert(). (check-in: 778e57a558 user: drh tags: trunk) | |
| 20:11 | Transitive equality constriants do not work on a RIGHT JOIN, since the right-hand side might be a non-matched row. (check-in: 0f96810b84 user: drh tags: trunk) | |
| 19:50 | Walk back the optimization from check-in [cc458317bd77046c] that tries to reuse the same ephemeral cursor of a list subquery when that subquery is reused, as it does not work in cases where the list subquery is used both for lookups and for scans. (check-in: 12ee29d632 user: drh tags: trunk) | |
| 17:45 | Defer generating WHERE clause constraints for a RIGHT JOIN until after the ON-clause processing for the RIGHT JOIN has done its own row elimination. This fixes and incorrect output from some RIGHT JOINs that was identified by forum post 41cc3851d864c5e6. (check-in: 238d9c247c user: drh tags: trunk) | |
| 16:38 | Redefine the acccess rules for the Expr.w union so that the Expr.w.iJoin member is accessible on either EP_OuterON or EP_InnerON. (check-in: 6f741d6cfb user: drh tags: trunk) | |
| 15:36 | Corrections to the header comment to the new joinE.test script. Add the generator TCL as a comment at the bottom of the script. (check-in: 2f4456f67f user: drh tags: trunk) | |
| 15:31 | New test cases for outer joins. Case joinE-32 currently gets an incorrect answer. See forum post 41cc3851d8 for the bug report. (check-in: 02b24863e6 user: drh tags: trunk) | |
| 14:52 | Improved names for flags on the Expr object: EP_FromJoin becames EP_OuterON and EP_InnerJoin becomes EP_InnerON. (check-in: 1ffea07ff9 user: drh tags: trunk) | |
|
2022-05-12
| ||
| 17:09 | Fix a harmless compiler warning in the CLI. (check-in: 7a2ac303d1 user: drh tags: trunk) | |
| 11:56 | Ensure that ON clauses are applied to the correct outer join. (check-in: c7e3a13a32 user: drh tags: trunk) | |
| 11:45 | Add IS NOT DISTINCT FROM and IS DISTINCT FROM binary operators which are equivalent to IS and IS NOT, respectively, for compatability with PostgreSQL and hence standard SQL. (check-in: db27611e17 user: drh tags: trunk) | |
| 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, version-3.38.5, branch-3.38) | |
| 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) | |