FlameRobin Files

FlameRobin 26.11.0 brings improvements to query plan visibility and legacy Firebird compatibility, fixes an SQL editor zoom-out bug on Linux/X11 caused by a wxWidgets/Scintilla key-code collision, and unifies collection naming across tree view ordering modes.

Highlights

1. SQL Editor & Query Execution Improvements

• Legacy Query Plan Fallback for Firebird 2.5 and Earlier (#753, #754):
• When connected to older Firebird servers (such as Firebird 2.5) where the detailed execution plan API (isc_info_sql_explain_plan / IStatement::getPlan()) is not supported and returns an empty plan or throws an exception, FbCppStatement::getPlan() now automatically falls back to getLegacyPlan() (isc_info_sql_get_plan).

• Restores full visibility into index usage (PLAN (... INDEX (...))) vs. natural table scans (PLAN (... NATURAL)) on Firebird 2.5 and earlier databases.

• Show Prepared Statement Text and Plan Immediately Before Executing (#747):

• Added ExecuteSqlFrame::flushLogView() to synchronously repaint the statistics log (styled_text_ctrl_stats) and query plan tree (tree_query_plan) immediately after logging and before blocking database calls (prepare, execute, transaction start, commit, and rollback).
• Previously, when running a long-running query or script, the "Statement prepared" message and execution plan were appended to the log buffer before execute() was called, but the window remained unpainted and frozen until execution completed. Now the prepared statement text and execution plan are rendered immediately before execution starts.

• Uses wxWindow::Update() rather than wxYield() so only pending paint events are processed without risking re-entrant event handler execution.

• Prevent Unwanted SQL Editor Zoom-Out on Ctrl Shortcuts (#755):

• Fixed an issue on Linux/X11 where pressing Ctrl shortcuts (such as Ctrl+A or Ctrl+C) in setups that emit Caps Lock key-down events while Ctrl is held unexpectedly zoomed out the SQL editor font size.
• Root cause: in wxWidgets (ScintillaWX::DoKeyDown), WXK_CAPITAL (311) is not translated and collides numerically with Scintilla's wxSTC_KEY_SUBTRACT (SCK_SUBTRACT = 311), which Scintilla binds to SCI_ZOOMOUT when Ctrl is held.
• SqlEditor::OnKeyDown and ExecuteSqlFrame::OnKeyDown now consume Ctrl + WXK_CAPITAL key-down events before passing them to wxStyledTextCtrl, preventing unintended zoom changes while preserving legitimate Ctrl + Numpad-Subtract (WXK_SUBTRACT / WXK_NUMPAD_SUBTRACT) and Ctrl + Mouse Wheel zooming.

2. Tree View & Metadata Consistency

• Consistent Collection Naming Across Tree Ordering Modes (#756):
• Fixed inconsistent collection node names in the main tree view when Database objects ordering in tree was set to Firebird DDL / logical order.
• Both alphabetical context-grouped order and logical order now consistently use the same collection captions:
  • Tables [Global Temporary] (instead of Global Temporary Tables)
  • Triggers [Table] (instead of Table Triggers)
  • Triggers [DDL] (instead of DDL Triggers)
  • Triggers [Database] (instead of Database Triggers)

Full Changelog: https://github.com/mariuz/flamerobin/compare/v26.10.1...v26.11.0