SQLite.load! fails inside transaction

[TheZXCVQ]

When executing example code below

using SQLite
using TypedTables

db=SQLite.DB("test.db")

SQLite.execute(db,"""
CREATE TABLE IF NOT EXISTS test_table (
	id INTEGER PRIMARY KEY,
   	number INTEGER
)
""")

table_to_insert=Table(id=[1,2,3], number=[6,2,8])
try
    SQLite.transaction(db)
    SQLite.load!(table_to_insert, db, "test_table")
    SQLite.commit(db)
catch e
    SQLite.rollback(db)
    throw(e)
end

It on SQLite.load! throws ERROR: SQLiteException("Safety level may not be changed inside a transaction")

[caleb-allen]

I'm experiencing something similar with intermittent errors calling load!, although I haven't been able to confirm the precise scenario that causes it.

It seems to only occur shortly after initializing a new database, or a new table. It appears that if load! does not throw this SQLiteException on the first call to the method, it does not throw it on subsequent calls.

[Zentrik]

You can comment out

SQLite.jl/src/SQLite.jl

Line 652 in 7acb8a9

execute(db, "PRAGMA synchronous = OFF;")

and

SQLite.jl/src/SQLite.jl

Line 662 in 7acb8a9

execute(db, "PRAGMA synchronous = ON;")

to get around it.