Bug #99145 Incorrect result when comparing a floating-point number with an integer

Description:
Consider the following statements:

How to repeat:
CREATE TABLE t0(c0 INT);
INSERT INTO t0(c0) VALUES (0);
SELECT * FROM t0 WHERE 0.9 > t0.c0; -- expected: {0}, actual: {}

Unexpectedly, the SELECT does not fetch any rows. Using "0.9 <= t0.c0" as a predicate also results in no rows being fetched. The first predicate should evaluate to TRUE, as demonstrated by the following statement:

SELECT 0.9 > t0.c0 FROM t0; -- 1

Hello Manuel Rigger,

Thank you for the report.

regards,
Umesh

Posted by developer:
 
WL#11935: Add folding of constants when compared to fields

Documented fix as follows in the MySQL 8.0.21 changelog:

    A logical error in the constant folding code for the case in
    which a constant of type DECIMAL or FLOAT was the left-hand
    operand and an integer column value was the right-hand operand
    yielded an incorrect result.
      
Closed.