Multiple windows to same DB causes transactions to be committed immediately

[mikethm]

• Sequel Ace Version (including build number): Version 4.0.7 Build 20050
• Sequel Ace Source (App Store/GitHub/Homebrew): App store
• macOS Version: 13.4.1
• Processor Type (Intel/Apple): Apple
• MySQL Version: 8.0.28
• macOS Localization: US English

Description
A clear and concise description of what the bug is.

Steps To Reproduce
Open same database in different windows.
do an update SQL statement inside a transaction, rollback.
the update was still applied.
close one window.
do an update inside a transaction, rollback.
the update is rolled back

Expected Behaviour
rollback should rollback transaction even if multiple windows open

[Jason-Morcos]

Hmmm
Are you certain this is happening? After rolling back, have you reloaded the windows to ensure that they have the latest content?

Transaction rollback should be an atomic process handled by the database itself - it seems unlikely that having sequel ace opening multiple windows should impact this (although it is possible windows might have cached content that would need to be refreshed)