Bug #26604 | foreign_key_info() implementation | ||
---|---|---|---|
Submitted: | 23 Feb 2007 18:53 | Modified: | 28 Feb 2007 3:21 |
Reporter: | Dave Rolsky | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connectors: DBD::mysql ( Perl ) | Severity: | S3 (Non-critical) |
Version: | OS: | ||
Assigned to: | Jim Winstead | CPU Architecture: | Any |
[23 Feb 2007 18:53]
Dave Rolsky
[23 Feb 2007 23:14]
MySQL Verification Team
Thank you for the bug report and contribution.
[28 Feb 2007 1:26]
Jim Winstead
I've added an implementation of foreign_key_info to the repository, and it will be in the next release (4.002). Your implementation was not correct -- it had the foreign and primary keys switched around, and the wrong field names. I based the final implementation (and tests) on the implementation in our JDBC driver. (Sorry you got caught in the rate-limiting when submitting your patches.)
[28 Feb 2007 3:21]
Dave Rolsky
If you look at the DBI docs, there's two sets of names you can use for the returned data. It'd probably be best to support both.