Bug #6926 IN(NULL) on date column

• Submitted: 1 Dec 2004 21:06
• Modified: 1 Dec 2004 21:25
• Reporter: Rénald CASAGRAUDE
• Status: Can't repeat
• Category: MySQL Server: MyISAM storage engine
• Severity: S1 (Critical)
• Version: 4.1.7
• OS: Linux (Linux i686)
• CPU Architecture: Any

[1 Dec 2004 21:06] Rénald CASAGRAUDE

Description:
When you select fields putting your condition on a DATE column using `date_column_name` IN(NULL), MySQL crash.

How to repeat:
Using latin1_swedish collation

CREATE TABLE `bug` (
`date` DATE NOT NULL
);

SELECT COUNT(*) FROM `bug` WHERE `date` IN(NULL);

This last query conduct to a server crash.

Suggested fix:
No idea, sorry

[1 Dec 2004 21:25] MySQL Verification Team

I tested it with latest 4.1 BK source and the server not crashes:

miguel@hegel:~/dbs/4.1$ bin/mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.8-debug-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE TABLE `bug` (
    -> `date` DATE NOT NULL
    -> );
Query OK, 0 rows affected (0.06 sec)

mysql> 
mysql> SELECT COUNT(*) FROM `bug` WHERE `date` IN(NULL);
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+
1 row in set (0.05 sec)