JDBC adapter generates wrong SQL when selft join with subquery when DB2 dialect used .
select t1."customer_id", t2."customer_id"
from (select "customer_id" from "sales_fact_1997") as t1
inner join (select "customer_id" from "sales_fact_1997") t2
on t1."customer_id" = t2."customer_id"
FROM (SELECT sales_fact_1997.customer_id
FROM foodmart.sales_fact_1997 AS sales_fact_1997) AS t
INNER JOIN (SELECT sales_fact_19970.customer_id
FROM foodmart.sales_fact_1997 AS sales_fact_19970) AS t0 ON sales_fact_1997.product_id = sales_fact_19970.product_id
sales_fact_1997.product_id = sales_fact_19970.product_id is wrong, can not found tables sales_fact_1997 and sales_fact_19970 in ON condition.