[teiid-issues] [JBoss JIRA] (TEIID-4550) Validation issues with upsert
Steven Hawkins (JIRA)
issues at jboss.org
Tue Nov 1 08:43:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4550?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-4550.
-----------------------------------
Resolution: Done
Relaxed the validation to allow for a non-updatable primary key in an upsert and to allow a null value if the column is defaultable or auto increment.
> Validation issues with upsert
> -----------------------------
>
> Key: TEIID-4550
> URL: https://issues.jboss.org/browse/TEIID-4550
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.2
>
>
> An upsert using a primary key that is non-updatable should still succeed as the statement is not modifying the key.
> Similarly an upsert using a non-updatable primary key and a null value should still be allowed even if the column is marked as not null as long as it is auto increment or defaultable - as it can be source dependent whether the null key means an insert.
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
More information about the teiid-issues
mailing list