[debian-mysql] Bug#465795: mysql-server-5.0: SELECT string IN (col_subquery) does not match while it should

[Frédéric Brière]

Package: mysql-server-5.0
Version: 5.0.32-7etch5
Severity: normal

This happens in etch as well as in sid:

  mysql> CREATE TABLE test (foo VARCHAR(255));
  mysql> INSERT INTO test VALUES ('1234');
  mysql> SELECT '1234' IN (SELECT foo FROM test);
  0
  mysql> SELECT 1234 IN (SELECT foo FROM test);
  1
  mysql> SELECT '1234' = ANY (SELECT foo FROM test);
  0
  mysql> SELECT '1234' = ALL (SELECT foo FROM test);
  1

All queries should return 1, shouldn't they?


-- System Information:
Debian Release: lenny/sid
  APT prefers unstable
  APT policy: (1001, 'unstable')
Architecture: i386 (i686)

Kernel: Linux 2.6.18 (SMP w/1 CPU core)
Locale: LANG=en_CA.UTF-8, LC_CTYPE=en_CA.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash