summaryrefslogtreecommitdiffstats
path: root/src/test/isolation/specs/fk-contention.spec
blob: f11a1d8cefc4795ab5a49925f06a9a3d34455efd (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
setup
{
  CREATE TABLE foo (a int PRIMARY KEY, b text);
  CREATE TABLE bar (a int NOT NULL REFERENCES foo);
  INSERT INTO foo VALUES (42);
}

teardown
{
  DROP TABLE foo, bar;
}

session s1
setup		{ BEGIN; }
step ins	{ INSERT INTO bar VALUES (42); }
step com	{ COMMIT; }

session s2
step upd	{ UPDATE foo SET b = 'Hello World'; }