Bug #119415 Incorrect IN Subquery on ARCHIVE Engine

• Submitted: 18 Nov 6:07
• Reporter: little a
• Status: Open
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 9.4.0
• OS: Any
• CPU Architecture: Any

[18 Nov 6:07] little a

Description:
Just like the test cases, the number of rows returned by the two queries should be the same

How to repeat:
CREATE TABLE t269 (c1 MEDIUMINT ZEROFILL, c2 BIT) ENGINE ARCHIVE;
INSERT t269 () VALUES (12613998,b'0');
INSERT t269 () VALUES ();
INSERT t269 () VALUES ();

SELECT 0 FROM t269 WHERE (1.7976931348623157E308 NOT IN (SELECT t269.c2 FROM t269));
-- empty set
SELECT SUM(count) FROM (SELECT ((1.7976931348623157E308 NOT IN (SELECT t269.c2 FROM t269))) IS TRUE AS count FROM t269) AS ta_norec;
-- Returned Row Count: 3