Bug #101374 Bigint calculation error
Submitted: 29 Oct 2020 12:04 Modified: 29 Oct 2020 12:50
Reporter: DaYong Gao Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[29 Oct 2020 12:04] DaYong Gao 
Description:
column a is bigint, column b is bigint unsigned
data: id = 1 a = 5 b = 10
run "update table set a = a - 10, b = b + 10 where id = 1"
result: a = 0 b = 20

How to repeat:
column a is bigint, column b is bigint unsigned
data: id = 1 a = 5 b = 10
run "update table set a = a - 10, b = b + 10 where id = 1"
result: a = 0 b = 20