MySQL Bugs: #118391: Inconsistent BIGINT overflow behavior with unary minus operator in multiplication

Bug #118391	Inconsistent BIGINT overflow behavior with unary minus operator in multiplication
Submitted:	8 Jun 16:43	Modified:	9 Jun 5:25
Reporter:	Long Gu	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DML	Severity:	S3 (Non-critical)
Version:	8.4.2, 8.0	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
MySQL shows inconsistent behavior when handling mathematically equivalent expressions involving unary minus operators and large number multiplication.

How to repeat:
1. Execute: SELECT -(-(100)) * 100000000000000000;
   Result: 10000000000000000000 (succeeds)

2. Execute: SELECT 100 * 100000000000000000;
   Result: ERROR 1690 (22003) at line 1: BIGINT value is out of range in '(100 * 100000000000000000)'

Hello Long Gu,

Thank you for the report and feedback.
Verified as described. 

regards,
Umesh

Posted by developer:
 
SELECT -(-(100)) * 100000000000000000;
is computed as DECIMAL, hence no overflow