model-writtenrun 5784 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Narek Galstyan reported that COMMIT/ROLLBACK AND CHAIN after a transaction error silently reverted transaction characteristics to defaults, and supplied regression tests plus a fix preserving those characteristics across AbortTransaction() in #1.
- Michael Paquier accepted the report, suggested saving characteristics at function entry for consistency with CommitTransactionCommandInternal(), and asked whether other transaction states needed attention in #2.
- Michael Paquier found a second bug: COMMIT AND CHAIN inside a subtransaction could inherit that subtransaction's READ ONLY setting instead of the top transaction's READ WRITE setting, as demonstrated in #3.
- Michael Paquier's combined revision retained Narek Galstyan's original fix, moved the initial save, added another save after subtransactions commit, and expanded tests for subtransaction COMMIT/ROLLBACK AND CHAIN; the thread ends with his request for comments on that revision in #3.
- The combined revision subsequently landed as 0dbe240dc0, with unchanged code and tests from #3 and only the Backpatch-through trailer changed from 14 to 15.