ACTUAL RESULT

• Procedures input and output parameters do not support TYPE OF COLUMN:

ALTER PROCEDURE USER_SEARCH (
ID BIGINT )
RETURNS (
USER_NAME VARCHAR(32),
FIRST_NAME VARCHAR(32),
LAST_NAME VARCHAR(32),
SITE_ID BIGINT,
DBA TYPE OF VISIBLE,
KEEPALIVE_TIME TIMESTAMP,
VISIBLE TYPE OF VISIBLE,
FULL_NAME VARCHAR(100) )

EXPECTED RESULT

• Procedures input and output parameters should support TYPE OF COLUMN:

ALTER PROCEDURE USER_SEARCH (
ID TYPE OF COLUMN USERS.ID )
RETURNS (
USER_NAME TYPE OF COLUMN USERS.USER_NAME,
FIRST_NAME TYPE OF COLUMN USERS.FIRST_NAME,
LAST_NAME TYPE OF COLUMN USERS.LAST_NAME,
SITE_ID TYPE OF COLUMN USERS.SITE_ID,
DBA TYPE OF COLUMN USERS.DBA,
KEEPALIVE_TIME TYPE OF COLUMN USERS.KEEPALIVE_TIME,
VISIBLE OF COLUMN USERS.VISIBLE,
FULL_NAME TYPE OF COLUMN USERS.FULL_NAME )

STEPS TO REPRODUCE THIS ISSUE
1- Create a Firebird 3.0 database with the following DDL instruction: FB30_DDL.txt

• ISSUE 1:
  Right mouse click on USER_SEARCH procedure and then select Alter; input and output parameters are not showed as TYPE OF COLUMN
• ISSUE 2:
  Double mouse click on USER_SEARCH procedure to Open the procedure property; input and output parameters are not showed as TYPE OF COLUMN.

IMPORTANT NOTES
For more details about the Use of Column Type in Declarations please check:
https://firebirdsql.org/file/documentation/html/en/refdocs/fblangref25/firebird-25-language-reference.html#fblangref25-ddl-proc-paramscoltype