[teiid-issues] [JBoss JIRA] (TEIID-2839) Selection of nested document based on non primary key does not work on MongoDB Translator

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12941605#comment-12941605 ] 

Ramesh Reddy commented on TEIID-2839:
-------------------------------------

This only applicable in MERGE case as EMBEDDABLE scenario the data is stored in top level collection as well as nested document. But the selection happens on top level document. Testing the same in JOIN scenario is another usecase needs validating.
                
> Selection of nested document based on non primary key does not work on MongoDB Translator
> -----------------------------------------------------------------------------------------
>
>                 Key: TEIID-2839
>                 URL: https://issues.jboss.org/browse/TEIID-2839
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.4
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>             Fix For: 8.7
>
>
> When a table is either EMBEDDED or MERGED into a parent table, issuing a "SELECT" query using WHERE clause that uses a NON primary key results in empty result.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira