dolthub / dolthub/dolt

Cannot commit with constraint violations

Open
#5,992 2 comments 0 reactions 0 assignees View on GitHub
bug merge
Dominant language
Go
Stars
24.4k
Forks
873
Avg merge
1d 5h
Merged PRs (30d)
108

Description

Dolt version `v1.1.0`.

`call dolt_commit()` fails in a database that has constraint violations, despite setting `dolt_force_transaction_commit=1` in the session and globally.

```
mysql> select @@global.dolt_force_transaction_commit;
+----------------------------------------+
| @@GLOBAL.dolt_force_transaction_commit |
+----------------------------------------+
| 1 |
+----------------------------------------+
1 row in set (0.00 sec)
mysql> select @@dolt_force_transaction_commit;
+-----------------------------------------+
| @@SESSION.dolt_force_transaction_commit |
+-----------------------------------------+
| 1 |
+-----------------------------------------+
1 row in set (0.00 sec)
mysql> call dolt_commit('-Am', 'capture constraint violations');
ERROR 1105 (HY000): error: the table(s) delivery_attempts have constraint violations
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.