Package: mysql-server-5.0 Version: 5.0.51a-12 Severity: important when i tried to create a table containing md5 hashes, i encountered in stable and testing a problem supposed to be solved: http://bugs.mysql.com/bug.php?id=14189 in the following table should length(hash) always be 2.
mysql> CREATE TABLE missig_trailing_spaces (hash char(2), expanded char(4)); Query OK, 0 rows affected (0.04 sec) mysql> INSERT INTO missig_trailing_spaces (hash,expanded) VALUES (0x0020,"0020"); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO missig_trailing_spaces (hash,expanded) VALUES (0x0000,"0000"); Query OK, 1 row affected (0.00 sec) mysql> SELECT *,length(hash) FROM missig_trailing_spaces; +------+----------+--------------+ | hash | expanded | length(hash) | +------+----------+--------------+ | | 0020 | 1 | | | 0000 | 2 | +------+----------+--------------+ 2 rows in set (0.00 sec) -- System Information: Debian Release: 4.0 APT prefers stable APT policy: (905, 'stable'), (605, 'testing'), (309, 'unstable'), (305, 'unstable'), (105, 'experimental') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.24-16-generic Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8) Versions of packages mysql-server-5.0 depends on: ii adduser 3.102 Add and remove users and groups ii debconf [debconf-2.0] 1.5.11etch2 Debian configuration management sy ii libc6 2.7-13 GNU C Library: Shared libraries ii libdbi-perl 1.53-1etch1 Perl5 database interface by Tim Bu ii libgcc1 1:4.3.1-9 GCC support library ii libmysqlclient15off 5.0.51a-12 MySQL database client library ii libncurses5 5.6+20080804-1 shared libraries for terminal hand ii libreadline5 5.2-2 GNU readline and history libraries ii libstdc++6 4.3.1-9 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-13 Wietse Venema's TCP wrappers libra ii lsb-base 3.1-23.2etch1 Linux Standard Base 3.1 init scrip ii mysql-client-5.0 5.0.51a-12 MySQL database client binaries ii mysql-common 5.0.51a-12 MySQL database common files ii passwd 1:4.0.18.1-7 change and administer password and ii perl 5.8.8-7etch3 Larry Wall's Practical Extraction ii psmisc 22.3-1 Utilities that use the proc filesy ii zlib1g 1:1.2.3.3.dfsg-12 compression library - runtime Versions of packages mysql-server-5.0 recommends: ii libhtml-template 2.8-1 HTML::Template : A module for usin ii mailx 1:8.1.2-0.20050715cvs-1 A simple mail user agent -- debconf information: mysql-server-5.0/really_downgrade: false mysql-server-5.0/start_on_boot: true mysql-server-5.0/nis_warning: mysql-server-5.0/postrm_remove_databases: false * mysql-server-5.0/need_sarge_compat: false mysql-server/error_setting_password: mysql-server-5.0/need_sarge_compat_done: true mysql-server/password_mismatch: -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]