[teiid-issues] [JBoss JIRA] (TEIID-3703) Cannot make references to view columns in view update
Steven Hawkins (JIRA)
issues at jboss.org
Sun Oct 11 15:19:03 EDT 2015
[ https://issues.jboss.org/browse/TEIID-3703?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins closed TEIID-3703.
---------------------------------
> Cannot make references to view columns in view update
> -----------------------------------------------------
>
> Key: TEIID-3703
> URL: https://issues.jboss.org/browse/TEIID-3703
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.7
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.12
>
>
> Issuing an update against an updatable view with an instead of trigger that uses a view column in a set expression will fail at runtime saying that a reference to the value cannot be found.
> for example with a gx view: update gx set x = x || 'a' where y = 2
> would result in:
> org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate x: No value was available
> at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:501)
> at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:696)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
More information about the teiid-issues
mailing list