Altering procedure parameters can lead to unrestorable database [CORE1592] #2013
Submitted by: mbabuskov (mbabuskov)
Tried with 126.96.36.19910 and 188.8.131.5280
The problem is that FB tracks stored procedure column dependencies,
Database: test.fdb, User: sysdba
Now, backup that database, and when you try to restore it, you would get:
The error message is also wrong, as X1 is not a table, and procedure name is P1.
As I understand, the parameters are recreated at ALTER statement. To fix the problem, Firebird should not allow the ALTER PROCEDURE statements if there are records in RDB$DEPENDENCIES that reference a parameter that is not going to exists after the statement. This would allow to spot the problem at development time and not much later when user tries to restore the backup (can be too late at that point).
The text was updated successfully, but these errors were encountered: