Bug #95866 "Can't find record" error in SELECT statement
Submitted: 18 Jun 2019 21:47 Modified: 19 Jun 2019 5:48
Reporter: Manuel Rigger Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Memory storage engine Severity:S3 (Non-critical)
Version:8.0.16, 5.7.26 OS:Ubuntu
Assigned to: CPU Architecture:x86

[18 Jun 2019 21:47] Manuel Rigger 
Description:
A SELECT statement results in an error "ERROR 1032 (HY000): Can't find record in 't0'", which is unexpected. This is similar to a previous bug that I reported (see https://bugs.mysql.com/bug.php?id=95856). However, I believe that this bug is distinct, since it affects the HEAP engine, while the previous bug affects the MyISAM engine. Furthermore, a more specific SQL query is necessary to trigger this bug.

How to repeat:
CREATE TABLE t0(c0 INT UNIQUE) ENGINE = HEAP;
INSERT INTO t0(c0) VALUES (DEFAULT), ("a"), ("a");
SELECT (NULL) IN (SELECT t0.c0 FROM t0 WHERE ((t0.c0) OR TRUE) IS NULL); -- unexpected: ERROR 1032 (HY000): Can't find record in 't0'
[19 Jun 2019 5:48] MySQL Verification Team 
Hello Manuel Rigger,

Thank you for the report.

regards,
Umesh