>Description:
Multiple IS NULL tests in a WHERE clause appear to be broken
when testing NOT NULL date fields. Queries work fine against
varchar and int, probably(?) others.
>How-To-Repeat:
create temporary table test (a date not null, b date not null);
insert into test values (now(), now());
insert into test values (now(), now());
select count(*) from test where a is null or b is null;
The SELECT query should return 0, instead it returns every row
in the table (2 in this case). For what it's worth, the
query returns the right number for int and varchar fields, and
returns the right number if the columns allow null values.
>Fix:
No idea.
>Submitter-Id: No idea.
>Originator: Andrew Houghton
>Organization:
Impact Online, Inc., dba VolunteerMatch
>MySQL support: extended email support
>Synopsis: multiple IS NULL tests in a where clause don't work with NOT NULL date
>columns
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.9-gamma (Official MySQL RPM)
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
System: Linux romeo.impactonline.org 2.4.7-10smp #1 SMP Thu Sep 6 17:09:31 EDT 2001
i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc'
CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jul 30 2002 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x 1 root root 5734914 Jul 22 2002 /lib/libc-2.2.4.so
-rw-r--r-- 1 root root 27335606 Jul 22 2002 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Jul 22 2002 /usr/lib/libc.so
Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static'
'--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb'
'--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile'
'--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock'
'--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr'
'--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share'
'--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info'
'--includedir=/usr/include' '--mandir=/usr/share/man' '--with-embedded-server'
'--enable-thread-safe-client' '--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O6
-fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer
-felide-constructors -fno-exceptions -fno-rtti -mpentium' 'CXX=gcc'
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
