GeezerVison

What I ran: ./build.sh, then mvn test -Dtest=BalanceSetOperationsTests,NegativeParserTests: all pass. I also ran the jar on the issue's 3000-branch repro and on a chain of 3000 string literals, with and without -Xss512m. I did not run cargo check on pipeline-manager; that change is one argument.

• missing (medium): None of the cases in the table are in the PR's tests. INTERSECT/INTERSECT ALL in particular now go through a new N-ary LogicalIntersect path with no test. Please add at least the issue repro, INTERSECT, and the fallback-in-subquery case. The tests I used:

@Test public void intersectLong() {
    var ccs = this.getCCS("CREATE TABLE t (x INT);\nCREATE VIEW v AS " +
            chain(300, i -> "SELECT x FROM t", "INTERSECT") + ";");
    ccs.stepWeightOne("INSERT INTO t VALUES(1),(1),(2);", " x\n---\n 1\n 2");
}
@Test public void mixedInSubquery() {
    var ccs = this.getCCS("CREATE TABLE t (b BIGINT, d DOUBLE);\nCREATE VIEW v AS SELECT b FROM t WHERE b IN (" +
            chain(200, i -> i == 150 ? "SELECT d FROM t" : "SELECT b FROM t", "UNION ALL") + ");");
    ccs.stepWeightOne("INSERT INTO t VALUES(5, 1);", " b\n---\n 5");
}
@Test public void issue3000() {
    this.getCC("CREATE TABLE t (id BIGINT NOT NULL, v BIGINT);\nCREATE MATERIALIZED VIEW u AS " +
            chain(3000, i -> "SELECT id, v + " + i + " AS v FROM t", "UNION ALL") + ";");
}

• commit quality (medium): The subject of the first commit runs past 72 characters (GitHub cuts it off with …). The body of the second commit is only Fixes #7931; it should say why the chains are balanced and why mixed types fall back to the left-deep form. The PR description says the stack is 256 MB, but the code and the commit both use 512 MB.