# Create a table that spans two row groups to trigger parallelism.

statement ok
CREATE TABLE tbl (id UBIGINT);

statement ok
INSERT INTO tbl SELECT range FROM range(38_330);

# Insert the same value for row IDs 38_330 and 38_331.

statement ok
INSERT INTO tbl VALUES (38_330), (38_330);

# Fill up until row ID 418_986.
# 418_986 - 2 - 38_330 = 380_654.

statement ok
INSERT INTO tbl SELECT range + 2 + 38_330 FROM range (380_654);

# Insert the same value for row IDs 418_986 and 418_987.
statement ok
INSERT INTO tbl VALUES (38_330), (38_330);

query I
SELECT rowid FROM tbl WHERE id = 38_330 ORDER BY rowid;
----
38330
38331
418986
418987

statement ok
CREATE INDEX idx ON tbl(id);

query I
SELECT COUNT(id) FROM tbl WHERE id = 38_330;
----
4