GitHub user DaveBirdsall opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1253
[TRAFODION-1610][TRAFODION-2630] Generate constr exprs on update operators
This set of changes plugs a hole in our implementation of
update/upsert/merge operators. It completes work started by JIRA TRAFODION-1575.
This set of changes adds logic to the generator to generate update
constraint check and insert constraint check expressions for update operators.
(The update constraint check handles the run-time update path; the insert
constraint check handles the run-time insert path for upsert and merge; it is
absent for vanilla update and for merges that lack a "when not matched" clause.)
This set of changes also removes temporary code added long ago that
transformed an UPDATE to an INSERT + a DELETE when constraint expressions were
present. (The INSERT operator had a correct implementation of constraint
checking.) This should make many non-key-column UPDATEs faster, and will also
eliminate the possibility of HBase timestamp collisions because the INSERT
happens within a millisecond of the DELETE.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/DaveBirdsall/incubator-trafodion Trafodion1610
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1253.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1253
----
commit c22b6d10fdd3065a948163d64a20c3039128474c
Author: Dave Birdsall <dbirds...@apache.org>
Date: 2017-10-03T16:09:29Z
[TRAFODION-1610][TRAFODION-2630] Generate constr exprs on update operators
----
---
