On Fri, 15 Aug 2003, Richard Froud wrote:
> Please enter a FULL description of your problem:
> ------------------------------------------------
> When reading database metadata for foreign keys using the JDBC
> DatabaseMetaData.getImportedKeys() and DatabaseMetaData.getExportedKeys()
> methods the ON UPDATE rule is returned as the ON DELETE rule. It is also
> correctly returned as the ON UPDATE rule. Therefore there is no way to
> access the ON DELETE rule. Consequenntly innaccurate representations of the
> database structure are obtained.
Here is a patch for this. Additionally the on delete rule would not
return importedKeyRestrict because of a missing if statement. Also an
addition to the test suite is attached.
Kris Jurka