[FB-Tracker] Created: (CORE-2736) More user friendly error message for duplicate field names

View: New views
1 Messages — Rating Filter:   Alert me  

[FB-Tracker] Created: (CORE-2736) More user friendly error message for duplicate field names

by JIRA tracker@firebirdsql.org :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

More user friendly error message for duplicate field names
----------------------------------------------------------

                 Key: CORE-2736
                 URL: http://tracker.firebirdsql.org/browse/CORE-2736
             Project: Firebird Core
          Issue Type: Improvement
          Components: Engine
            Reporter: Claudio Valderrama C.


SQL> create table t(a int);
SQL> create view vj1 as select a from t;
SQL> create view vj2 as select * from vj1, vj1;
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-STORE RDB$RELATION_FIELDS failed
-attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_15"

Indeed, this could be any two tables that have fields with the same name. We can do better. The end-user does not know about an index in a system table.


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

       

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel