START 2
-- An initial implementation of a parallel test harness.
-- Simple READ COMMITTED visibility test
STEP 1
Q 0 CREATE TABLE vis_test (col1 text, col2 integer);
STEP 2
Q 0 INSERT INTO vis_test(col1, col2) VALUES ('test string',245);
Q 1 BEGIN; 
STEP 3
Q 1 INSERT INTO vis_test(col1, col2) VALUES ('test b', 123);
STEP 4
Q 0 SELECT * FROM vis_test;
Q 1 SELECT * FROM vis_test;
STEP 5
Q 1 COMMIT;
STEP 6
Q 0 SELECT * FROM vis_test;
Q 1 SELECT * FROM vis_test;
STEP 7
-- Simple deadlock case
Q 0 CREATE TABLE vis_test2 (col1 text, col2 text);
STEP 8
Q 0 BEGIN;
Q 1 BEGIN;
STEP 9
Q 0 LOCK TABLE vis_test;
Q 1 LOCK TABLE vis_test2;
STEP 10
Q 0 LOCK TABLE vis_test2;
Q 1 LOCK TABLE vis_test;
STEP 11
Q 0 SELECT * FROM vis_test;
STEP 12
Q 0 COMMIT;
Q 1 COMMIT;
STEP 13
-- Clearing up
Q 0 DROP TABLE vis_test;
Q 1 DROP TABLE vis_test2;
-- End of test schedule