Method executeAutoCommit

backend/plugin/db/mssql/mssql.go:319–331

executeAutoCommit executes a single statement in auto-commit mode

(ctx context.Context, statement string)

// executeAutoCommit executes a single statement in auto-commit mode
func (d *Driver) executeAutoCommit(ctx context.Context, statement string) (int64, error) {
	sqlResult, err := d.db.ExecContext(ctx, statement)
	if err != nil {
		return 0, errors.Wrap(err, "failed to execute statement in auto-commit mode")
	}
	rowsAffected, err := sqlResult.RowsAffected()
	if err != nil {
		// Since we cannot differentiate DDL and DML yet, we have to ignore the error.
		slog.Debug("rowsAffected returns error in auto-commit mode", log.BBError(err))
		return 0, nil
	}
	return rowsAffected, nil
}

func execute(ctx context.Context, txn *sql.Tx, statement string) (int64, error) {
	sqlResult, err := txn.ExecContext(ctx, statement)