Bug #13140 UNIQUE isn't meant in the description of SERIAL
Submitted: 13 Sep 2005 14:12 Modified: 13 Sep 2005 20:49
Reporter: Gleb Paharenko Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:4.1.14 OS:Linux (Linux)
Assigned to: Stefan Hinz CPU Architecture:Any

[13 Sep 2005 14:12] Gleb Paharenko 
Description:
There in no UNIQUE in the description for the SERIAL type at
  http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html

BIGINT UNSIGNED NOT NULL AUTO_INCREMENT

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

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

mysql> show create table tb\G;
*************************** 1. row ***************************
       Table: tb
Create Table: CREATE TABLE `tb` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

Suggested fix:
fix the manual :)
[13 Sep 2005 20:49] Stefan Hinz 
Added "UNIQUE".