SQL Dialects Reference/Transactions

Transactions

This page includes comparison tables which can be big and complex.

While it's perfectly all right to view them in their complete state, it is recommended to install a comparison tables extension that would allow to select particular columns of interest for comparison.

SQL version Feature Standard
SQL:2011		 DB2 Firebird Ingres Linter MSSQL MySQL
Vers. 5.x		 MonetDB Oracle
Vers. 11.x		 PostgreSQL SQLite Virtuoso
 ? Start START TRANSACTION
[transaction characteristics]		 Implicit SET TRANSACTION  ?  ? BEGIN TRAN[SACTION] BEGIN [WORK]
START [TRANSACTION]		 START TRANSACTION
BEGIN TRANSACTION		 Implicit BEGIN [WORK|TRANSACTION]
START TRANSACTION		 BEGIN [TRANSACTION] Implicit
 ? Commit COMMIT [WORK] COMMIT [WORK] COMMIT [WORK] [EXEC SQL] COMMIT [WORK]  ? COMMIT [WORK]
COMMIT TRAN[SACTION] [transaction_name]		 COMMIT [WORK] COMMIT [WORK] [AND [NO] CHAIN] COMMIT [WORK] COMMIT [WORK|TRANSACTION] COMMIT [TRANSACTION]
END [TRANSACTION]		 COMMIT WORK
 ? Rollback whole transaction ROLLBACK [WORK] ROLLBACK [WORK] ROLLBACK [WORK] [EXEC SQL] ROLLBACK [WORK]  ? ROLLBACK [WORK]
ROLLBACK TRAN[SACTION]		 ROLLBACK [WORK] ROLLBACK [WORK] [AND [NO] CHAIN] ROLLBACK [WORK] ROLLBACK [WORK|TRANSACTION] ROLLBACK [TRANSACTION] ROLLBACK WORK
 ? Define a savepoint x, while inside a transaction SAVEPOINT x SAVEPOINT x ON ROLLBACK RETAIN CURSORS SAVEPOINT x SAVEPOINT x  ? SAVE TRAN[SACTION] x SAVEPOINT x SAVEPOINT x SAVEPOINT x SAVEPOINT x SAVEPOINT x N/A
 ? Rollback to given savepoint x ROLLBACK [WORK] TO SAVEPOINT x ROLLBACK [WORK] TO SAVEPOINT x ROLLBACK [WORK] TO [SAVEPOINT] x [EXEC SQL] ROLLBACK [WORK] TO x  ? ROLLBACK TRAN[SACTION] x ROLLBACK [WORK] TO [SAVEPOINT] x ROLLBACK [WORK] [AND [NO] CHAIN] TO SAVEPOINT x ROLLBACK [WORK] TO [SAVEPOINT] x ROLLBACK [WORK|TRANSACTION] TO [SAVEPOINT] x ROLLBACK [TRANSACTION] TO [SAVEPOINT] x N/A
 ? Release (forget) savepoint x RELEASE SAVEPOINT x RELEASE [TO] SAVEPOINT x RELEASE SAVEPOINT x N/A  ? N/A RELEASE SAVEPOINT x RELEASE SAVEPOINT x N/A RELEASE [SAVEPOINT] x RELEASE [SAVEPOINT] x N/A
 ? Prepare transaction named id for two-phase commit  ?  ? N/A  ?  ?  ?  ? N/A  ? PREPARE TRANSACTION id N/A  ?
 ? Commit prepared transaction named id  ?  ? N/A  ?  ?  ?  ? N/A  ? COMMIT PREPARED id N/A  ?
 ? Rollback prepared transaction named id  ?  ? N/A  ?  ?  ?  ? N/A  ? ROLLBACK PREPARED id N/A  ?
Start Commit Rollback Prepare Execute prepared
Linter Implicit
  • a COMMIT statement is executed
  • any DDL statement is executed
  • any statement is executed in AUTOCOMMIT mode
  • a ROLLBACK statement is executed
  • a user process is terminated abnormally or disconnects without COMMIT/ROLLBACK
  ?  ?
Category:Book:SQL Dialects Reference#Transactions%20
Category:Book:SQL Dialects Reference