Choose data engine (vinyl or memtx)

[ligurio]

In SQL:
box.execute([[set session "sql_default_engine" = 'memtx';]])

In Lua:
box.space.j:alter{engine = memtx}

(was broken in 3214905#diff-5e0349f9a230fa195fa381f7688a7bdad9ebc811c4828edfdc82ce46b7433698)

[ligurio]

perhaps with-transaction can help
https://cljdoc.org/d/seancorfield/next.jdbc/1.1.610/api/next.jdbc#with-transaction

[ligurio]

how test-run sets engine:

UPDATE "_session_settings" SET "value" = 'memtx|vinyl' WHERE "name" = 'sql_default_engine'
pragma sql_default_engine='memtx|vinyl'

https://github.com/tarantool/test-run/blob/f246567bfc444b7bee4e66d6e187da572b962cbd/lib/tarantool_server.py#L126-L166