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-julyFirebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel