Skip to content

Cannot insert data into package table with fully qualified name #9143

Description

@AlexBekhtin
RECREATE PACKAGE PACKAGE_WITH_TABLE AS
BEGIN
  TEMPORARY TABLE T_PUB(
    ID INTEGER
  ) ON COMMIT PRESERVE ROWS
  INDEX IDX_T_PUB_ID (ID);
END;

RECREATE PACKAGE BODY PACKAGE_WITH_TABLE AS
BEGIN
END;

INSERT INTO PACKAGE_WITH_TABLE.t_pub values (1); -- Correct
INSERT INTO PUBLIC.PACKAGE_WITH_TABLE.t_pub values (2); 
/*
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 38
-.
*/
-- Both selects are working correctly.
SELECT * FROM PACKAGE_WITH_TABLE.t_pub;
SELECT * FROM PUBLIC.PACKAGE_WITH_TABLE.t_pub;

Firebird-6.0.0.2167

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    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