query-b-query.sql

-- This file only supports 8 tables case

-- The number of partitions
\set N 1

\timing on
EXPLAIN
SELECT *
FROM testtable_1_:N, testtable_2_:N, testtable_3_:N, testtable_4_:N, testtable_5_:N, testtable_6_:N, testtable_7_:N, testtable_8_:N
WHERE testtable_1_:N.x = testtable_2_:N.x AND testtable_1_:N.x = testtable_3_:N.x AND testtable_1_:N.x = testtable_4_:N.x AND testtable_1_:N.x = testtable_5_:N.x AND testtable_1_:N.x = testtable_6_:N.x AND testtable_1_:N.x = testtable_7_:N.x AND testtable_1_:N.x = testtable_8_:N.x;