What isolation levels are supported in SingleStore?
The "Read Committed" is the only isolation level that is supported in SingleStore.
This isolation level guarantees we will not see uncommitted transactions.
This means that it is possible for a running query to see data changes that happened in a query that came afterward.
Thread 1: "select * from a;"
Thread 2: "insert into a values (1),(100);"
It is valid for thread 1 to:
- Not return 1 and 100.
- Return 100 but not 1.
- Return 1 but not 100.
- Return both 1 and 100.
You can find more information here.