Package: tedia2sql
Version: 1.2.12-2
Severity: normal
Tags: patch

Since version 5.0 MySQL supports views. tedia2sql should be updated to
accommodate this. The following patch corrects the warnings and impletments
the 'drop view' which was previosly only output in a comment.

Cheers,

Nick.

--- /usr/bin/tedia2sql  2006-12-03 04:47:40.000000000 +0900
+++ tedia2sql   2008-07-23 10:55:58.000000000 +0900
@@ -1199,8 +1199,7 @@
        }
 
        if (($opt_t eq 'mysql' || $opt_t eq 'innodb') && $objectType eq 'view') 
{
-               print $createFileHandle &sqlComment("WARNING! tedia2sql 
currently believes MySQL does not support") . "\n";
-               print $createFileHandle &sqlComment("views, but you're trying 
to create a view here. Expect errors.") . "\n";
+               print $createFileHandle &sqlComment("WARNING: MySQL versions 
prior to 5.0 don't support views.") . "\n";
        }
 
        # the create part
@@ -2884,8 +2883,7 @@
        } elsif ($opt_t eq 'mysql' || $opt_t eq 'innodb') {
                my $toComment;
                if ($objectType eq 'view') {
-                       $toComment  = &sqlComment("MySQL doesn't support views 
yet") . "\n";
-                       $toComment .= &sqlComment(" ");
+                       $toComment  = &sqlComment("WARNING: MySQL versions 
prior to 5.0 don't support views.") . "\n";
                } else {
                        $toComment = '';
                }



-- 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.

Versions of packages tedia2sql suggests:
ii  dia                           0.96.1-7   Diagram editor
ii  dia-gnome                     0.96.1-7   Diagram editor (GNOME version)

-- no debconf information



-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to