Merge Table Example Error

[Grum De Henseler]

In https://dev.mysql.com/doc/refman/5.6/en/merge-storage-engine.html

the example code

mysql> CREATE TABLE total (
-> a INT NOT NULL AUTO_INCREMENT,
-> message CHAR(20), INDEX(a))
-> ENGINE=MERGE UNION=(t1,t2) INSERT_METHOD=LAST;

will result in 1168. I believe you want the following

mysql> CREATE TABLE total (
-> a INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> message CHAR(20))
-> ENGINE=MERGE UNION=(t1,t2) INSERT_METHOD=LAST;


Grum