benchbase icon indicating copy to clipboard operation
benchbase copied to clipboard

Sqlite missing features for ResourceStresser

Open bpkroth opened this issue 1 year ago • 0 comments

sqlite doesn't support

  • explicit "lock table"
  • sleep operations in its SQL syntax.

The former may possible with a BEGIN EXCLUSIVE TRANSACTION; {stmt}; COMMIT TRANSACTION; style operation, however the substitution logic for expanding the ?? syntax in setSQL() in SQLUtil.java needs fixing.

The sleep logic may be possible by introducing a callback function, but that's specific to the Sqlite driver class which would require some custom code that's only loaded with that profile or reflection to do so dynamically.

See Also: #268 (especially the resourcestresser/ddl-sqlite.sql file for additional links and details).

bpkroth avatar Apr 03 '23 14:04 bpkroth