duckdb-rs
duckdb-rs copied to clipboard
Pivot not working with prepared statements
Executing the pivot statement results in the following error:
let sql = r"
with tbl as (
select * from read_parquet('test.parquet')
)
PIVOT tbl on a using sum(b)";
let con = duckdb::Connection::open_in_memory().unwrap();
let stmt = con.prepare(sql);
println!("{:?}", stmt);
// Err(DuckDBFailure(Error { code: Unknown, extended_code: 1 }, Some("Invalid Input Error: Cannot prepare multiple statements at once!")))
It may be related to https://github.com/duckdb/duckdb/issues/7720