TYPE OF COLUMN does not support rdb$db_key

[EPluribusUnum]

Hi *!

CREATE OR ALTER PROCEDURE test
RETURNS (
    db_key TYPE OF COLUMN rdb$database.rdb$db_key)
AS
BEGIN
END

Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 3, column 40.
rdb$db_key

Thank you!

[asfernandes]

rdb$db_key is not a normal column.
This is not a bug nor a thing I would support.

[aafemt]

I see neither PR nor commit that implement this feature. Where it is?

[aafemt]

I disagree. Both RDB$DB_KEY and RDB$RECORD_VERSION are perfectly valid select expressions that return values of definite types. These types in PSQL code can be assigned to variables or parameters and these variables must be declared with corresponding types. TYPE OF COLUMN is purposed exactly for such cases.

[aafemt]

@EPluribusUnum If you don't mind testing work-in-progress, you can try artifacts from #8947. Usage of type of column x.rdb$db_key should work there in all cases (including reference to complex views) except for functions' parameters.

If core developers change their mind and reopen this ticket, I can continue the development.

[EPluribusUnum]

@aafemt , tested with 5.0.4.1784, the error is the same.