Bug #119262 Incorrect result on comparison between a float expression and an indexed SMALLINT column.

• Submitted: 29 Oct 9:01
• Modified: 4 Nov 23:01
• Reporter: zz z
• Status: Verified
• Category: MySQL Server: Optimizer
• Severity: S3 (Non-critical)
• Version: 8.0.44,8.4.6,9.4.0
• OS: Any
• CPU Architecture: Any

[29 Oct 9:01] zz z

Description:
The WHERE clause compares a floating-point expression, (3) / -1E37, with a SMALLINT column containing the value 0. 

How to repeat:
CREATE TABLE t7 (c2 SMALLINT, KEY (c2));
INSERT t7 () VALUES (0);
SELECT * FROM t7 WHERE (((3) / -1E37) = (c2)); -- return 0

CREATE TABLE t7 (c2 SMALLINT);
INSERT t7 () VALUES (0);
SELECT * FROM t7 WHERE (((3) / -1E37) = (c2)); -- return null

[4 Nov 23:01] Roy Lyseng

Verified as described.