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

[Ramesh Reddy (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Reddy reassigned TEIID-4639:
-----------------------------------

    Assignee: Ramesh Reddy  (was: Steven Hawkins)


> 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: Ramesh Reddy
>
> 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)