calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zhiqiang He (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CALCITE-1636) JDBC adapter generates wrong SQL when selft join with subquery when DB2 dialect used
Date Wed, 15 Feb 2017 12:19:42 GMT
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)

Mime
View raw message