FlameRobin Files

FlameRobin 26.9.0 Release Notes

FlameRobin v26.9.0 is a maintenance and quality-of-life release delivering critical fixes for result grid navigation, SQL keyword resolution, database object searching, and default transaction isolation preferences.

Highlights & Key Improvements

1. Data Grid Last Row Navigation on Partial Result Sets (#706)

• Instant Full Result Navigation: Fixed an issue where pressing Ctrl+End (or Ctrl+Shift+End) on a result set only jumped to the end of the currently fetched in-memory chunk (e.g. row 99 or 199) and only retrieved the next 100 rows incrementally.
• Synchronous Full Retrieval: Added DataGridTable::fetchAllSynchronous() and updated DataGrid::OnKeyDown() to synchronously fetch all remaining records from the database stream before passing navigation to wxGrid, enabling direct jump and selection straight to the true final row (e.g. row 3,703).
• Automated Test Coverage: Added automated regression testing in DataGridFetchTest simulating multi-batch retrieval on large datasets.

2. OFFSET Reserved Word & Keyword Recognition (#707)

• Modern Firebird Keyword Defaulting: Fixed an issue where OFFSET (and other Firebird 3.0+ keywords such as BOOLEAN, DECFLOAT, INT128, LATERAL, LOCKED, etc.) were not recognized as reserved words during unversioned identifier checks (Identifier::needsQuoting()) or in unattached SQL editor windows.
• Updated Fallback: Corrected SqlTokenizer::normalizeKeywordVersion() so unversioned lookups default to modern Firebird (FB 5.0 / ODS 13.1) instead of legacy Firebird 2.5, ensuring proper SQL quoting and editor syntax highlighting.
• Automated Test Coverage: Added test cases in SqlTokenizerTest verifying OFFSET reserved word status across version targets (FB 2.5, 3.0, 4.0, 5.0, 6.0).

3. Database Object Tree Search for Collapsed/Unloaded Metadata (#708)

• Seamless Tree Search Traversal: Fixed an issue where typing into the search bar failed to find tables, views, procedures, triggers, domains, generators, and other database objects unless their parent folders had already been manually expanded in the tree.
• Dynamic Child Population: Implemented DBHTreeControl::ensureNodeChildrenCreated() to populate child tree nodes dynamically during forward and backward search traversal while keeping folders visually collapsed until a match is selected and revealed via EnsureVisible().
• Connection Safeguards: Preserved connection safety by ensuring disconnected databases are never automatically connected during search typing.

4. Default Transaction Isolation Mode in Preferences (#705)

• Preferences Radio Box Default Retention: Fixed a bug where opening the Preferences dialog on clean installations displayed the Transaction Isolation Mode radio box as Consistency isolation mode (index 0) instead of Concurrency isolation mode (index 1).
• Confdef Parsing Fix: Updated PrefDlgRadioboxSetting::setDefault() to retain non-negative default indices defined before <option> tags in .confdef XML definitions so that FlameRobin's standard Concurrency default is properly applied.

Full Commit Log since v26.8.9

• 85a31567 Release v26.9.0: Bug fixes for data grid navigation, OFFSET reserved word, metadata tree search, and default transaction isolation mode (#705, [#706], [#707], [#708])
• c42cab1a Fix Concurrency not selected as default Transaction Isolation Mode in Preferences (Fixes [#705])
• 8b32ad6c Fix database object search failing when metadata folders are collapsed (Fixes [#708])
• 5b0ec7ce Fix OFFSET and FB 3.0+ keywords not recognized as reserved words by default (Fixes [#707])
• b00a63e4 Fix unable to go to last row on partial result sets with Ctrl+End (Fixes [#706])