Skip to content

FB 6.0. Unable to allocate memory when creating a package containing packaged temporary table with an index #9026

@sim1984

Description

@sim1984
SQL> show version;
ISQL Version: WI-T6.0.0.1948 Firebird 6.0 3fadfab
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T6.0.0.1948 Firebird 6.0 3fadfab"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T6.0.0.1948 Firebird 6.0 3fadfab/tcp (DESKTOP-MCH5AOF)/P20:C"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T6.0.0.1948 Firebird 6.0 3fadfab/tcp (DESKTOP-MCH5AOF)/P20:C"
on disk structure version 14.0
SET TERM ^ ;

CREATE OR ALTER PACKAGE TEST_PKG
AS
BEGIN
  TEMPORARY TABLE T_PUBLIC (
    ID BIGINT NOT NULL,
    F BIGINT
  )
  UNIQUE INDEX IDX_T_PUBLIC_ID ON (ID)
  ON COMMIT DELETE ROWS;
END^

SET TERM ;^
Statement failed, SQLSTATE = HY001
unable to allocate memory from operating system

If the index is removed, the package with the table is created successfully.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions