dolthub / dolthub/dolt

Support `READ COMMITTED`

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

Description

Currently, Dolt only supports the transaction isolation level `REPEATABLE READ`. This is acceptable for most use cases, but is not fully MySQL compatible. In particular, Django database migrations use the `READ COMMITTED` isolation level during database initialization.

[MySQL docs](https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-isolation-levels.html#isolevel_read-committed)

A Django-specific migration [workaround](https://github.com/dolthub/go-mysql-server/pull/528) has been included in the sql engine behind a feature flag, but this is not a general purpose solution for `READ COMMITTED`.

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.