Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

FbConnection.GetSchema("ForeignKeyColumns") returns invalid data [DNET372] #377

Closed
firebird-automations opened this issue Mar 23, 2011 · 6 comments

Comments

@firebird-automations
Copy link

Submitted by: Tobias Wolschon (t.wolschon)

Is duplicated by DNET295

Attachments:
DNET-372.patch

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.

Commits: 440fdb5

@firebird-automations
Copy link
Author

Commented by: Gareth Goslett (gareth)

I have been using something similar to this fix for a while now, I recently updated from trunk and had to redo the changes.

@firebird-automations
Copy link
Author

Modified by: Gareth Goslett (gareth)

Attachment: DNET372.patch [ 12135 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: vNext [ 10466 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Link: This issue duplicates DNET295 [ DNET295 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Link: This issue is duplicated by DNET295 [ DNET295 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Link: This issue duplicates DNET295 [ DNET295 ] =>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants