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]

Reply via email to