executemultiple fallback only executes the first statement.

[joshday]

DBInterface.jl/src/DBInterface.jl

Line 219 in a2734ab

executemultiple(stmt::Statement, params) = (execute(stmt, params),)

Not sure if the line above is the right place for an error/warning, but I would expect something in the pipeline to tell me that SQLite.jl doesn't support executemultiple.

julia> db = SQLite.DB();

julia> DBInterface.executemultiple(db, "CREATE TABLE temp(x INTEGER); CREATE TABLE temp2(x INTEGER);");

julia> SQLite.tables(db)
(name = ["temp"],)

[quinnj]

This isn't a DBInterface thing, but an sqlite thing, in that it doesn't support executing multiple statements at a time (note not an SQLite.jl thing, but sqlite thing).