This is an automated email from the ASF dual-hosted git repository. ilyak pushed a commit to branch ignite-2.11 in repository https://gitbox.apache.org/repos/asf/ignite.git
The following commit(s) were added to refs/heads/ignite-2.11 by this push: new d39a9ad IGNITE-15349 Fixed feedback-4 (#9346) d39a9ad is described below commit d39a9adda9b06e152c27fee550c0c8a8ba6fdf02 Author: IgGusev <des...@mail.ru> AuthorDate: Fri Aug 20 23:50:00 2021 +0300 IGNITE-15349 Fixed feedback-4 (#9346) * ignite-15349-fixed-feedback-4 * Finished the sentence * Fixed wording again --- docs/_docs/sql-reference/transactions.adoc | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/docs/_docs/sql-reference/transactions.adoc b/docs/_docs/sql-reference/transactions.adoc index 78fc40d..100bf25 100644 --- a/docs/_docs/sql-reference/transactions.adoc +++ b/docs/_docs/sql-reference/transactions.adoc @@ -40,7 +40,7 @@ The `BEGIN`, `COMMIT` and `ROLLBACK` commands allow you to manage SQL Transactio The `ROLLBACK [TRANSACTION]` statement undoes all updates made since the last time a `COMMIT` or `ROLLBACK` command was issued. == Example -Add a person and update the city population by 1 in a single transaction. +Add a person and update the city population by 1 in a single transaction and commit it. [source,sql] ---- @@ -53,7 +53,8 @@ UPDATE City SET population = population + 1 WHERE id = 3; COMMIT; ---- -Roll back the changes made by the previous commands. + +Add a person, update the city population and then roll back changes instead of committing them. [source,sql] ---- @@ -62,5 +63,7 @@ BEGIN; INSERT INTO Person (id, name, city_id) VALUES (1, 'John Doe', 3); UPDATE City SET population = population + 1 WHERE id = 3; + +ROLLBACK; ----