1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
# name: test/sql/transactions/aborted_transaction_commit.test
# description: Commiting an aborted transaction turns it into a rollback.
# group: [transactions]
statement ok
CREATE TABLE keys(i INTEGER PRIMARY KEY);
statement ok
BEGIN;
statement ok
INSERT INTO keys VALUES (1);
statement error
INSERT INTO keys VALUES (1);
----
<REGEX>:Constraint Error.*constraint violation.*
# Implicit ROLLBACK.
statement ok
COMMIT
query I
SELECT COUNT(*) FROM keys
----
0
statement ok
BEGIN;
statement ok
INSERT INTO keys VALUES (1);
statement error
INSERT INTO keys VALUES (1);
----
<REGEX>:Constraint Error.*constraint violation.*
statement error
SELECT 42;
----
<REGEX>:TransactionContext Error.*transaction is aborted.*
|
