Hi all, I've been using DBI with DBD::Sybase and SQL Server, and discovered a couple of issues. I will be happy to offer a patch if I can get some consensus on what the correct resolutions are:
The DBI docs say that foreign_key_info() can take from 3 to 7 arguments, but the code demands 6 or 7 (even though many of the arguments can be undef). My opinion is that the docs are good and the code is broken. Any objections on this point? Also, at least with SQL Server, foreign_key_info() returns columns named [FP]KTABLE_OWNER and [FP]KTABLE_QUALIFIER instead of [FP]KTABLE_SCHEMA and [FP]KTABLE_CAT. I think the driver should rewrite the column names. Does anybody disagree? Thanks, Kurt Starsinic