[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:all-tabpanel ]

Ramesh Reddy resolved TEIID-2839.
---------------------------------

        Labels: Alpha3 mongodb  (was: )
    Resolution: Done


Corrected to refer to the correct values in the nested document rather than looking at the parent document.  When looking at parent you have only KEY information to filter on, but looking at nested level you can filter on any of fields defined in the nested document.
                
> 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
>              Labels: mongodb, Alpha3
>             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