Bug #110256 An incorrect query result for an indexed decimal column
Submitted: 2 Mar 2023 8:35 Modified: 2 Mar 2023 14:29
Reporter: John Jove Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:8.0.32 OS:Any
Assigned to: CPU Architecture:Any

[2 Mar 2023 8:35] John Jove
Description:
The SELECT statement returns an incorrect query result for an indexed decimal column. When removing such index, the query result is correct.

How to repeat:
CREATE TABLE t0(c0 DECIMAL) ;
INSERT DELAYED IGNORE INTO t0(c0) VALUES('');
CREATE INDEX i0 ON t0(c0 DESC);
SELECT ALL t0.c0 FROM t0 WHERE (t0.c0) = (LEAST('1507214118', "0W*-+	U0")); -- actual:{}, expected:{0}
[2 Mar 2023 14:29] MySQL Verification Team
Hi Mr. Jove,

Thank you for your bug report.

We have repeated it fully.

We have done some code analysis and discovered that your bug is a duplicate of the following bug:

https://bugs.mysql.com/bug.php?id=110209