1 files changed, 19 insertions, 0 deletions
diff --git a/src/test/isolation/specs/fk-contention.spec b/src/test/isolation/specs/fk-contention.spec
new file mode 100644
index 0000000..f11a1d8
--- /dev/null
+++ b/src/test/isolation/specs/fk-contention.spec
@@ -0,0 +1,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'; }