What are the consequences if a transactional operation ends with an error and is not committed?

If a transactional operation ends with an error and is not committed, then all changes made within that transaction will be rolled back. This guarantees data integrity — the database will remain in the state it was before the transaction began. For example, if you insert multiple records and one of them causes an error, then without a commit, none of the records will be saved.