rdbms: add setTempTablesOnlyMode() to suppress CONN_TRX_AUTOCOMMIT during tests