Major Description
run a query like
select t.id, t.c11 from foo t join bar tt on t.id = tt.id limit 10
calcite makes a sub-query to JDBC driver like
SELECT "t0"."ID", "t0"."C11"
FROM ( SELECT * FROM "FOO" INNER JOIN (SELECT "ID" FROM "BAR") AS "t" ON "FOO"."ID" = "t"."ID"
FETCH NEXT 10 ROWS ONLY ) AS "t0"
which cannot be executed since ID column present in both tables, see example in attachment