Skip to main content
Journey Uncommon Logo
JourneyUncommon
hardSQLdirty phantom non-repeatable readsSingle-choice MCQ

Consider this PostgreSQL session at REPEATABLE READ. Session B commits an INSERT of a matching row after session A's first SELECT. What does session A's second SELECT count, and why?

-- Session A (REPEATABLE READ), 10 rows have status='active' BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT count(*) FROM jobs WHERE status='active'; -- returns 10 -- meanwhile Session B: INSERT INTO jobs(status) VALUES('active'); COMMIT; SELECT count(*) FROM jobs WHERE status='active'; -- returns ?