Bug #69332 InnoDB will overwrite the sam row_id rows in the same table

Description:
If an InnoDB table is defined without an primary key, the system will use the auto-increment system row_id(6 bytes) as the primary key. The row_id is increased for each row, and the maxnumber is 2^48. If exceeds, reset and reuse from 1.

So it will face the  problem when a new row_id is the same with an old one, if a server keeps running for long time.

The current strategy is just to overwrite the row that has the same row_id. This will lead to data lost and data inconsistency in master and slave.

How to repeat:
The code.

Suggested fix:
I think the stragety that auto-increment field uses now in MySQL is ok. Do not increase the row_id when it reach up to the maximum, and returns a duplicated-key error.

Repeatable step

http://dl2.iteye.com/upload/attachment/0085/1069/55343d35-869c-3ab8-a304-10907116cdc0.jpg

1.7 million per second for 5 years to exhaust 2^48 :)

That number is feasible to reach with modern hardware :)