MySQL Bugs: #31655: TIMESTAMP DDL not working as shown in manual

Bug #31655	TIMESTAMP DDL not working as shown in manual
Submitted:	17 Oct 2007 1:42	Modified:	17 Nov 2007 6:51
Reporter:	Peter Breyfogle	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: DDL	Severity:	S1 (Critical)
Version:	5.0	OS:	Windows (Vista Premium)
Assigned to:		CPU Architecture:	Any

Description:
I get the following when following the example in the manual:

ou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

Here is the DDL:

CREATE TABLE member (
	ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

How to repeat:
Attempt to run the DDL

Suggested fix:
Review manual to see if supplied syntax might be wrong.

Please, specify the exact version, 5.0.x, and complete statement you had used. The problem, if any, is not in that column:

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -uroot -proot -P3308
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.44-enterprise-gpl-nt-log MySQL Enterprise Server (GPL)

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

mysql> use test;
Database changed
mysql> CREATE TABLE member (
    ->  ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
Query OK, 0 rows affected (0.36 sec)

So, it works, as you can see.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".