Your message dated Mon, 26 Mar 2012 12:59:38 -0400 with message-id <[email protected]> and subject line Re: Bug#465795: mysql-server-5.0: SELECT string IN (col_subquery) does not match while it should has caused the Debian Bug report #465795, regarding mysql-server-5.0: SELECT string IN (col_subquery) does not match while it should to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 465795: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=465795 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---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
--- End Message ---
--- Begin Message ---On Thu, Feb 14, 2008 at 04:44:14PM -0500, Frédéric Brière wrote: > 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? They now do, even on squeeze. This was probably fixed a long time ago. -- < jaybonci> actually d-i stands for "divine intervention" ;) -- in #debian-devel
--- End Message ---
