[teiid-issues] [JBoss JIRA] (TEIID-4714) Google translator allows to be inserted duplicate key

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-4714.
-----------------------------------
    Resolution: Rejected


Adding a key would be a manual exercise for the user as the importer won't automatically add one.  Regardless of the source Teiid interprets that key then as a hint - and not something Teiid is responsible for enforcing.  It is possible to have Teiid attempt to enforce the key, but will require the use of a view with an insert trigger - and even then the source is not transactional so it's not guaranteed.

> Google translator allows to be inserted duplicate key 
> ------------------------------------------------------
>
>                 Key: TEIID-4714
>                 URL: https://issues.jboss.org/browse/TEIID-4714
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 9.2
>            Reporter: Lucie Fabrikova
>            Assignee: Steven Hawkins
>         Attachments: googlespreadsheetcrud-vdb.xml
>
>
> It is possible to insert duplicate key, e.g. by running following query multiple times:
> INSERT INTO SmallA (IntKey, StringKey) VALUES (1, '1')



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