GBAK v5 - Restore from 2.5 - What are BLRs in restored DB will be recreated by GBAK?

[AnatolyLoy]

Context:
During database migration, we catch a case when the stored procedure only works correctly in Firebird 5.0 once recompiled (recreated or altered). We found that BLRs # 1 (after restoration) and # 2 (after recompilation) were differed.
As a solution, we decide to use recompilation of all procedures and triggers as part of the migration process.
However, database metadata also contains other types of BLRs for objects.
So, any BLR not recompiled during database restoration may differ from the BLR created by extracting metadata and creating an empty database.
In FirebirdSQL 5.0, we have the next BLRs:

• Procedures, functions and triggers
  • RDB$PROCEURES.RDB$PROCEDURE_BLR
  • RDB$FUNCTIONS.RDB$FUNCTION_BLR
  • RDB$TRIGGERS.RDB$TRIGGER_BLR
• Views
  • RDB$RELATIONS.RDB$VIEW_BLR
  • RDB$FIELDS.RDB$VALIDATE_BLR
• Domains and columns
  • RDB$FIELDS.RDB$VALIDATION_BLR
  • RDB$FIELDS.RDB$COMPUTED_BLR
• Indices
  • RDB$INDICES.RDB$EXPRESSION_BLR
  • RDB$INDICES.RDB$CONDITION_BLR

Question:
What BLRs are copying during restoration, and what are re-creating by GBAK 5.0?

[aafemt]

No BLR is recreated during restore. Everything is copied as is.

[aafemt]

Yes, BLR and behavior is changed from version to version. That's why migration by gbak is NOT the best way, only the simplest one.

[alexeykovyazin]

@AnatolyLoy Can you please share the metadata (from gbak -b -m) of the original database and example of stored procedure call with differnt behaviour?

[asfernandes]

Yes, BLR and behavior is changed from version to version. That's why migration by gbak is NOT the best way, only the simplest one.

This is incorrect answer. There is no such recommendation.

[aafemt]

There is no word "recommendation" in the quoted message. On purpose.

[AnatolyLoy]

@AnatolyLoy Can you please share the metadata (from gbak -b -m) of the original database and example of stored procedure call with differnt behaviour?

@alexeykovyazin , I made the GDB-file and test script; see the attached archive.
TEST__BLR25_50_BROKEN.zip