dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
40.6k stars 3.5k forks source link

Empty source when showing metadata of UDR (external Stored Procedure) #34039

Open tonne1 opened 6 months ago

tonne1 commented 6 months ago

Description

Metadata of UDRs (user defined routines) is not extracted, in this case metadata of external Stored Procedures.

DBeaver Version

Community Edition 24.0.5

Operating System

Win10, Win11

Database and driver

  1. Firebird 4, Firebird 5
  2. org.firebirdsql.jdbc:jaybird:RELEASE 5.0.4.java11

Steps to reproduce

Not as easy as with external stored functions, since there are no external stored procedures shipped with a Firebird installation. This system table query gives an idea of what to look for:

select trim(rdb$procedure_name) name, trim(rdb$engine_name) engine, trim(rdb$entrypoint) entrypoint
from rdb$procedures
where rdb$engine_name = 'UDR'

The outcome of metadata extraction should be something like this:

CREATE PROCEDURE WRITE_TXT (
    TEXT blob sub_type 1 NOT NULL,
    FILE_NAME varchar(500) NOT NULL,
    "MODE" varchar(10) NOT NULL )
RETURNS (
    STATUS varchar(100) )
EXTERNAL NAME 'pascaludr!write_txt' 
ENGINE UDR

similar to the extraction of external stored functions.

Additional context

No response

E1izabeth commented 6 months ago

Thank you for bug report.