You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Pavel Vinokurov (JIRA)" <ji...@apache.org> on 2018/03/29 04:12:00 UTC
[jira] [Created] (IGNITE-8072) SQL query with multiple JOIN and
subquery with UNION produces "Column not found" exception
Pavel Vinokurov created IGNITE-8072:
---------------------------------------
Summary: SQL query with multiple JOIN and subquery with UNION produces "Column not found" exception
Key: IGNITE-8072
URL: https://issues.apache.org/jira/browse/IGNITE-8072
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 2.4, 2.2, 2.1
Reporter: Pavel Vinokurov
Initial script:
CREATE TABLE Person(id INTEGER PRIMARY KEY, company_id INTEGER);
CREATE TABLE Company(id INTEGER PRIMARY KEY, name VARCHAR);
CREATE TABLE Department(id INTEGER PRIMARY KEY, company_id INTEGER);
Query:
select * from
(
select
p.id as id,
p.company_id as company_id
from person p
union
select
p.id as id,
p.company_id as company_id
from person p
) p
left join company c on p.company_id=c.id
left join department d on p.company_id=d.id
Result:
SEVERE: Failed to run map query on local node.
class org.apache.ignite.IgniteCheckedException: Failed to parse SQL query: SELECT
C__Z3.NAME __C2_0,
D__Z4.ID __C2_1,
D__Z4.COMPANY_ID __C2_2,
C__Z3.ID __C2_3
FROM PUBLIC.COMPANY C__Z3
LEFT OUTER JOIN PUBLIC.DEPARTMENT D__Z4
ON P__Z2.COMPANY_ID = D__Z4.ID
ORDER BY 4
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)