search

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
8 stars 5 forks source link

Provenance of transaction - TABLE specified - ONLY UPDATED filter condition not added #24

Closed lordpretzel closed 6 years ago

lordpretzel commented 6 years ago

Test case:

./src/command_line/gprom -db orcl -port 1521  -log -loglevel 3 -sql "PROVENANCE WITH ONLY UPDATED SHOW INTERMEDIATE STATEMENT ANNOTATIONS TABLE r OF TRANSACTION '0A0010008E160000';" -backend oracle -Pexecutor run -Boracle.audittable FGA_LOG$

returns all tuples, seems that update's condition is not added as a selection even though ONLY UPDATED is specified.

lordpretzel commented 6 years ago

was causes by READ COMMITTED merging of updates that reversed the order of the list of updated table names which causes the code adding conditions to fail if there is more than one table affected by the transaction