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
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
