Bug #121457 Inconsistant result after modifying engine_condition_pushdown

• Submitted: 8 Oct 21:56
• 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:56] Jiyuan Li

Description:
Queries in following testcase return different results after modifying engine_condition_pushdown

How to repeat:
SET SESSION sql_mode='';
DROP DATABASE IF EXISTS d0; CREATE DATABASE d0; USE d0;
CREATE TABLE t (id INT PRIMARY KEY, c CHAR(5)) ENGINE=NDB;
INSERT INTO t VALUES (1,'a'),(2,'ab'),(3,'a '),(4,'a  '),(5,'abcde');
SET SESSION optimizer_switch='engine_condition_pushdown=on';
SELECT id, c FROM t WHERE c = 'a ';
+----+------+
| id | c    |
+----+------+
|  3 | a    |
|  1 | a    |
|  4 | a    |
+----+------+
SET SESSION optimizer_switch='engine_condition_pushdown=off';
SELECT id, c FROM t WHERE c = 'a ';
-- Empty set