System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 1ec39fe4bdebcd69f5b0c22a9fd5950904b8840d
Title: SQLiteConnection.GetSchema ForeignKeys metadata collection returns incorrect FK constraint names
Status: Open Type: Feature_Request
Severity: Minor Priority: Medium
Subsystem: Connection Resolution: Not_Backwards_Compatible
Last Modified: 2013-07-19 22:16:12
Version Found In: 1.0.87.0
User Comments:
anonymous added on 2013-07-12 04:53:44:
The result set returned by calling SQLiteConnection.GetSchema for the ForeignKeys metadata collection contains a column called CONSTRAINT_NAME, which should be populated with the named constraint identifier.  For composite foreign keys, this table should contain one row per column reference, but all rows pertaining to the same foreign key should have the same constraint name.  Instead, a mangled name is being returned, resulting in multiple references within the same constraint appearing as separate constraints.

Workaround: The FKEY_ID column appears to be correctly populated, allowing one to identify all rows for the same foreign key, for a given table.

mistachkin added on 2013-07-15 04:14:59:
Changing to feature request.