[debian-mysql] Bug#497256: mysql-server-5.0: trailing space ignored

[Michael Stransky]

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: