[debian-mysql] Bug#454227: mysql-server-5.0: 'null' is shown as type of fields for view with bad definer, breaks mysqldump

[Andrea Briganti]

Package: mysql-server-5.0
Version: 5.0.45-1+lenny1
Severity: normal

According to this link http://bugs.mysql.com/bug.php?id=31662 :

"if a view is created with invalid definer (or a definer gets removed),
DESCRIBE shows
field types as 'null'.
As field types are reused later by  mysqldump, invalid stub table
entries are placed to
dumps afterwards:

/*!50001 CREATE TABLE `a` (
  `xx` null
) */;

This renders mysqldumps not executable."

mysql >= 5.0.52 is not affected by this bug.

If you want to fix this into the current debian release, then you can
apply this patch:

http://lists.mysql.com/commits/36404

Best regards.

-- System Information:
Debian Release: lenny/sid
  APT prefers testing
  APT policy: (650, 'testing'), (600, 'unstable'), (500, 'stable'), (1, 'experimental')
Architecture: i386 (i686)

Kernel: Linux 2.6.23.1-kbytelnx (SMP w/2 CPU cores; PREEMPT)
Locale: LANG=it_IT.UTF-8, LC_CTYPE=it_IT.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages mysql-server-5.0 depends on:
ii  adduser                 3.105            add and remove users and groups
ii  debconf [debconf-2.0]   1.5.17           Debian configuration management sy
ii  libc6                   2.7-3            GNU C Library: Shared libraries
ii  libdbi-perl             1.601-1          Perl5 database interface by Tim Bu
ii  libgcc1                 1:4.2.2-3        GCC support library
ii  libmysqlclient15off     5.0.45-1+lenny1  MySQL database client library
ii  libncurses5             5.6+20071013-1   Shared libraries for terminal hand
ii  libreadline5            5.2-3            GNU readline and history libraries
ii  libstdc++6              4.2.2-3          The GNU Standard C++ Library v3
ii  libwrap0                7.6.dbs-14       Wietse Venema's TCP wrappers libra
ii  lsb-base                3.1-24           Linux Standard Base 3.1 init scrip
ii  mysql-client-5.0        5.0.45-1+lenny1  MySQL database client binaries
ii  mysql-common            5.0.45-1+lenny1  MySQL database common files
ii  passwd                  1:4.0.18.1-11    change and administer password and
ii  perl                    5.8.8-12         Larry Wall's Practical Extraction 
ii  psmisc                  22.5-1           Utilities that use the proc filesy
ii  zlib1g                  1:1.2.3.3.dfsg-6 compression library - runtime

Versions of packages mysql-server-5.0 recommends:
ii  mailutils [mailx]        1:1.1+dfsg1-3.1 GNU mailutils utilities for handli

-- debconf information excluded

-- 
| /
| \Byte - Andrea Briganti - kbyte at despammed.com
http://kbytesys.altervista.org - ICQ: 40872731
CSLug member: http://cslug.linux.it - JID: kbyte at jabber.linux.it
*** Un errore di lancio o puntamento rende la bomba intelligente stupida