Skip to content

SHOW DEPENDENCIES command terminates unexpectedly if there are packages in the dependencies #8665

@sim1984

Description

@sim1984

Test database:

create database 'inet4://localhost:3056/test'
user "SYSDBA" password 'masterkey'
page_size 8192 default character set utf8;

CREATE TABLE TEST (
  ID BIGINT GENERATED BY DEFAULT AS IDENTITY,
  A INT,
  CONSTRAINT PK_TEST PRIMARY KEY(ID)
);

SET TERM ^ ;

CREATE OR ALTER package pkg_test
as
begin
  function get_a(id bigint) returns int;
end^

RECREATE package body pkg_test
as
begin
  function get_a(id bigint) returns int
  as
  begin
    return (select a from test where id = :id);
  end
end^

SET TERM ; ^

The test itself:

c:\Firebird\6.0>isql inet://localhost:3056/test -user SYSDBA -password masterkey -ch utf8
Database: inet://localhost:3056/test, User: SYSDBA
SQL> show depen TEST;

c:\Firebird\6.0>

Please note that not only are the dependencies not displayed, but the isql session is terminated immediately.

In firebird.log there are only such entries:

DESKTOP-NO2H8I1	Wed Jul 23 08:53:42 2025
	INET/inet_error: read errno = 10054, client host = desktop-no2h8i1, address = ::1/51703, user = denis

Metadata

Metadata