[Info-ingres] AUTOCOMMIT OFF ignored by tm

[Paul White]

On Tuesday, February 14, 2023 at 7:19:47 PM UTC+10, G Jones wrote:
> My take on this: The error rolls back the failing statement, \nocontinue is set so processing terminates, with II_TM_EXIT_ON_ERROR not set to 'rollback' an implicit commit is issued as tm exits. 
> GJ

Thanks Geraint,
I will be looking to change the default behaviour to align with other mainstream DBMS scripting languages.  It would be great if the behaviour matched the documentation.

In my opinion, an explicit transaction which fails needs to rollback.  In some circumstances I choose AUTOCOMMIT ON expecting the last completed statement to have automatically committed.
More on this when I have time to play...
Paul