Your message dated Wed, 23 Jul 2008 23:32:08 +0000 with message-id <[EMAIL PROTECTED]> and subject line Bug#491267: fixed in tedia2sql 1.2.12-3 has caused the Debian Bug report #491267, regarding tedia2sql: foreign key bug with mysql output 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.) -- 491267: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=491267 Debian Bug Tracking System Contact [EMAIL PROTECTED] with problems
--- Begin Message ---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
--- End Message ---
--- Begin Message ---Source: tedia2sql Source-Version: 1.2.12-3 We believe that the bug you reported is fixed in the latest version of tedia2sql, which is due to be installed in the Debian FTP archive: tedia2sql_1.2.12-3.diff.gz to pool/main/t/tedia2sql/tedia2sql_1.2.12-3.diff.gz tedia2sql_1.2.12-3.dsc to pool/main/t/tedia2sql/tedia2sql_1.2.12-3.dsc tedia2sql_1.2.12-3_all.deb to pool/main/t/tedia2sql/tedia2sql_1.2.12-3_all.deb A summary of the changes between this version and the previous one is attached. Thank you for reporting the bug, which will now be closed. If you have further comments please address them to [EMAIL PROTECTED], and the maintainer will reopen the bug report if appropriate. Debian distribution maintenance software pp. Leo Costela <[EMAIL PROTECTED]> (supplier of updated tedia2sql package) (This message was generated automatically at their request; if you believe that there is a problem with it please contact the archive administrators by mailing [EMAIL PROTECTED]) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Format: 1.8 Date: Thu, 24 Jul 2008 00:27:12 +0200 Source: tedia2sql Binary: tedia2sql Architecture: source all Version: 1.2.12-3 Distribution: unstable Urgency: low Maintainer: [EMAIL PROTECTED] Changed-By: Leo Costela <[EMAIL PROTECTED]> Description: tedia2sql - Converts a Dia diagram to various SQL dialects Closes: 491267 491989 Changes: tedia2sql (1.2.12-3) unstable; urgency=low . * debian/patches: add patches to modify warning about MySQL and View (closes: #491989) and to uncomment "alter table" on contraint addition for MySQL (closes:#491267) * debian/rules,debian/compat,debian/control: bump debhelper version to 5 * debian/control: - add Homepage field - policy 3.8.0 (no changes) * debian/rules: revamp and cleanup Checksums-Sha1: a8287db6e387901ba779f08cbea0477781082b0e 999 tedia2sql_1.2.12-3.dsc 7cd76bea27e043f5c4ae912cb677d641052236f1 4302 tedia2sql_1.2.12-3.diff.gz fd73ae87ef250071463084a3daa63beaec3b6b68 77826 tedia2sql_1.2.12-3_all.deb Checksums-Sha256: 55a3a2c931aabe1819a4275175c9a839a1257ef9e0905d2ec6162c60443c886c 999 tedia2sql_1.2.12-3.dsc edfb06dd060799dbaa00dfb20080736f5365c210ac697cc6d2a322edba7cbd64 4302 tedia2sql_1.2.12-3.diff.gz 57aac6201edc87d2175d989074c72f1a0a5266c86002a357f669d2013b476e3e 77826 tedia2sql_1.2.12-3_all.deb Files: 2775740783589c4a583a1a4ccd725bcc 999 graphics optional tedia2sql_1.2.12-3.dsc 815db9ded958e39af4b83626b297235a 4302 graphics optional tedia2sql_1.2.12-3.diff.gz 72fb3fc76b394220bd5b8fa46101001e 77826 graphics optional tedia2sql_1.2.12-3_all.deb -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkiHvEwACgkQImLTb3rflGaGqwCgqu7OuEHfYpbKoGjUcM698UBX 1XUAniNmgd2nA8G5zaDM247trdIGSzEC =J6uN -----END PGP SIGNATURE-----
--- End Message ---
