[
https://issues.jboss.org/browse/TEIID-4714?page=com.atlassian.jira.plugin...
]
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)