Package: mysql-client-5.0 Version: 5.0.21-3 Severity: normal Here's a quick demonstration of the problem:
mysql> create table test(col1 text default NULL, col2 text default NULL, col3 text default NULL); Query OK, 0 rows affected (0.06 sec) mysql> desc test; +-------+------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+------+------+-----+---------+-------+ | col1 | text | YES | | NULL | | | col2 | text | YES | | NULL | | | col3 | text | YES | | NULL | | +-------+------+------+-----+---------+-------+ 3 rows in set (0.00 sec) mysql> INSERT INTO test VALUES (1,'',3); Query OK, 1 row affected (0.01 sec) mysql> INSERT INTO test(col1,col2) VALUES (1,3); Query OK, 1 row affected (0.00 sec) mysql> select * from test; +------+------+------+ | col1 | col2 | col3 | +------+------+------+ | 1 | NULL | 3 | | 1 | 3 | NULL | +------+------+------+ 2 rows in set (0.00 sec) mysql> select * from test where col2 is null or col3 is null; +------+------+------+ | col1 | col2 | col3 | +------+------+------+ | 1 | 3 | NULL | +------+------+------+ 1 row in set (0.03 sec) mysql> \q -- System Information: Debian Release: testing/unstable APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.16.051406 Locale: LANG=en_US.ISO-8859-1, LC_CTYPE=en_US.ISO-8859-1 (charmap=ISO-8859-1) Versions of packages mysql-client-5.0 depends on: ii debianutils 2.16.1 Miscellaneous utilities specific t ii libc6 2.3.6-9 GNU C Library: Shared libraries ii libdbd-mysql-perl 3.0002-2+b1 A Perl5 database interface to the ii libdbi-perl 1.50-2 Perl5 database interface by Tim Bu ii libgcc1 1:4.1.0-4 GCC support library ii libmysqlclient15off 5.0.21-3 mysql database client library ii libncurses5 5.5-2 Shared libraries for terminal hand ii libreadline5 5.1-7 GNU readline and history libraries ii libstdc++6 4.1.0-4 The GNU Standard C++ Library v3 ii libwrap0 7.6.dbs-9 Wietse Venema's TCP wrappers libra ii mysql-common 5.0.21-3 mysql database common files (e.g. ii perl 5.8.8-4 Larry Wall's Practical Extraction ii zlib1g 1:1.2.3-11 compression library - runtime mysql-client-5.0 recommends no packages. -- no debconf information -- Larry Holish <[EMAIL PROTECTED]> -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
