Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
28 check-ins related to "lateral-join"
|
2024-10-25
| ||
| 16:20 | Merge the latest trunk enhancements into the lateral-join branch. (Leaf check-in: e7f27bbd user: drh tags: lateral-join) | |
| 15:28 | Update the compile-for-*.md documents. (check-in: c4da7fa2 user: drh tags: trunk) | |
|
2024-10-05
| ||
| 22:28 | Fix minor problem with error recovery after OOM in the parser. (check-in: aafab584 user: drh tags: lateral-join) | |
| 22:02 | Merge the Makefile fix from trunk. (check-in: 9403bbaa user: drh tags: lateral-join) | |
| 21:44 | Back out [2f7eab381e16] because the stderr output on systems without gmake causes grief in the testing tools. (check-in: cc6f3de0 user: stephan tags: trunk) | |
| 15:51 | Merge latest trunk changes into this branch. (check-in: a92bb48a user: dan tags: lateral-join) | |
| 12:02 | Add ext/wasm to the top-level clean/distclean rules in such a way that any error due to a lack of gmake are ignored. (check-in: 2f7eab38 user: stephan tags: trunk) | |
|
2024-07-31
| ||
| 23:49 | Merge the latest trunk enhancements into the lateral-join branch. (check-in: ac6ae846 user: drh tags: lateral-join) | |
| 22:36 | Fix the tclsqlite.c TCL interface module so that it works with both Tcl8 and Tcl9. Make changes across the TCL-based test harness to enable SQLite to be tested with either Tcl8 or Tcl9. Get the --with-tcl= argument on the configure script working. Testing changes only - no changes to the SQLite core. I believe the previous merge attempt didn't work because of errors in the merge itself, not because of faults in the code. Trying again... (check-in: ea9d88f9 user: drh tags: trunk) | |
|
2024-07-22
| ||
| 19:31 | Fix undesirable C++-style comments in the parser. (check-in: e330596a user: drh tags: lateral-join) | |
| 17:09 | Do not abort the resolver early if a LIMIT expression does not resolve, as that can result in a memory leak. (check-in: ac6dc8c6 user: drh tags: lateral-join) | |
| 16:59 | Only allow variables in LIMIT clauses if the LIMIT is within a LATERAL subquery and the variable resolves to another FROM clause term to the left of the subquery. We cannot allow variables from outer contexts because the LIMIT value is computed before the cursors in the outer context have been initialized. (check-in: 0a2531c3 user: drh tags: lateral-join) | |
| 16:15 | Allow LIMIT expressions to appear in any outer context. (check-in: c9d3427d user: drh tags: lateral-join) | |
| 13:55 | Do not allow LIMIT and OFFSET to be expressions except for in a LATERAL. (check-in: 10347821 user: drh tags: lateral-join) | |
| 00:46 | Allow LIMIT and OFFSET to contain variables from prior terms of the FROM clause in a LATERAL subquery. Forum post dfe2cd37ca3a9a80 (check-in: 4f051513 user: drh tags: lateral-join) | |
|
2024-07-21
| ||
| 23:36 | Merge debugging output fixes from trunk into the lateral-join branch. (check-in: 9182e999 user: drh tags: lateral-join) | |
| 23:34 | Fixes to TreeView debugging output for VALUES clauses. (check-in: b6aed8bc user: drh tags: trunk) | |
| 21:37 | Fix to the case of a LATERAL subquery that references a prior table that uses a covering index. Forum post fc29fa4f14. (check-in: 6d863172 user: drh tags: lateral-join) | |
| 18:03 | Assert added to ensure that LATERAL subqueries are materialized instead of implemented as a co-routine. (check-in: 6c14b94f user: drh tags: lateral-join) | |
| 10:35 | Fix LATERAL subqueries so that they are able to reference other subqueries to their left that are implemented as co-routines. See Forum post dfe2cd37ca3a9a80. (check-in: 31e175fc user: drh tags: lateral-join) | |
|
2024-07-20
| ||
| 17:38 | Fix rule (1c-ii) of the fromClauseTermCanBeCoroutine() decision so that it work with LATERAL. Add testcase() macros to verify bitmask conditions are all checked. (check-in: 23d83a41 user: drh tags: lateral-join) | |
| 14:06 | Add testcase() macros to bitmap tests in the new code. (check-in: 874bc7bc user: drh tags: lateral-join) | |
| 09:36 | Remove an unnecessary error offset assignment. (check-in: 4ee74b72 user: drh tags: lateral-join) | |
| 08:31 | Optimizations and improved comments. (check-in: 84b80233 user: drh tags: lateral-join) | |
| 03:57 | Do not do an early abort if a lateral subquery is an empty set. (check-in: 9e50d338 user: drh tags: lateral-join) | |
| 03:19 | "LATERAL" may not be a keyword, as that would cause problems for legacy databases that have tables named "lateral". It has to be parsed as an identifier. (check-in: 8217bdda user: drh tags: lateral-join) | |
| 01:19 | Experimental implementation of LATERAL JOIN. (check-in: 3c045a96 user: drh tags: lateral-join) | |
|
2024-07-18
| ||
| 19:17 | Minor typo fixes in test-script-interpreter.md. (check-in: bf54b260 user: stephan tags: trunk) | |