db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

No overlapping shifts, enforced

PRIMARY KEY (team_id, shift WITHOUT OVERLAPS) forbids overlapping ranges per team. 14 team-weeks of org.on_call overlap today.

task

Add the temporal primary key to temp table oc. It fails first; delete the later row of each overlapping pair, then add it.

hints