bug_19332_attempt.sql

CREATE TABLE test_run (
  id INT PRIMARY KEY,
  test_id INT NOT NULL,
  regression_id INT NOT NULL,
  status INT NOT NULL,
  wall_time float8 NOT NULL,
  seed INT NOT NULL
) WITH (autovacuum_enabled = false);


CREATE INDEX test_run_test_id_85a7b38c ON test_run (test_id);

CREATE TABLE regression (
  id INT PRIMARY KEY,
  run_id UUID NOT NULL UNIQUE
);

CREATE TABLE test (
  id INT PRIMARY KEY,
  name TEXT NOT NULL
);

INSERT INTO test_run SELECT x,x,x,1,123.456,1234 FROM generate_Series(1,7432721)x;
DELETE FROM test_run;
ANALYZE test_run;

SELECT "test_run"."id", "test_run"."test_id", "test_run"."regression_id", "test_run"."status", "test_run"."wall_time", "test_run"."seed", "test"."id", "test"."name"
FROM "test_run"
INNER JOIN "regression" ON ("test_run"."regression_id" = "regression"."id")
INNER JOIN "test" ON ("test_run"."test_id" = "test"."id")
WHERE "regression"."run_id" = '019a3799-9f30-7ee6-952b-ba296105f7aa';