Bug #121458 Inconsistant result after modifying optimizer_switch with enum

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

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

How to repeat:
SET SESSION sql_mode='';
CREATE TABLE t (id INT PRIMARY KEY, e ENUM('a','b','c'), s SET('x','y','z')) ENGINE=NDB;
INSERT INTO t VALUES (1,'a','x'),(2,'b','x,y'),(3,'c','z'),(4,'','');
SET SESSION optimizer_switch='engine_condition_pushdown=on';

SELECT id, e, s FROM t WHERE e = '1';
+----+------+------+
| id | e    | s    |
+----+------+------+
|  1 | a    | x    |
+----+------+------+

SET SESSION optimizer_switch='engine_condition_pushdown=off';

SELECT id, e, s FROM t WHERE e = '1';
--Empty set