IITDBGroup / gprom

GProM is a middleware that adds support for provenance to database backends.
http://www.cs.iit.edu/%7edbgroup/research/gprom.php
Apache License 2.0
9 stars 5 forks source link

Provenance for transaction - read committed - multiple tables - only updated adds selection condition on wrong table #22

Closed lordpretzel closed 7 years ago

lordpretzel commented 7 years ago

Test case

./src/command_line/gprom -host **** -db orcl -port 1521 -user **** -passwd **** -log -loglevel 4 -sql "PROVENANCE WITH ONLY UPDATED SHOW INTERMEDIATE STATEMENT ANNOTATIONS TABLE R OF TRANSACTION '06001B0011070000';" -backend oracle -Pexecutor run -Boracle.audittable FGA_LOG$

transaction is

update R set A = 21 where B = 17;
update S set C = 30 where D = 3;

The problem is that a selection on D=3 is added where it should add a selection on table R, the table for which provenance is requested.

lordpretzel commented 7 years ago

after fixing check for reenactment