Merged PRs

dolt

10485: Git remote support fixes: shard git blobstore writes and normalize clone/remote URLs
Fix git-remote workflows by defaulting git-blobstore sharding to 50MB and correcting clone dir inference, SSH remote parsing, and empty-remote validation (with tests).
10483: Add git+* dbfactory remotes with required --git-cache-dir, --ref support, and integration tests
Implements git-backed Dolt remotes via dbfactory (git+file/http/https/ssh), requiring --git-cache-dir and supporting --ref, with end-to-end BATS + Go multi-client coverage for push/clone/pull and empty-remote bootstrap.
10481: [no-review-notes] Removed most of the remaining LD_1 specific codepaths and types
10474: NBS-on-Git: add GitBlobstore-backed NBS store and empty-remote bootstrap
Add nbs.NewGitStore wiring plus fetch/push semantics and tests to open against an empty Git remote and bootstrap refs/dolt/data on first write.
10466: GitBlobstore: add cache
Make GitBlobstore cache fetches.
10458: GitBlobstore: remote-managed fetch/merge/push sync
10429: go/store/nbs: For local databases, crash on fatal I/O errors during writes.
If an fsync fails, or if a critical write(2) calls returns an error against a shared mutable file, it is not safe for the server to keep running because it cannot necessarily guarantee the state of the files as they exist on disk and will exist on disk in the future.
Implement functionality so that the Dolt process cashes in such cases.

3425: Do not set scope length during join planning
related to #10472
Scope length should only be set when assigning indexes if the scope length then is not zero. The scope length set during join planning is doesn't actually refer to the correct scope length, and if it was actually supposed to be zero, it was never correct set back to zero, causing a panic.
3423: Do not allow sort-based joins between text and number type columns
fixes #10435
Disables merge and range heap joins between text and number type columns