Issue Details (XML | Word | Printable)

Key: CORE-1871
Type: Improvement Improvement
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Attid
Votes: 2
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Exception about duplicated metadata could be more informative

Created: 28/Apr/08 06:54 AM   Updated: 16/Oct/08 10:13 PM
Component/s: Engine
Affects Version/s: 2.0.3
Fix Version/s: None


 Description  « Hide
some exception can be more informative for sample

DO
CREATE INDEX COUNTRY_IDX1 ON COUNTRY (CURRENCY);
CREATE INDEX COUNTRY_IDX1 ON COUNTRY (CURRENCY);
GET
This operation is not defined for system tables. unsuccessful metadata update. STORE RDB$INDICES failed. attempt to store duplicate value (visible to active transactions) in unique index «RDB$INDEX_5»


DO
CREATE generator test;
CREATE generator test;
GET
This operation is not defined for system tables. unsuccessful metadata update. DEFINE GENERATOR failed. attempt to store duplicate value (visible to active transactions) in unique index «RDB$INDEX_11».


DO
CREATE TABLE test(x int, x varchar(30));
GET
This operation is not defined for system tables. unsuccessful metadata update. STORE RDB$RELATION_FIELDS failed. attempt to store duplicate value (visible to active transactions) in unique index «RDB$INDEX_15».

DO
CREATE procedure test (t int) returns (t varchar(30)) AS begin end;
GET
This operation is not defined for system tables. unsuccessful metadata update. STORE RDB$PROCEDURE_PARAMETERS failed. attempt to store duplicate value (visible to active transactions) in unique index «RDB$INDEX_18».

DO
CREATE domain test smallint; CREATE domain test smallint;
GET
This operation is not defined for system tables. unsuccessful metadata update. STORE RDB$FIELDS failed. attempt to store duplicate value (visible to active transactions) in unique index «RDB$INDEX_2».

DO
CREATE TRIGGER country_bi0 FOR country active before INSERT position 0 AS begin /* Trigger text */ end;
CREATE TRIGGER country_bi0 FOR country active before INSERT position 0 AS begin /* Trigger text */ end;
GET
This operation is not defined for system tables. unsuccessful metadata update. DEFINE TRIGGER failed. attempt to store duplicate value (visible to active transactions) in unique index «RDB$INDEX_8».

DO
DECLARE EXTERNAL FUNCTION DIV INTEGER, INTEGER RETURNS DOUBLE PRECISION BY VALUE ENTRY_POINT 'IB_UDF_div' MODULE_NAME 'ib_udf';
DECLARE EXTERNAL FUNCTION DIV INTEGER, INTEGER RETURNS DOUBLE PRECISION BY VALUE ENTRY_POINT 'IB_UDF_div' MODULE_NAME 'ib_udf';
GET
This operation is not defined for system tables. unsuccessful metadata update. DEFINE FUNCTION failed. attempt to store duplicate value (visible to active transactions) in unique index «RDB$INDEX_9».

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Robert Gilland added a comment - 16/Oct/08 10:13 PM
This forces a restore to fail.
It should never fail a restore.
Just whatever task it is, log an error and keep going!