When reenacting a sequence of DML statements which include more than one INSERT INTO SELECT ..., then activating statement annotations causes the rewrite to produce an algebra graph that fails the consistency check (it seems the schema gets messed up when replacing table accesses with reenactment queries for previous updates during merging).
Test case (put in the appropriate --passwd):
./src/command_line/gprom -backend oracle -db orcl -host ligeti.cs.iit.edu -user testuser -loglevel 3 -query "REENACT WITH PROVENANCE STATEMENT ANNOTATIONS (INSERT INTO R (SELECT * FROM R WHERE B = 2); INSERT INTO R (SELECT * FROM R WHERE B = 2););"
When reenacting a sequence of DML statements which include more than one
INSERT INTO SELECT ...
, then activating statement annotations causes the rewrite to produce an algebra graph that fails the consistency check (it seems the schema gets messed up when replacing table accesses with reenactment queries for previous updates during merging).Test case (put in the appropriate --passwd):