Bug #105481 BIGINT UNSIGNED value on: SELECT (2 < 3) * -1;
Submitted: 6 Nov 2021 8:10 Modified: 6 Nov 2021 9:09
Reporter: Pratyush Mittal Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:8.0.27 OS:Any
Assigned to: CPU Architecture:Any
Tags: regression

[6 Nov 2021 8:10] Pratyush Mittal 
Description:
Version 8.0.27, the queries are giving "BIGINT UNSIGNED value is out of range" when comparing inequality results with negative whole numbers.

These work fine:
mysql> select (2 < 3) * -1.0;
-1.0

mysql> select (2 < 3) * 1;
1

This gives error:
mysql> select (2 < 3) * -1;
BIGINT UNSIGNED value is out of range

How to repeat:
SELECT (2 < 3) * -1;
[6 Nov 2021 9:09] MySQL Verification Team 
Hello Pratyush,

Thank you for the report and test case.
Observed that 8.0.27 build is affected.

regards,
Umesh
[8 Nov 2021 7:55] Roy Lyseng 
Posted by developer:
 
Problem is caused by the same issue as bug#33516898