Bug #120677 Incorrect result for `col OR GREATEST(...)`
Submitted: 13 Jun 17:33
Reporter: mu mu Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:9.6.0 OS:Ubuntu
Assigned to: CPU Architecture:Any

[13 Jun 17:33] mu mu 
Description:
On identical table data, `WHERE (t0.c0) OR (GREATEST(0.958227073580661, t0.c0, "", t0.c0))` should return **4** rows, but MySQL 9.6.0 returns **3** rows.

How to repeat:
DROP TABLE IF EXISTS `t0`;

CREATE TABLE `t0` (
  `c0` bigint(7) unsigned zerofill  DEFAULT NULL COMMENT 'asdf'
) PACK_KEYS=0 STATS_PERSISTENT=1 CHECKSUM=1;

INSERT INTO `t0` (`c0`) VALUES (NULL);
INSERT INTO `t0` (`c0`) VALUES (829027710);
INSERT INTO `t0` (`c0`) VALUES (0);
INSERT INTO `t0` (`c0`) VALUES (1334113288);
INSERT INTO `t0` (`c0`) VALUES (1334113288);

SELECT ALL t0.c0 AS ref0 FROM t0 WHERE (t0.c0) OR (GREATEST(0.958227073580661, t0.c0, "", t0.c0));