rdbms: add more comments and sanity checks for CONN_TRX_AUTOCOMMIT