mysql:tx:isolation
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| mysql:tx:isolation [2026/05/16 03:32] – phong2018 | mysql:tx:isolation [2026/05/16 03:52] (current) – [Default level by database] phong2018 | ||
|---|---|---|---|
| Line 399: | Line 399: | ||
| ^ Database ^ Default Level ^ Dirty Read ^ Non-repeatable Read ^ Phantom Read ^ | ^ Database ^ Default Level ^ Dirty Read ^ Non-repeatable Read ^ Phantom Read ^ | ||
| - | | PostgreSQL | READ COMMITTED | ✅ No | ❌ Possible | ❌ Possible | | ||
| | MySQL InnoDB | REPEATABLE READ | ✅ No | ✅ No | ✅ No* | | | MySQL InnoDB | REPEATABLE READ | ✅ No | ✅ No | ✅ No* | | ||
| + | | PostgreSQL | READ COMMITTED | ✅ No | ❌ Possible | ❌ Possible | | ||
| | SQL Server | READ COMMITTED | ✅ No | ❌ Possible | ❌ Possible | | | SQL Server | READ COMMITTED | ✅ No | ❌ Possible | ❌ Possible | | ||
| | Oracle | READ COMMITTED | ✅ No | ❌ Possible | ❌ Possible | | | Oracle | READ COMMITTED | ✅ No | ❌ Possible | ❌ Possible | | ||
mysql/tx/isolation.1778902353.txt.gz · Last modified: by phong2018