Package: tedia2sql Version: 1.2.12-2 Severity: normal Tags: patch
When using mysql output tedia2sql will produce an partly commented line. It appears that perhaps this line was intended to be entirely commented out, assuming that mysql cannot deal with this syntax. Please find the patch below: perhaps it explains the situation best. Cheers, Nick. --- /usr/bin/tedia2sql 2006-12-03 04:47:40.000000000 +0900 +++ tedia2sql 2008-07-18 09:27:31.000000000 +0900 @@ -2815,9 +2815,9 @@ $return .= $in . "foreign key ($keyColumns)" . $nl; $return .= $in . "references $refTable ($refColumns) $goCommand"; } elsif ($opt_t eq 'mysql' || $opt_t eq 'ingres') { - $return = &sqlComment("alter table $className add constraint $constraintName") . $nl; - $return .= $in . "foreign key ($keyColumns) references" . $nl; - $return .= $in . "$refTable ($refColumns) for $opt_t"; + $return = "alter table $className add constraint $constraintName" . $nl; + $return .= $in . "foreign key ($keyColumns) references" . $nl; + $return .= $in . "$refTable ($refColumns);"; } return $return; -- System Information: Debian Release: lenny/sid APT prefers unstable APT policy: (990, 'unstable'), (500, 'testing'), (500, 'stable'), (1, 'experimental') Architecture: i386 (i686) Kernel: Linux 2.6.24-1-686-bigmem (SMP w/4 CPU cores) Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages tedia2sql depends on: ii libxml-dom-perl 1.44-1 Perl module for building DOM Level ii perl 5.10.0-11.1 Larry Wall's Practical Extraction tedia2sql recommends no packages. -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]