{question}
What isolation levels are supported in SingleStore?
{question}
{answer}
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.
For example:
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.
{answer}