Your message dated Thu, 07 Jun 2012 21:35:31 +0000
with message-id <[email protected]>
and subject line Bug#676403: Removed package(s) from unstable
has caused the Debian Bug report #354660,
regarding tedia2sql: Dies if foreign key constraint refers to non-primary key 
field
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)


-- 
354660: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=354660
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: tedia2sql
Version: 1.2.12-1
Severity: normal
Tags: patch

If a foreign key relation is setup that doesn't refer to the primary
key, I get the following error, and the output file isn't generated:

In association fooFoo a doesn't refer to a primary key or unique index

This occurs even though I have setup a unique index on the target field.
If the name of the index matches the target field name it works, but not
otherwise.

This seems to be because when building the indices it doesn't actually
use the names of the indexed columns for the hash key.

I'm attaching a simple example Dia file, and a patch that fixes this
problem, at least when only one field is involved.

The patch applies cleanly to current CVS as well as to 1.2.12.

-- System Information:
Debian Release: testing/unstable
  APT prefers unstable
  APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.15-1-k7
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)

Versions of packages tedia2sql depends on:
ii  libxml-dom-perl               1.43-4     Perl module for building DOM Level
ii  perl                          5.8.8-2    Larry Wall's Practical Extraction 

tedia2sql recommends no packages.

-- no debconf information

Attachment: foo.dia
Description: Binary data

--- /usr/bin/tedia2sql  2005-02-16 14:27:31.000000000 -0600
+++ tedia2sql   2006-02-27 16:27:50.284442947 -0600
@@ -923,6 +923,8 @@
                                ];
                        }
 
+                       $paramString = join(',', @$paramDescs);
+
                        if ($verbose) { print " * Got operation: $operName / 
$operType / ($paramString) / ($operTemplate)\n"; }
                        push @$operationDescs, [ $operName, $operType,
                                                 $paramDescs, $operTemplate,

--- End Message ---
--- Begin Message ---
Version: 1.2.12-3+rm

Dear submitter,

as the package tedia2sql has just been removed from the Debian archive
unstable we hereby close the associated bug reports.  We are sorry
that we couldn't deal with your issue properly.

For details on the removal, please see http://bugs.debian.org/676403

The version of this package that was in Debian prior to this removal
can still be found using http://snapshot.debian.org/.

This message was generated automatically; if you believe that there is
a problem with it please contact the archive administrators by mailing
[email protected].

Debian distribution maintenance software
pp.
Luca Falavigna (the ftpmaster behind the curtain)


--- End Message ---

Reply via email to