MySQL Bugs: #119723: Inconsistant result executing functionally equivalent queries

Bug #119723	Inconsistant result executing functionally equivalent queries
Submitted:	19 Jan 18:25
Reporter:	Jiyuan Li	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	9.3.0-cluster	OS:	Ubuntu
Assigned to:		CPU Architecture:	Any

Description:
Queries having same function return different results. 

How to repeat:
CREATE TABLE t0(c0 SMALLINT ZEROFILL  STORAGE DISK UNIQUE PRIMARY KEY COMMENT 'asdf'  COLUMN_FORMAT DEFAULT NOT NULL) ;

REPLACE LOW_PRIORITY INTO t0(c0) VALUES(0.024427270112527988);

SELECT ALL t0.c0 AS ref0 FROM t0;
+-------+
| ref0  |
+-------+
| 00000 |
+-------+
1 row in set (0.00 sec)

SELECT t0.c0 AS ref0 FROM t0 WHERE (t0.c0) OR ((CAST(t0.c0 AS SIGNED)) LIKE (IF(0.8647961722676645, t0.c0, t0.c0))) UNION ALL SELECT ALL t0.c0 AS ref0 FROM t0 WHERE (! ((t0.c0) OR ((CAST(t0.c0 AS SIGNED)) LIKE (IF(0.8647961722676645, t0.c0, t0.c0))))) UNION ALL SELECT ALL t0.c0 AS ref0 FROM t0 WHERE ((t0.c0) OR ((CAST(t0.c0 AS SIGNED)) LIKE (IF(0.8647961722676645, t0.c0, t0.c0)))) IS NULL;
Empty set, 1 warning (0.00 sec)