You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ignite.apache.org by dm...@apache.org on 2021/08/20 20:50:29 UTC
[ignite] branch master updated: IGNITE-15349 Fixed feedback-4
(#9346)
This is an automated email from the ASF dual-hosted git repository.
dmagda pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/ignite.git
The following commit(s) were added to refs/heads/master by this push:
new dfb8f0f IGNITE-15349 Fixed feedback-4 (#9346)
dfb8f0f is described below
commit dfb8f0fe552b5b2c57047e2113b0fae86fab6693
Author: IgGusev <de...@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;
----