MySQL Bugs: #8664: SERIAL Date Type Documentation

Bug #8664	SERIAL Date Type Documentation
Submitted:	21 Feb 2005 23:09	Modified:	22 Feb 2005 13:55
Reporter:	Mark Leith	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	Current	OS:	N/A
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
The SERIAL data type is only documented within the changelog:

http://dev.mysql.com/doc/mysql/en/news-4-1-0.html 

" In CREATE TABLE the attribute SERIAL is now an alias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE."

It isn't however documented within any of the data type documentation.

How to repeat:
mysql> create table ser (id serial);
Query OK, 0 rows affected (0.08 sec)

mysql> insert into ser values (''),
    -> (''),
    -> (''),
    -> (''),
    -> ('');
Query OK, 5 rows affected, 5 warnings (0.05 sec)
Records: 5  Duplicates: 0  Warnings: 5

mysql> select * from ser;
+----+
| id |
+----+
|  1 |
|  2 |
|  3 |
|  4 |
|  5 |
+----+
5 rows in set (0.00 sec)

Suggested fix:
Add SERIAL to "Overview of Numeric Types":

http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html

Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).