[teiid-issues] [JBoss JIRA] (TEIID-2838) Update and Delete Operations fail in One-2-One mapping in MongoDB Translator

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy resolved TEIID-2838.
---------------------------------

    Resolution: Done


Previously the MERGED case only looked at ONE-2-MANY scenarios, thus missed NON array embedded document. Both have different call semantics to handle an update. Array requires "$pull" and non requires "$unset". Corrected to code to detect the behavior based on metadata.
                
> Update and Delete Operations fail in One-2-One mapping in MongoDB Translator
> ----------------------------------------------------------------------------
>
>                 Key: TEIID-2838
>                 URL: https://issues.jboss.org/browse/TEIID-2838
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.4
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>              Labels: mongodb
>             Fix For: 8.7
>
>
> When two tables are defined in ONE-2-ONE relation like defined in TEIID-2830, the UPDATE and DELETE operations on those tables end up in failure always.
> for ex:
> {code}
> DELETE FROM Address WHERE CustomerId = '1002'
> UPDATE Address SET Street = 'Highway 100' WHERE CustomerId = '1002'
> {code}

--
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