conn_mt:exec fails on BEGIN ... END blocks

[Siapran]

https://github.com/stepelu/lua-ljsqlite3/blob/master/init.lua#L341

doesn't work on, for instance, CREATE TRIGGER statements , that require BEGIN .. END blocks

this type of query works fine with sqlite3_exec

[xiejiangzhi]

I have implement the sqlite3_exec. Maybe you can try it https://github.com/Codezerker/lua-ljsqlite3/commit/4efb927a6514039ec657ce977154b6ea3596f2ce

[luveti]

In case anyone else runs into this issue, you can use rowexec instead as it doesn't perform any splitting. It basically acts like sqlite3_exec but with less features.