Join filters get pushed into Arrow scans that can't handle them (string_view / binary_view tables) #665

diff --git a/test/arrow/arrow_filter_pushdown.cpp b/test/arrow/arrow_filter_pushdown.cpp
--- a/test/arrow/arrow_filter_pushdown.cpp
+++ b/test/arrow/arrow_filter_pushdown.cpp
@@ -86,6 +86,34 @@
 	}
 }
 
+// Helper: get the EXPLAIN ANALYZE output for a hash join that probes an arrow_scan on id with a one-row build side
+static string GetExplainAnalyzeForJoin(Connection &con, ArrowTestFactory &factory) {
+	con.TableFunction("arrow_scan", {}, {}, ArrowTestHelper::ConstructArrowScan(factory))->CreateView("probe");
+	const auto result =
+	    con.Query("EXPLAIN ANALYZE SELECT count(*) FROM probe JOIN (SELECT 5 AS k) v ON probe.id = v.k");
+	REQUIRE(!result->HasError());
+	return result->Collection().GetValue(1, 0).ToString();
+}
+
+TEST_CASE("Arrow filter pushdown - join filters follow the pushdown types", "[arrow]") {
+	DuckDB db;
+	Connection con(db);
+
+	REQUIRE(!con.Query("CREATE TABLE src AS SELECT i AS id, i::VARCHAR AS name FROM range(10) tbl(i)")->HasError());
+
+	SECTION("Table with a string view column: no join filter in scan") {
+		auto factory = MakeArrowFactory(con, "SELECT * FROM src", true);
+		auto explain_str = GetExplainAnalyzeForJoin(con, *factory);
+		REQUIRE(explain_str.find("Dynamic Filters") == string::npos);
+	}
+
+	SECTION("Table with a regular string column: join filter in scan") {
+		auto factory = MakeArrowFactory(con, "SELECT * FROM src", false);
+		auto explain_str = GetExplainAnalyzeForJoin(con, *factory);
+		REQUIRE(explain_str.find("Dynamic Filters") != string::npos);
+	}
+}
+
 TEST_CASE("Arrow filter pushdown - nested view types disable pushdown", "[arrow]") {
 	DuckDB db;
 	Connection con(db);

diff --git a/tests/fast/arrow/test_filter_pushdown.py b/tests/fast/arrow/test_filter_pushdown.py
--- a/tests/fast/arrow/test_filter_pushdown.py
+++ b/tests/fast/arrow/test_filter_pushdown.py
@@ -647,6 +647,20 @@
         res = duckdb.sql("SELECT * FROM dset WHERE col = 'abc'").fetchall()
         assert res == [("abc",)]
 
+    @pytest.mark.parametrize(
+        ("view_type", "values", "key"),
+        [
+            pytest.param(pa.string_view(), ["abc", "efg"], "'abc'", id="string_view"),
+            pytest.param(pa.binary_view(), [b"abc", b"efg"], "'abc'::BLOB", id="binary_view"),
+        ],
+    )
+    def test_view_join_does_not_crash(self, view_type, values, key):
+        """A join's runtime filters cannot be pushed into a scan of a table with a view column either."""
+        con = duckdb.connect()
+        con.register("t", pa.table({"x": [1, 2], "col": pa.array(values, type=view_type)}))
+        assert con.execute(f"SELECT x FROM t JOIN (SELECT {key} AS k) b ON t.col = b.k").fetchall() == [(1,)]
+        assert con.execute("SELECT x FROM t JOIN (SELECT 2 AS k) b ON t.x = b.k").fetchall() == [(2,)]
+
 
 # ===========================================================================
 # 11. Projection / scanner-path interactions