FlameRobin Files

FlameRobin 26.9.2 Release Notes

FlameRobin v26.9.2 is a maintenance release delivering key bug fixes for Global Temporary Table (GTT) index management, DDL metadata synchronization, and multi-monitor window visibility recovery.

Highlights & Key Improvements

1. Global Temporary Table Index and DDL UI Synchronization Fix (#715)

• Live Index Visibility: Fixed an issue where creating (CREATE [UNIQUE] [ASC[ENDING] | DESC[ENDING]] INDEX ... ON <gtt_table>) or dropping indexes on Global Temporary Tables (GTTable) did not reflect in the database tree or table properties until manual disconnect and reconnect.
• Unified Relation Resolution: Updated committed SQL DDL parsing (Database::parseCommitedSql) to resolve all relation types (tables, GTTs, and views) via Database::findRelation().
• Database-Level Index Lookups: Synchronized database-level index lookup collections (usrIndicesM and sysIndicesM) in Database::addObject and Database::dropObject so newly created and dropped indexes on GTTs are immediately indexed and searchable.
• DDL Classification & Invalidation: Recognized CREATE GLOBAL TEMPORARY TABLE DDL statements as ntGTT in SqlStatement and ensured GTTable relations and their columns are properly invalidated upon ALTER TABLE / ALTER DOMAIN statement commits.
• Dependencies & Utilities: Extended relation and table dependency lookups and data grid helpers across MetadataItem::getDependencies, Relation::getDependentChecks, Table::tablesRelate, and IncompleteStatement::getColumnsForObject to support GTTs seamlessly.
• Automated Test Coverage: Added gtt_index_test unit test suite verifying GTTable index creation, drop handling, and observer cache invalidation.

2. Preferences and Dialog Window Multi-Monitor Recovery Fix (#716)

• Multi-Monitor Coordinate Validation: Fixed an issue where modal dialogs (including the Preferences dialog) and frames became completely invisible or opened off-screen when disconnected from an external monitor or switched from a multi-monitor setup to a single screen.
• Display Geometry Detection: Integrated wxDisplay multi-monitor intersection checks in BaseDialog::readConfigSettings() and BaseFrame::readConfigSettings(). When saved geometry is determined to be outside all connected displays, windows automatically fall back to centering on the parent window / primary display (Centre(wxCENTER_FRAME | wxBOTH)).
• Boundary Clamping: Implemented boundary clamping across all display edges so window title bars, resize handles, and interactive elements always remain accessible on the active screen.

Full Commit Log since v26.9.1

• a746e12d Release v26.9.2: Fix GTT index UI refresh and multi-monitor window visibility (#715, [#716])