FlameRobin Files

FlameRobin 26.11.1

FlameRobin 26.11.1 introduces asynchronous background SQL execution with interactive query cancellation in the SQL Editor, and fixes user list truncation in the Manage Users dialog on servers with large numbers of users.

🚀 Highlights & New Features

1. Asynchronous SQL Execution & Query Cancellation (#752)

• Non-Blocking Background Execution: Standard non-DDL SQL statements (SELECT, INSERT, UPDATE, DELETE, MERGE, EXECUTE BLOCK, and EXECUTE PROCEDURE) now execute on a dedicated wxThreadHelper worker thread (SqlExecutionWorker) rather than blocking the main wxWidgets UI thread. The SQL Editor window remains responsive to repainting, moving, and resizing during long-running queries.
• Live Elapsed Timer & Execution Lock: While a statement is running in the background, the status bar displays a live Executing... (MM:SS) elapsed timer (100 ms update interval) and editor/transaction actions are safely locked to prevent concurrent access to the shared database attachment.
• Cancel Execution (Shift+F4): Added a Cancel Execution toolbar button, menu item (Query -> Cancel Execution), and keyboard shortcut (Shift+F4) that aborts the running query via Firebird's native fb_cancel_operation(fb_cancel_raise) API (IAttachment::cancelOperation), with an automatic fallback to DELETE FROM MON$STATEMENTS WHERE MON$ATTACHMENT_ID = ? on a short-lived auxiliary connection when needed.
• Safe Window Closure & Multi-Statement Handling: Closing the SQL Editor frame while a query is running automatically requests cancellation and waits for the worker thread to finish before destroying the window. Multi-statement scripts automatically advance to the next statement until completion, error, or user cancellation.

🐛 Bug Fixes

2. Full User List Retrieval Beyond 64 KB in Manage Users (#758)

• Fixed isc_info_truncated Handling in FbCppService::getUsers(): Previously, FbCppService::getUsers() issued only a single svc->query call into a 65,535-byte buffer and ignored isc_info_truncated, silently omitting all remaining users once the Firebird Service Manager response exceeded 64 KB (approximately 1,800+ users) and potentially pushing a half-populated trailing user record.
• Multi-Chunk Stream Reassembly: FbCppService::getUsers() now loops svc->query with isc_info_svc_get_users whenever the buffer terminates with isc_info_truncated (or isc_info_data_not_ready / isc_info_svc_timeout), preserving the in-progress UserData struct and any incomplete trailing item bytes across chunk boundaries and only committing the final user after the last untruncated chunk.
• Additional SPB Tag Support: Cleanly handles isc_spb_sec_admin (4-byte int) and isc_spb_sec_groupname (string) tags so buffer offsets remain aligned across all Firebird server versions.

📋 Full Changelog

• e6f0eceb feat(sql): execute SQL statements on background worker thread with Cancel support (#752)
• 38b921e2 Fix Manage Users truncating user list beyond 64 KB (#758)
• 46a78461 Release v26.11.1: Background SQL execution with Cancel support and full >64 KB user list retrieval (#752, (#758))

Full Diff: v26.11.0...v26.11.1