mod(cid, 7)
FROM
  generate_series(1, 15) AS ID(cid);
INSERT INTO child2 VALUES
  (-1, -1, -1, -1),
  (0, 0, 0, 0),
  (16, 16, 2, 2),
  (20, 20, 6, 6);
INSERT INTO grandchild1 SELECT
  mod(mod(gcid-1, 150), 40) + 1,
  mod(gcid-1, 150) + 1,
  gcid,
  mod(gcid, 201)
FROM
  generate_series(1, 410) AS ID(gcid);
INSERT INTO grandchild1 VALUES
  (-1, -1, -1, -1),
  (0, 0, 0, 0),
  (200, 200, 200, 200),
  (411, 411, 411, 9);
INSERT INTO grandchild2 SELECT
  mod(gcid-1, 40) + 1,
  mod(gcid-1, 15) + 1,
  mod(mod(gcid-1, 15) + 1, 14),
  gcid,
  mod(gcid, 13)
FROM
  generate_series(1, 51) AS ID(gcid);
ALTER TABLE parent1 SPLIT AT SELECT i FROM generate_series(8, 32, 8) AS g(i);
ALTER TABLE child1 SPLIT AT SELECT pid1, pid1 + 40 FROM
generate_series(4, 36, 8) AS g(pid1);
ALTER TABLE grandchild2 SPLIT AT SELECT pid1, pid1 + 40, pid1, pid1 FROM
generate_series(2, 38, 4) AS g(pid1);
ALTER TABLE grandchild2 EXPERIMENTAL_RELOCATE
  SELECT ARRAY[((i-1)/2)::INT%5+1], i, i+20, i, i FROM generate_series(1, 39, 2) AS g(i);
--- progress: testdata/logic_test/distsql_merge_join: 20 statements/queries
SELECT start_key, end_key, replicas, lease_holder from [SHOW RANGES FROM TABLE parent1];
	-- OK;
SELECT start_key, end_key, replicas, lease_holder from [SHOW RANGES FROM TABLE child1];
	-- OK;
SELECT start_key, end_key, replicas, lease_holder from [SHOW RANGES FROM TABLE grandchild1];
	-- OK;
SELECT * FROM parent1 JOIN child1 USING(pid1) WHERE pid1 >= 3 AND pid1 <= 5;
	-- OK;
SELECT * FROM child1 JOIN parent1 USING(pid1) WHERE pid1 >= 3 AND pid1 <= 5;
	-- OK;
SELECT * FROM parent1 JOIN child1 ON parent1.pid1 = child1.pid1 WHERE parent1.pid1 >= 29 AND parent1.pid1 <= 31 ORDER BY parent1.pid1;
	-- OK;
SELECT * FROM parent1 JOIN child2 USING(pid1) WHERE pid1 >= 12;
FAIL	github.com/cockroachdb/cockroach/pkg/sql/logictest	3008.499s