What happens?

Unnest() works with resursive but not with RECURSIVE.

But https://duckdb.org/docs/sql/keywords_and_identifiers states:

Case-Sensitivity of Identifiers

Following the convention of the SQL standard, identifiers in DuckDB are case-insensitive.

To Reproduce

-- works
SELECT CORR(Y,X) AS RESULTS 
FROM( SELECT UNNEST([{Y:1.0,X:5.0},(3.0,9.0),(4.0,7.0)], recursive=>true));

-- fails: Unsupported parameter "RECURSIVE" for unnest
SELECT CORR(Y,X) AS RESULTS 
FROM( SELECT UNNEST([{Y:1.0,X:5.0},(3.0,9.0),(4.0,7.0)], RECURSIVE=>true));

Please note: Both statement fail on 0.11-Snapshot and you need to test against 0.10.0 release for verification.

OS:

Linux

DuckDB Version:

0.10.1

DuckDB Client:

Java

Full Name:

Andreas Reichel

Affiliation:

manticore-projects.com

Have you tried this on the latest nightly build?

I have tested with a release build (and could not test with a nightly build)

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

• Yes, I have