Bug #119137 Incorrect result for ADDTIME expression

• Submitted: 13 Oct 2025 3:23
• Modified: 6 Jan 14:32
• Reporter: zz z
• Status: Verified
• Category: MySQL Server: Optimizer
• Severity: S3 (Non-critical)
• Version: 8.0
• OS: Any
• CPU Architecture: Any

[13 Oct 2025 3:23] zz z

Description:
When querying a table with a `VARCHAR` column using a complex expression involving `ATAN(ADDTIME(10, '2003-05-11'), c1) = 0` in the `WHERE` clause, the query incorrectly evaluates the condition.

How to repeat:
CREATE TABLE t245 (c1 VARCHAR(20));
INSERT INTO t245 (c1) VALUES ('DQ9');
SELECT c1 FROM t245 WHERE (((ATAN((ADDTIME(10, '2003-05-11')), c1))=0));
-- result count : 1
SELECT SUM(count) FROM (SELECT ((((ATAN((ADDTIME(10, '2003-05-11')), c1)) =0))) IS TRUE AS count FROM t245) AS ta_norec;
-- result: 0

[6 Jan 14:32] Roy Lyseng

Thank you for the bug report.
Verified as described.