|Title:||SQLiteConnection.GetSchema ForeignKeys metadata collection returns incorrect FK constraint names|
|Last Modified:||2013-07-19 22:16:12|
|Version Found In:||126.96.36.199|
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.