MySQL Bugs: #13292: SELECT CURDATE()

Bug #13292	SELECT CURDATE()
Submitted:	17 Sep 2005 8:33	Modified:	26 Sep 2005 7:24
Reporter:	Dmitry Moskalets	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	4.1.10-nt	OS:	Windows (Windows XP Pro)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
SELECT VERSION();

4.1.10-nt

SELECT CURDATE()
UNION ALL
SELECT CURDATE()

and server down...

P.S. I'm in shock.

How to repeat:
SELECT CURDATE()
UNION ALL
SELECT CURDATE()

Thank you for taking the time to report a problem.  Unfortunately
you are not using a current version of the product your reported a
problem with -- the problem might already be fixed. Please download
a new version from http://www.mysql.com/downloads/

If you are able to reproduce the bug with one of the latest versions,
please change the version on this bug report to the version you
tested and change the status back to "Open".  Again, thank you for
your continued support of MySQL.

Additional info:

c:\mysql\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.14-nt

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

mysql> SELECT CURDATE()
    -> UNION ALL
    -> SELECT CURDATE();
+------------+
| CURDATE()  |
+------------+
| 2005-09-17 |
| 2005-09-17 |
+------------+
2 rows in set (0.08 sec)

mysql>

D:\DB\MySQL4.1\bin>mysql -u root --password="123456"
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.10-nt

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

mysql> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 4.1.10-nt |
+-----------+
1 row in set (0.02 sec)

mysql> SELECT CURDATE();
+------------+
| CURDATE()  |
+------------+
| 2005-09-26 |
+------------+
1 row in set (0.00 sec)

mysql> SELECT CURDATE()
    -> UNION ALL
    -> SELECT CURDATE();
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> SELECT VERSION();
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
ERROR:
Can't connect to the server

Notice that you are using an older server version 4.1.10, so please
do the upgrade to 4.1.14.