Bug #121459 Inconsistant result after modifying optimizer switch while using date

• Submitted: 9 Oct 0:33
• 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

[9 Oct 0:33] Jiyuan Li

Description:
Queries in following testcase return different results before/after modifying optimizer switch

How to repeat:
SET SESSION sql_mode='';
CREATE TABLE t (id INT PRIMARY KEY, d DATETIME(0)) ENGINE=NDB;
INSERT INTO t VALUES (1,'2020-01-01 12:00:00');
SET SESSION optimizer_switch='engine_condition_pushdown=on';
SELECT id, d FROM t WHERE d = '2020-01-01 12:00:00.4';
+----+---------------------+
| id | d                   |
+----+---------------------+
|  1 | 2020-01-01 12:00:00 |
+----+---------------------+
SET SESSION optimizer_switch='engine_condition_pushdown=off';
SELECT id, d FROM t WHERE d = '2020-01-01 12:00:00.4';
-- Empty set