| Subject: | PATCH: foreign_key_info and statistics_info parameter inconsistencies |
primary_key_info, foreign_key_info and statistics_info have different orderings of catalog (for example "master"), schema (for example "dbo") and table.
This patch fixes foreign_key_info and statistics_info to use the same definition of catalog, schema and table as primary_key_info.
| Subject: | dbd_sybase_info.patch |
diff -Naur old/Sybase.pm new/Sybase.pm
--- old/Sybase.pm 2011-10-03 01:56:17.000000000 +1100
+++ new/Sybase.pm 2013-06-10 16:07:06.837185676 +1000
@@ -326,7 +326,7 @@
my $sth =
$dbh->prepare(
-"sp_fkeys $pk_table, $pk_catalog, $pk_schema, $fk_table, $fk_catalog, $fk_schema"
+"sp_fkeys $pk_table, $pk_schema, $pk_catalog, $fk_table, $fk_schema, $fk_catalog"
);
$sth->execute;
@@ -343,7 +343,7 @@
my $sth =
$dbh->prepare(
-"sp_indexes \@\@servername, $table, $catalog, $schema, NULL, $is_unique"
+"sp_indexes \@\@servername, $table, $schema, $catalog, NULL, $is_unique"
);
$sth->execute;