[MDEV-8703] Wrong result for SELECT..WHERE LENGTH(decimal_10_1_column)!=3 AND decimal_10_1_column=1.10 - Jira

XML

Word

Printable

In this script:

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a DECIMAL(10,1));

INSERT INTO t1 VALUES (1.1);

SELECT * FROM t1 WHERE LENGTH(a)!=3;

SELECT * FROM t1 WHERE LENGTH(a)!=3 AND a=1.10;

The first SELECT query correctly returns empty set, and the second SELECT query erroneously returns one row.

blocks

MDEV-8728 Fix a number of problems in equal field and equal expression propagation