Roman Churganov created CALCITE-4272: ----------------------------------------
Summary: Incorrect sub-query to JDBC driver Key: CALCITE-4272 URL: https://issues.apache.org/jira/browse/CALCITE-4272 Project: Calcite Issue Type: Bug Components: core Affects Versions: 1.23.0 Reporter: Roman Churganov Attachments: podd-tests.zip run a query like {quote}select t.id, t.c11 from foo t join bar tt on t.id = tt.id limit 10 {quote} calcite makes a sub-query to JDBC driver like {quote}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" {quote} which cannot be executed since ID column present in both tables, see example in attachment -- This message was sent by Atlassian Jira (v8.3.4#803005)