Problem with TransactionHandling:Autonomous folders and SQL Server

[crimpeline]

I am having an issue with running grate in a SQL Server transaction with a mix of TransactionHandling:Autonomous and TransactionHandling:Default folders.

my folders.txt is like this:

DB_Update_Helper=path:00_DB_Update_Helper,type:EveryTime,TransactionHandling:Autonomous;

Stored_Procedures=path:09_Stored_Procedures,type:AnyTime,TransactionHandling:Default;

Cleanup=path:50_Cleanup,type:EveryTime,TransactionHandling:Autonomous;

When I run grate with '--trx false' it works fine and records the running of all scripts in the grate.ScriptsRun table. On subsequent runs only the scripts in Stored_Procedures which have changed are run.

But when I run it in a transaction with '--trx true', it only records the running of the scripts from the two TransactionHandling:Autonomous folders in the grate.ScriptsRun table. So on subsequent runs all scripts in the the AnyTime folder Stored_Procedures are run again even though they have not changed.

It also works fine when running with '--trx true' if all the folders are either TransactionHandling:Autonomous or TransactionHandling:Default. It is only when there is a mix that the script runs from the TransactionHandling:Default folders are not recorded in grate.ScriptsRun.

TIA for any help.