Can't create foreign keys in temporary tables

[krlmlr]

What happens?

The syntax CREATE TEMP TABLE y (a int, FOREIGN KEY (a) REFERENCES x (a)) fails with a parser error: "Parser Error: Only TEMPORARY table names can use the "temp" schema"

To Reproduce

CREATE TEMP TABLE x (a int, PRIMARY KEY (a))
CREATE TEMP TABLE y (a int, FOREIGN KEY (a) REFERENCES x (a))

echo "CREATE TEMP TABLE x (a int, PRIMARY KEY (a)); CREATE TEMP TABLE y (a int, FOREIGN KEY (a) REFERENCES x (a));" | build/debug/duckdb

con <- DBI::dbConnect(duckdb::duckdb())

DBI::dbExecute(con, "CREATE TEMP TABLE x (a int, PRIMARY KEY (a))")
#> [1] 0
DBI::dbExecute(con, "CREATE TEMP TABLE y (a int, FOREIGN KEY (a) REFERENCES x (a))")
#> Error: rapi_execute: Failed to run query
#> Error: Parser Error: Only TEMPORARY table names can use the "temp" schema

^{Created on 2022-06-15 by the reprex package (v2.0.1)}

Environment (please complete the following information):

• OS: macOS
• DuckDB Version: cdfb9f9
• DuckDB Client: CLI, R

Before Submitting

• Have you tried this on the latest master branch?

• Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

[krlmlr]

Trying to remove the code that triggers the warning, checking if tests are failing: https://github.com/krlmlr/duckdb/actions/runs/2499751954.

[krlmlr]

Awesome, thanks! I'll try out very soon.

[krlmlr]

Works like a charm locally, now trying in CI/CD: cynkra/dm#1091.