Details
-
Task
-
Resolution: Fixed
-
Major
-
Cheshire-Cat
-
DOC-2021-Apr11-S7, DOC-2021-Apr25-S8, DOC-2021-May09-S9
-
1
Description
Create complete walkthrough of an entire transactions session in N1QL.
For example:
cbq> BEGIN WORK;
|
cbq> INSERT INTO test VALUES("abc2", {"a":1});
|
cbq> SAVEPOINT s1;
|
cbq> UPDATE test AS d SET d.b = 10 WHERE d.a > 0;
|
cbq> SELECT d.*, META(d).id FROM test AS d WHERE d.a >= 0;
|
cbq> SAVEPOINT s2;
|
cbq> UPDATE test AS d SET d.b = 10, d.c = "xyz" WHERE d.a > 0;
|
cbq> SELECT d.*, META(d).id FROM test AS d WHERE d.a >= 0;
|
cbq> ROLLBACK TRAN TO SAVEPOINT s2;
|
cbq> SELECT d.*, META(d).id FROM test AS d WHERE d.a >= 0;
|
cbq> ROLLBACK WORK;
|