Subject | Switch back from Firebird 3.0.X to 2.5.X |
---|---|
Author | |
Post date | 2017-06-29T15:37:58Z |
Because of the new behaviour of Firebird 3.0.X regarding explicit nested inner joins (where in the "on" part, a reference to a table column on a higher level in the hierarchy is not allowed anymore), I want to switch back to Firebird 2.5.x. I made a transportable backup from the 3.0 database, but got an error restoring this backup with Firebird 2.5.x:
Connecting to server localhost...
Database restore started 17:23:28
gbak:opened file D:\FIREBIRD_3_0.fbk
gbak:transportable backup -- data in XDR format
Database restore canceled 17:23:28 due to IBPP exception:
*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed
SQL Message : -901
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
Engine Code : 336330796
Engine Message :
Expected backup version 1..9. Found 10
Exiting before completion due to errors
Connecting to server localhost...
Database restore started 17:23:28
gbak:opened file D:\FIREBIRD_3_0.fbk
gbak:transportable backup -- data in XDR format
Database restore canceled 17:23:28 due to IBPP exception:
*** IBPP::SQLException ***
Context: ServiceImpl::Wait
Message: isc_service_query failed
SQL Message : -901
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
Engine Code : 336330796
Engine Message :
Expected backup version 1..9. Found 10
Exiting before completion due to errors
Backup was made and restored with FlameRobin.