[Firebird-devel] [FB-Tracker] Created: (CORE-1871) exeption aboute dublicate metadata can be more informative

[Attid (JIRA) <tr...@fi...>]

exeption aboute dublicate metadata can be more informative 
-----------------------------------------------------------

                 Key: CORE-1871
                 URL: http://tracker.firebirdsql.org/browse/CORE-1871
             Project: Firebird Core
          Issue Type: Bug
    Affects Versions: 2.0.3
            Reporter: Attid


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».

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira