[teiid-issues] [JBoss JIRA] (TEIID-3703) Cannot make references to view columns in view update

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-3703:
-------------------------------------

             Summary: 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)