You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Zhiqiang He (JIRA)" <ji...@apache.org> on 2017/02/15 12:19:42 UTC
[jira] [Created] (CALCITE-1636) JDBC adapter generates wrong SQL
when selft join with subquery when DB2 dialect used
Zhiqiang He created CALCITE-1636:
------------------------------------
Summary: JDBC adapter generates wrong SQL when selft join with subquery when DB2 dialect used
Key: CALCITE-1636
URL: https://issues.apache.org/jira/browse/CALCITE-1636
Project: Calcite
Issue Type: Bug
Components: jdbc-adapter
Affects Versions: 1.11.0
Reporter: Zhiqiang He
Assignee: Julian Hyde
JDBC adapter generates wrong SQL when selft join with subquery when DB2 dialect used .
input sql
{code:sql}
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"
{code}
output sql
{code:sql}
SELECT *
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
{code}
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.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)