Commented by: Segey Khalyutin (notesoft)

on ver 3.0.5 this error too

Commented by: @mrotteveel

I don't think the index is created on the wrong fields (because that index is relevant for TYPE_OF parameters), the problem is there is an index missing.

Commented by: Segey Khalyutin (notesoft)

ok. In our db we add temporary index:

create index RDB$PROC_PARAM on RDB$PROCEDURE_PARAMETERS (RDB$PROCEDURE_NAME, RDB$PARAMETER_NAME);

if it possible, add like index in trunk.

Commented by: @dyemanov

In Firebird index exists on three fields (RDB$PACKAGE_NAME, RDB$PROCEDURE_NAME, RDB$PARAMETER_NAME) and this is correct because all lookups should now consider a package name.

Commented by: @mrotteveel

While tools and people should consider package name, I would argue that a lot of tools (and probably also people) still don't. Maybe it would be better to remove RDB$PACKAGE_NAME from these indexes and give it its own? Or maybe add a separate on RDB$PROCEDURE_NAME as a form of accommodation.

Commented by: @dyemanov

System indices are primarily for speeding Firebird itself, not 3rd party applications. Having RDB$PACKAGE_NAME indexed separately is less optimal. Those who need something different may create custom indices, if required.

Commented by: @hvlad

> In Firebird index exists on three fields (RDB$PACKAGE_NAME, RDB$PROCEDURE_NAME, RDB$PARAMETER_NAME) and this is correct because all lookups should now consider a package name.

Probably it make sence to set RDB$PACKAGE_NAME as last segment in this index ?

Commented by: @asfernandes

To drop/alter a package the better index would be one starting with the package name.