duckdb-rs icon indicating copy to clipboard operation
duckdb-rs copied to clipboard

Pivot not working with prepared statements

Open l1xnan opened this issue 9 months ago • 1 comments

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

l1xnan avatar May 16 '24 02:05 l1xnan