Bug #121456 Inconsistant result while disabling engine_condition_pushdown

• Submitted: 8 Oct 21:51
• Reporter: Jiyuan Li
• Status: Open
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: |26.10.0-cluster
• OS: Ubuntu (24.04)
• CPU Architecture: Any

[8 Oct 21:51] Jiyuan Li

Description:
In following testcase, turning off engine_condition_pushdown causes inconsistent results

How to repeat:
SET SESSION sql_mode='';
DROP DATABASE IF EXISTS fb_float; CREATE DATABASE fb_float; USE fb_float;
CREATE TABLE t (id INT PRIMARY KEY, f FLOAT) ENGINE=NDB;
INSERT INTO t VALUES (1,0.1),(2,0.7),(3,1.5);
SET SESSION optimizer_switch='engine_condition_pushdown=on';
SELECT id, f, (f = 0.1) AS eq FROM t WHERE f = 0.1;
+----+------+------+
| id | f    | eq   |
+----+------+------+
|  1 |  0.1 |    0 |
+----+------+------+
SET SESSION optimizer_switch='engine_condition_pushdown=off';
SELECT id, f, (f = 0.1) AS eq FROM t WHERE f = 0.1;
-- empty set