Hello-
I believe this bug was not fixed in version 5.0.22. I'm still seeing the
problem:
mysql> CREATE TABLE test(col1 text, col2 int, col3 char);
Query OK, 0 rows affected (0.00 sec)
mysql> desc test;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| col1 | text | YES | | NULL | |
| col2 | int(11) | YES | | NULL | |
| col3 | char(1) | YES | | NULL | |
+-------+---------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> INSERT INTO test VALUES ('abc',4,'');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO test VALUES ('',0,'Z');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO test VALUES (NULL,1,'Y');
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM test;
+------+------+------+
| col1 | col2 | col3 |
+------+------+------+
| abc | 4 | NULL |
| NULL | 0 | Z |
| NULL | 1 | Y |
+------+------+------+
3 rows in set (0.00 sec)
mysql> SELECT * FROM test WHERE col3 IS NULL;
Empty set (0.00 sec)
mysql> SELECT * FROM test WHERE col1 IS NULL;
+------+------+------+
| col1 | col2 | col3 |
+------+------+------+
| NULL | 1 | Y |
+------+------+------+
1 row in set (0.00 sec)
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)
libmysqlclient15off 5.0.22-3 mysql database client
library
mysql-client-5.0 5.0.22-3 mysql database client
binaries
mysql-common 5.0.22-3 mysql database common files
(e.g. /etc/mysql/my.cnf)
mysql-server 5.0.22-3 mysql database server
(current version)
mysql-server-5.0 5.0.22-3 mysql database server
binaries
--
Larry Holish
<[EMAIL PROTECTED]>
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
