Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3703

Cannot make references to view columns in view update

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 8.12
    • 8.7
    • Query Engine
    • None

      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)

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: