Cannot execute multi-statement queries about go-duckdb HOT 5 CLOSED

I've reopened this and requested an ExtractStatements function for the C API. See duckdb/duckdb#4977

from go-duckdb.

Thanks for reporting this. I've tested multiple statements with other DuckDB drivers (Rust, Python).
The Python driver uses a very clever way of splitting a string of multiple statements into single statements and executing them one by one. They make use of the ExtractStatements method in the C++ API.
Maybe we can leverage this?

Until we have a fix, I would suggest to merge your quick fix. Could you please open a PR?

from go-duckdb.

Yeah, I noticed the ExtractStatements method in the Python driver as well, unfortunately I was not able to find it in the C API. If you can't find it, do you think it makes sense to request DuckDB to add it?

I submitted a PR for my fix, but please beware that I put it together very quickly, so please double-check it before merging.

from go-duckdb.

Thanks, I've tested and merged the PR.
I think we should request the ExtractStatements method for the C API, as this would be a cleaner solution. I'll ask them tomorrow.

from go-duckdb.

I think we can close this.

from go-duckdb.