monetdb_query cannot run multiple SQL statements, stopping after first statement without any error or message if first statement was successfully executed.
I expect multiple DDL or DML statements to be able to run at once within the same transaction ended by either commit or rollback depending on the execution success, as long as they do not expect results. Using monetdb_set_autocommit in combination with with start transaction; commit; did not work either.
monetdb_query cannot run multiple SQL statements, stopping after first statement without any error or message if first statement was successfully executed.
I expect multiple DDL or DML statements to be able to run at once within the same transaction ended by either commit or rollback depending on the execution success, as long as they do not expect results. Using monetdb_set_autocommit in combination with with start transaction; commit; did not work either.