Semantic inconsistency between IANA names and fixed offsets in TIMESTAMP WITH TIME ZONE
In Firebird 4.0+, the TIMESTAMP WITH TIME ZONE type allows for storage using both numeric UTC offsets and IANA region names (e.g., 'Europe/Berlin'). While the engine normalizes these values to UTC for comparison and sorting purposes, the long-term behavior differs significantly based on the input format. When an IANA region name is stored, the engine evaluat