Submitted by: @asfernandes

If the connection charset is different from NONE and the package header is created there, then it's impossible to create the package body.

If the package header is created in the NONE connection charset, then it becomes possible to create its body in any other connection charset.

In order to reproduce you need to connect with any non-NONE charset. Then:

CREATE PACKAGE TEST1 AS
BEGIN
FUNCTION F1(X CHAR(3)) RETURNS CHAR(6) ;
END

runs fine. Commit. Then:

CREATE PACKAGE BODY TEST1 AS
BEGIN
FUNCTION F1(X CHAR(3)) RETURNS CHAR(6)
AS
BEGIN
RETURN X;
END
END

returns the error:

Unsuccessful metadata update.
CREATE PACKAGE BODY TEST1 failed.
Function F1 has a signature mismatch on package body TEST1

If both parts are done with the NONE connection charset, there's no error.

Commits: 7c0ce8c FirebirdSQL/fbt-repository@d2c7f43