[teiid-issues] [JBoss JIRA] (TEIID-4639) Mongo translator - embeddable tables - NULL primary key of embedded table in result

[Juraj Duráni (JIRA)]

Juraj Duráni created TEIID-4639:
-----------------------------------

             Summary: Mongo translator - embeddable tables - NULL primary key of embedded table in result
                 Key: TEIID-4639
                 URL: https://issues.jboss.org/browse/TEIID-4639
             Project: Teiid
          Issue Type: Bug
          Components: Misc. Connectors
    Affects Versions: 8.12.8.6_3
            Reporter: Juraj Duráni
            Assignee: Steven Hawkins


Issuing query like \[1\] on embeddable tables scenario \[2\], in the result, primary key of embedded table is NULL \[3\].

{code:sql|title=\[1\] Sample query}
SELECT a.id AS a_id, a.company_id AS a_cid, b.id AS b_id FROM Person a INNER JOIN Company b IN a.company_id = b.id
{code}

{code:sql|title=\[2\] DDL}
CREATE FOREIGN TABLE Person (
    id integer PRIMARY KEY,
    name varchar(25),
    company_id integer,
    FOREIGN KEY (company_id) REFERENCES Company (id)
) OPTIONS(UPDATABLE 'TRUE');

CREATE FOREIGN TABLE Company (
    id integer PRIMARY KEY,
    name varchar(25)
) OPTIONS(UPDATABLE 'TRUE', "teiid_mongo:EMBEDDABLE" 'TRUE');
{code}

*\[3\] Result*
||a_id||a_cid||b_id||
|11|11|<null>|



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)