You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "xiong duan (Jira)" <ji...@apache.org> on 2023/06/05 02:14:00 UTC
[jira] [Created] (CALCITE-5749) Join table with different database name and same table name will throw exception
xiong duan created CALCITE-5749:
-----------------------------------
Summary: Join table with different database name and same table name will throw exception
Key: CALCITE-5749
URL: https://issues.apache.org/jira/browse/CALCITE-5749
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.34.0
Reporter: xiong duan
Assignee: xiong duan
When we execute SQL:
{code:java}
select * from test1.tablea,test2.tablea {code}
Calcite will throw exception:
{code:java}
Duplicate relation name 'tablea' in FROM clause {code}
Because when we generate alias for this table, just use the last value in the names.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)