I'm using XE7 & FB 2.5.4.
I want to use CommitRetaining instead of Commit for each transcantion. I have activated this option:

db.TxOptions.StopOptions:= db.TxOptions.StopOptions + [xoFinishRetaining];

but when I open a query the application goes into infinite loop. This is the log from the monitor:

..
Commit [ConnectionDef="", Retaining=True]
Commit [ConnectionDef="", Retaining=True]
Commit [ConnectionDef="", Retaining=True]
Commit [ConnectionDef="", Retaining=True]
..

I attach the minimal example that duplicates the behavior [https://drive.google.com/open?id=0B66zhuObV8pxcXhmaGVUSVFSczA]
Why do I get this behavior?

Edited by: Andrea Bettin on Jul 4, 2016 7:26 AM