FbConnection.GetSchema("ForeignKeyColumns") returns invalid data
----------------------------------------------------------------
Key: DNET-372
URL: http://tracker.firebirdsql.org/browse/DNET-372
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 2.6
Environment: .NET 4.0 with FirebirdSql.Data.FirebirdClient 2.6.0.0
Reporter: Tobias Wolschon
Assignee: Jiri Cincura
Priority: Minor
The meta data collection "ForeignKeyColumns" returns invalid data. There are
wrong values in the REFERENCED_TABLE_NAME and REFERENCED_COLUMN_NAME fields.
They differ from the real foreign key definitions, which I can view with
IBExpert.
I am working on a project, which reads some schema information from a database
and I use the MetaDataCollections for this task. A workaround for this issue is
to use the "IndexColumns" meta data collection, where I can find all needed
data.
I noticed, that the field ORDINAL_POSITION in "IndexColumns" is always 0 and I
think, this is a bug, too. I use the field COLUMN_NAME as a workaround for this.
--
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
------------------------------------------------------------------------------
Enable your software for Intel(R) Active Management Technology to meet the
growing manageability and security demands of your customers. Businesses
are taking advantage of Intel(R) vPro (TM) technology - will your software
be a part of the solution? Download the Intel(R) Manageability Checker
today! http://p.sf.net/sfu/intel-dev2devmar
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
