Bug #26685 MySQL server crashes with STR_TO_DATE(NULL,NULL)

• Submitted: 27 Feb 2007 15:08
• Modified: 27 Feb 2007 21:17
• Reporter: Victor de Buen
• Status: Can't repeat
• Category: MySQL Server: General
• Severity: S1 (Critical)
• Version: MySQL 5.0.18
• OS: Windows (Windows)
• CPU Architecture: Any

[27 Feb 2007 15:08] Victor de Buen

Description:
A query containing STR_TO_DATE(NULL,NULL) cause MySQL Windows server crashes. 
A friend that has the Linux server tried to reproduce this problem, but it worked fine.

How to repeat:
Run this query from mysql console

select STR_TO_DATE(NULL,NULL) from dual

[27 Feb 2007 15:24] MySQL Verification Team

Thank you for the bug report. Please upgrade to latest MySQL version.

C:\mydb>bin\mysql -uroot -P3307
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.27-community-nt MySQL Community Edition (GPL)

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

mysql> select STR_TO_DATE(NULL,NULL) from dual;
+------------------------+
| STR_TO_DATE(NULL,NULL) |
+------------------------+
| NULL                   |
+------------------------+
1 row in set (0.03 sec)

mysql> select version();
+---------------------+
| version()           |
+---------------------+
| 5.0.27-community-nt |
+---------------------+
1 row in set (0.01 sec)