Bug #69431 wrong ER_INSERT_INFO "Records: %ld Duplicates: %ld Warnings: %ld"
Submitted: 8 Jun 2013 12:19
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:5.6.12 OS:Windows
Assigned to: CPU Architecture:Any

[8 Jun 2013 12:19] Shane Bester 
Description:
Symptoms are an incorrect Records count in the output:

mysql> select count(*) from t1;
+------------+
| count(*)   |
+------------+
| 2176782336 |
+------------+
1 row in set (0.00 sec)

mysql> insert into t1 select * from t1;
Query OK, -2118184960 rows affected (3 hours 19 min 38.76 sec)
Records: -2118184960  Duplicates: 0  Warnings: 0

How to repeat:
insert more rows than %ld can display ;-0

Suggested fix:
use 64-bit integers
[10 Jun 2013 11:06] MySQL Verification Team 
i suspect same bug exists for the client part of the informational message. 
please fix both...
[15 Aug 2014 16:09] MySQL Verification Team 
related: http://bugs.mysql.com/bug.php?id=69023